useraction.java

个人网上银行系统设计该系统使用MySQL数据库。

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package com.perwebbank.action;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.GregorianCalendar;

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.perwebbank.DBOpertion;
import com.perwebbank.form.LoginForm;
import com.perwebbank.form.RegistForm;
import com.perwebbank.form.ServerForm;

public class UserAction extends DispatchAction {
	private ArrayList<ServerForm> array = new ArrayList<ServerForm>();

	public ActionForward login(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws SQLException {
		LoginForm loginForm = (LoginForm) form;
		int account = Integer.parseInt(loginForm.getAccount());
		System.out.println("account:" + String.valueOf(account));
		String sql = "select * from customer where account='" + account
				+ "' and loginpass='" + loginForm.getLoginpass() + "'";
		DBOpertion.getStatement();
		ResultSet rs = DBOpertion.executeQuery(sql);
		if (rs.next()) {
			ServerForm serverForm = new ServerForm();
			serverForm.setAccount(String.valueOf(rs.getInt(1)));
			serverForm.setUsername(rs.getString(2));
			serverForm.setSex(String.valueOf(rs.getInt(3)));
			serverForm.setTradepass(rs.getString(5));
			serverForm.setPhone(rs.getString(7));
			serverForm.setAddress(rs.getString(8));
			serverForm.setBalance(rs.getString(10));
			serverForm.setStatus(String.valueOf(rs.getInt(11)));
			request.getSession().setAttribute("serverForm", serverForm);
			DBOpertion.closeResultSet(rs);
			DBOpertion.closeStatement();
			DBOpertion.closeConnection();
			return mapping.findForward("mainMenu");
		} else {
			DBOpertion.closeResultSet(rs);
			DBOpertion.closeStatement();
			DBOpertion.closeConnection();
			return mapping.findForward("loginerror");
		}
	}

	public ActionForward regist(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws SQLException {
		RegistForm registForm = (RegistForm) form;

		SimpleDateFormat dateformat = new SimpleDateFormat("yyyy-MM-dd");
		String date = dateformat.format(new GregorianCalendar().getTime());
		Double balance = Double.parseDouble(registForm.getBalance());
		String sqlInsert = "insert into customer (username,sex,loginpass,tradepass,id,phone,address,date,balance)"
				+ "values ('"
				+ registForm.getUsername()
				+ "','"
				+ Integer.parseInt(registForm.getSex())
				+ "','"
				+ registForm.getLoginpass()
				+ "','"
				+ registForm.getTradepass()
				+ "','"
				+ registForm.getId()
				+ "','"
				+ registForm.getPhone()
				+ "','"
				+ registForm.getAddress()
				+ "','"
				+ date
				+ "','"
				+ balance.doubleValue() + "')";
		DBOpertion.getStatement();
		DBOpertion.excuteInsert(sqlInsert);

		String sql = "select account from customer where username='"
				+ registForm.getUsername() + "' and sex='"
				+ Integer.parseInt(registForm.getSex()) + "' and loginpass='"
				+ registForm.getLoginpass() + "' and tradepass='"
				+ registForm.getTradepass() + "' and id='" + registForm.getId()
				+ "' and phone='" + registForm.getPhone() + "' and address='"
				+ registForm.getAddress() + "' and date='" + date
				+ "' and balance='" + balance.doubleValue() + "'";
		ResultSet rs = DBOpertion.executeQuery(sql);
		if (rs.next()) {
			ServerForm serverForm = new ServerForm();
			serverForm.setAccount(String.valueOf(rs.getInt(1)));
			serverForm.setUsername(registForm.getUsername());
			serverForm.setSex(registForm.getSex());
			serverForm.setTradepass(registForm.getTradepass());
			serverForm.setPhone(registForm.getPhone());
			serverForm.setAddress(registForm.getAddress());
			serverForm.setBalance(registForm.getBalance());
			serverForm.setStatus(String.valueOf(1));
			request.getSession().setAttribute("serverForm", serverForm);
			DBOpertion.closeResultSet(rs);
			DBOpertion.closeStatement();
			DBOpertion.closeConnection();
			return mapping.findForward("mainMenu");
		} else {
			DBOpertion.closeResultSet(rs);
			DBOpertion.closeStatement();
			DBOpertion.closeConnection();
			return mapping.findForward("registerror");
		}
	}

	public ActionForward modify(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws SQLException {
		RegistForm registForm = (RegistForm) form;
		ServerForm serverForm = (ServerForm) request.getSession().getAttribute(
				"serverForm");
		System.out.println("modity account:" + serverForm.getAccount());
		String sql = null;
		if (registForm.getAddress() == null && registForm.getPhone() != null) {
			sql = "Update customer set loginpass='" + registForm.getLoginpass()
					+ "', tradepass='" + registForm.getTradepass()
					+ "', phone='" + registForm.getPhone()
					+ "' where account='" + serverForm.getAccount() + "'";
		} else if (registForm.getAddress() != null
				&& registForm.getPhone() == null) {
			sql = "Update customer set loginpass='" + registForm.getLoginpass()
					+ "', tradepass='" + registForm.getTradepass() + "', address='"
					+ registForm.getAddress() + "' where account='"
					+ serverForm.getAccount() + "'";
		} else {
			sql = "Update customer set loginpass='" + registForm.getLoginpass()
					+ "', tradepass='" + registForm.getTradepass()+"', phone='"
					+ registForm.getPhone() + "', address='"
					+ registForm.getAddress() + "' where account='"
					+ serverForm.getAccount() + "'";
		}
		DBOpertion.getStatement();
		DBOpertion.exeuteUpdate(sql);
		serverForm.setAddress(registForm.getAddress());
		serverForm.setLoginpass(registForm.getLoginpass());
		serverForm.setPhone(registForm.getPhone());
		serverForm.setTradepass(registForm.getTradepass());
		request.getSession().setAttribute("serverForm", serverForm);
		DBOpertion.closeStatement();
		DBOpertion.closeConnection();
		return mapping.findForward("mainMenu");
	}

	public ActionForward checkAllAcount(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws SQLException {
		LoginForm loginForm = (LoginForm) form;
		String sql = "select * from admin where account='"
				+ Integer.parseInt(loginForm.getAccount())
				+ "' and loginpass='" + loginForm.getLoginpass() + "'";
		request.getSession().setAttribute("adminaccount",
				loginForm.getAccount());
		DBOpertion.getStatement();
		ResultSet rs = DBOpertion.executeQuery(sql);
		if (rs != null) {
			String checkAll = "select * from customer";
			ResultSet rsAll = DBOpertion.executeQuery(checkAll);
			while (rsAll.next()) {
				ServerForm sform = new ServerForm();
				sform.setAccount(String.valueOf(rsAll.getInt(1)));
				sform.setUsername(rsAll.getString(2));
				sform.setSex(String.valueOf(rsAll.getInt(3)));
				sform.setLoginpass(rsAll.getString(4));
				sform.setTradepass(rsAll.getString(5));
				sform.setId(rsAll.getString(6));
				sform.setPhone(rsAll.getString(7));
				sform.setAddress(rsAll.getString(8));
				sform.setTradedate(rsAll.getString(9));
				sform.setBalance(rsAll.getString(10));
				sform.setStatus(rsAll.getString(11));
				array.add(sform);
			}
			request.getSession().setAttribute("array", array);
			DBOpertion.closeResultSet(rsAll);
			DBOpertion.closeResultSet(rs);
			DBOpertion.closeStatement();
			DBOpertion.closeConnection();
			return mapping.findForward("admin");
		} else {
			DBOpertion.closeResultSet(rs);
			DBOpertion.closeStatement();
			DBOpertion.closeConnection();
			return mapping.findForward("adminerror");
		}
	}

}