编辑项目中的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 block e.printStackTrace(); } } private void DBUtil(){} public static Connection getConnection() throws SQLException{ return ds.getConnection(); } }