public EventDTO(Evento e) {
this.id = e.getId();
this.name = e.getName();
this.invate = e.getInvate();
for (Account account : e.getAccessAccounts()) {
this.accessAccounts.add(AccountDTO.convertToTransport(account));
}
}
// basically makes a result set to return to the view for display purposes.
private AccountDTO createRowDTO(ResultSet rs) throws SQLException {
AccountDTO result = new AccountDTO();
result.setUsername(rs.getString("username"));
result.setPassword(rs.getString("password"));
return result;
}
private ActionForward doLogin(ActionMapping mapping, HttpServletRequest request) {
/** @todo: complete the business logic here, this is just a skeleton. */
String stuempno = request.getParameter("stuempno");
String password = request.getParameter("password");
DB2CustomerDAO customerdao = new DB2CustomerDAO();
DB2DeviceDAO devicedao = new DB2DeviceDAO();
DB2TradeCodeDAO tradecodedao = new DB2TradeCodeDAO();
try {
if (stuempno.equals("") || password.equals("")) {
ActionErrors errors = new ActionErrors();
errors.add("login", new ActionError("errors.empty"));
if (!errors.isEmpty()) {
saveErrors(request, errors);
}
return mapping.findForward("failure");
}
String ciphered = Util.DESEnc(password);
String sql =
"select * from ykt_cur.t_cif_customer cus "
+ "join ykt_cur.T_PIF_Card card on cus.Cut_id=card.Cosumer_id "
+
// "where cus.cut_id=" + stuempno +" and card.password='******' ";
"where cus.StuEmp_no='"
+ stuempno
+ "' and card.password='******' and card.state_id <> '2000'";
ArrayList customers = customerdao.RetriveCustomer(sql);
if (customers.size() == 0) {
ActionErrors errors = new ActionErrors();
errors.add("login", new ActionError("errors.login"));
if (!errors.isEmpty()) {
saveErrors(request, errors);
}
return mapping.findForward("failure");
} else {
HttpSession session = request.getSession(true);
HashMap device = devicedao.RetriveDevice();
HashMap trademsg = tradecodedao.RetriveTradeMsgs();
session.setAttribute("name", ((CustomerDTO) customers.get(0)).getCut_name());
int cutid = ((CustomerDTO) customers.get(0)).getCut_id();
session.setAttribute("cutid", new Integer(cutid));
session.setAttribute("stuempno", stuempno);
session.setAttribute("password", password);
session.setAttribute("device", device);
session.setAttribute("trademsg", trademsg);
DB2AccountDAO accountdao = new DB2AccountDAO();
ArrayList accounts = accountdao.getAccountInfo(stuempno);
if (accounts.size() == 0) {
ArrayList lossaccounts = accountdao.getLossAccountInfo(stuempno);
if (lossaccounts.size() > 0) {
AccountDTO acc = (AccountDTO) lossaccounts.get(0);
request.setAttribute("card_id", String.valueOf(acc.getCard_id()));
request.setAttribute("state", String.valueOf(acc.getState_id()));
}
return (mapping.findForward("isnull"));
}
Iterator i = accounts.iterator();
while (i.hasNext()) {
AccountDTO account = (AccountDTO) i.next();
String state = account.getState_id();
// 只有正常卡与写卡失败的卡可以挂失
if (KSConstant.CARDSTAT_NORMAL.equals(state) || KSConstant.CARDSTAT_WFAIL.equals(state)) {
session.setAttribute("card_id", new Long(account.getCard_id()));
session.setAttribute("account", account);
return (mapping.findForward("success"));
}
}
return (mapping.findForward("isnull"));
}
} catch (Exception e) {
e.printStackTrace();
ActionErrors errors = new ActionErrors();
errors.add("login", new ActionError("errors.login"));
if (!errors.isEmpty()) {
saveErrors(request, errors);
}
return mapping.findForward("failure");
}
}
