spring4.2+struts2.5+jdbc实例-PIMS(三)

来源:互联网 发布:淘宝日产手办 编辑:程序博客网 时间:2024/05/29 17:00

注册、个人信息管理功能实现


用户信息JavaBean:

public class MyMessBean implements Serializable {    private String name;    private String sex;    private String birth;    private String nation;    private String edu;    private String work;    private String phone;    private String place;    private String email;

注册页面:

<body>    <div id="headerDiv">        <h2>注册页面</h2>    </div>    <div id="bodyDiv">    <form action="register" method="post">        <table id="table">            <tr><td id="td-text"><s:textfield name="userName" label="登录名:"/></td></tr>            <tr><td id="td-text"><s:password name="password" label="密码:"/></td></tr>            <tr><td id="td-text"><s:password name="password1" label="再次输入密码:"/></td></tr>            <tr><td id="td-text"><s:textfield name="name" label="用户真实姓名:"/></td></tr>            <tr>                <td id="td-text"><s:text name="用户性别:"/></td>                <td id="td-text"><input type="radio" name="sex" value="男" checked/><input type="radio" name="sex" value="女" /></td>            </tr>            <tr><td id="td-text"><s:textfield name="birth" label="出生日期:"/></td></tr>            <tr><td id="td-text"><s:textfield name="nation" label="用户民族:"/></td></tr>            <tr><td id="td-text">                <s:select name="edu" label="用户学历:" headerValue="---请选择---" headerKey="1" list="{'博士','硕士','本科','专科','高中','初中','小学','其他'}"></s:select>            </td></tr>            <tr><td id="td-text">                <s:select name="work" label="用户职称:" headerValue="---请选择---" headerKey="1" list="{'软件测试工程师','教师','学生','职员','经理','老板','公务员','其他'}"></s:select>            </td></tr>            <tr><td id="td-text"><s:textfield name="phone" label="用户电话:"/></td></tr>            <tr><td id="td-text"><s:textfield name="place" label="用户住址:"/></td></tr>            <tr><td id="td-text"><s:textfield name="email" label="用户邮箱:"/></td></tr>        </table>    </div>    <div id="buttonDiv">        <button type="submit" class="button">提交</button>        <button type="reset" class="button">清空</button>     </div>    </form>    <div id="returnDiv">        <a href="http://localhost:8080/PIMS/index.jsp">返回</a>       </div></body>

注册registerAction:

