今天做数据库实现增删改查功能,做了一天把登陆做好了,后来实现数据列表功能的时候登陆页面又不能实现了,通过自己的努力改错,调试,使部分功能实现了。
1、在UserSqlMap.xml中键入关键代码
<select id="" 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=""parameterClass="cn.training.bean.UserBean"
resultClass="cn.training.bean.UserBean">
SELECT userid as userId, username as userName,
password as passWord FROM user
</select>
2、在UserBean.java中键入关键代码
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; }}
3、在hellowordservice.java中键入关键代码
public class HelloWorldService {
@Autowired QueryDAO queryDao;
@Autowired UpdateDAO updateDao;
public UserBean (UserBean result) {
result = ("User.", result,UserBean.class);
return result;}
public (UserBean frm)
{List<UserBean> result = queryDao.executeForObjectList(" null);return result; }
4、在hellowordController.java中键入关键代码
@RequestMapping(value = ", method = RequestMethod.POST,
public String initLogin(UserBean userBean, Model model)
{ result = helloWorldService.searchUser();
model.addAttribute("userBean", result);
if(){
List<UserBean> = helloWorldService.(userBean);
model.addAttribute("", );return "login";
}
else{ model.addAttribute("message", "您输入的用户名或密码错误");
return "helloWorld";}}
@RequestMapping(value = "/", method = RequestMethod.POST,params="a")
public String initregister(UserBean userBean, Model model)
{UserBean result = helloWorldService.searchUser(userBean);
model.addAttribute("userBean", result);
return "register";}
5、在helloworld.html中键入关键代码
<h3>登录信息</h3>
<form action="init" th:object="${UserBean}" method="post">
<span th:text="${message}"></span>
<div>
<span><label>用户名:</label></span> <span><input name="userId" type="text" /></span>
</div>
<div>
<span><label>密码:</label></span> <span><input name="password" type="password" /></span>
</div>
<div>
<span><input type="submit" value="登陆" name="a" /><input type="submit" value="注册" name="b"/></span>
</div>
</form>
<div class="clear"></div>
6、在register.html中键入关键代码
<h3>用户注册</h3>
<form action="register" th:object="${UserBean}" method="post">
<div>
<span><label>ID<span style="display:inline;color:red;"></span></label></span> <span><input name="password" type="password" /></span>
</div>
<div>
<span><label>用户名<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="password" type="password" /></span>
</div>
<div>
<span><label>确认密码</label></span> <span><input name="passwordConfirm" type="password" /></span>
</div>
<div>
<span><input type="submit" value="提交" /><input type="submit" value="后退" /></span>
</div>
<div class="clear"></div>