我用mysql的可以server.xml
<Context path="/addressbook" docBase="addressbook" debug="5" reloadable="true" crossContext="true">
<Resource name="jdbc/quickstart" auth="Container" type="javax.sql.DataSource"
maxActive="4" maxIdle="2" maxWait="3000" username="root" password="admin" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/ddressbooksample?autoReconnect=true"/>
</Context>
Servlet:
{
PrintWriter out = response.getWriter();
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource source = (DataSource)envContext.lookup("jdbc/addressbook");
Connection con = source.getConnection();
String sql = "select * from addressbook_table";
Statement sm = con.createStatement();
ResultSet rs = sm.executeQuery(sql);
while (rs.next()) {
out.println(rs.getString(1) + " " + rs.getString(2));
}
}
<Context path="/addressbook" docBase="addressbook" debug="5" reloadable="true" crossContext="true">
<Resource name="jdbc/quickstart" auth="Container" type="javax.sql.DataSource"
maxActive="4" maxIdle="2" maxWait="3000" username="root" password="admin" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/ddressbooksample?autoReconnect=true"/>
</Context>
Servlet:
{
PrintWriter out = response.getWriter();
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource source = (DataSource)envContext.lookup("jdbc/addressbook");
Connection con = source.getConnection();
String sql = "select * from addressbook_table";
Statement sm = con.createStatement();
ResultSet rs = sm.executeQuery(sql);
while (rs.next()) {
out.println(rs.getString(1) + " " + rs.getString(2));
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货