H2 Database Import CSV file realization principle Simple analysis _mssql

1. Start the H2 database does not open the browser window (default is open)
2. Database creation SQL adds support for bigdecimal types, H2 databases do not support BigDecimal types by default:

SQL code

Copy Code code as follows:

CREATE TABLE test (ID int (one), Charge BigDecimal (12))

SQL code

Copy Code code as follows:

CREATE TABLE test (ID int (one), Charge BigDecimal (12))

3. Import database scripts by passing parameters

Copy Code code as follows:

New Console (). Runtool ();
New RunScript (). RunCustomTool ("Jdbc:h2:~/test", "sa", "" "," C:/schema.sql ");

H2 Database Import CSV file

Copy Code code as follows:

Insert INTO prescription (SELECT * from Csvread (' c:/jv/demo/prescription2012-05-10 22-26-37.csv '));