jsp中论坛发帖翻页问题 select * from tablename where id >"+y+" order by id limit N,M-N 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 下一页(button)是JS,sql语句是jsp,那2者怎么结合使用啊 这是page控制帖子发表的方法,有问题吗?public List listByPage(int page){ page=1; int y=(page-1)*4; List list=new ArrayList(); if(list.size()==4){ page=page+1; //list.clear(); } try { conn=this.getConn(); String str="select * from TBL_MESSAGE where id>"+y+" order by id limit 4"; pstmt=conn.prepareStatement(str); rs=pstmt.executeQuery(); while(rs.next()){ Message message=new Message(); message.setId(rs.getInt("id")); message.setMessage(rs.getString("message")); message.setAuthor(rs.getString("author")); message.setPostTime(rs.getString("postTime").substring(0, 16)); list.add(message); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ closeAll(conn,pstmt,rs); } return list; }这是index.jsp里表单提交的serlvet:public class PostServlet extends HttpServlet { Connection conn=null; PreparedStatement pstmt=null; int page=1; public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request,response); } public void doPost(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { req.setCharacterEncoding("GBK"); res.setContentType("text/html;charset=gb2312"); PrintWriter out = res.getWriter(); String author=req.getParameter("name"); String message=req.getParameter("info"); String time=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date()); MessageDao md=new MessageDao(); List list=md.listByPage(page); Message m=new Message(); m.setMessage(message); m.setAuthor(author); m.setPostTime(time); int row=md.save(m); if(row==1){ out.println("发表成功"); if(list.size()==4*page){ res.sendRedirect("index.jsp?page="+(page+1)); list=md.listByPage(page+1); }else{ res.sendRedirect("index.jsp?page="+page); } }else{ out.println("发表失败"); } out.close(); }} 怎么实现用户评论的顶踩功能? 如何将EXCEL中的数据如何导入到MySQL中,能否提供一个方法 eclipse3.6.1 tomcat7.0 jdk6.0开发jsp web出现HTTP Status 404 关于struts作的网站的问题 使用MYEclipse做的项目,如果从原来的Struts1.1升级到Struts1.2? session值,取出后是空值??? 帮忙解决apache的问题 问个基本问题,POST和GET的区别! 学JSP 看什么书啊? :( 新人请问如何用el表达式??? getInitParameterNames()返回结果问题? 急问,100分求jsp中jar包的运用
public List listByPage(int page){
page=1;
int y=(page-1)*4;
List list=new ArrayList();
if(list.size()==4){
page=page+1;
//list.clear();
}
try {
conn=this.getConn();
String str="select * from TBL_MESSAGE where id>"+y+" order by id limit 4";
pstmt=conn.prepareStatement(str);
rs=pstmt.executeQuery();
while(rs.next()){
Message message=new Message();
message.setId(rs.getInt("id"));
message.setMessage(rs.getString("message"));
message.setAuthor(rs.getString("author"));
message.setPostTime(rs.getString("postTime").substring(0, 16));
list.add(message);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
closeAll(conn,pstmt,rs);
}
return list;
}这是index.jsp里表单提交的serlvet:
public class PostServlet extends HttpServlet {
Connection conn=null;
PreparedStatement pstmt=null;
int page=1; public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request,response);
} public void doPost(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException {
req.setCharacterEncoding("GBK");
res.setContentType("text/html;charset=gb2312");
PrintWriter out = res.getWriter();
String author=req.getParameter("name");
String message=req.getParameter("info");
String time=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date());
MessageDao md=new MessageDao();
List list=md.listByPage(page);
Message m=new Message();
m.setMessage(message);
m.setAuthor(author);
m.setPostTime(time);
int row=md.save(m);
if(row==1){
out.println("发表成功");
if(list.size()==4*page){
res.sendRedirect("index.jsp?page="+(page+1));
list=md.listByPage(page+1);
}else{
res.sendRedirect("index.jsp?page="+page);
}
}else{
out.println("发表失败");
}
out.close();
}
}