public class Test { private static final String DRIVER_CLASS_NAME = ""; private static final String JDBC_URL = ""; private static final String USER = ""; private static final String PASSWORD = ""; public static void main(String[] args) { int count = 10; // 插入记录的数目 Object[][] params = new Object[count][]; for (int i = 0; i < count; i++) // 将每条记录的数据插入数组 params[i] = new Object[] { "", "", "" }; batch(params); } public static Connection getConnection() { Connection conn = null; try { Class.forName(DRIVER_CLASS_NAME); conn = DriverManager.getConnection(JDBC_URL, USER, PASSWORD); return conn; } catch (Exception e) { return null; } } public static void batch(Object[][] params) { QueryRunner queryRunner = new QueryRunner(true); String sql = "INSERT INTO TABLE_NAME VALUES (?,?,?)"; try { queryRunner.batch(getConnection(), sql, params); } catch (SQLException e) { e.printStackTrace(); } } }
JAVA - 将List集合插入到数据库
最新推荐文章于 2024-05-11 16:06:20 发布