    public String execute() throws Exception {        MessDaoImpl mdi = new MessDaoImpl();        //用户信息保存到数据库        String mess = mdi.insertMess(request,this.getUserName(),this.getPassword1(),this.getName(),this.getSex(),this.getBirth(),this.getNation(),this.getEdu(),this.getWork(),this.getPhone(),this.getPlace(),this.getEmail());        if(mess.equals("ok"))            return SUCCESS;        else if(mess.equals("one"))            return INPUT;        else            return ERROR;    }}

查看个人信息页面:

      <div>        <table id="table">          <%            //获取此用户个人信息            ArrayList MyMessage = (ArrayList)session.getAttribute("MyMess");            if(MyMessage==null||MyMessage.size()==0){                response.sendRedirect("http://localhost:8080/PIMS/index.jsp");            }else{                for(int i=MyMessage.size()-1;i>=0;i--){                    MyMessBean mess=(MyMessBean)MyMessage.get(i);                    %>                       <tr>                         <td id="td-text"><s:text name="用户姓名:"></s:text><%=mess.getName()%></td>                       </tr>                       <tr>                         <td id="td-text"><s:text name="用户性别:"></s:text><%=mess.getSex()%></td>                       </tr>                       <tr>                         <td id="td-text"><s:text name="出生日期:"></s:text><%=mess.getBirth()%></td>                       </tr>                       <tr>                         <td id="td-text"><s:text name="用户民族:"></s:text><%=mess.getNation()%></td>                       </tr>                       <tr>                         <td id="td-text"><s:text name="用户学历:"></s:text><%=mess.getEdu()%></td>                       </tr>                       <tr>                         <td id="td-text"><s:text name="用户职称:"></s:text><%=mess.getWork()%></td>                       </tr>                       <tr>                         <td id="td-text"><s:text name="用户电话:"></s:text><%=mess.getPhone()%></td>                       </tr>                       <tr>                         <td id="td-text"><s:text name="家庭住址:"></s:text><%=mess.getPlace()%></td>                       </tr>                       <tr>                         <td id="td-text"><s:text name="邮箱地址:"></s:text><%=mess.getEmail()%></td>                       </tr>                    <%                }            }          %>        </table>      </div>    </body>

更新个人信息页面:

     <div>      <s:form action="upMessAction" method="post">      <table id="table">          <%            //获取此用户个人信息            ArrayList MyMessage=(ArrayList)session.getAttribute("MyMess");            if(MyMessage==null||MyMessage.size()==0){                response.sendRedirect("http://localhost:8080/PIMS/index.jsp");            }else{                for(int i=MyMessage.size()-1;i>=0;i--){                    MyMessBean mess=(MyMessBean)MyMessage.get(i);                    %>                       <tr>                            <td id="td-text"><s:text name="用户姓名:"></s:text><input type="text" name="name" value="<%=mess.getName()%>" class="input"/></td>                       </tr>                       <tr>                            <td id="td-text"><s:text name="用户性别:"></s:text><input type="text" name="sex" value="<%=mess.getSex()%>" class="input"/></td>                       </tr>                       <tr>                            <td id="td-text"> <s:text name="出生日期:"></s:text><input type="text" name="birth" value="<%=mess.getBirth()%>" class="input"/></td>                       </tr>                       <tr>                            <td id="td-text"><s:text name="用户民族:"></s:text><input type="text" name="nation" value="<%=mess.getNation()%>" class="input"/></td>                       </tr>                       <tr>                            <td id="td-text"><s:text name="用户学历:"></s:text><input type="text" name="edu" value="<%=mess.getEdu()%>" class="input"/></td>                       </tr>                       <tr>                            <td id="td-text"><s:text name="用户职称:"></s:text><input type="text" name="work" value="<%=mess.getWork()%>" class="input"/></td>                       </tr>                       <tr>                            <td id="td-text"><s:text name="用户电话:"></s:text><input type="text" name="phone" value="<%=mess.getPhone()%>" class="input"/></td>                       </tr>                       <tr>                            <td id="td-text"><s:text name="家庭住址:"></s:text><input type="text" name="place" value="<%=mess.getPlace()%>" class="input"/></td>                       </tr>                       <tr>                            <td id="td-text"><s:text name="邮箱地址:"></s:text><input type="text" name="email" value="<%=mess.getEmail()%>" class="input"/></td>                       </tr>                    <%                }            }          %>        </table>        </div>        <div id="button">            <button type="submit">确 定</button>            &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;            <button type="reset" >清空</button>        </div>      </s:form>

更新信息updateMessAction:

 public String execute() throws Exception {        LoginDaoImpl LDI = new LoginDaoImpl();        MessDaoImpl MDI = new MessDaoImpl();        userName = LDI.returnLogin(request);        //调用更新方法        String mess=MDI.updateMess(request, userName, this.getName(), this.getSex(), this.getBirth(), this.getNation(), this.getEdu(), this.getWork(), this.getPhone(), this.getPlace(), this.getEmail());        return SUCCESS;    }  

更新密码页面:

      <div>      <s:form action="upPassAction" method="post">      <table id="table">          <%            ArrayList login=(ArrayList)session.getAttribute("userName");            if(login==null||login.size()==0){                response.sendRedirect("http://localhost:8080/PIMS/index.jsp");            }else{                for(int i=login.size()-1;i>=0;i--){                    UserNameBean nm=(UserNameBean)login.get(i);                    %>                       <tr>                           <td id="td-text"><s:text name="用户密码"></s:text><input class="input" type="text" name="password1" value="<%=nm.getPassword()%>"/></td>                       </tr>                       <tr>                         <td id="td-text"><s:text name="重复密码"></s:text><input class="input" type="text" name="password2" value="<%=nm.getPassword()%>"/></td>                       </tr>                    <%                    }            }          %>        </table>       </div>       <div id="button">       <input type="submit" value="确 定" size="12"/>        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;        <input type="reset" value="清 除" size="12"/>       </div>       </s:form>

更新密码updatePassAction:

public String execute() throws Exception {        LoginDaoImpl ldi = new LoginDaoImpl();        userName= ldi.returnLogin(request);        String pass= ldi.updatePass(request, userName, this.getPassword1());        if(pass.equals("ok")){            return SUCCESS;        }        return ERROR;    } 

对应DAO层代码:

    //保存用户信息    public String insertMess(HttpServletRequest request,String userName,String password,String name,String sex,String birth,String nation,String edu,String work,String phone,String place,String email) {        try{                    String sure = null;            rs = selectMess(request, userName);            if(rs.next()) {                sure = "one";            }else {                String sql = "insert into user" + "(userName,password,name,sex,birth,nation,edu,work,phone,place,email)" + "value(" + "'" + userName + "'" + "," + "'" + password + "'" + "," + "'" + name + "'" + "," + "'" + sex + "'" + "," + "'" + birth + "'" + "," + "'" + nation + "'" + "," + "'" +edu + "'" + "," + "'" + work + "'" + "," + "'" + phone + "'" + "," + "'" + place + "'" + "," + "'" + email + "')";                int row = st.executeUpdate(sql);                if(row == 1) {                    String mess = myMessage(request,userName);                    if(mess.equals("ok")) {                        sure = "ok";                    }else {                        sure = null;                    }                }else {                    sure = null;                }            }            return sure;        }catch(Exception e) {            e.printStackTrace();            return null;        }    }    //更新用户信息    public String updateMess(HttpServletRequest request,String userName,String name,String sex,String birth,String nation,String edu,String work,String phone,String place,String email) {        try {            String sure = null;            HttpSession session = request.getSession();            String sql = "update user set name='" + name + "',sex='" + sex + "',birth='" + birth + "',nation='" + nation + "',edu='"+ edu +"',work='"+ work +"',phone='"+ phone +"',place='"+ place +"',email='"+ email +"' where userName='" + userName + "'";            int row = st.executeUpdate(sql);                if(row == 1) {                    String mess = myMessage(request,userName);                    if(mess.equals("ok")) {                        sure = "ok";                    }else {                        sure = null;                    }                }else {                    sure = null;                }            return sure;        }catch(Exception e) {            e.printStackTrace();            return null;        }    }    //返回查询的用户信息    public ResultSet selectMess(HttpServletRequest request, String userName) {        try {            String sql = "select * from user where userName='" + userName + "'";            return st.executeQuery(sql);        }catch(Exception e) {            e.printStackTrace();            return null;        }    }    //获取用户信息并插入session    public String myMessage(HttpServletRequest request, String userName) {        try {            ArrayList listName = null;            HttpSession session = request.getSession();            listName = new ArrayList();            rs = selectMess(request,userName);            while(rs.next()) {                MyMessBean mess = new MyMessBean();                mess.setName(rs.getString("name"));                mess.setSex(rs.getString("sex"));                mess.setBirth(rs.getString("birth"));                mess.setNation(rs.getString("nation"));                mess.setEdu(rs.getString("edu"));                mess.setWork(rs.getString("work"));                mess.setPhone(rs.getString("phone"));                mess.setPlace(rs.getString("place"));                mess.setEmail(rs.getString("email"));                listName.add(mess);                session.setAttribute("MyMess",listName);            }            return "ok";        }catch(Exception e) {            e.printStackTrace();            return null;        }    }    //调用myMessage    public String addmess(HttpServletRequest request, String userName) {        String sure = null;        String mess = myMessage(request,userName);        if(mess.equals("ok")) {            sure = "ok";        }else {            sure = null;        }        return sure;    }}   
阅读全文
0 0
原创粉丝点击