時間：2023-09-19 23:24:01 | 來源：網(wǎng)站運營
時間：2023-09-19 23:24:01 來源：網(wǎng)站運營
博客網(wǎng)站的設(shè)計與實現(xiàn)：
在線咨詢
//用戶登錄 public String login2() throws IOException { HttpServletRequest request = this.getRequest(); PrintWriter writer = this.getPrintWriter(); String username = request.getParameter("username"); String password = request.getParameter("password"); User user = userDao.selectBean(" where username = '" + username + "' and password= '" + password + "' and deletestatus=0 and role=2 and status=0 "); if (user != null) { HttpSession session = request.getSession(); session.setAttribute("user", user); writer.print("<script language=javascript>window.location.href='index.action';</script>"); } else { writer.print("<script language=javascript>alert('用戶名或者密碼錯誤或者賬戶已封禁');window.location.href='indexmethod!login.action';</script>"); } return null; }說明：本段代碼是程序的登陸代碼，首先從獲取從頁面輸入的用戶名、密碼，然后調(diào)用userDao.selectBean方法，從數(shù)據(jù)庫里取出該條記錄進(jìn)行判斷，如果該條記錄存在，則說明：用戶登陸成功，同時把用戶信息存在session里面方便調(diào)用，如果記錄為空，則跳轉(zhuǎn)到登陸頁面，同時提醒用戶錯誤信息。//博文列表 public String articlelist() { HttpServletRequest request = this.getRequest(); String atitle = request.getParameter("atitle"); StringBuffer sb = new StringBuffer(); sb.append(" where "); if (atitle != null && !"".equals(atitle)) { sb.append("atitle like '%" + atitle + "%'"); sb.append(" and "); request.setAttribute("atitle", atitle); } HttpSession session = request.getSession(); User user = (User)session.getAttribute("user"); sb.append(" articledelete=0 and user.id="+user.getId()+" order by id desc "); String where = sb.toString(); int currentpage = 1; int pagesize = 10; if (request.getParameter("pagenum") != null) { currentpage = Integer.parseInt(request.getParameter("pagenum")); } int total = articleDao.selectBeanCount(where.replaceAll("order by id desc", "")); request.setAttribute("list", articleDao.selectBeanList((currentpage - 1) * pagesize, pagesize, where)); request.setAttribute("pagerinfo", Pager.getPagerNormal(total, pagesize, currentpage, "usermethod!articlelist.action", "共有" + total + "條記錄")); request.setAttribute("url", "usermethod!articlelist.action"); request.setAttribute("url2", "usermethod!article"); request.setAttribute("title", "博文管理"); this.setUrl("user/article/articlelist.jsp"); return SUCCESS; }說明：首先通過 String atitle = request.getParameter("atitle ");這句代碼從頁面獲取查詢的選項，然后通過if(atitle!=null &&!"".equals(atitle)){通過這句條件語句分別判斷下這個值是否為空，當(dāng)不為空時則通過StingBuffer 來疊加組裝查詢的sql語句，最后當(dāng)sql語句組裝好了之后，通過articleDao.selectBeanList方法來調(diào)用數(shù)據(jù)庫的查詢方法來查到符合條件的記錄，在通過request.setAttribute方法把查詢到的記錄傳到顯示的頁面。關(guān)鍵詞：設(shè)計,實現(xiàn)
微信公眾號
版權(quán)所有? 億企邦 1997-2025 保留一切法律許可權(quán)利。
