jsp中mysql跳转后为空白_JSP 连接 MySQL为什么是 空白页

分页显示数据分页显示数据

java.sql.Connection sqlCon; //数据库连接对象

java.sql.Statement sqlStmt; //SQL语句对象

java.sql.ResultSet sqlRst; //结果集对象

java.lang.String strCon; //数据库连接字符串

java.lang.String strSQL; //SQL语句

int pagesize=5;

String CLASSFORNAME="com.mysql.jdbc.Driver";

String SERVANDDB="jdbc:mysql://localhost：3306/test";

String USER="root";

String PWD="312";

try

{

Class.forName(CLASSFORNAME);

sqlCon = java.sql.DriverManager.getConnection(SERVANDDB,USER,PWD);

sqlStmt = sqlCon.createStatement(java.sql.ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);

sqlRst = sqlStmt.executeQuery("select * from student");

out.println("

info 表信息

");

%>

int intPageSize;

int intRowCount;

int intPageCount;

int intPage;

int i;

java.lang.String strPage;

intPageSize=4;

strPage=request.getParameter("page");

if(strPage==null)

{

intPage=1;

}else{

intPage=java.lang.Integer.parseInt(strPage);

}

if(intPage<1)

{

intPage=1;

}

sqlRst.last();

intRowCount=sqlRst.getRow();

intPageCount=(intRowCount+intPageSize-1)/intPageSize;

if(intPage>intPageCount) intPage=intPageCount;

if(intPageCount>0)

{

sqlRst.absolute((intPage-1)*intPageSize+1);

}

%>

id

name

i=0;

while(i

{

%>

sqlRst.next();

i++;

}

%>

sqlRst.close();

%>

共个记录，分页显示，当前页是：第页

}

catch(Exception e)

{

e.printStackTrace();

}

%>

展开