C# 批量插入Mysql数据的实例代码
本文导语: 本节内容: 一例批量插入Mysql数据的c#代码。 例子: 代码示例: public void loadData(Connection connection) { long starTime = System.currentTimeMillis(); String sqlString = "load data local infile ? into table test"; PreparedStatement pstmt; ...
本节内容:
一例批量插入Mysql数据的c#代码。
例子:
public void loadData(Connection connection)
{
long starTime = System.currentTimeMillis();
String sqlString = "load data local infile ? into table test";
PreparedStatement pstmt;
try {
pstmt = connection.prepareStatement(sqlString);
pstmt.setString(1, "tfacts_result");
pstmt.executeUpdate();
pstmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
long endTime = System.currentTimeMillis();
System.out.println("program runs " + (endTime - starTime) + "ms");
}
//批量插入mysql数据
public static void mysql_batch(string sqlStr,int point)
{
string sql = "insert into test(node1, node2, weight) values(?, ?, ?)";
Connection conn = getConn("mysql");
conn.setAutoCommit(false);
//clear(conn);
try
{
PreparedStatement prest = conn.prepareStatement(sql);
//long a = System.currentTimeMillis();
for (int x = 1; x