¼òµ¥µÄjsp·ÖÒ³

<%@ page import="java.sql.*,java.io.*" %>
<%
int intPage;//´ýÏÔʾµÄÒ³Âë
int pageSize;//ÿҳÏÔʾµÄÌõÄ¿
int pageCount;//×ÜÒ³Êý
int rowCount;//¼Ç¼×ÜÊý
String strPage;//»ñÈ¡´ýÏÔʾҳÂë
pageSize=12;//ÉèÖÃÿҳÏÔʾÌõÊý
Connection con;//Á¬½Ó¶ÔÏó
Statement stmt;//Êý¾Ý¿â¶ÔÏó
ResultSet rs£»//½á¹û¼¯
String strCon;//Á¬½Ó×Ö·û´®
strPage=request.getParameter("page");
if(strPage==null)
{
int page=1;
}
else
{
intPage=Integer.parseInt(strPage);
if(intPage<1)
intPage=1;
}
//×°ÔØSQLÇý¶¯
try
{
Class.forName("com.mysql.jdbc.Driver");
}
catch(ClassNotFoundException e)
{
out.print("¼ÓÔØÇý¶¯´íÎó");
}
//ÉèÖÃÁ¬½Ó×Ö·û´®
strCon="jdbc:mysql://localhost:3306/database";
//Á¬½ÓÊý¾Ý¿â
con=DriverManager.getConnection(strCon,"root","");
stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
//ÉèÖÃsqlÓï¾ä
strSql="select * from bwf_appraise order by appraiseDate desc";
//Ö´ÐÐSQLÓï¾ä²¢»ñÈ¡½á¹û¼¯
rs=stmt.executeQuery(strSql);
//»ñÈ¡¼Ç¼×ÜÊý
rs.last();
rowCount=rs.getRow()
%>