TestBatch

最新推荐文章于 2024-06-29 10:38:46 发布

原创最新推荐文章于 2024-06-29 10:38:46 发布 · 542 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#insert #string #exception #user #jdbc #import

JDBC 专栏收录该内容

5 篇文章

订阅专栏

import java.sql.*; public class TestBatch {//JDBC的批处理 /** * @param args */ public static void main(String[] args) throws Exception{ // TODO Auto-generated method stub Connection connect = null; Statement stmt = null; String url = "jdbc:mysql://localhost:3306/test"; String name = "java"; String password = "123"; Class.forName("com.mysql.jdbc.Driver"); connect = DriverManager.getConnection(url, name, password); /* //====方法1：==== stmt = connect.createStatement(); stmt.addBatch("insert into user values (21,'北京')"); stmt.addBatch("insert into user values (22,'上海')"); stmt.addBatch("insert into user values (23,'深圳')"); stmt.executeBatch(); stmt.close(); */ //====方法2：==== PreparedStatement ps = connect.prepareStatement("insert into user values (?,?)"); ps.setInt(1, 24); ps.setString(2, "青岛"); ps.addBatch(); ps.setInt(1, 25); ps.setString(2, "厦门"); ps.addBatch(); ps.setInt(1, 26); ps.setString(2, "大连"); ps.addBatch(); ps.executeBatch(); ps.close(); } }