tomcat6连接池

1.配置文件 WebRoot/META-INF/context.xml
<Context reloadable="true">
<WatchedResource>WEB-INF/web.xml</WatchedResource>
<Resource name="jdbc/mysql" auth="Container" type="javax.sql.DataSource"
maxActive="100"
maxIdle="30"
maxWait="10000"
username="root"
password="root"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://118.186.210.242:447/wucaiju?user=root&amp;password=root&amp;useUnicode=true&amp;characterEncoding=utf-8"/>
</Context>


2.WebRoot/WEB-INF/web.xml
<resource-ref>
<res-ref-name>jdbc/mysql</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
　 </resource-ref>

3.测试类
public class TestDao {

public void test()throws Exception{
Context context = new InitialContext();
DataSource ds = (DataSource)context.lookup("java:/comp/env/jdbc/mysql");


JdbcTemplate jdbcTemplate = new JdbcTemplate(ds);
jdbcTemplate.afterPropertiesSet();
System.out.println(jdbcTemplate);

String sql = "select * from t_pic";
List list = jdbcTemplate.queryForList(sql);

for(int i=0; i<list.size(); i++){
Map map = (Map)list.get(i);
System.out.println(map.get("createTime"));
}
}
}