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);
}
} servletsexceptionservlet
解决方案 »
- 购物车 首次刷新会报错,二次后有不会了
- alert(xmlHttp.status)乱码?在线等!急啊,解决立刻给分
- 各位做的系统权限是怎么设计的?
- jsp运行时的错误.貌似简单.求解决
- 连接问题
- 迷途的羔羊:我现在是学JSTL还是直接跳过学JSF呢?谢谢!!!
- 一个经典的分页例子!欢迎各位达人进来看看
- 在ASP中返回的記錄集可用getrow()直接賦給一個數據,請問各位大俠在jsp中是怎樣實現???
- 如何在JAVA写的窗口程序里面内嵌IE或其它的浏览器或者怎么样自己实现浏览网站的功能?
- URL中的空格该怎么解决?
- 表单元素赋值
- FAIL - Application at context path /openbravo could not be started
这是什么??
pstate =connect.prepareStatement("select * from passengerMessage limit"+(pageNow-1)*pageSize+","+pageSize+";");这个要改的话或许应该在limit后面加个空格
扯淡,JDBC直接执行带分号的sql,能对才怪。