test.jsp测试页面
DataSource ds = null;
try{
Context ctx=new InitialContext();
Context envCtx=(Context)ctx.lookup("java:comp/env");
ds=(DataSource)envCtx.lookup("jdbc/mysql");
Connection conn = ds.getConnection();
Statement stm = conn.createStatement();
ResultSet rs = stm.executeQuery("select * from userinfo");
while(rs.next())
{
out.print(rs.getString("User_id"));
}
}catch(Exception e)
{
out.print(e.getMessage());
}
hibernate配置读取tomcat数据源
在hibernate.cfg.xml文件中添加
<session-factory>
<property name="connection.datasource">
java:comp/env/jdbc/mysql
</property>
<property name="show_sql">true</property>
<property name="dialect">
org.hibernate.dialect.MySQLDialect
</property>
</session-factory>
web.xml添加
<description>mysqlDB</description>
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/mysql</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>