Spring整合Mybatis极简完整示例（结构清晰仅需一个xml系统配置文件！）

缺乏、安全感 2023-10-05 12:58 1阅读 0赞

看网上的教程都是一堆xml配置文件，我今天出一个教程，除mybatis映射文件外,整个spring容器框架整合mybatis只需要一个xml配置文件即可完成，

无需 :mybatis-config.xml, db.properties，web.xml。

**示例环境：**

spring5.2.9,下载地址：[JFrog][]

Mybatis:3.5.6,下载地址：[https://github.com/mybatis/mybatis-3/releases][https_github.com_mybatis_mybatis-3_releases]

以上包均为目前最新版本

**1,User.java实体类**

package com.sm.entity;
    
    public class User {
        private String loginid;
        private String loginname;
        private String sex;
        private String mobile;
    
        public String getLoginid() {
            return loginid;
        }
    
        public void setLoginid(String loginid) {
            this.loginid = loginid;
        }
    
        public String getLoginname() {
            return loginname;
        }
    
        public void setLoginname(String loginname) {
            this.loginname = loginname;
        }
    
        public String getSex() {
            return sex;
        }
    
        public void setSex(String sex) {
            this.sex = sex;
        }
    
        public String getMobile() {
            return mobile;
        }
    
        public void setMobile(String mobile) {
            this.mobile = mobile;
        }
    
        @Override
        public String toString() {
            StringBuilder sb = new StringBuilder();
            sb.append(getClass().getSimpleName());
            sb.append(" [");
            sb.append("loginid=").append(loginid);
            sb.append(", loginname=").append(loginname);
            sb.append(", sex=").append(sex);
            sb.append(", mobile=").append(mobile);
            sb.append("]");
            return sb.toString();
        }
    
    }

**2,UserDao.java 接口类**

package com.sm.dao;
    
    import java.util.List;
    
    import com.sm.entity.User;
    
    public interface UserDao {
    	public User selectUserByID (int id);
    	public List<User> selectUserByName (String loginname);
    }

**3，UserDao.xml 映射文件**

<?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.sm.dao.UserDao">
    
    <select id="selectUserByID" parameterType="int" resultType="com.sm.entity.User" >
      select * from t_users where id=#{id}
    </select>
    
    
    <select id="selectUserByName" parameterType="string" resultType="com.sm.entity.User" >
      select * from t_users where loginName like '%${value}%'
    </select>
    
    </mapper>

**4，applicationContext.xml （spring+mybatis配置文件）**

<?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:tx="http://www.springframework.org/schema/tx"
        xmlns:p="http://www.springframework.org/schema/p"
        xmlns:context="http://www.springframework.org/schema/context"
        xmlns:mvc="http://www.springframework.org/schema/mvc"
        xsi:schemaLocation="http://www.springframework.org/schema/beans
            http://www.springframework.org/schema/beans/spring-beans-4.3.xsd
            http://www.springframework.org/schema/context
            http://www.springframework.org/schema/context/spring-context-4.3.xsd
            http://www.springframework.org/schema/aop
            http://www.springframework.org/schema/aop/spring-aop-4.3.xsd
            http://www.springframework.org/schema/tx
            http://www.springframework.org/schema/tx/spring-tx-4.3.xsd
            http://www.springframework.org/schema/mvc
            http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd">
            
        	
    	
    	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"  destroy-method="close">
    		<property name="driverClassName" value="com.mysql.jdbc.Driver" />
    		<property name="url" value="jdbc:mysql://127.0.0.1:3306/itqs" />
    		<property name="username" value="root" />
    		<property name="password" value="123" />
    	</bean>
    
    	
         
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            <property name="dataSource" ref="dataSource"/>
    
            <property name="mapperLocations" value="com/sm/dao/*.xml"/>
    
        </bean>
     
    
        
        <bean id="userMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
            <property name="mapperInterface" value="com.sm.dao.UserDao"/>
            <property name="sqlSessionFactory" ref="sqlSessionFactory"/>
        </bean>	
    </beans>

**5，测试类Test.java**

package com.sm.test;
    
    
    import java.util.List;
    
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
    
    import com.sm.dao.UserDao;
    import com.sm.entity.User;
    
    public class Test1 {
    
    	public static void main(String[] args) {
    		
    		//第一种写法
    	    ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
    	    UserDao mapper = (UserDao)context.getBean("userMapper");
            User user = mapper.selectUserByID(18);
            System.out.println(user);
            
            //第二种写法
    	    ApplicationContext ctx = new ClassPathXmlApplicationContext("applicationContext.xml");
    	    UserDao mapper1 = ctx.getBean("userMapper",UserDao.class);
            List<User> userlist = mapper1.selectUserByName("李");
            System.out.println(userlist);		
    
    	}
    
    }

**6, 效果：**

![20201030235421722.png][]

[JFrog]: https://repo.spring.io/libs-release-local/org/springframework/spring/5.2.9.RELEASE/
[https_github.com_mybatis_mybatis-3_releases]: https://github.com/mybatis/mybatis-3/releases
[20201030235421722.png]: https://img-blog.csdnimg.cn/20201030235421722.png