java多线程操作mysql_多线程实现数据库的并发操作

在Java中，程序需要操作数据库，操作数据首要事就是要获得数据库的Connection对象，利用多线程对数据导入数据库中将会加快操作进度，但是多个线程共享Connection对象，是不安全的，因为可以利用Java中的ThreadLocal为每个线程保存一个Connection对象，代码如下：

package com.quar.innovation.db;

import java.sql.Connection;

import java.sql.DriverManager;

public class ConnnectionManager {

private static final ThreadLocal connectionHolder = new ThreadLocal();

private static final String BETADBURL = "jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=utf8&autoReconnect=true&user=root&password=root";

public static Connection getConnectionFromThreadLocal() {

Connection conn = connectionHolder.get();

try {

if (conn == null || conn.isClosed()) {

Connection con = ConnnectionManager.getConnection();

connectionHolder.set(con);

System.out.println("[Thread]" + Thread.currentThread().getName());

return con;

}

return conn;

} catch (Exception e) {

System.out.println("[ThreadLocal Get Connection Error]" + e.getMessage());

}

return null;

}

public static Connection getConnection() {

Connection conn = null;

try {

Class.forName("com.mysql.jdbc.Driver");

conn = (Connection) DriverManager.getConnection(BETADBURL);

} catch (Exception e) {

System.out.println("[Get Connection Error]" + e.getMessage());

}

return conn;

}

}

通过ThreadLocal就可以为每个线程保留一份Connection对象，利用Java的ThreadPoolExecutor启动线程池，完成数据库操作，完整代码如下：

public class QunarThreadPoolExecutor extend