mybatis整合spring

小灰灰 2021-09-27 06:18 430阅读 0赞

1、创建数据库micro\_message及表message

CREATE TABLE `message` (
      `ID` int(11) NOT NULL AUTO_INCREMENT,
      `COMMAND` varchar(16) DEFAULT NULL,
      `DESCRIPTION` varchar(32) DEFAULT NULL,
      `CONTENT` varchar(2048) DEFAULT NULL,
      PRIMARY KEY (`ID`)
    ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

2、使用generator生成文件

![70][]

generatorConfig.xml 如下：

<?xml version="1.0" encoding="UTF-8"?>  
    <!DOCTYPE generatorConfiguration  
      PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"  
      "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">  
    <generatorConfiguration>  
      
        <classPathEntry  location="mysql-connector-java-5.1.38.jar"/>  
        <context id="DB2Tables"  targetRuntime="MyBatis3">  
            <commentGenerator>  
                <property name="suppressDate" value="true"/>  
                  
                <property name="suppressAllComments" value="true"/>  
            </commentGenerator>  
              
            <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://127.0.0.1:3306/micro_message" userId="root" password="123456">  
            </jdbcConnection>  
            <javaTypeResolver>  
                <property name="forceBigDecimals" value="false"/>  
            </javaTypeResolver>  
              
            <javaModelGenerator targetPackage="test.domain" targetProject="src">  
                <property name="enableSubPackages" value="true"/>  
                <property name="trimStrings" value="true"/>  
            </javaModelGenerator>  
              
            <sqlMapGenerator targetPackage="test.mapping" targetProject="src">  
                <property name="enableSubPackages" value="true"/>  
            </sqlMapGenerator>  
              
            <javaClientGenerator type="XMLMAPPER" targetPackage="test.IDao" targetProject="src">  
                <property name="enableSubPackages" value="true"/>  
            </javaClientGenerator>  
              
            <table tableName="message" domainObjectName="Message" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"></table>
        </context>  
    </generatorConfiguration>

3、加入配置文件（4个）及生成的文件

![70 1][]

![70 2][]

**4、mybatis配置文件（****Configuration.xml****）引入mapper文件**

![70 3][]

**5、spring配置文件（****applicationContext.xml****）**

<context:property-placeholder location="classpath:db.properties" />
    	
    	
    	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
    		destroy-method="close">
    		<property name="driverClassName" value="${jdbc.driver}" />
    		<property name="url" value="${jdbc.url}" />
    		<property name="username" value="${jdbc.username}" />
    		<property name="password" value="${jdbc.password}" />
    		<property name="maxActive" value="10" />
    		<property name="maxIdle" value="5" />
    	</bean>
    	
    	
    	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    		
    		<property name="configLocation" value="classpath:mybatis/Configuration.xml" />
    		
    		<property name="dataSource" ref="dataSource" />
    	</bean>
    	
    	
    	 
    	
    	 <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    		<property name="basePackage" value="test.IDao"></property>
    	</bean>

6、测试

private ApplicationContext ac;
    	@Before
    	public void setUp1() {
    		ac=new ClassPathXmlApplicationContext("classpath:applicationContext.xml");
    	}
    	
    	@Test
    	public void test1() {
    		MessageMapper messageMapper=(MessageMapper) ac.getBean("messageMapper");
    		Message message=messageMapper.selectByPrimaryKey(1);
    		System.out.println(message);
    	}

[70]: /images/20210923/01cfb1e9c41346d8b89fedc13af984f2.png
[70 1]: /images/20210923/5a7dc22dceb94fdcacee7a03a783f99f.png
[70 2]: /images/20210923/813fb94f26f04372b2a039eae31316a6.png
[70 3]: /images/20210923/5c0504e40092446787c03c738cb8a3ae.png