conn = DriverManager.getConnection("jdbc:sqlite:/" + dbPath);
conn.setAutoCommit(false);//事物 String sql = "UPDATE tab2 SET content= '" + tempStr+"'";
String sqlActive = "SELECT * FROM tab1;";
stat = conn.prepareStatement(sql);
statActive = conn.prepareStatement(sqlActive);
statModify = conn.prepareStatement("UPDATE tab1 SET 'userName' = ? WHERE 'id' =?");
rs = statActive.executeQuery();
while(rs.next()) {
statModify.setString(1, domainNew);
statModify.setLong(2, Integer.parseInt(pk));
//statModify.executeUpdate(); //开始这样写的,网上说用批处理解决,可是问题依旧
statModify.addBatch();
} statModify.executeBatch();//tab1更新
stat.executeUpdate(); //tab2更新
conn.commit();
conn.setAutoCommit(false);//事物 String sql = "UPDATE tab2 SET content= '" + tempStr+"'";
String sqlActive = "SELECT * FROM tab1;";
stat = conn.prepareStatement(sql);
statActive = conn.prepareStatement(sqlActive);
statModify = conn.prepareStatement("UPDATE tab1 SET 'userName' = ? WHERE 'id' =?");
rs = statActive.executeQuery();
while(rs.next()) {
statModify.setString(1, domainNew);
statModify.setLong(2, Integer.parseInt(pk));
//statModify.executeUpdate(); //开始这样写的,网上说用批处理解决,可是问题依旧
statModify.addBatch();
} statModify.executeBatch();//tab1更新
stat.executeUpdate(); //tab2更新
conn.commit();
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货