所需要用到的其他工具或技术:
项目管理工具 : Maven
前台WEB展示：JSP
其他框架:Spring, Spring MVC
数据库 : Derby
新建一个Maven的Web项目
Maven Dependencies:
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
|
<!-- Spring --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <version>4.0.0.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>4.0.0.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-tx</artifactId> <version>4.0.0.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>4.0.0.RELEASE</version> </dependency> <!-- AspectJ --> <dependency> <groupId>org.aspectj</groupId> <artifactId>aspectjrt</artifactId> <version>1.6.10</version> </dependency> <!-- Logging --> <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-api</artifactId> <version>1.6.6</version> </dependency> <dependency> <groupId>org.slf4j</groupId> <artifactId>jcl-over-slf4j</artifactId> <version>1.6.6</version> <scope>runtime</scope> </dependency> <dependency> <groupId>org.slf4j</groupId> <artifactId>slf4j-log4j12</artifactId> <version>1.6.6</version> <scope>runtime</scope> </dependency> <!-- @Inject --> <dependency> <groupId>javax.inject</groupId> <artifactId>javax.inject</artifactId> <version>1</version> </dependency> <!-- Servlet --> <dependency> <groupId>javax.servlet</groupId> <artifactId>servlet-api</artifactId> <version>2.5</version> <scope>provided</scope> </dependency> <dependency> <groupId>javax.servlet.jsp</groupId> <artifactId>jsp-api</artifactId> <version>2.1</version> <scope>provided</scope> </dependency> <dependency> <groupId>javax.servlet</groupId> <artifactId>jstl</artifactId> <version>1.2</version> </dependency> <!-- Mybatis --> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.2.7</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>1.2.1</version> </dependency> <!-- Test --> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.9</version> <scope>test</scope> </dependency> <!-- Derby --> <dependency> <groupId>org.apache.derby</groupId> <artifactId>derby</artifactId> <version>10.10.2.0</version> </dependency> <dependency> <groupId>org.apache.derby</groupId> <artifactId>derbyclient</artifactId> <version>10.10.2.0</version> </dependency> |
SQL建表及数据插入
|
1
2
3
4
5
6
7
8
9
|
CREATE TABLE USER_TEST_TB( ID INT PRIMARY KEY, USERNAME VARCHAR(20) NOT NULL, PASSWORD VARCHAR(20) NOT NULL, NICKNAME VARCHAR(20) NOT NULL ); INSERT INTO USER_TEST_TB VALUES(1,'1st','111','Jack'); INSERT INTO USER_TEST_TB VALUES(2,'2nd','222','Rose'); INSERT INTO USER_TEST_TB VALUES(3,'3rd','333','Will'); |
web.xml（scr/main/webapp/WEB-INF下）
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
<?xml version="1.0" encoding="UTF-8"?> <web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"> <!-- Spring 的配置 --> <context-param> <param-name>contextConfigLocation</param-name> <param-value>/WEB-INF/*Context.xml</param-value> </context-param> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <servlet> <servlet-name>appServlet</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <load-on-startup>1</load-on-startup> </servlet> <servlet-mapping> <servlet-name>appServlet</servlet-name> <url-pattern>/</url-pattern> </servlet-mapping> </web-app> |
appServlet-servlet.xml（Spring的Servlet配置文件scr/main/webapp/WEB-INF下）
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
<?xml version="1.0" encoding="UTF-8"?> <beans:beans xmlns="http://www.springframework.org/schema/mvc" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:beans="http://www.springframework.org/schema/beans" xmlns:context="http://www.springframework.org/schema/context" xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd"> <!-- 开启Annotation支持 --> <annotation-driven /> <!-- Spring的渲染层配置 --> <beans:bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"> <beans:property name="prefix" value="/WEB-INF/views/" /> <beans:property name="suffix" value=".jsp" /> </beans:bean> <!-- Spring的Annotation默认扫描包 --> <context:component-scan base-package="com.bjpowernode.practice" /> <!-- 引入其他Spring配置文件 --> <beans:import resource="classpath:applicationContext.xml" /> </beans:beans> |
JSP文件
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
|
show.jsp(src/main/webapp/WEB-INF/views目录下)<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <title>Show All Users</title> <style type="text/css"> *{ margin: 0px; padding: 0px; } </style> </head> <body> <table border="1px" bordercolor="green"> <thead> <tr> <th>USER_NAME</th> <th>PASSWORD</th> <th>NICK_NAME</th> <th>EDIT</th> <th>DELETE</th> </tr> <c:forEach items="${users}" var="user" varStatus="status"> <tr> <td>${user.username}</td> <td>${user.password}</td> <td>${user.nickname}</td> <td><a href="update/${user.id}" rel="external nofollow" >edit</a></td> <td><a href="delete/${user.id}" rel="external nofollow" >delete</a></td> </tr> </c:forEach> </thead> </table> <a href="insert" rel="external nofollow" >Add new User</a> </body> </html> |
update.jsp(src/main/webapp/WEB-INF/views目录下)
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <title>Update Profile</title> </head> <body> <form action="${user.id}" method="post"> User ID:${user.id}<br> Username:<input type="text" name="username" value="${user.username}"/><br> Password:<input type="text" name="password" value="${user.password}"/><br> Nickname:<input type="text" name="nickname" value="${user.nickname}"/><br> <input type="submit" value="submit"> </form> </body> </html> |
insert.jsp(src/main/webapp/WEB-INF/views目录下)
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <title>Insert Profile</title> </head> <body> <form action="" method="post"> User Id:<input type="text" name="id"><br> Username:<input type="text" name="username" /><br> Password:<input type="text" name="password"/><br> Nickname:<input type="text" name="nickname"/><br> <input type="submit" value="submit"> </form> </body> </html> |
applicationContext.xml(Spring的Application配置文件在src/main/resources目录下)
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
|
<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context" xmlns:lang="http://www.springframework.org/schema/lang" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:mybatis-spring="http://mybatis.org/schema/mybatis-spring" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd http://www.springframework.org/schema/lang http://www.springframework.org/schema/lang/spring-lang-4.0.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring-1.2.xsd"> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="basePackage" value="com.bjpowernode.practice" /> <property name="sqlSessionFactoryBeanName" value="derbySqlSessionFactory" /> </bean> <!-- 配置Derby驱动数据源 --> <bean id="derbyDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="driverClassName" value="org.apache.derby.jdbc.ClientDriver" /> <property name="url" value="jdbc:derby://localhost:1527/freud;create=true" /> </bean> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean" name="derbySqlSessionFactory"> <property name="dataSource" ref="derbyDataSource" /> <property name="mapperLocations" value="classpath*:com/freud/practice/*Mapper.xml" /> </bean> <!-- 事务管理器 --> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource" ref="derbyDataSource" /> </bean> <!-- 开启基于注解的事务 --> <tx:annotation-driven /> </beans> |
Java文件
UserController.Java（在src/main/java/com.bjpowernode.practice.controller目录下）
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
|
package com.bjpowernode.practice.controller; import com.bjpowernode.practice.User; import com.bjpowernode.practice.UserMapper; import java.util.List; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.servlet.config.annotation.EnableWebMvc; @EnableWebMvc@Controllerpublic class UserController { @Autowired private UserMapper userMapper; /** * * 获得所有的User信息 * * @param model * @return */ @RequestMapping(value = {"/", ""}, method = RequestMethod.GET) public String getAllUser(Model model) { List<User> users = userMapper.getUsers(); System.out.println("Show all user size:" + users.size()); model.addAttribute("users", users); return "show"; } /** * * INSERT的GET请求，跳转到Insert的View即insert.jsp * * @return */ @RequestMapping(value = {"/insert", ""}, method = RequestMethod.GET) public String insertUser() { return "insert"; } /** * * INSERT的POST请求，执行插入操作并返回ShowAll页面 * * @param user * @return */ @RequestMapping(value = {"/insert", ""}, method = RequestMethod.POST) public String insertUserPOST(User user) { userMapper.insertUser(user); return "redirect:/"; } /** * * UPDATE的GET请求，跳转到update的View即update.jsp * * @param id * @param model * @return */ @RequestMapping(value = {"/update/{id}", ""}, method = RequestMethod.GET) public String updateUser(@PathVariable String id, Model model) { model.addAttribute("user", userMapper.getUser(Integer.valueOf(id))); return "update"; } /** * * UPDATE的POST请求，执行更新操作并返回ShowAll页面 * * @param id * @param user * @return */ @RequestMapping(value = {"/update/{id}", ""}, method = RequestMethod.POST) public String updateUserPOST(@PathVariable String id, User user) { userMapper.updateUser(user); return "redirect:/"; } /** * * 通过Id删除USER * * @param id * @return */ @RequestMapping(value = {"/delete/{id}", ""}, method = RequestMethod.GET) public String deleteUser(@PathVariable int id) { userMapper.deleteUser(id); return "redirect:/"; } } |
User.java(在src/main/java/com.bjpowernode.practice)
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
|
package com.bjpowernode.practice; /** * * User 对象。 * * @author Freud Kang * */public class User { private Integer id; private String username; private String password; private String nickname; public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public String getNickname() { return nickname; } public void setNickname(String nickname) { this.nickname = nickname; } } |
UserMapper.java(在src/main/java/com.bjpowernode.practice目录下)
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
|
package com.bjpowernode.practice; import java.util.List; public interface UserMapper { /** * * 获得所有User * * @return */ public List<User> getUsers(); /** * * 通过Id获得User * * @param id * @return */ public User getUser(int id); /** * * 插入User * * @param user */ public void insertUser(User user); /** * * 更新User * * @param user */ public void updateUser(User user); /** * * 通过Id删除User * * @param userId */ public void deleteUser(int userId); } |
UserMapper.xml（mybatis的mapper配置文件，在src/main/java/com.bjpowernode.practice目录下）
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.bjpowernode.practice.UserMapper"> <!-- 查询 --> <select id="getUsers" resultType="com.bjpowernode.practice.User"> select * from USER_TEST_TB </select> <!-- 查询 --> <select id="getUser" resultType="com.bjpowernode.practice.User"> select * from USER_TEST_TB where ID=#{id} </select> <!-- 插入 --> <insert id="insertUser"> insert into USER_TEST_TB values(#{id},#{username},#{password},#{nickname}) </insert> <!-- 更改 --> <update id="updateUser"> update USER_TEST_TB set USERNAME = #{username}, PASSWORD = #{password}, NICKNAME = #{nickname} where ID = #{id} </update> <!-- 删除 --> <delete id="deleteUser"> delete from USER_TEST_TB where ID=#{id} </delete> </mapper> |
总结
以上所述是小编给大家介绍的Mybatis集成Spring的实例代码，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对服务器之家网站的支持！
