<%@page contentType="text/html; charset=gb2312"%>
<%@page import="javax.naming.Context,javax.sql.DataSource,java.sql.*,javax.naming.InitialContext"%>
<%
DataSource ds=null;
try{
Context initCtx=new InitialContext();
ds=(javax.sql.DataSource)initCtx.lookup("myejb");
if(ds!=null){
out.println("已经获得数据源:"+ds.toString()+"<p>");
Connection con=ds.getConnection();
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from student");
out.println("以下是从数据库中读取出来的数据:<br/>");
while(rs.next()){
out.println("bookName:"+rs.getString(1)+"<br/>");
}
}
else{
out.println("连接数据源失败!");
}
}
catch(Exception e){
out.println(e);
e.printStackTrace();
}
%>
<%@page import="javax.naming.Context,javax.sql.DataSource,java.sql.*,javax.naming.InitialContext"%>
<%
DataSource ds=null;
try{
Context initCtx=new InitialContext();
ds=(javax.sql.DataSource)initCtx.lookup("myejb");
if(ds!=null){
out.println("已经获得数据源:"+ds.toString()+"<p>");
Connection con=ds.getConnection();
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from student");
out.println("以下是从数据库中读取出来的数据:<br/>");
while(rs.next()){
out.println("bookName:"+rs.getString(1)+"<br/>");
}
}
else{
out.println("连接数据源失败!");
}
}
catch(Exception e){
out.println(e);
e.printStackTrace();
}
%>