DBUtil类

package util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBUtil {
	//为每一个线程维护一个变量
	private static ThreadLocal<Connection> connHolder = 
		new ThreadLocal<Connection>();
	
	public static Connection getConnection(){
		Connection conn = connHolder.get();
		if(conn == null){
			conn = getConn();
			connHolder.set(conn);
		}
		return conn;
	}
	
	public static void close(){
		Connection conn = connHolder.get();
		if(conn!=null){
			close(conn);
		}
	}
	
	private static Connection getConn(){
		Connection conn = null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			conn = DriverManager
			.getConnection("jdbc:mysql://localhost:3306/sd1101db2?useUnicode=true&characterEncoding=utf8",
					"root","1234");
		} catch (Exception e) {
			e.printStackTrace();
		}
		return conn;
	}
	
	private static void close(Connection conn){
		if(conn!=null){
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub

	}

}