JDBC mysql数据库连接池配置

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

1.context.xml

<?xml version="1.0" encoding="UTF-8"?><Context antiJARLocking="true" path="/python" reloadable="true"> <Resource name="jdbc/jsp_manage" auth="Container" 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"/></Context> 

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 blocke.printStackTrace();}}private void DBUtil(){}public static Connection getConnection() throws SQLException{return ds.getConnection();}}