jdbc mysql 数据库连接池_JDBC mysql数据库连接池配置

编辑项目中的context.xml,如果没有，则新建context.xml

1.context.xml

type="javax.sql.DataSource"

maxActive="100" maxIdle="30" maxWait="10000"

username="root" password="123456"

driverClassName="com.mysql.jdbc.Driver"

url="jdbc:mysql://localhost:3306/jsp_manage?authReconnect=true"/>

characterEncoding=utf-8，设置数据库编码

2.连接连接池案例

package jdbc.util;

import java.sql.Connection;

import java.sql.SQLException;

import javax.naming.InitialContext;

import javax.naming.NamingException;

import javax.sql.DataSource;

public class DBUtil {

private static DataSource ds = null;

static{

InitialContext ctx;

try {

ctx = new InitialContext();

ds = (DataSource) ctx.lookup("java:comp/env/jdbc/bookstore");

} catch (NamingException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

private void DBUtil(){}

public static Connection getConnection() throws SQLException{

return ds.getConnection();

}

}