constants.java

基于Struts的电子银行系统

/*
 * Created on 2005-7-24
 *
 */
package banksystem;

//import java.sql.SQLException;

//import banksystem.exception.AccountNotExistException;
//import banksystem.exception.UserPasswordInvalidException;
import java.util.*;
/**
 * @author 曲本盛
 *
 * TODO Struts 项目实践
 */
public class Constants {
	//设置编码规范
	public static final String ISO_ENCODING = "8859_1";
	public static final String CN_ENODING = "GB2312";
	
	//设置Customer表中Status默认值为1
	public static final String STATUS_DEFAULT = "1";
	
	public static final String PROC_CREATE_CUSTOMERID = "{call prc_customerID(?,?)}";
	public static final String PROC_CREATE_TRADEID = "{call prc_tradeID(?,?)}";
	public static final String SQL_CUSTOMER_INSERT = "INSERT INTO Customer"+
      "(AccountID, UserName, Sex, LoginPass, TradePass, ID, Phone, Addr, OpenDate,Balance, Status)"+
	  "VALUES (?,?,?,?,?,?,?,?,?,?,?)";
	public static final String SQL_CUSTOMER_UPDATE = "UPDATE Customer "+
	"SET UserName=?, Sex=?, LoginPass=?, TradePass=?, ID=?, Phone=?, Addr=? "+
	" WHERE AccountID=?";
	public static final String SQL_CUSTOMER_LOGOUT = "UPDATE Customer SET Status='2' WHERE AccountID=?";
	public static final String SQL_CUSTOMER_SELECT = "select AccountID, UserName, Sex, LoginPass, TradePass, ID, Phone, Addr, OpenDate,Balance, Status from Customer";
	public static final String SQL_TRADE_INSERT = "INSERT INTO Trade"+
		"(TradeID,AccountID,TransferAccountID,Type,Money,TradeDate) values(?,?,?,?,?,?)";
	public static final String SQL_TRADE_SELECT = "SELECT TradeID,AccountID,TransferAccountID,Type,Money,TradeDate FROM Trade";
	public static final String TABLE_CUSTOMER = "Customer";
	public static final String TABLE_TRADE = "Trade";
	
	public static final String SQL_COLUMNNAME_ACCOUNTID="AccountID";
	public static final String SQL_COLUMNNAME_TRADEDATE = "TradeDate";
	
	
	public static final String INSERT_FAILED = "errors.InsertFailed";
	public static final String UPDATE_FAILED = "errors.UpdateFailed";
	public static final String DATABASE_CLOSE_FAILED="DataBase Close failed";
	
	
	public static final String ERRORS_ACCOUNT_NOT_EXIST = "errors.AccountNotExist";
	public static final String ERRORS_USER_PASSWARD_INVALID = "errors.UserPasswordInvalid";
	public static final String ERRORS_BALANCE_NOT_ENOUGH ="errors.BalanceNotEnough";
	public static final String ERRORS_TRANFER_NOT_EXIST = "errors.TransferNotExist";
	public static final String ERRORS_ACCOUNT_FREEZED = "errors.AccountFreezed";
	public static final String ERRORS_INVALID_INPUT = "errors.invalidInput";
	public static final String ERRORS_NO_RECORD_EXCEPTION = "errors.noRecord";
	public static final String ERRORS_SESSION_INVALID = "errors.SessionInvalid";
	public static final String ERRORS_UNKNOWN_EXCEPTION = "errors.UnknownException";
	public static final String ERRORS_DATA_SAVE_EXCEPTION = "errors.DataSaveException";
	public static final String ERRORS_SUBMIT_AGAIN = "errors.SubmitAgain";
	public static final String ERRORS_TRADEPASS_INVALID = "errors.TradePassInvalie";
	
	public static final int ERRORCODE_ACCOUNT_NOT_EXIST = 50010;
	public static final int ERRORCODE_BALANCE_NOT_ENOUGH = 50011;
	public static final int ERRORCODE_ACCOUNT_FREEZED = 50012;
	//session中的属性名
	public static final String KEY_CUSTOMER_INFO = "CustomerInfo";
	public static final String KEY_TRADE_INFO = "TradeInfo";
	//request中的属性名
	public static final String KEY_CUSTOMER_LOAD_INFO = "CustomerLoadInfo";
	public static final String KEY_TRADE_LOAD_INFO = "TradeLoadInfo";
	//查询出的结果集
	public static final String KEY_SEARCH_RESULT_TRADE = "TradeResult";
	public static final String KEY_SEARCH_RESULT_CUSTOMER = "CustomerResult";
	
	
	public static final String KEY_DATE_YEAR = "Date_Year";
	public static final String KEY_DATE_MONTH = "Date_Month";
	public static final String KEY_DATE_DAY = "Date_Day";
	public static final ArrayList YEAR = new ArrayList();
	public static final List getYearList(){
		YEAR.add("2005");
		YEAR.add("2006");
		YEAR.add("2007");
		YEAR.add("2008");
		YEAR.add("2009");
		YEAR.add("2010");
		YEAR.add("2011");
		YEAR.add("2012");
		YEAR.add("2013");
		YEAR.add("2014");
		return YEAR;
	}
	public static final ArrayList MONTH = new ArrayList();
	public static final List getMonthList(){
		MONTH.add("01");
		MONTH.add("02");
		MONTH.add("03");
		MONTH.add("04");
		MONTH.add("05");
		MONTH.add("06");
		MONTH.add("07");
		MONTH.add("08");
		MONTH.add("09");
		MONTH.add("10");
		MONTH.add("11");
		MONTH.add("12");	
		return MONTH;
	}
	public static final ArrayList DAY = new ArrayList();
	public static final List getDayList(){
		DAY.add("01");
		DAY.add("02");
		DAY.add("03");
		DAY.add("04");
		DAY.add("05");
		DAY.add("06");
		DAY.add("07");
		DAY.add("08");
		DAY.add("09");
		DAY.add("10");
		DAY.add("11");
		DAY.add("12");	
		DAY.add("13");	
		DAY.add("14");	
		DAY.add("15");	
		DAY.add("16");	
		DAY.add("17");	
		DAY.add("18");	
		DAY.add("19");	
		DAY.add("20");	
		DAY.add("21");	
		DAY.add("22");	
		DAY.add("23");	
		DAY.add("24");	
		DAY.add("25");	
		DAY.add("26");	
		DAY.add("27");	
		DAY.add("28");	
		DAY.add("29");	
		DAY.add("30");	
		DAY.add("31");	
		return DAY;
	}
}