jsp应用struts改造后的用户登录和增删查该的简单例子

/* * Generated by MyEclipse Struts * Template path: templates/java/JavaClass.vtl */ package action; import java.io.UnsupportedEncodingException; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; 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 form.LoginForm; import dl.Login; import data.Conn; /** * MyEclipse Struts Creation date: 03-29-2009 * * XDoclet definition: * * @struts.action validate="true" */ public class LoginAction extends DispatchAction { /* * Generated Methods */ /** * Method execute * * @param mapping * @param form * @param request * @param response * @return ActionForward */ public ActionForward login(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { // TODO Auto-generated method stub LoginForm lfrom = (LoginForm) form; String user = lfrom.getUser(); String pass = lfrom.getPass(); boolean b = Login.login(user, pass); if (b) { return mapping.findForward("true"); } else { return mapping.findForward("false"); } } public ActionForward add(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { // TODO Auto-generated method stub LoginForm lfrom = (LoginForm) form; boolean b = false; String id = request.getParameter("id"); String user = lfrom.getUser(); String pass = lfrom.getPass(); String sql = "insert into user values('" + id + "','" + user + "','" + pass + "')"; String str = ""; HttpSession session = request.getSession(); int result = Conn.doUpdate(sql); if (result > 0) { str = "<font color='green'>添加成功！</font>"; b = true; } else { str = "<font color='red'>添加失败！</font>"; } session.setAttribute("str", str); if (b) { return mapping.findForward("AddOK"); } else { return mapping.findForward("AddWrong"); } } public ActionForward update(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { // TODO Auto-generated method stub LoginForm lfrom = (LoginForm) form; String user = lfrom.getUser(); String id = request.getParameter("id"); System.out.print(id); //lfrom.getId(); /* String id = ""; try { id = new String(request.getParameter("id").getBytes("ISO-8859-1")); } catch (UnsupportedEncodingException e) { // TODO Auto-generated catch block e.printStackTrace(); }*/ String pass = lfrom.getPass(); String sql = "update user set user='" + user + "',pass='" + pass + "'where id='" + id + "'"; System.out.print(sql); int n = Conn.doUpdate(sql); String str = ""; boolean b = false; HttpSession session = request.getSession(); if (n > 0) { str = "<font color='green'>修改成功！</font>"; b = true; } else { str = "<font color='red'>修改失败！</font>"; } session.setAttribute("str", str); Conn.closeConnection(); if (b) { return mapping.findForward("updateok"); } else { return mapping.findForward("updatefailed"); } } public ActionForward delete(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { // TODO Auto-generated method stub // LoginForm lfrom = (LoginForm) form; String id = ""; try { id = new String(request.getParameter("id").getBytes("ISO-8859-1")); } catch (UnsupportedEncodingException e) { // TODO Auto-generated catch block e.printStackTrace(); } String sql = "delete from user where id='" + id + "'"; int n = Conn.doUpdate(sql); String str = ""; HttpSession session = request.getSession(); if (n > 0) { str = "<font color='green'>删除成功！</font>"; } else { str = "<font color='green'>删除失败！</font>"; } session.setAttribute("str", str); Conn.closeConnection(); return mapping.findForward("delete"); } public ActionForward load(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { // TODO Auto-generated method stub // LoginForm lfrom = (LoginForm) form; return null; } }