这里搭建的是maven多模块(父子项目)
创建父子项目参考上一篇文章(
自己记录下关于MAVEN创建多模块项目步骤(Eclipse)
)地址:http://blog.csdn.net/u012903135/article/details/78366536
下面来说说 spring boot集成mybatis注解 相关配置
首先看看项目结构附图:
父:Export --> pom.xml
子:sw-export-excel -->pom.xml
接下来看父pom 文件中的相关配置,
<?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>com.sw.export</groupId>
<artifactId>Export</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>pom</packaging>
<name>Export</name>
<url>http://maven.apache.org</url>
<modules>
<module>sw-export-excel</module>
</modules>
<properties> <!-- 这里将引入相关包的版本,进行统一配置管理 -->
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<spring-boot-version>1.4.1.RELEASE</spring-boot-version>
<spring-version>4.3.3.RELEASE</spring-version>
<mybatis-spring-version>1.2.3</mybatis-spring-version>
<mybatis-version>3.3.0</mybatis-version>
<druid-version>1.0.14</druid-version>
<mybatis-spring-version>1.2.3</mybatis-spring-version>
<mysql-version>5.1.30</mysql-version>
<tomcat.embed.jasper.version>8.0.23</tomcat.embed.jasper.version>
<spring-boot-maven-plugin-version>1.3.5.RELEASE</spring-boot-maven-plugin-version>
<spring-boot-loaded-version>1.2.6.RELEASE</spring-boot-loaded-version>
<maven-war-plugin-version>2.6</maven-war-plugin-version>
<start-class>com.transport.oa.App</start-class>
<maven-war-plugin-version>2.6</maven-war-plugin-version>
<maven-compiler-plugin-version>3.2</maven-compiler-plugin-version>
<maven-resources-plugin-version>2.6</maven-resources-plugin-version>
<maven-source-plugin-version>2.2.1</maven-source-plugin-version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
<version>${spring-boot-version}</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-actuator</artifactId>
<version>${spring-boot-version}</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>${druid-version}</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<version>${spring-boot-version}</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>dom4j</groupId>
<artifactId>dom4j</artifactId>
<version>1.6.1</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
<version>${spring-boot-version}</version>
</dependency>
<!-- <dependency> <groupId>org.springframework.security</groupId> <artifactId>spring-security-web</artifactId>
<version>4.1.1.RELEASE</version> </dependency> <dependency> <groupId>org.springframework.security</groupId>
<artifactId>spring-security-config</artifactId> <version>4.1.1.RELEASE</version>
</dependency> -->
<!-- SPRING basic begin(一般不需要显式定义) -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>${spring-version}</version>
<!-- <exclusions> <exclusion> <groupId>commons-logging</groupId> <artifactId>commons-logging</artifactId>
</exclusion> </exclusions> -->
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>${spring-version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>${spring-version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>${spring-version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>${spring-version}</version>
</dependency>
<!-- email/scheduler/freemarker -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context-support</artifactId>
<version>${spring-version}</version>
</dependency>
<!-- SPRING basic end -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${spring-version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context-support</artifactId>
<version>${spring-version}</version>
</dependency>
<dependency>
<groupId>com.thoughtworks.xstream</groupId>
<artifactId>xstream</artifactId>
<version>1.4.9</version>
</dependency>
<dependency>
<groupId>xpp3</groupId>
<artifactId>xpp3</artifactId>
<version>1.1.4c</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>${mysql-version}</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>${mybatis-version}</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>${mybatis-spring-version}</version>
</dependency>
<dependency>
<groupId>commons-beanutils</groupId>
<artifactId>commons-beanutils</artifactId>
<version>1.9.3</version>
</dependency>
<!-- https://mvnrepository.com/artifact/com.oracle/ojdbc6 -->
<dependency>
<groupId>com.oracle</groupId>
<artifactId>ojdbc6</artifactId>
<version>11.1.0.7.0</version>
</dependency>
<dependency>
<groupId>com.google.code.gson</groupId>
<artifactId>gson</artifactId>
<version>2.8.0</version>
</dependency>
</dependencies>
<!-- 构建设置 -->
<build>
<resources>
<resource>
<directory>src/main/resources/${profiles.active}</directory>
<filtering>true</filtering>
</resource>
<resource>
<directory>src/main/resources</directory>
<filtering>true</filtering>
<includes>
<include>*.properties</include>
</includes>
</resource>
</resources>
<!-- <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId>
<version>1.3.5.RELEASE</version> </plugin> </plugins> -->
<pluginManagement>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
<version>${spring-boot-maven-plugin-version}</version>
<configuration>
<executable>true</executable>
</configuration>
<executions>
<execution>
<goals>
<goal>repackage</goal>
</goals>
</execution>
</executions>
<dependencies>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>springloaded</artifactId>
<version>${spring-boot-loaded-version}</version>
</dependency>
</dependencies>
</plugin>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-war-plugin</artifactId>
<version>${maven-war-plugin-version}</version>
<configuration>
<failOnMissingWebXml>false</failOnMissingWebXml>
</configuration>
</plugin>
</plugins>
</pluginManagement>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>${maven-compiler-plugin-version}</version>
<configuration>
<source>1.8</source>
<target>1.8</target>
</configuration>
</plugin>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-resources-plugin</artifactId>
<version>${maven-resources-plugin-version}</version>
<configuration>
<encoding>utf-8</encoding>
</configuration>
</plugin>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-source-plugin</artifactId>
<version>${maven-source-plugin-version}</version>
<configuration>
<attach>true</attach>
</configuration>
<executions>
<execution>
<phase>compile</phase>
<goals>
<goal>jar</goal>
</goals>
</execution>
</executions>
</plugin>
</plugins>
</build>
</project>
父pom 中配置好了就再来配置 子项目 pom文件
<?xml version="1.0"?>
<project
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"
xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>com.sw.export</groupId>
<artifactId>Export</artifactId>
<version>0.0.1-SNAPSHOT</version>
</parent>
<artifactId>sw-export-excel</artifactId>
<name>sw-export-excel</name>
<url>http://maven.apache.org</url>
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>3.8.1</version>
<scope>test</scope>
</dependency>
</dependencies>
<build>
<finalName>sw-export-excel</finalName>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
<version>${spring-boot-maven-plugin-version}</version>
</plugin>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.5.1</version>
<configuration>
<source>1.8</source>
<target>1.8</target>
<encoding>UTF-8</encoding>
</configuration>
</plugin>
</plugins>
</build>
</project>
3: application.properties
mysql.datasource.url=jdbc:mysql://address:prot/DBNAME?useUnicode=true&characterEncoding=utf8
mysql.datasource.username=****
mysql.datasource.password=*****
oracle.datasource.url=jdbc:oracle:thin:@address:port:orcl
oracle.datasource.username=***
oracle.datasource.password=***
# 这里是配置端口
export.server.port=9090
mysql.datasource.driverclass=com.mysql.jdbc.Driver
oracle.datasource.driverclass=oracle.jdbc.driver.OracleDriver
#配置日志路径
logging.file=/var/log/oanc/logs/oa.log
4:开始java类 接口的编写
mysql 连接 配置类
在包名:com.export.configuation下面 不多说,直接贴代码,
package com.export.configuation;
import javax.sql.DataSource;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import com.alibaba.druid.pool.DruidDataSource;
@Configuration
@MapperScan(basePackages = "com.export.oa.mysql",sqlSessionFactoryRef="mysqlSqlSessionFactory")
public class MysqlConfig {
@Value("${mysql.datasource.url}")
private String url;
@Value("${mysql.datasource.username}")
private String username;
@Value("${mysql.datasource.password}")
private String password;
@Value("${mysql.datasource.driverclass}")
private String driverclass;
@Primary
@Bean(name = "mysqldatasouce")
public DataSource dataSource() {
DruidDataSource datasource = new DruidDataSource();
datasource.setUrl(url);
datasource.setUsername(username);
datasource.setPassword(password);
datasource.setDriverClassName(driverclass);
datasource.setInitialSize(5);
datasource.setMinIdle(5);
datasource.setMaxActive(50);
datasource.setMaxWait(60000);
datasource.setTimeBetweenEvictionRunsMillis(60000);
datasource.setMinEvictableIdleTimeMillis(300000);
datasource.setValidationQuery("SELECT 'x'");
datasource.setTestWhileIdle(true);
datasource.setTestOnBorrow(false);
datasource.setTestOnReturn(false);
return datasource;
}
@Primary
@Bean(name = "mysqlSqlSessionFactory")
public SqlSessionFactory sqlSessionFactory() throws Exception {
SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();
factoryBean.setDataSource(dataSource());
return factoryBean.getObject();
}
}
oracle 连接配置类:
package com.export.configuation;
import javax.sql.DataSource;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import com.alibaba.druid.pool.DruidDataSource;
@Configuration
@MapperScan(basePackages="com.export.oa.oracle",sqlSessionFactoryRef="oracleSqlSessionFactory")
public class OracleConfig {
@Value("${oracle.datasource.url}")
private String url;
@Value("${oracle.datasource.username}")
private String username;
@Value("${oracle.datasource.password}")
private String password;
@Value("${oracle.datasource.driverclass}")
private String driverclass;
@Bean(name="oracledatasouce")
public DataSource dataSource() {
DruidDataSource datasource = new DruidDataSource();
datasource.setUrl(url);
datasource.setUsername(username);
datasource.setPassword(password);
datasource.setDriverClassName(driverclass);
datasource.setInitialSize(5);
datasource.setMinIdle(5);
datasource.setMaxActive(50);
datasource.setMaxWait(60000);
datasource.setTimeBetweenEvictionRunsMillis(60000);
datasource.setMinEvictableIdleTimeMillis(300000);
// datasource.setValidationQuery("SELECT 'x'");
datasource.setTestWhileIdle(true);
datasource.setTestOnBorrow(false);
datasource.setTestOnReturn(false);
return datasource;
}
@Bean(name = "oracleSqlSessionFactory")
public SqlSessionFactory sqlSessionFactory() throws Exception {
SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();
factoryBean.setDataSource(dataSource());
return factoryBean.getObject();
}
}
5:spring boot 入口main方法:
package com.export.oa;
import org.springframework.beans.factory.annotation.Configurable;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.boot.builder.SpringApplicationBuilder;
import org.springframework.boot.context.embedded.ConfigurableEmbeddedServletContainer;
import org.springframework.boot.context.embedded.EmbeddedServletContainerCustomizer;
import org.springframework.boot.context.web.SpringBootServletInitializer;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Configuration;
@Configuration
@Configurable
@SpringBootApplication(scanBasePackages = {"com.export"})
public class App extends SpringBootServletInitializer implements EmbeddedServletContainerCustomizer {
/** 启动端口号 */
@Value("${export.server.port}")
private int serverPort;
public static void main(String[] args) {
SpringApplication.run(App.class, args);
}
@Override
protected SpringApplicationBuilder configure(SpringApplicationBuilder application) {
return application.sources(App.class);
}
public void customize(ConfigurableEmbeddedServletContainer container) {
container.setPort(serverPort);
}
}
6: 开始编写dao:
例子:
package com.export.oa.mysql.dao;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
public interface UserSwDao {
@Insert("INSERT INTO usersw(name,age) values(#{name},#{age})")
public int save(@Param(value="name") String name,
@Param(value="age") int age);
}
简单的insert 插入一条数据的语句。
7:编写server接口和实现:
package com.export.oa.service;
public interface IService {
String testInsertUser();
}
实现类:
package com.export.oa.service;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.export.oa.mysql.dao.UserSwDao;
@Service("testService")
public class TestService implements IService{
private static Logger logger=LoggerFactory.getLogger(TestService.class);
@Autowired
private UserSwDao userSwDao;
@Override
public String testInsertUser() {
logger.info("打印日志的地方******");
userSwDao.save("SHIWEI", 28);
return "SUCCESS";
}
}
7:控制层:
package com.export.oa.controller;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import com.export.oa.service.TestService;
@RestController
public class TestController {
private static Logger logger= LoggerFactory.getLogger(TestController.class);
@Autowired
TestService testService;
@RequestMapping("home")
public String helloWorld(){
return "helloworld";
}
@RequestMapping("testInsert")
public String testInsert(){
testService.testInsertUser();
return "SUCCESS";
}
}
8:我这里没有写实体,你们后续需要的话可以编写实体类作为参数传入 进行增删改查即可!
9:开始run App的main方法: 项目跑起来后,
localhost:9090/属于你需要调用的控制层 配置的
@RequestMapping即可
localhost:9090/home
只为记录方便自己以后回忆!不喜勿喷
项目下载 地址 :
http://download.csdn.net/download/u012903135/10109341