JDBC(PreparedStatement)--Batch Update Record

最新推荐文章于 2020-12-07 20:34:37 发布

浪迹天涯鬼剑愁

最新推荐文章于 2020-12-07 20:34:37 发布

阅读量791

点赞数

分类专栏： JDBC 文章标签： jdbc mysql

本文链接：https://blog.csdn.net/u010381633/article/details/44939027

版权

package com.jack.common;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
 
public class JDBCBatchUpdateExample {
 
	private static final String DB_DRIVER = "com.mysql.jdbc.Driver";
	private static final String DB_CONNECTION = "jdbc:mysql://localhost:3306/jdbc";
	private static final String DB_USER = "root";
	private static final String DB_PASSWORD = "root";
 
	public static void main(String[] argv) {
 
		try {
 
			batchInsertRecordsIntoTable();
 
		} catch (SQLException e) {
 
			System.out.println(e.getMessage());
 
		}
 
	}
 
	private static void batchInsertRecordsIntoTable() throws SQLException {
 
		Connection dbConnection = null;
		PreparedStatement preparedStatement = null;
 
		String insertTableSQL = "INSERT INTO DBUSER1"
				+ "(USER_ID, USERNAME, CREATED_BY, CREATED_DATE) VALUES"
				+