1. 连接数据库在context.xml中添加代码:
<Context>
<Resource
name="jdbc/TerasolunaSampleDataSource"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
username="root"
password="root"
url="jdbc:mysql://localhost:3306/test" //test为数据库名
useUnicode="true"
characterEncoding="UTF-8"
maxIdle="2"
maxWait="5000"
maxActive="4"/>
</Context>
2. 以UserID为查询条件查询数据库中的数据:
在HelloWorld.jsp中
<form action="name" method="post">
<input name="userID" type="text">
<button type="submit" name="login">search</button>
由上述代码中action="name"的路径往前
在HelloWorldControlller.java中
@RequestMapping(value = "/name", method = RequestMethod.POST)
public String nameLogin(UserBean UserBean,Model model) {
UserBean result=helloWorldService.searchname(UserBean); //找到searchname方法在HelloWorldService.java中,执行那个方法,将结果返回到UserBean中
model.addAttribute("UserBean",result);
return "login"; //最后返回到login.jsp页面显示结果
}
public UserBean searchname(UserBean nn) {
UserBean result = queryDao.executeForObject("User.selectname", nn, UserBean.class);
return result;} //由User.selectname找到SQL文
在UserSqlMap.xml中:
<select id="selectname"
parameterClass="cn.training.controller.UserBean"
resultClass="cn.training.controller.UserBean">
SELECT UserID as userID,username FROM user WHERE UserID = #userID#
</select>
3. 在上述查询最后返回到login页面的基础上添加一个更新按钮,保存原有的id不变,修改ID所对应的name,单击更新按钮后将改后的值存入数据库中。然后用相似的思路创建更新按钮的事件
<update id="updatename"
parameterClass="cn.training.controller.UserBean">
UPDATE user SET username=#username# WHERE UserID = #userID#
</update>
public int updateUser(UserBean gg){
return updateDao.execute("User.updatename", gg);
}
@RequestMapping(value = "/update", method = RequestMethod.POST)
public String Login(UserBean UserBean,Model model) {
if(helloWorldService.updateUser(UserBean)!=0)
return "success";
else
return"login";
}
4. 往数据库中的表格添加一条记录,在输入框中输入要添加的数据,传值到UserBean,然后添加到数据库中
@RequestMapping(value = "/aa", method = RequestMethod.POST)
public String aaLogin(UserBean UserBean,Model model) {
if(helloWorldService.insertUser(UserBean)!=0)
return "success";
else
return"helloWorld";
}
public int insertUser(UserBean mm){
return updateDao.execute("User.insertUser", mm);
}
<insert id="insertUser"
parameterClass="cn.training.controller.UserBean">
INSERT INTO user VALUES(#userID#,#username#)
</insert>
5. 查询数据库表格中所有的记录,以表格的形式显示,并给ID加一个链接,转到delete事件,删除以ID为条件的记录,并显示剩余的记录,链接方式为
GET
@RequestMapping(value = "/list", method = RequestMethod.POST)
public String listLogin(UserBean UserBean,Model model) {
List<UserBean> result=helloWorldService.listUser(UserBean);
model.addAttribute("list",result);
return "list";
}
@RequestMapping(value = "/delete", method = RequestMethod.GET)
public String delete(UserBean UserBean,Model model) {
int result1=helloWorldService.deleteUser(UserBean);
model.addAttribute("list",result1);
List<UserBean> result=helloWorldService.listUser(UserBean);
model.addAttribute("list",result);
return "list";
}
public List<UserBean> listUser(UserBean ls) {
List<UserBean> result = queryDao.executeForObjectList("User.selectlistUser", ls);
return result;
}
public int deleteUser(UserBean de) {
return updateDao.execute("User.deleteUser", de);
}
<select id="selectlistUser"
parameterClass="cn.training.controller.UserBean"
resultClass="cn.training.controller.UserBean">
SELECT UserID as userID,username FROM user
</select>
<delete id="deleteUser"
parameterClass="cn.training.controller.UserBean">
DELETE FROM user WHERE UserID = #userID#
</delete>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<body>
<h2>用户信息</h2>
<table >
<tr>
<td>id</td>
<td>name</td>
</tr>
<c:forEach items="${list}" var="user" varStatus="status"> //c:forEach 循环使显示表中所有记录
<tr>
<td><a href="delete?userID=${user.userID}">${user.userID}</a></td> //链接为get方式
<td>${user.username}</td>
</tr>
</c:forEach>