我用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));
}
}