Spring+Mybatis 整合

太过爱你忘了你带给我的痛 2022-06-02 01:24 185阅读 0赞

# Spring+Mybatis整合 #

*  整体结构
    
     *  ![1D9jdDW.png][]
 *  所需jar包
    
     *  ![SZjpTWH.png][]
 *  数据库
    
     *  数据库名称
        
         *  mybatis\_db
     *  表名称
        
         *  user
     *  表结构
        
         *  ![96oLOof.png][]
 *  代码
    
     *  com.peng.mapper
        
         *  UserMapper
            
            #  #
            
                package com.peng.mapper;
                
                import java.util.List;
                
                import org.springframework.stereotype.Repository;
                
                import com.peng.pojo.User;
                
                @Repository(value = "userMapper")
                public interface UserMapper {
                    // 查询全部的User
                    public List<User> findAll();
                }
     *  com.peng.pojo
        
         *  User
            
            #  #
            
                package com.peng.pojo;
                
                public class User {
                    private int id;
                    private String name;
                    private int age;
                
                    public User() {
                        super();
                    }
                
                    public User(int id, String name, int age) {
                        super();
                        this.id = id;
                        this.name = name;
                        this.age = age;
                    }
                
                    public int getId() {
                        return id;
                    }
                
                    public void setId(int id) {
                        this.id = id;
                    }
                
                    public String getName() {
                        return name;
                    }
                
                    public void setName(String name) {
                        this.name = name;
                    }
                
                    public int getAge() {
                        return age;
                    }
                
                    public void setAge(int age) {
                        this.age = age;
                    }
                
                    @Override
                    public String toString() {
                        return "编号：" + id + "，姓名：" + name + "，年龄：" + age;
                    }
                
                }
         *  UserMapper
            
            #  #
            
                <?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.peng.mapper.UserMapper">
                    <select id="findAll" resultType="com.peng.pojo.User">
                        select * from user
                    </select>
                </mapper>
     *  com.peng.service
        
         *  UserService
            
            #  #
            
                package com.peng.service;
                
                import java.util.List;
                
                import com.peng.pojo.User;
                
                public interface UserService {
                    public List<User> findAll();
                }
         *  UserServiceImpl
            
            #  #
            
                package com.peng.service;
                
                import java.util.List;
                
                import com.peng.pojo.User;
                
                public interface UserService {
                    public List<User> findAll();
                }
     *  com.peng.test
        
         *  Test
            
            #  #
            
                package com.peng.test;
                
                import java.util.List;
                
                import org.springframework.context.ApplicationContext;
                import org.springframework.context.support.ClassPathXmlApplicationContext;
                
                import com.peng.pojo.User;
                import com.peng.web.UserServlet;
                
                public class Test {
                    @org.junit.Test
                    public void findAllTest() {
                        ApplicationContext ac = new ClassPathXmlApplicationContext(
                                "applicationContext.xml");
                        UserServlet us = (UserServlet) ac.getBean("userServlet");
                        List<User> findAll = us.findAll();
                        for (User user : findAll) {
                            System.out.println(user);
                        }
                    }
                }
     *  com.peng.web
        
         *  UserServlet
            
            #  #
            
                package com.peng.web;
                
                import java.util.List;
                
                import org.springframework.beans.factory.annotation.Autowired;
                import org.springframework.beans.factory.annotation.Qualifier;
                import org.springframework.stereotype.Controller;
                
                import com.peng.pojo.User;
                import com.peng.service.UserService;
                
                @Controller(value = "userServlet")
                public class UserServlet {
                    @Autowired
                    @Qualifier(value = "userService")
                    private UserService userService;
                
                    public List<User> findAll() {
                        return userService.findAll();
                    }
                }
     *  配置文件
        
         *  applicationContext.xml
            
            #  #
            
                <?xml version="1.0" encoding="UTF-8"?>
                <beans xmlns="http://www.springframework.org/schema/beans"
                    xmlns:context="http://www.springframework.org/schema/context"
                    xmlns:aop="http://www.springframework.org/schema/aop" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
                    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.2.xsd
                    http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-3.2.xsd 
                    http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.2.xsd ">
                    
                    <context:component-scan base-package="com.peng"></context:component-scan>
                    
                    <context:annotation-config></context:annotation-config>
                    
                    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
                        
                        <property name="dataSource" ref="c3p0dataSource"></property>
                        
                        <property name="configLocation" value="classpath:/sqlMapConfig.xml"></property>
                        
                        <property name="mapperLocations" value="classpath:/com/peng/pojo/*.xml"></property>
                    </bean>
                    
                    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
                        <property name="basePackage" value="com.peng.mapper"></property>
                    </bean>
                    
                    <bean
                        class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
                        <property name="location" value="classpath:/jdbc_config.properties"></property>
                    </bean>
                    
                    <bean id="c3p0dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
                        <property name="driverClass" value="${jdbc.driver}"></property>
                        <property name="jdbcUrl" value="${jdbc.url}"></property>
                        <property name="user" value="${jdbc.user}"></property>
                        <property name="password" value="${jdbc.password}"></property>
                        <property name="minPoolSize" value="3"></property>      
                        <property name="initialPoolSize" value="5"></property>  
                        <property name="acquireIncrement" value="3"></property> 
                    </bean>
                </beans>
         *  jdbc\_config.properties
            
            #  #
            
                jdbc.user=root
                jdbc.password=root
                jdbc.url=jdbc\:mysql\://localhost\:3306/mybatis_db
                jdbc.driver=com.mysql.jdbc.Driver
         *  log4j.properties
            
            #  #
            
                log4j.rootLogger=DEBUG, Console
                #Console
                log4j.appender.Console=org.apache.log4j.ConsoleAppender
                log4j.appender.Console.layout=org.apache.log4j.PatternLayout
                log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
                log4j.logger.java.sql.ResultSet=INFO
                log4j.logger.org.apache=INFO
                log4j.logger.java.sql.Connection=DEBUG
                log4j.logger.java.sql.Statement=DEBUG
                log4j.logger.java.sql.PreparedStatement=DEBUG
         *  sqlMapConfig.xml
            
            #  #
            
                <?xml version="1.0" encoding="UTF-8" ?>
                <!DOCTYPE configuration
                PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
                "http://mybatis.org/dtd/mybatis-3-config.dtd">
                <configuration>
                </configuration>

[1D9jdDW.png]: https://i.imgur.com/1D9jdDW.png
[SZjpTWH.png]: https://i.imgur.com/SZjpTWH.png
[96oLOof.png]: https://i.imgur.com/96oLOof.png