摘要:addSqllite
java build path>>>SQLite-jdbc-3.8.10.1.jar
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.util.Date;
public class addSqllite {
/**
* @param args
*/
public static void main(String[] args) {
// 設定jdbc連結字串，請依你的SQL Server設定值修改
Connection con = null;
try {
// 註冊JODBC類
Class.forName("org.sqlite.JDBC").newInstance();
con = DriverManager
.getConnection("jdbc:sqlite:D:\\DB\\sqllite\\test.db");
int num = 0;
Statement stmt = con.createStatement();
Date d1 = new Date();
System.out.println("Start time====" + (d1.getTime()) / 1000);
for (int i = 1; i < 1000000; i++) {
num++;
if (i % 10 == 0) {
System.out.println("Start add===" + i + " Time== "
+ (new Date().getTime()) / 1000);
}
String SQL = "insert into YDD_RESOURCE_DESCRIPTION "
+ "(RESOURCE_DESCRIPTION_ID,RESOURCE_ID,RESOURCE_TYPE_ID ,RESOURCE_TYPE_PROPERTY,RESOURCE_DESCRIPTION_VALUE) "
+ " values (" + num + ",'1','6','DbType','SQLSERVER') ";
stmt.execute(SQL);
num++;
SQL = "insert into YDD_RESOURCE_DESCRIPTION "
+ "(RESOURCE_DESCRIPTION_ID,RESOURCE_ID,RESOURCE_TYPE_ID ,RESOURCE_TYPE_PROPERTY,RESOURCE_DESCRIPTION_VALUE) "
+ " values (" + num + ",'1','6','DbCd','cd') ";
stmt.execute(SQL);
num++;
SQL = "insert into YDD_RESOURCE_DESCRIPTION "
+ "(RESOURCE_DESCRIPTION_ID,RESOURCE_ID,RESOURCE_TYPE_ID ,RESOURCE_TYPE_PROPERTY,RESOURCE_DESCRIPTION_VALUE) "
+ " values (" + num + ",'1','6','TableCd','TableCd') ";
stmt.execute(SQL);
num++;
SQL = "insert into YDD_RESOURCE_DESCRIPTION "
+ "(RESOURCE_DESCRIPTION_ID,RESOURCE_ID,RESOURCE_TYPE_ID ,RESOURCE_TYPE_PROPERTY,RESOURCE_DESCRIPTION_VALUE) "
+ " values (" + num + ",'1','6','TableNm','TableNm') ";
stmt.execute(SQL);
}
Date d2 = new Date();
System.out.println("End time====" + (d2.getTime()) / 1000);
System.out.println("ADD ===========time 秒===="
+ (d2.getTime() - d1.getTime()) / 1000);
stmt.close();
System.out.println("finish");
// 循環搜尋結果，請依你的資料庫來作提取資料欄位，以將下面的資料欄位對映你的資料欄位
// int i=0;
// while (rs.next()) {
// i++;
// System.out.println("no="+ i
// +" :"+rs.getString("RESOURCE_TYPE_PROPERTY") + ", " +
// rs.getString("RESOURCE_DESCRIPTION_VALUE"));
// }
} catch (Exception ex) {
ex.printStackTrace();
}
}
}