
复制<%@page contentType="text/html;charset=GB2312"%> <%@page import="javax.naming.*"%> <%@page import="javax.sql.*"%> <%@page import="java.sql.*"%> <% int n = 20; Connection conn = null; CallableStatement stmt = null; ResultSet rs = null; Context ctx = null; try { ctx = new InitialContext(); //获取连接池对象 DataSource ds = (DataSource) ctx.lookup("JNDITEST_150");//JNDITEST_150是据库记录集
weblogic数据源的
WordPress模板名字 //String strSql_p="GetDataByPage @SqlStr=\"select * from bzlist\", @PageSize=20, @CurrentPage=1"; String sproc="{?=call GetDataByPage(?,?,?)}"; conn = ds.getConnection(); stmt=conn.prepareCall(sproc); stmt.setString(2,"select * from bzlist"); stmt.setInt(3,20); stmt.setInt(4,1); rs=stmt.executeQuery(); out.print("<Tableborder=1><tr><th>分类号<th>标准编号<th>标准名称<th>文件路径</tr>"); while(rs.next()){ out.print("<tr><td>" + rs.getString("flh") + "</td>"); out.print("<td>" + rs.getString("bzbh") + "</td>"); out.print("<td>" + rs.getString("bzmc") + "</td>"); out.print("<td>" + rs.getString("path") + rs.getString("filenames") + rs.getString("ext") + "</td></tr>"); } out.print("</table>"); rs.close(); stmt.close(); conn.close(); } catch (Exception e) { System.out.println("错误如下:<br>" + e); e.printStackTrace(); } %> 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.30.31.32.33.34.35.36.37.38.39.40.
源码库(责任编辑:系统运维)