在helloword.html
<div><span th:text="${message}"></span></div>
<form action="init" th:object="${UserBean}" method="post">
<table><tr><td>登录界面</td></tr><tr><td>用户名:<input name="UserId" type="text"/></td></tr>
<tr><td>密码:<input name="PassWord" type="password"/></td></tr>
</table>
<button type="submit" name="dl">登 陆</button>
<button type="submit" name="zc">注 册</button></form>
在login.html
用户列表
<div th:each="userInfo,status:${list}">
<table><tr><td><a th:href="@{delete(userId=${userInfo.userId})}"><span th:text="${userInfo.userId}">
</span></a></td>
<td><a th:href="@{(userId=${userInfo.userId})}"><span th:text="${userInfo.userName}"></span></a>
</td></tr></table></div>
在register.html
<div><span th:text="${message}"></span></div>
<form action="initadd" th:object="${userBean}" method="post">
<table><tr><td><caption>注册界面</caption></td></tr>
<tr><td>ID:<input name="UserId" type="text"/></td></tr>
<tr><td>用户名:<input name="UserName" type="text"/></td></tr>
<tr><td>密码:<input name="passWord" type="password"/></td></tr>
<tr><td>确认密码:<input name="passWordconfim" type="password"/></td></tr>
<tr><td> <button type="sumbit" name="register">注册</button>
<button type="sumbit" name="return">返回首页</button></td></tr> </table><
/form>
在result.html
<span th:text="${message}"></span>
在sure.html
<form action="deletes" th:object="${UserBean}" method="post">
<input name="userId" type="hidden" th:value="${userBean.userId}"/>
<button name="yesdel" type="submit">确认删除</button>
<button name="nodel" type="submit">取消删除</button></form>
在usersqlmap.xml
<sqlMap namespace="User">
<select id="selectUser" parameterClass="cn.training.bean.UserBean"
resultClass="cn.training.bean.UserBean">
SELECT userid as userId, username as userName,password as passWord
FROM user where userid=#userId# and password=#passWord#
</select>
<select id="cxUser"parameterClass="cn.training.bean.UserBean"
resultClass="cn.training.bean.UserBean">
SELECT userid as userId,
username as userName,
password as passWord FROM user
</select>
<delete id="deleteUser" parameterClass="cn.training.bean.UserBean">
delete from user WHERE userid=#userId#
</delete>
<insert id="userinsert" parameterClass="cn.training.bean.UserBean">
insert into user values(#userId#,#userName#,#passWord#) </insert>
<update id="userupdate" parameterClass="cn.training.bean.UserBean">
UPDATE user SET username=#userName# WHERE userid=#userId# </update>
</sqlMap>
在userbean.java
package cn.training.bean;
public class UserBean {
private String userId;
public String getUserId() {
return userId; }
public void setUserId(String userId) {
this.userId = userId; }
private String userName;
public String getUserName() { return userName; }
public void setUserName(String userName) {
this.userName = userName; }
private String passWord;
public String getPassWord() {
return passWord; }
public void setPassWord(String passWord) {
this.passWord = passWord; }
private String passWordconfim;
public String getPassWordconfim() {
return passWordconfim; }
public void setPassWordconfim(String passWordconfim) {
this.passWordconfim = passWordconfim; }}
在hellowordcontroller.java
@RequestMapping(value = "/init", method = RequestMethod.POST,params="dl")
public String initLogin(UserBean userBean, Model model)
{UserBean result = helloWorldService.searchUser(userBean);
model.addAttribute("userBean", result);
if(result!=null){
List<UserBean> result1= helloWorldService.checkUser(userBean);
model.addAttribute("list", result1);
return "login"; }
else{ model.addAttribute("message", "用户名或密码错误");
return "helloWorld";}}
@RequestMapping(value = "/init", method = RequestMethod.POST,params="zc")
public String initregister(UserBean userBean, Model model)
{UserBean result = helloWorldService.searchUser(userBean);
model.addAttribute("userBean", result);return "register";}
@RequestMapping(value = "/initadd", method = RequestMethod.POST,params="register")
public String initinsert(UserBean userBean, Model model)
{String pass1=userBean.getPassWord();String pass2=userBean.getPassWordconfim();
if(pass1.equals(pass2)){
int insert=helloWorldService.insert(userBean);
if(insert==1) {
model.addAttribute("message","注册成功");
return "result"; }
else{ model.addAttribute("message","注册失败");
model.addAttribute("userBean",userBean);
return "register"; }}
else{ model.addAttribute("message","输入两次密码不一致");
model.addAttribute("userBean",userBean);
return "register"; = "/initadd", method = RequestMethod.POST,params="return")
public String returninsert(UserBean userBean, Model model) {
return "helloWorld"; }
@RequestMapping(value = "/delete", method = RequestMethod.GET)
public String delete(UserBean userBean, Model model) {
//int result = helloWorldService.deleteUser(userBean);
return "sure"; }
@RequestMapping(value = "/deletes", method = RequestMethod.POST,params="yesdel")
public String yesdelete(UserBean userBean, Model model) {
int result = helloWorldService.deleteUser(userBean);
List<UserBean> refresh=helloWorldService.checkUser(userBean);
model.addAttribute("list",refresh);
return "login"; }
@RequestMapping(value = "/deletes", method = RequestMethod.POST,params="nodel")
public String nodelete(UserBean userBean, Model model)
{// int result = helloWorldService.deleteUser(userBean);
List<UserBean> refresh=helloWorldService.checkUser(userBean);
model.addAttribute("list",refresh); return "login"; }}
在hellowordservice.java
public UserBean searchUser(UserBean result)
{result = queryDao.executeForObject("User.selectUser", result,UserBean.class);
//frm.setUserId("test");
return result;}
public List<UserBean> checkUser(UserBean frm) {
List<UserBean> result = queryDao.executeForObjectList("User.cxUser", frm);
return result;}
public int deleteUser(UserBean frm) {
int result = updateDao.execute("User.deleteUser", frm);
//frm.setUserId("test");
return result; }
//return result; //}
public int insert(UserBean frm) {
int result=0;
try{return updateDao.execute("User.userinsert", frm); }
catch(Exception e)
{result=999; }
return result; }