|-----四种不同的作用域区别!
<% pageContext.setAttribute("name", "小明");//pageContext:page作用域 只能在当前的页面使用 request.setAttribute("age", 12);//在一次请求中使用 session.setAttribute("address", "东湖边上");//会话,在默认或指定的时间内可以使用! application.setAttribute("gender", "男");//全局,何时何地都可以使用! %> |
cookie的使用:
|-------实体分页
|-----BizDaoImpl
//分页
@Override
public List<NewsInfo> getAllNewsInfoByPage(Page page) {
// TODO Auto-generated method stub
List<NewsInfo> list=new ArrayList<NewsInfo>();
try {
String sql="select * from news_info limit ?,?";
pst=getconn().prepareStatement(sql);
//赋值
pst.setInt(1, (page.getCurrentpage()-1)*page.getPagesize());
pst.setInt(2, page.getPagesize());
//执行
rs=pst.executeQuery();
while(rs.next()){
NewsInfo ni=new NewsInfo();
ni.setNews_id(rs.getInt(1));
ni.setType_id(rs.getInt(2));
ni.setNews_title(rs.getString(3));
ni.setNews_author(rs.getString(4));
ni.setNews_summary(rs.getString(5));
ni.setNews_content(rs.getString(6));
ni.setNews_pic(rs.getString(7));
list.add(ni); //装载
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
return list;
}
@Override
public int getSumNewsInfo() {
// TODO Auto-generated method stub
int cc=0;
try {
String sql="SELECT COUNT(1) FROM news_info";
pst=getconn().prepareStatement(sql); //预编译
//执行
rs=pst.executeQuery();
while(rs.next()){
cc=rs.getInt(1);
}
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
return cc;
}
|--PageServelt
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=UTF-8");
String uname= request.getParameter("uname");
String upwd= request.getParameter("upwd");
BizServiceImpl bs=new BizServiceImpl();
BizDaoImpl bdi= new BizDaoImpl();
bs.setBizDao(bdi); //注入
boolean flag=bdi.selectUser(uname, upwd);
HttpSession session=request.getSession();
PrintWriter out=response.getWriter();
if(flag){
//存用户名 键和值
session.setAttribute("name", uname);
Page pg=new Page();
int count=bdi.getSumNewsInfo();
pg.setSumcount(count);
pg.setLastpage(pg.getSumcount()%pg.getPagesize()==0?pg.getSumcount()/pg.getPagesize():pg.getSumcount()/pg.getPagesize()+1);
//首页
pg.setCurrentpage(1);
//List<NewsInfo> list= bdi.selectNewsInfo();
List<NewsInfo> list= bdi.getAllNewsInfoByPage(pg);
request.setAttribute("pg", pg);
request.setAttribute("list", list);
//转发哪个页面
request.getRequestDispatcher("admin/admin1.jsp").forward(request, response);