2019獨角獸企業重金招聘Python工程師標準>>>

今天做數據庫實現增刪改查功能，做了一天把登陸做好了，后來實現數據列表功能的時候登陸頁面又不能實現了，通過自己的努力改錯，調試，使部分功能實現了。

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>

轉載于:https://my.oschina.net/u/2411770/blog/480526

總結

以上是生活随笔為你收集整理的实现数据库的增删改查的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。