pstate =connect.prepareStatement("select * from passengerMessage limit"+(pageNow-1)*pageSize+","+pageSize+";");这是报错的那一句
// pstate =connect.prepareStatement("select * from passengerMessage limit 0,5");
result = pstate.executeQuery();这一句没有运行
下面是全部代码----------------
=====================================================================
package servlets;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class SelectPassenger extends HttpServlet {
Connection connect = null;
PreparedStatement pstate = null;
ResultSet result = null;
public void doGet(HttpServletRequest req, HttpServletResponse res)
{
//业务逻辑
try
{
res.setContentType("text/html;charset=UTF-8");
res.setCharacterEncoding("UTF-8");
PrintWriter out = res.getWriter();
int pageSize = 5;//一页显示几条记录
int pageNow = 1;//希望显示第几页
int rowCount = 0;//一共有几条记录(查表)
int pageCount = 0;//一共有几页(计算)
//动态的接收pageNow
String sPageNow = req.getParameter("pageNow");
if(sPageNow!=null)
{
pageNow = Integer.parseInt(sPageNow);
}
//得到rowCount
//加载jdbc驱动
Class.forName("com.mysql.jdbc.Driver");
//得到数据库连接
connect=DriverManager.getConnection("jdbc:mysql://localhost:3306/flightTicket","root","flight");
pstate = connect.prepareStatement("select count(*) from passengerMessage");
result = pstate.executeQuery();
if(result.next()) { rowCount = result.getInt(1);//获得数据库中的记录条数
}
System.out.println(rowCount+"条数据");
//计算pageCount
if(rowCount%pageSize==0)
{
pageCount = rowCount/pageSize;
}
else
{
pageCount = rowCount/pageSize+1;
}
System.out.println(pageCount+"pageCount");
System.out.println(pageSize+"pageSize");
System.out.println(pageNow+"pageNow");
pstate =connect.prepareStatement("select * from passengerMessage limit"+(pageNow-1)*pageSize+","+pageSize+";");
// pstate =connect.prepareStatement("select * from passengerMessage limit 0,5");
result = pstate.executeQuery();
System.out.println(pageSize+"pageSize");
out.println("<table border=1>");
out.println("<tr><th>passengerName</th><th>IDCard</th><th>PTel</th></tr>");
while(result.next())
{
out.println("<tr>");
out.println("<td>"+result.getString(1)+"</td>");
out.println("<td>"+result.getString(2)+"</td>");
out.println("<td>"+result.getString(3)+"</td>");
out.println("</tr>");
}
out.println("</table>");
if(pageNow>1)
{
out.println("<a href=SelectPassenger?pageNow="+(pageNow-1)+">上一页</a>");
}
//显示超链接
for(int i=1;i<=pageCount;i++)
{
out.println("<a href=SelectPassenger?pageNow="+i+">"+i+"</a>");
}
if(pageNow<pageCount)
{
out.println("<a href=SelectPassenger?pageNow="+(pageNow+1)+">下一页</a>");
}
}
catch(Exception e)
{
e.printStackTrace();
}
}
public void doPost(HttpServletRequest req,HttpServletResponse res)
{
this.doGet(req,res);
}
}