个人中心
gpt4 book ai didi

Mybatis集成Spring的实例代码_动力节点Java 学院整理

转载 作者：qq735679552 更新时间：2022-09-28 22:32:09 27 4
gpt4 key购买 nike

CFSDN坚持开源创造价值，我们致力于搭建一个资源共享平台，让每一个IT人在这里找到属于你的精彩世界.

这篇CFSDN的博客文章Mybatis集成Spring的实例代码_动力节点Java 学院整理由作者收集整理，如果你对这篇文章有兴趣，记得点赞哟.

所需要用到的其他工具或技术

项目管理工具 : 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
@Controller
public 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的实例代码，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对我网站的支持！ 。

最后此篇关于Mybatis集成Spring的实例代码_动力节点Java 学院整理的文章就讲到这里了,如果你想了解更多关于Mybatis集成Spring的实例代码_动力节点Java 学院整理的内容请搜索CFSDN的文章或继续浏览相关文章，希望大家以后支持我的博客！ 。

27 4 0
文章推荐： 图文详解mysql5.7安装教程
文章推荐： php循环table实现一行两列显示的方法
文章推荐： MySql安装与使用图文教程【推荐】
文章推荐： PHP实现过滤掉非汉字字符只保留中文字符
qq735679552
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
全站热门文章
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com