关于Tomcat中的datasource的配置可以有多种方式下面介绍两种:
第一种用将配置文件放置在%TOMCAT_HOME%/conf/Catalina/localhost文件夹下
创建配置文件WebDemo.xml
内容为:
maxActive="100" maxIdle="30" maxWait="10000" username="root"
password="system" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/test?autoReconnect=true"/>
在servlet中的取得datasource:
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
try {
Context ctx = new InitialContext();
//取得datasource对象java:comp/env为固定格式
DataSource ds = (DataSource) ctx.lookup("java:comp/env/jdbc/bookstore");
Connection conn = ds.getConnection();
String sql = "select * from tuser";