conpool.jsp

来自「< J2EE应用开发详解>>一书全部的源代码. 本书基于J」· JSP 代码 · 共 32 行

<%@ page import="javax.naming.Context" %> 
 <%@ page import="javax.sql.DataSource"%> 
 <%@ page import="javax.naming.InitialContext"%> 
 <%@ page import="java.sql.*"%> 

 <% 
   DataSource ds = null; 
   try{ 
     Context initCtx = new InitialContext(); 
    // Context envCtx = (Context) initCtx.lookup("java:comp/env"); 
     ds = (DataSource)initCtx.lookup("java:/OracleDS"); 
if(ds!=null) 
{
 out.println("Connection is OK!"); 
out.println("<br>");
Connection conn = ds.getConnection();
Statement stmt=conn.createStatement();
stmt.execute("create table dd(id int)");
stmt.execute("insert into dd values(1)");
ResultSet rst=stmt.executeQuery("select * from dd");
while(rst.next())
{
out.println(rst.getString("id"));
out.println("<br>");
}
stmt.execute("drop table dd");
}

else 
 out.println("Fail!"); 
   }catch(Exception ne){ out.println(ne);} 
 %>