信用卡管理系统信用卡管理系统

/* * Generated by MyEclipse Struts * Template path: templates/java/JavaClass.vtl */ package com.jd.icc.struts.action; import java.sql.*; import java.text.SimpleDateFormat; import java.util.ArrayList; 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 com.jd.icc.struts.form.AccountActionForm; import com.jd.icc.struts.form.UseractionForm; import com.jd.icc.entity.*; import com.jd.icc.jdbc.*; /** * MyEclipse Struts * Creation date: 12-21-2010 * * XDoclet definition: * @struts.action path="/accountAction" name="accountActionForm" input="/staff/addcustomer.jsp" parameter="method" scope="request" validate="true" */ public class AccountActionAction extends DispatchAction { /* * Generated Methods */ /** * Method execute * @param mapping * @param form * @param request * @param response * @return ActionForward */ public ActionForward addcustomer(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { AccountActionForm accountActionForm = (AccountActionForm) form;// TODO Auto-generated method stub ConData cd=new ConData(); Connection conn=cd.connectionDB(); //获取要插入的信息 Date nowTime=new Date(); SimpleDateFormat matter=new SimpleDateFormat("yyyy-MM-dd"); String time = matter.format(nowTime); String name=accountActionForm.getName(); String gender=accountActionForm.getGender(); String id=accountActionForm.getId(); String address=accountActionForm.getAddress(); String tel=accountActionForm.getTel(); String mobile=accountActionForm.getMobile(); String email=accountActionForm.getEmail(); String overdraft="2000"; String deficit=accountActionForm.getDeficit(); if(Integer.parseInt(deficit)==0){ overdraft="3000"; } else if(Integer.parseInt(deficit)==2){ overdraft="1000"; } String bank=accountActionForm.getBank(); //添加基本信息 String sql1="insert into customer(Name,Gender,ID,Address,Email,Tel,Mobile) values('"+name+"',"+gender+",'"+id+"','"+address+"','"+email+"','"+tel+"','"+mobile+"')"; // System.out.println(sql1); cd.updateDB(conn, sql1); //添加账号信息 String sql2="insert into account(AccountNO,AccountDate,Bank,Overdraft,Deficit) values('"+id+"','"+time+"','"+bank+"',"+overdraft+","+deficit+")"; cd.updateDB(conn, sql2); // System.out.println(sql2); return mapping.findForward("addaccount"); } public ActionForward allinfo(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { AccountActionForm accountActionForm = (AccountActionForm) form; // System.out.println("allinfo"); String sql="select AccountNO,ID,Name,Tel,Mobile,Email,Address from customer ,account where AccountNO=ID"; try { ConData cd=new ConData(); Connection conn=cd.connectionDB(); Statement stat=conn.createStatement(); ResultSet rs=stat.executeQuery(sql); rs.last(); int count = rs.getRow(); rs.beforeFirst(); List<customer> list = new ArrayList(); for(int i=0;i<count;i++) { if(rs.next()) { customer c = new customer(); c.setAccountNO(rs.getString("AccountNO")); c.setId(rs.getString("ID")); c.setName(rs.getString("Name")); c.setTel(rs.getString("Tel")); c.setMobile(rs.getString("Mobile")); c.setEmail(rs.getString("Email")); c.setAddress(rs.getString("Address")); list.add(i,c); } } request.setAttribute("list",list); } catch (SQLException e) { e.printStackTrace(); } return mapping.findForward("allcustomer"); } public ActionForward edit(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { AccountActionForm accountActionForm = (AccountActionForm) form; String id=request.getParameter("id"); String sql="select * from customer where ID='"+id+"'"; ConData cd= new ConData(); Connection conn=cd.connectionDB(); Statement stat; try { stat = conn.createStatement(); ResultSet rs=stat.executeQuery(sql); rs.last(); int count = rs.getRow(); rs.beforeFirst(); List<customer> list = new ArrayList(); for(int i=0;i<count;i++) { if(rs.next()) { customer c = new customer(); c.setClient(rs.getString("Client")); c.setGender(rs.getString("Gender")); c.setId(rs.getString("ID")); c.setName(rs.getString("Name")); c.setTel(rs.getString("Tel")); c.setMobile(rs.getString("Mobile")); c.setEmail(rs.getString("Email")); c.setAddress(rs.getString("Address")); list.add(i,c); } } request.setAttribute("list",list); } catch (SQLException e) { e.printStackTrace(); } System.out.println(id); return mapping.findForward("editcustomer"); } //更新客户的基本信息 public ActionForward update(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { AccountActionForm accountActionForm = (AccountActionForm) form; String id=request.getParameter("id"); String sql="update customer set Address='"+accountActionForm.getAddress()+"',Email='"+accountActionForm.getEmail()+"',Tel='"+accountActionForm.getTel()+"',Mobile='"+accountActionForm.getMobile()+"' where ID='"+id+"'"; ConData cd=new ConData(); Connection conn=cd.connectionDB(); Statement stat; try { stat = conn.createStatement(); stat.executeUpdate(sql); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } System.out.println(sql); return mapping.findForward("upsuc"); } //删除 public ActionForward delete(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { AccountActionForm accountActionForm = (AccountActionForm) form; return null; } //通过身份证号选择出对应的账号 public ActionForward select(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { AccountActionForm accountActionForm = (AccountActionForm) form; String id=accountActionForm.getId(); String sql="select AccountNO,ID,Name,Tel,Mobile,Email,Address from customer ,account where AccountNO=ID"; if(id!="") sql+=" and ID='"+id+"'"; try { ConData cd=new ConData(); Connection conn=cd.connectionDB(); Statement stat=conn.createStatement(); ResultSet rs=stat.executeQuery(sql); rs.last(); int count = rs.getRow(); rs.beforeFirst(); List<customer> list = new ArrayList(); for(int i=0;i<count;i++) { if(rs.next()) { customer c = new customer(); c.setAccountNO(rs.getString("AccountNO")); c.setId(rs.getString("ID")); c.setName(rs.getString("Name")); c.setTel(rs.getString("Tel")); c.setMobile(rs.getString("Mobile")); c.setEmail(rs.getString("Email")); c.setAddress(rs.getString("Address")); list.add(i,c); } } request.setAttribute("list",list); } catch (SQLException e) { e.printStackTrace(); } return mapping.findForward("allcustomer"); } public ActionForward allaccount(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { AccountActionForm accountActionForm = (AccountActionForm) form; String sql="select AccountNO,Balance,Overdraft,Deficit,ID,Name,Tel from customer ,account where AccountNO=ID"; ConData cd=new ConData(); Connection conn=cd.connectionDB(); Statement stat; try { stat = conn.createStatement(); ResultSet rs=stat.executeQuery(sql); rs.last(); int count = rs.getRow();