📄 indexservlet.java
字号:
//***************************************************************
//显示首页数据的servlet
//***************************************************************
package servlet;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import conn.*;
import bean.*;
import face.*;
import java.util.List;
import java.util.Iterator;
import util.*;
public class IndexServlet extends HttpServlet
{
public void init(ServletConfig config) throws ServletException
{
super.init(config);
}
public void service(ServletRequest request, ServletResponse respone) throws ServletException,IOException
{
request.setCharacterEncoding("gb2312"); //设置语言
String pageNo = request.getParameter("pageNo"); //获取当前页数
int current;
//如果页数为空,就把当前页数设置为“1”
if(pageNo == null)
{
current = 1;
}
else
{
current = Integer.parseInt(pageNo);
}
//获取一个out对象
PrintStream out = new PrintStream(respone.getOutputStream());
out.print("&page=" + current); //向flash传递当前页数
//异常处理机制
try
{
//获取一个操作数据类的对象
FlashDbDao dd = FlashDbDao.instance(Constants.driver,
Constants.url,Constants.username,Constants.password);
//定义一条sql语句
String sql = "select edition_id,edition_title,edition_content,us.user_name from bbs_edition ed,bbs_user us " +
"where ed.user_id = us.user_id";
dd.setPstmt(sql);
//获取一个分页类的对象
Pagination pager = new Pagination(dd);
//输出总页数
out.print("&count=" + pager.getNonce(current));
//设置每个分页显示的条数
pager.setPageSize(3);
//获取一个bean
EditionBean bb = new EditionBean();
out.print("&page=" + current); //向flash传递当前页数
out.print("&count=" + pager.getNonce(current)); //当前记录
out.print("&pageCount=" + pager.getPageCount()); //全部页数
List ls = pager.getPageResult(current,bb); //获取一个包含数据bean的list
String allId = "";
String allTitle = "";
String allContent = "";
String allUser = "";
//遍历list,把相应的数据累加在相应的字符串里,用“#”作为分割符
for(Iterator it = ls.iterator(); it.hasNext(); )
{
bb = (EditionBean)it.next();
allId += bb.getId() + "#";
allTitle += bb.getTitle() + "#";
allContent += bb.getContent() + "#";
allUser += bb.getUser() + "#";
}
//把数据输向flash
out.print("&allId=" + allId.substring(0, allId.length() -1));
out.print("&allTitle=" + allTitle.substring(0, allTitle.length() -1));
out.print("&allContent=" + allContent.substring(0, allContent.length() -1));
out.print("&allUser=" + allUser.substring(0, allUser.length() -1));
}
catch (Exception e)
{
System.out.println("index的数据异常!");
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -