基于Struts2+MySQL的多表出差明细表单

下载地址：http://download.csdn.net/detail/qq_33599520/9790629

项目结构：

UserAction

package com.mstf.action;import com.mstf.entity.Detail;import com.mstf.entity.User;import com.mstf.service.UserService;import com.opensymphony.xwork2.ActionContext;import java.sql.Timestamp;import java.util.List;import java.util.Map;public class UserAction {  private String msg; // 登录失败提示信息  private User user;  private Detail detail;  private String sheng;  private String shi;  private List<User> userList;  // 获得Session  Map<String, Object> session = ActionContext.getContext().getSession();  public User getUser() {    return user;  }  public void setUser(User user) {    this.user = user;  }  public String getMsg() {    return msg;  }  public void setMsg(String msg) {    this.msg = msg;  }  public List<User> getUserList() {    return userList;  }  public void setUserList(List<User> userList) {    this.userList = userList;  }  public Detail getDetail() {    return detail;  }  public void setDetail(Detail detail) {    this.detail = detail;  }  public String getSheng() {    return sheng;  }  public void setSheng(String sheng) {    this.sheng = sheng;  }  public String getShi() {    return shi;  }  public void setShi(String shi) {    this.shi = shi;  }  // 根据账号查询用户基本信息  public String userInfo() throws Exception {    Map<String, Object> session = ActionContext.getContext().getSession();    userList = UserService.userInfo((String) session.get("u_no"));    return "infoSucc";  }  // 登录  public String login() throws Exception {    String u_no = user.getU_no();    String u_pwd = user.getU_pwd();    if (UserService.userLogin(u_no, u_pwd)) {      session.put("u_no", u_no);      userInfo();      return "loginSucc";    } else {      msg = "您输入的账号或密码有误，请稍后重试！";      return "fail";    }  }  // 退出登录  public String outLogin() {    session.remove("u_no");    msg = "退出成功";    return "outSucc";  }  // 添加详情  public String add() throws Exception {    // 获得Request    String u_no = (String) session.get("u_no");    String[] d_city = detail.getD_city();    String d_whither = sheng + shi + ",";    String[] d_whithers = d_whither.split(",");    String[] d_type = detail.getD_type();    String[] d_intent = detail.getD_intent();    Timestamp[] d_start_date = detail.getD_start_date();    Timestamp[] d_stop_date = detail.getD_stop_date();    int[] d_business_number = detail.getD_business_number();    if ((null == d_city) || (null == d_whithers) || (null == d_intent) ||        (null == d_business_number)) {      session.put("addMsg", "带有*号的是必填项！");      return "addFail";    }    int result = UserService.add(d_city, d_whithers, d_type, d_intent,        d_start_date, d_stop_date, d_business_number, u_no);    if (result > 0) {      session.put("addMsg", "添加成功！");      return "addSucc";    } else {      session.put("addMsg", "添加失败！");      return "addFail";    }  }}

海外公司注册、海外银行开户、跨境平台代入驻、VAT、EPR等知识和在线办理：https://www.xlkjsw.com

原标题：基于Struts2+MySQL的多表出差明细表单

关键词：MYSQL