nbsp;if(ctx==null) throw new Exception("没有匹配的环境"); DataSource ds=(DataSource)ctx.lookup("java:comp/env/jdbc/connectDB"); if(ds==null) throw new Exception("没有匹配数据库");
cnn=ds.getConnection(); stmt=cnn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); rs=stmt.executeQuery("select * from table1");