java调用mybatis demo

绝地灬酷狼 2021-09-25 02:08 228阅读 0赞

spring集成mybatis的资料很多，但是java程序单独调用mybatis的资料却很少，整理一个例子作为备用。

pom

<dependency>
    			<groupId>org.mybatis</groupId>
    			<artifactId>mybatis</artifactId>
    			<version>3.4.5</version>
    		</dependency>
    		<dependency>
    			<groupId>org.mybatis</groupId>
    			<artifactId>mybatis-spring</artifactId>
    			<version>1.3.3</version>
    		</dependency>
    		<dependency>
    			<groupId>mysql</groupId>
    			<artifactId>mysql-connector-java</artifactId>
    			<version>8.0.11</version>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-tx</artifactId>
    			<version>5.1.8.RELEASE</version>
    		</dependency>
    		<dependency>
    			<groupId>org.springframework</groupId>
    			<artifactId>spring-jdbc</artifactId>
    			<version>5.1.8.RELEASE</version>
    		</dependency>

mybatis-config.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>
    
    	<properties resource="db.properties"></properties>
    
        <settings>
            
            <setting name="cacheEnabled" value="true"/>
            
            <setting name="logImpl" value="STDOUT_LOGGING" />
    
            
            <setting name="lazyLoadingEnabled" value="true"/>
    
            
            <setting name="aggressiveLazyLoading" value="false"/>
    
            
            <setting name="multipleResultSetsEnabled" value="true"/>
    
            
            <setting name="useColumnLabel" value="true"/>
    
            
            <setting name="useGeneratedKeys" value="false"/>
    
            
            <setting name="autoMappingBehavior" value="PARTIAL"/>
    
            
            <setting name="defaultExecutorType" value="SIMPLE"/>
    
            
            <setting name="mapUnderscoreToCamelCase" value="false"/>
    
            
            <setting name="localCacheScope" value="SESSION"/>
    
            
            <setting name="jdbcTypeForNull" value="NULL"/>
        </settings>
        
        <environments default="development">  
            <environment id="development">  
                <transactionManager type="JDBC" />  
                <dataSource type="POOLED">
                    <property name="driver" value="${driver}" />  
                    <property name="url" value="${url}" />  
                    <property name="username" value="${username}" />  
                    <property name="password" value="${password}" />  
                </dataSource>  
            </environment>  
    	</environments>
        
        <mappers >
        	<mapper resource="config/mapper/demo.xml" />
        </mappers>
    </configuration>

db.properties

url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai
    username=root
    password=root
    driver=com.mysql.cj.jdbc.Driver

demo.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="demo.test">
    
    	<select id="test" parameterType="java.util.Map" resultType="java.util.HashMap">
    		select 1 a from dual
    	</select>
    
    </mapper>

java

InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");
    		SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
    		SqlSessionTemplate sessionTemplate = new SqlSessionTemplate(sqlSessionFactory);
    		System.out.println(sessionTemplate.selectList("demo.test.test", null));