JDBC学习之三Batch

最新推荐文章于 2024-10-05 13:44:14 发布

win19guan

最新推荐文章于 2024-10-05 13:44:14 发布

阅读量230

点赞数

文章标签： jdbc sqlserver string microsoft insert exception

本文链接：https://blog.csdn.net/win19guan/article/details/2304046

版权

package com.cn.MyJDBC;

import java.sql.*;

public class TestBatch {
public static void main(String[] args) throws Exception{
   String url = "jdbc:microsoft:sqlserver://localhost:1433;databaseName=Market";
   String user = "sa";
   String password = "sa";
   Connection conn = null;
   Statement stat = null;
   Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
   conn = DriverManager.getConnection(url,user,password);
   stat = conn.createStatement();
   stat.addBatch("insert into Citys values (3,'武汉','汉口')");
   stat.addBatch("insert into Citys values (4,'宜昌','小溪塔')");
   stat.executeBatch();
   stat.close();
   conn.close();


   /*以下是用PreparedStatement来执行批处理
   PreparedStatement pstat = null;
   pstat = conn.prepareStatement("inser into Citys value (?,?,?)");
   pstat.setInt(1,3);
   pstat.setString(2,"武汉");
   pstat.setString(3,"汉口");
   pstat.addBatch();

   pstat.setInt(1,3);
   pstat.setString(2,"宜昌");
   pstat.setString(3,"小溪塔");
   pstat.addBatch();

   pstat.executeBatch();
   pstat.close();
   conn.close();
   */

}
}