Spring boot2整合Mybatis

叁歲伎倆 2022-05-20 06:05 260阅读 0赞

1.pom.xml配置

<?xml version="1.0" encoding="UTF-8"?>
    <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    	<modelVersion>4.0.0</modelVersion>
    
    	<groupId>cn.com</groupId>
    	<artifactId>project</artifactId>
    	<version>0.0.1-SNAPSHOT</version>
    	<packaging>jar</packaging>
    
    	<name>spring_boot</name>
    
    	
    	<parent>
    		<groupId>org.springframework.boot</groupId>
    		<artifactId>spring-boot-starter-parent</artifactId>
    		<version>2.0.3.RELEASE</version>
    		<relativePath/> 
    	</parent>
    
    	
    	<properties>
    		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    		<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
    		<java.version>1.8</java.version>
    	</properties>
    
    	<dependencies>
    	
    		
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-web</artifactId>
    		</dependency>	
    		
    		
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-thymeleaf</artifactId>
    		</dependency>
    		
    		
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-test</artifactId>
    			<scope>test</scope>
    		</dependency>
    		
    		
    		<dependency>
    			<groupId>org.mybatis.spring.boot</groupId>
    			<artifactId>mybatis-spring-boot-starter</artifactId>
    			<version>1.3.1</version>
    			
                            <exclusions>
                                <exclusion>
                                    <groupId>org.apache.tomcat</groupId>
                                    <artifactId>tomcat-jdbc</artifactId>
                                </exclusion>
                            </exclusions>
    		</dependency>
    		
    		
    		<dependency>
        		        <groupId>com.oracle</groupId>
        		        <artifactId>ojdbc6</artifactId>
        		        <version>11.2.0.3</version>
    		</dependency>
    		
    		
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-devtools</artifactId>
    			<scope>runtime</scope>
    		</dependency>
    		
    		
    		<dependency>
                            <groupId>javax.servlet</groupId>
                            <artifactId>javax.servlet-api</artifactId>
                            <scope>provided</scope>
                    </dependency>      
    	    
    	        
                    <dependency>
        		        <groupId>org.apache.shiro</groupId>
        		        <artifactId>shiro-spring</artifactId>
        		        <version>1.4.0</version>
    		</dependency> 	
    		
    		
                    <dependency>
                            <groupId>com.github.theborakompanioni</groupId>
                            <artifactId>thymeleaf-extras-shiro</artifactId>
                            <version>2.0.0</version>
                    </dependency>
            
    	</dependencies>
    
    	
    	<build>
    		<plugins>
    			<plugin>
    				<groupId>org.springframework.boot</groupId>
    				<artifactId>spring-boot-maven-plugin</artifactId>
    			</plugin>
    		</plugins>
    	</build>
    
    
    </project>

2.application.properties配置数据库连接池及mapper映射文件

#数据库连接
    spring.datasource.driver-class-name=oracle.jdbc.driver.OracleDriver
    spring.datasource.url=jdbc:oracle:thin:@localhost:1521:orcl
    spring.datasource.username=jdjk
    spring.datasource.password=jdjk
    #Hikari连接池
    spring.datasource.type=com.zaxxer.hikari.HikariDataSource
    spring.datasource.hikari.minimum-idle=5
    spring.datasource.hikari.maximum-pool-size=15
    spring.datasource.hikari.auto-commit=true
    spring.datasource.hikari.idle-timeout=30000
    spring.datasource.hikari.max-lifetime=1800000
    spring.datasource.hikari.connection-timeout=30000
    spring.datasource.hikari.connection-test-query=SELECT 1 FROM DUAL
    
    #mybatis映射文件路径
    mybatis.mapper-locations=classpath*:mapper/*Mapper.xml
    #当查询数据为空时字段返回为null，不加这个查询数据为空时，字段将被隐藏
    mybatis.configuration.call-setters-on-nulls=true
    #打印指定包下SQL语句(若配置logback-spring.xml,需在其中设置控制台打印级别为debug)
    logging.level.cn.com.app.dao=debug
    #打印SQL语句
    #mybatis.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl

3.创建Mapper接口

import java.util.List;
    import java.util.Map;
    
    import org.apache.ibatis.annotations.Mapper;
    
    @Mapper
    public interface JkconfigDao { 
    	
    	Map selectByPrimaryKey(String xh);
    	
    	List<Map> selectList();
    	
    	Map selectByXh(String xh);
    }

4.在resources下创建mapper文件夹并创建mapper文件

<?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="xxx.xxx.dao.JkconfigDao">
    	
    	
    	<resultMap id="BaseResultMap" type="java.util.Map">
    		<result column="XH" jdbcType="VARCHAR"  javaType="String" property="XH" />    
    		<result column="SERVER_IP" jdbcType="VARCHAR"  javaType="String" property="SERVER_IP" />    
    		<result column="SERVER_NAME" jdbcType="VARCHAR"  javaType="String" property="SERVER_NAME" />    
    		<result column="SERVER_ACTION" jdbcType="VARCHAR"  javaType="String" property="SERVER_ACTION" />
    		<result column="LRSJ" jdbcType="VARCHAR"  javaType="String" property="LRSJ" />
    	</resultMap>
    	
    	
    	<sql id="Base_Column_List">
    		XH,
    		SERVER_IP,
    		SERVER_NAME,
    		SERVER_ACTION,
    		TO_CHAR(LRSJ,'YYYY-MM-DD HH24:MI:SS') LRSJ
    	</sql>
    
    	
    	<select id="selectByPrimaryKey" parameterType="java.util.Map" resultMap="BaseResultMap">
        	SELECT 
    		<include refid="Base_Column_List" />
     		FROM T_SYS_JKCONFIG
    		WHERE XH = #{xh,jdbcType=VARCHAR}
    	</select>
    	
    	
    	<select id="selectList" parameterType="java.util.Map" resultMap="BaseResultMap">
        	SELECT 
    		<include refid="Base_Column_List" />
     		FROM T_SYS_JKRZ
    	</select>
    	
    	
    	<select id="selectByXh" parameterType="java.util.Map" resultMap="BaseResultMap">
        	SELECT C.XH,C.SERVER_IP,J.SERVER_NAME 
        	FROM T_SYS_JKCONFIG C,T_SYS_JKRZ J WHERE C.XH = J.XH
    		AND C.XH = #{xh,jdbcType=VARCHAR}
    	</select>
    	
    </mapper>

5.在Controller中调用方法

import java.util.List;
    import java.util.Map;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.ui.Model;
    import org.springframework.web.bind.annotation.RequestMapping;
    
    import cn.com.highset.goexpo.dao.JkconfigDao;
    
    @Controller
    public class IndexController {
    	
    	@Autowired
    	private JkconfigDao jkconfigDao;
    	
    	@RequestMapping("/")
    	public String root(Model model) {
    		List<Map> list = jkconfigDao.selectList();
    		model.addAttribute("list", list);
    		return "home";
    	}
    
    }

6.在启动类Application中添加扫描注解

import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    import org.springframework.web.bind.annotation.RestController;
    
    @RestController
    @SpringBootApplication
    @MapperScan("xxx.xxx.dao")
    public class Application {
    
    	public static void main(String[] args) {
    		SpringApplication.run(Application.class, args);
    	}
    }