struts与jdbc连接的实例

/* * Generated by MyEclipse Struts * Template path: templates/java/JavaClass.vtl */ package com.struststest.struts.action; import java.sql.ResultSet; import java.util.ArrayList; import java.util.Collection; 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 com.struststest.struts.form.AdduserForm; import com.strusttest.bean.UserBean; public class AdduserAction extends DispatchAction { public ActionForward save(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { AdduserForm adduserForm = (AdduserForm) form; String name = adduserForm.getName(); String password = adduserForm.getPassword(); String age = adduserForm.getAge(); try { new UserBean().save(name, password, age); return mapping.findForward("ok"); } catch (Exception e) { return mapping.findForward("error"); } } /*************************************************************************** * * 查询数据,以便更新 **************************************************************************/ public ActionForward getUsersByID(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { String id = request.getParameter("id").toString(); ResultSet rs = new UserBean().getData(id); AdduserForm adduserForm = (AdduserForm)form; try { while (rs.next()) { adduserForm.setId(id); adduserForm.setName(rs.getString("name")); adduserForm.setPassword(rs.getString("password")); adduserForm.setAge(rs.getString("age")); } } catch (Exception e) { e.printStackTrace(); } request.setAttribute("adduserForm", adduserForm); return mapping.findForward("edit"); } public ActionForward update(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { AdduserForm adduserForm = (AdduserForm) form; String id = request.getParameter("id").toString(); new UserBean().update(adduserForm.getName(), adduserForm.getPassword(), adduserForm.getAge(),id); List list = new ArrayList(); ResultSet rs = new UserBean().getList(); try { while (rs.next()) { AdduserForm adduserForm1 = new AdduserForm(); adduserForm1.setId(new Integer(rs.getInt("id")).toString()); adduserForm1.setName(rs.getString("name")); System.out.println(rs.getString("name")); adduserForm1.setPassword(rs.getString("password")); adduserForm1.setAge(rs.getString("age")); list.add(adduserForm1); } } catch (Exception e) { e.printStackTrace(); } request.setAttribute("list", list); return mapping.findForward("list"); } public ActionForward list(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { List list = new ArrayList(); ResultSet rs = new UserBean().getList(); try { while (rs.next()) { AdduserForm adduserForm = new AdduserForm(); adduserForm.setId(new Integer(rs.getInt("id")).toString()); adduserForm.setName(rs.getString("name")); System.out.println(rs.getString("name")); adduserForm.setPassword(rs.getString("password")); adduserForm.setAge(rs.getString("age")); list.add(adduserForm); } } catch (Exception e) { e.printStackTrace(); } request.setAttribute("list", list); return mapping.findForward("list"); } public ActionForward delete(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { String id = request.getParameter("id").toString(); new UserBean().delete(id); List list = new ArrayList(); ResultSet rs = new UserBean().getList(); try { while (rs.next()) { AdduserForm adduserForm = new AdduserForm(); adduserForm.setId(new Integer(rs.getInt("id")).toString()); adduserForm.setName(rs.getString("name")); System.out.println(rs.getString("name")); adduserForm.setPassword(rs.getString("password")); adduserForm.setAge(rs.getString("age")); list.add(adduserForm); } } catch (Exception e) { e.printStackTrace(); } request.setAttribute("list", list); return mapping.findForward("list"); } }