context.xml
<Resource name="jdbc/fengqing"
auth="Container"
type="javax.sql.DataSource"
maxActive="100"
maxIdle="30"
maxWait="10000"
username="root"
password="123456"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/fengqing"
/>
JndiUtil.java
package com.fengqing.servlet;
import java.sql.Connection;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;
public class JndiUtil {
public static Connection getConn() {
Connection conn = null;
try {
Context cxt = new InitialContext();
DataSource ds = (DataSource)cxt.lookup("java:comp/env/jdbc/fengqing");
conn = ds.getConnection();
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
}
jdni.jsp
<body>
<%
Connection conn = JndiUtil.getConn();
PreparedStatement ps = conn.prepareStatement("select count(1) from student");
ResultSet rs = ps.executeQuery();
if (rs.next()) {
out.println(rs.getInt(1));
}
%>
</body>