struts版的简单留言板

/* * Generated by MyEclipse Struts * Template path: templates/java/JavaClass.vtl */ package com.caiyi.guestbook.action; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.text.SimpleDateFormat; import java.util.Date; import java.util.List; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.struts.action.ActionForm; import org.apache.struts.action.ActionForward; import org.apache.struts.action.ActionMapping; import org.apache.struts.actions.DispatchAction; import org.apache.taglibs.standard.lang.jstl.parser.SimpleCharStream; import com.caiyi.guestbook.model.AdminDTO; import com.caiyi.guestbook.model.GuestBookDAO; import com.caiyi.guestbook.model.GuestBookDTO; import com.caiyi.guestbook.util.Pagable; public class GuestbookAction extends DispatchAction { private Connection con; private String cc; public ActionForward guestList(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { // 分页 String strPage = request.getParameter("page"); int showPage = 1; if (strPage != null) { showPage = Integer.parseInt(strPage); } // 搜索(拼凑SQL语句) String sql = "select * from users where 1=1"; String sqlCount = "select count(*) from users where 1=1"; try { System.out.println(1111111111); con = this.getDataSource(request).getConnection(); GuestBookDAO dao = new GuestBookDAO(con); List list = dao.findAll(sql, showPage, 4); // 通过dao调用findRecordNum查詢出数据库里面的总记录数ͨ��dao����findRecordNum��ԃ����ݿ�������ܼ�¼�� int totalRecords = dao.findRecordNum(sqlCount); con.close(); // 把所有分页的信息全部放到pagable里面去ȫ���ŵ�pagable����ȥ Pagable pages = new Pagable(list, showPage, 4, totalRecords, "guestbook.do?guest=guestList"); // 把pages对象里面的值存放到pages里 request.setAttribute("users", pages); List slist = dao.finalladmin(); request.setAttribute("admin", slist); } catch (SQLException e) { e.printStackTrace(); } finally { try { if (con != null & !con.isClosed()) { con.close(); } } catch (SQLException e) { e.printStackTrace(); } } return mapping.findForward("list"); } public ActionForward guestsList(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { // 分页 String strPage = request.getParameter("page"); int showPage = 1; if (strPage != null) { showPage = Integer.parseInt(strPage); } // 搜索(拼凑SQL语句) String sql = "select * from users where 1=1"; String sqlCount = "select count(*) from users where 1=1"; try { System.out.println(1111111111); con = this.getDataSource(request).getConnection(); GuestBookDAO dao = new GuestBookDAO(con); List list = dao.findAll(sql, showPage, 4); // 通过dao调用findRecordNum查詢出数据库里面的总记录数ͨ��dao����findRecordNum��ԃ����ݿ�������ܼ�¼�� int totalRecords = dao.findRecordNum(sqlCount); con.close(); // 把所有分页的信息全部放到pagable里面去ȫ���ŵ�pagable����ȥ Pagable pages = new Pagable(list, showPage, 4, totalRecords, "guestbook.do?guest=guestsList"); // 把pages对象里面的值存放到pages里 request.setAttribute("users", pages); List slist = dao.finalladmin(); request.setAttribute("admin", slist); } catch (SQLException e) { e.printStackTrace(); } finally { try { if (con != null & !con.isClosed()) { con.close(); } } catch (SQLException e) { e.printStackTrace(); } } return mapping.findForward("adminlist"); } public ActionForward admin(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { String username = request.getParameter("username"); String password = request.getParameter("password"); if (username == null && password == null) { username = ""; password = ""; } System.out.println("用户名"+ username); System.out.println("密 码"+ password); try { con = this.getDataSource(request).getConnection(); GuestBookDAO dao = new GuestBookDAO(con); AdminDTO dto = dao.findbyusername(username); if (username == "") { request.setAttribute("info","用户名，密码不能为空"); return mapping.findForward("login"); } else if (password.equals(dto.getPassword())) { request.getSession().setAttribute("userInfo", dto); return mapping.findForward("admin"); } else { request.setAttribute("err","用户，密码错误"); return mapping.findForward("login"); } } catch (SQLException e) { e.printStackTrace(); } finally { try { if (con != null & !con.isClosed()) { con.close(); } } catch (SQLException e) { e.printStackTrace(); } } return null; } public ActionForward guestPreEdit(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { System.out.println("guestPreEdit"); int id = Integer.parseInt(request.getParameter("id")); try { Connection con = this.getDataSource(request).getConnection(); GuestBookDAO dao = new GuestBookDAO(con); GuestBookDTO dto = dao.finbyid(id); request.setAttribute("dto", dto); } catch (SQLException e) { e.printStackTrace(); } finally { try { if (con != null & !con.isClosed()) { con.close(); } } catch (SQLException e) { e.printStackTrace(); } } return mapping.findForward("edit"); } public ActionForward guestPreEdit1(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { System.out.println("guestPreEdit1"); int id = Integer.parseInt(request.getParameter("id")); try { Connection con = this.getDataSource(request).getConnection(); GuestBookDAO dao = new GuestBookDAO(con); GuestBookDTO dto = dao.finbyid(id); request.setAttribute("dto", dto); } catch (SQLException e) { e.printStackTrace(); } finally { try { if (con != null & !con.isClosed()) { con.close(); } } catch (SQLException e) { e.printStackTrace(); } } return mapping.findForward("re"); } public ActionForward guestEdit1(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { System.out.println("guestEdit1"); String test = request.getParameter("recontent"); System.out.println("%%%%%%%%" + test); int id = Integer.parseInt(request.getParameter("id")); System.out.println("@@@@@@@" + id); GuestBookDTO dto = new GuestBookDTO(); dto.setText(test); dto.setId(id); try { Connection con = this.getDataSource(request).getConnection(); GuestBookDAO dao = new GuestBookDAO(con); dao.update1(dto); } catch (SQLException e) { e.printStackTrace(); } finally { try { if (con != null & !con.isClosed()) { con.close(); } } catch (SQLException e) { e.printStackTrace(); } } return mapping.findForward("admin"); } public ActionForward guestEdit(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { System.out.println("guestEdit"); String name = request.getParameter("name"); String context = request.getParameter("content"); String text = request.getParameter("recontent"); int id = Integer.parseInt(request.getParameter("id")); System.out.println("###########" + name); System.out.println("###########" + context); System.out.println("###########" + text); Syste