Tomcat配置SQLServer连接池

Context ctx = (Context) initCtx.lookup("java:comp/env");

Object obj = (Object) ctx.lookup("/Default_JDBC ");//获取连接池对象

javax.sql.DataSource ds = (javax.sql.DataSource) obj; //类型转换

conn = ds.getConnection();

Statement stmt = conn.createStatement();

PreparedStatement ps=conn.prepareStatement("select * from FinalOrderdata");

ResultSet rs=ps.executeQuery();

while(rs.next()){

out.println(rs.getString(1) "<BR>");

i ;

}

rs.close();

stmt.close();