摘要:addSqlliteByCommandLine
java build path>>>>>commons-exec-1.0.1.jar
java build path>>>>>sqlite-jdbc-3.8.10.1.jvar
import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.util.Date;
import org.apache.commons.exec.CommandLine;
import org.apache.commons.exec.DefaultExecutor;
import org.apache.commons.exec.PumpStreamHandler;
public class addSqlliteByCommandLine {
/**
* @param args
*/
public static void main(String[] args) {
// 設定jdbc連結字串，請依你的SQL Server設定值修改
try {
int num = 0;
Date d1 = new Date();
System.out.println("Start time====" + (d1.getTime()) / 1000);
for (int i = 1; i <= 1000000; i++) {
num++;
if (i % 1000 == 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') \" ";
String sqlString = "D:/DB/sqllite/sqlite3 D:/DB/sqllite/test.db "+SQL;
runCommand(sqlString);
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') ";
sqlString = "D:/DB/sqllite/sqlite3 D:/DB/sqllite/test.db "+SQL;
runCommand(sqlString);
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') ";
sqlString = "D:/DB/sqllite/sqlite3 D:/DB/sqllite/test.db "+SQL;
runCommand(sqlString);
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') ";
sqlString = "D:/DB/sqllite/sqlite3 D:/DB/sqllite/test.db "+SQL;
runCommand(sqlString);
}
Date d2 = new Date();
System.out.println("End time====" + (d2.getTime()) / 1000);
System.out.println("ADD ===========time 秒===="
+ (d2.getTime() - d1.getTime()) / 1000);
System.out.println("finish");
} catch (Exception ex) {
ex.printStackTrace();
}
}
public static String runCommand(String cmd) throws IOException {
String msg = "";
try {
CommandLine commandLine = CommandLine.parse(cmd);
ByteArrayOutputStream output = new ByteArrayOutputStream();
DefaultExecutor executor = new DefaultExecutor();
PumpStreamHandler streamHandler = new PumpStreamHandler(output);
executor.setStreamHandler(streamHandler);
int exitValue = executor.execute(commandLine);
msg = new String(output.toByteArray());
} catch (IOException e) {
}
return msg;
}
}
