高效简单的jsp分

<table width=”760″ border=”0″ cellspacing=”0″ cellpadding=”0″ align=”center”>
<tr>
<td>
<table width=”750″ border=”0″ cellspacing=”2″ cellpadding=”2″ align=”center”>
<tr align=”center”>
<td> </td>
</tr>
<tr>
<td>
<table width=”740″ border=”0″ cellspacing=”1″ cellpadding=”1″ align=”center”>
<tr align=”center” bgcolor=”#CCCCCC”>
<td><b>祟}</b></td>
<td><b>作者</b></td>
<td><b>型</b></td>
<td><b>c</b></td>
<td><b>加入rg</b></td>
</tr>
<%
int i;
int ipage=5; //分挝
int allpage; //
int pages; //接受的a
int cpage=1; //前
int spage; //_始
int allCol=0;
Vector v=null;

//Y料B接明
Connection conn=null;
 java.lang.String sql,pagesql;
 java.sql.ResultSet rs,pagers;
 Statement statement=null;
 String kmsdb=”jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=DBName”;
 Class.forName(“com.microsoft.jdbc.sqlserver.SQLServerDriver”);
    conn = DriverManager.getConnection(kmsdb, “user”, “pwd”);
 
 pagesql = “SELECT COUNT(*) FROM  Authors”;

//取文章
statement = conn.createStatement();
pagers = statement.executeQuery(pagesql);
 while(pagers.next())
  {
  allCol = pagers.getInt(1);
  System.out.println(allCol);

  }
 
//@得面
allpage = (int)Math.ceil((allCol + ipage-1) / ipage);
//判pages是否空
if (request.getParameter(“pages”)==null) {
pages=1;
} else {
pages = new Integer(request.getParameter(“pages”)).intValue();
System.out.println(pages);
}
//判喈前
if(pages > allpage || pages == 0)
{cpage = 1;}
else
{
cpage = pages;
}
//判嗥鹗柬
sql = “select Top “+ipage+” au_id,au_lname,au_fname,address,phone from authors where au_id not in (select top “+(cpage-1)*ipage+” au_id from authors order by au_id desc)order by au_id desc”;
rs = statement.executeQuery(sql);
while (rs.next())
{
 au_id=rs.getString(“au_id”);
 au_lname=rs.getString(“au_lname”);
 au_fname=rs.getString(“au_fname”);
 phone=rs.getString(“phone”);
 address=rs.getString(“address”);

%> 
 <td width=”300″><%= au_id %></a></td>
 <td width=”300″><%= au_lname %></a></td>
 <td width=”300″><%= au_fname %></a></td>
 <td width=”300″><%= phone %></a></td>
 <td width=”300″><%= address %></a></td>
</tr>
<%    
}%>
<tr bgcolor=”#CCCCCC”>
<td colspan=”5″ align=”right” valign=”middle”>共 <%= allCol %>l 共 <%= allpage %> <% if (cpage>1) { %><a href=”fy.jsp?pages=<%= cpage-1 %>”><img src=”http://www.webjx.com/htmldata/2005-03-09/images/prev.gif” border=”0″></a><% } if (cpage<allpage) { %><a href=”fy.jsp?pages=<%= cpage+1 %>”><img src=”http://www.webjx.com/htmldata/2005-03-09/images/next.gif” border=”0″></a><% } %> / <% for (i=1;i<=allpage;i++) { if (i != pages) {%><a href=”fy.jsp?pages=<%= i %>”><%= i %></a> <% }} %></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>