Jndi技术

来源：互联网发布：我国近年财政补贴数据编辑：程序博客网时间：2024/06/06 05:48

jndi技术：

public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {// 写 jndi的代码 Connection conn = null;PreparedStatement stmt = null;ResultSet rs = null;try {// 拿到 jndi上下文 对象Context context = new InitialContext();Context envCtx = (Context) context.lookup("java:comp/env");// 获得数据库连接池 象DataSource ds = (DataSource) envCtx.lookup("jdbc/EmployeeDB");conn=ds.getConnection();stmt = conn.prepareStatement("select * from account");rs = stmt.executeQuery();while(rs.next()){String name = rs.getString("name");String money = rs.getString("money");System.out.println( " name : " + name +", money : " + money);}} catch (Exception e) {// TODO Auto-generated catch blocke.printStackTrace();}finally{JdbcUtils.release(rs, stmt, conn);}}

Context.xml:

放在WETA-INFO目录下

<Context>  <Resource name="jdbc/EmployeeDB"            type="javax.sql.DataSource"            username="root"            password="root"            driverClassName="com.mysql.jdbc.Driver"            url="jdbc:mysql:///day13"          /></Context>

0 0