站内搜索: 请输入搜索关键词

当前页面: 开发资料首页JSP 专题高效简单的jsp分??

高效简单的jsp分??

摘要: 高效简单的jsp分??


<%@ page import="java.sql.*,java.io.*,java.util.*" %>
<%@ page language="java" pageEncoding="Big5" %>
<%! String au_id,au_lname,au_fname,phone,address,city,state;%>
HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<head>
ArticleList
<link> rel="stylesheet" href="style.css">
</head>
<body bgcolor="#FFFFFF">

<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>&nbsp;</td>
</tr>
<tr>
<td>
<table width="740" border="0" cellspacing="1" cellpadding="1" align="center">
<tr align="center" bgcolor="#CCCCCC">
<td>?祟}</td>
<td>作者</td>
<td></td>
<td>?c </td>
<td>加入?r?g</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 %></td>
<td width="300"><%= au_lname %></td>
<td width="300"><%= au_fname %></td>
<td width="300"><%= phone %></td>
<td width="300"><%= address %></td>
</tr>
<%
}%>
<tr bgcolor="#CCCCCC">
<td colspan="5" align="right" valign="middle">共 <%= allCol %>?l 共 <%= allpage %> <% if (cpage>1) { %>"><% } if (cpage<% } %> / <% for (i=1;i<=allpage;i++) { if (i != pages) {%>"><%= i %>&nbsp;<% }} %></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>

</td> </tr> <tr> <td vAlign=top align=left height="100%">
↑返回目录
前一篇: Struts下JSP页面传递复选框值技巧
后一篇: JSP程序员成长之路