saas-export项目-项目搭建之spring与Mybatis的整合

朴灿烈づ我的快乐病毒、 2022-12-17 07:26 8阅读 0赞

# spring整合Mybatis #

## 检查 pom.xml ##

有没有spring与mybatis的整合包

<dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis-spring</artifactId>
                <version>${mybatis.spring.version}</version>
            </dependency>

export\_dao

*  （1）properties/db.properties
 *  （2）spring/applicationContext.xml
 *  （3）定义ICompanyDao
 *  （4）定义ICompanyDao.xml
 *  （5）测试

## properties/db.properties ##

# key=value
    jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://47.115.79.211:3308/saas-export?characterEncoding=utf-8
    jdbc.username=root
    jdbc.password=admin123

## spring/applicationContext-dao.xml ##

子工程，dao子工程的交给spring管理，创建一个对应的applicationContext-dao.xml

<?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:context="http://www.springframework.org/schema/context" xsi:schemaLocation="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">
    
        
        <context:component-scan base-package="com.lbl">
            <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
        </context:component-scan>
        
        
        
        <context:property-placeholder location="classpath:properties/db.properties"></context:property-placeholder>
    
        
        <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
            <property name="url" value="${jdbc.url}"/>
            <property name="driverClassName" value="${jdbc.driver}"/>
            <property name="username" value="${jdbc.username}"/>
            <property name="password" value="${jdbc.password}"/>
        </bean>
    
        
        
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            
            <property name="dataSource" ref="dataSource"/>
            
            <property name="typeAliasesPackage" value="com.lbl.domain"/>
        </bean>
    
        
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            
            <property name="basePackage" value="com.lbl.dao"/>
        </bean>
    
    </beans>

## ICompanyDao ##

public interface ICompanyDao { 
        //查询所有的公司记录
        //select * from ss_company
        List<Company> findAll();
    }

## ICompanyDao.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.lbl.dao.company.ICompanyDao">
    
        <select id="findAll" resultType="company">
            select * from ss_company
        </select>
    </mapper>

## ICompanyDaoTest ##

package com.lbl.dao.company;
    
    import com.lbl.domain.Company;
    import junit.framework.TestCase;
    import org.apache.log4j.Logger;
    import org.junit.Assert;
    import org.junit.Test;
    import org.junit.runner.RunWith;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.test.context.ContextConfiguration;
    import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
    
    import java.util.List;
    
    @RunWith(SpringJUnit4ClassRunner.class)
    @ContextConfiguration("classpath*:spring/applicationContext-*.xml")
    public class ICompanyDaoTest extends TestCase { 
    
        private static final Logger log = Logger.getLogger(ICompanyDaoTest.class.getName());
    
        @Autowired
        ICompanyDao companyDao;
    
        @Test
        public void testFindAll() { 
            List<Company> list = companyDao.findAll();
            log.info(list);
            Assert.assertNotNull(list);
        }
    }

## 运行结果： ##

!![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3OTI0OTA1_size_16_color_FFFFFF_t_70_pic_center]  
[在这里插入图片描述][Link 1]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3OTI0OTA1_size_16_color_FFFFFF_t_70_pic_center]: /images/20221123/65344d02ba6f41c8820140ec4cfe162e.png
[Link 1]: https://img-blog.csdnimg.cn/20201022195804220.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzM3OTI0OTA1,size_16,color_FFFFFF,t_70#pic_center