首先要注意完成跳转需要写完前台跳转后要写后台controller。
比如<form action="index" method="POST">这个写完后 后台得写
@RequestMapping(value = "/index", method = RequestMethod.POST,params="back")
public String back(UserBean userBean,Model model) {
return "index";
}
类似这样的错误别再范了。
首先登录界面:
<div>
<h3>登录信息</h3>
<form action="init1" th:object="${userBean}" method="post">
<div>
登录ID: <span><input name="userId" type="text" /></span>
</div>
<div>
密码: <span><input name="userPass" type="password" /></span>
</div>
<div>
<button type="submit" name="search" >登录</button>
</div>
<div>
<button type="submit" name="register" >注册</button>
</div>
</form>
</div>
登录之后可以完成输入帐号密码来登录,也可注册。
首先注册页面如下:
<h3>注册信息</h3>
<form action="addUser" th:object="${userBean}" method="post">
<div>
<span><label>ID<span style="display:inline;color:red;">*</span></label></span> <span><input name="userId" type="text" /></span>
</div>
<div>
<span><label>密码<span style="display:inline;color:red;">*</span></label></span> <span><input name="userPass" type="password" /></span>
</div>
<div>
<span><label>确定密码<span style="display:inline;color:red;">*</span></label></span> <span><input name="userPass2" type="password" /></span>
</div>
<div>
<span><label>用户名<span style="display:inline;color:red;">*</span></label></span> <span><input name="userName" type="text" /></span>
</div>
<div>
<span><input type="submit" name="addUser" value="确定" /></span>
</div>
<span th:text="${message}"></span>
</form>
注册就是对数据库进行插入。
在service里这么写:
public int insert(UserBean frm){
int result=0;
try {
result=updateDao.execute("user.insertuser", frm);
}catch(Exception e){
return result;
}
return result;
最后在controller里面这么写:
@RequestMapping(value = "/addUser", method = RequestMethod.POST,params="addUser")
public String initadd(UserBean userinsert, Model model){
String pass1=userinsert.getUserPass();
String pass2=userinsert.getUserPass2();
if(pass1.equals(pass2)){
int insert = helloWorldService.insert(userinsert);
UserBean user=new UserBean();
model.addAttribute("userBean",user);
if(insert==1){
model.addAttribute("message","注册成功!");
return "back";
}
else{
model.addAttribute("message","注册失败!");
return "back";
}
}else{
model.addAttribute("message","注册失败!");
return "back";
}
其中的equals语句是用来判断两次密码是否输入一致的,需要在userBean中调用两个密码的get方法,也就是建立两个来完成。
然后是登录。
登录就是先搜索一次数据库是否有输入的帐号密码。
代码是:
@RequestMapping(value = "/init1", method = RequestMethod.POST,params="search")
public String initLogin(UserBean userBean, Model model) {
UserBean result = helloWorldService.searchUser(userBean);
List<UserBean>result1 =helloWorldService.searchUserall(userBean);
if(result != null) {
model.addAttribute("List", result1);
return "search";
}else{
model.addAttribute("message", "登录失败!");
return "index";
第一步搜索完老师让完成搜索全部用户信息上面代码完成。
第一次select的Spl文是:
<select id="selectuser"
parameterClass="cn.training.bean.UserBean"
resultClass="cn.training.bean.UserBean">
SELECT
user_id as userId,
userName as userName
FROM
user
WHERE
user_id = #userId#
AND userPass = #userPass#
</select>
第二次全检索的SQL文是:
<select id="selectuserall"
parameterClass="cn.training.bean.UserBean"
resultClass="cn.training.bean.UserBean">
SELECT
user_id as userId,
userName as userName
FROM
user
</select>
接下来是删除:
首先sql文是:
<delete id="deleteuser"
parameterClass="cn.training.bean.UserBean">
delete from user
WHERE
user_id = #userId#
</delete>
其次需要在search页面弄一个超链接点了之后删除,那么就要在search页面上写入下代码:
<div th:each="userInfo,status:${List}">
<form action="delete" th:object="${userBean}" method="POST">
<table>
<tr>
<td><a th:href="@{delete?(userId=${userInfo.userId})}">删不删?<span th:text="${userInfo.userId}">250</span></a></td>
<td><span th:text="${userInfo.userName}"></span></td>
</tr>
</table>
</form>
</div>
其中使用了List方法。
同时在controller中需要写入:
int result = helloWorldService.deleteUser(userBean);
同时我们弄了一个确认删除,取消删除的页面
代码入下:
<form action="Suredelete" method="POST">
<input name="userId" type="hidden" th:value="${userBean.userId}"/>
<button type="submit" name="delete" >确认删除</button>
<button type="submit" name="cancle" >取消删除</button>
</form>
而后我们要让这两个button有用的话,我们需要在controller里面写入:
@RequestMapping(value = "/Suredelete", method = RequestMethod.POST,params="delete")
public String suredelete(UserBean userBean, Model model) {
int result = helloWorldService.deleteUser(userBean);
List<UserBean> result1 = helloWorldService.searchUserall(userBean);
model.addAttribute("List", result1);
return "search";
}
@RequestMapping(value = "/Suredelete", method = RequestMethod.POST,params="cancle")
public String deleteno(UserBean userBean, Model model) {
List<UserBean> result1 = helloWorldService.searchUserall(userBean);
model.addAttribute("List", result1);
return "search";
}
大概内容就是这样。