tomcat lib文件夹里面加入jdbc驱动
config文件夹里面修改context.xml文件:
<resource name="java/news"
auth="Container" type="javax.sql.DataSource" maxActive="100"
maxIdle="30" maxWail="10000" username="root" password="tiger"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/loong"
/>
修改conn获取方式:
import javax.naming.InitialContext;
import javax.naming.NamingException;
try {
javax.naming.Context ctx = new InitialContext();
// 获取与逻辑名相关联的数据源对象
DataSource ds = (DataSource) ctx.lookup("java:comp/env/jdbc/news");
conn = ds.getConnection();
} catch (NamingException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}