%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="javax.naming.Context" %>
<%@ page import="javax.sql.DataSource"%>
<%@ page import="javax.naming.InitialContext"%>
<%@ page import="java.util.*"%>
<%@ page import="net.snapbug.util.dbtool.*"%>
舟山市普陀区审批办证服务中心
<%--
int intPageSize; //每页显示的记录数
int intRowCount; //记录总数
int intPageCount; //总页数
int intPage; //要显示的页码
String strPage; //获得网址后面的参数值
//取得要显示的页码
strPage = request.getParameter("page");
if(strPage==null){ //表示网址后面没有参数,显示第一页
intPage = 1;
}
else{
intPage = Integer.parseInt(strPage);
if(intPage<1) intPage = 1;
}
//DataSource ds = null;
try{
//Context iniCtx = new InitialContext();
//Context envCtx = (Context)iniCtx.lookup("java:comp/env");
//ds = (DataSource)envCtx.lookup("jdbc/TestDB");
//Connection cn = ds.getConnection();
ConnectionManager.init("/www/users/ptbz.gov.cn/DatabasePool.conf");
ConnectionManager.debug(true);
ConnectionPool cn = ConnectionManager.getConnectionPool("testSQLServer");
Statement stmt = cn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stmt.executeQuery("select count(*) from zxdt");
rs.next();
intRowCount = rs.getInt(1);
rs.close();
intPageSize=8;
intPageCount = (intRowCount+intPageSize-1)/intPageSize; //计算总页数
if (intPage>intPageCount) intPage = intPageCount; //调整要显示的页码
--%>
| |
| |
| |
| |
|
|
|
 |
 |
| |
| 版权所有 舟山市普陀区审批办证服务中心 |
| 设计制作:中心业务科 联系电话:0580-3820610 |
| 地址:浙江省舟山市普陀区东港海莲路行政综合大楼 |
| |
|
|
<%--cn.close();
}
catch(SQLException e)
{out.print(e);}
--%>