idea+maven+springboot+mybatis
确认maven环境,安装maven在这里就不赘述了.
在idea新建maven项目
下图中填上你Maven安装的目录
打开pom文件,导入jar包(手动敲入/拷贝)
下面是配置之后的pom文件内容
<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/maven-v4_0_0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.xzk</groupId> <artifactId>testboot</artifactId> <packaging>war</packaging> <version>1.0-SNAPSHOT</version> <name>testboot Maven Webapp</name> <url>http://maven.apache.org</url> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>1.4.3.RELEASE</version> </parent> <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>3.8.1</version> <scope>test</scope> </dependency> </dependencies> <build> <finalName>testboot</finalName> </build> </project>
maven刷新/重新生成,确认导入包,
在main下新建java文件夹
先按这个目录/包结构建立
新建入口类Application.java
import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.EnableAutoConfiguration; import org.springframework.boot.web.support.SpringBootServletInitializer; import org.springframework.context.annotation.ComponentScan; import org.springframework.context.annotation.Configuration; @Configuration @EnableAutoConfiguration @ComponentScan public class Application extends SpringBootServletInitializer{ public static void main(String[] args) { SpringApplication.run(Application.class,args); } }
实体model
public class User { private String name; public String getName() { return name; } public void setName(String name) { this.name = name; } }
控制层
import org.springframework.boot.autoconfigure.EnableAutoConfiguration; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; @RestController @EnableAutoConfiguration @RequestMapping("/testboot") public class TestBootController { @RequestMapping("getuser") public User getUser() { User user = new User(); user.setName("test"); return user; } }
启动,
或者按alt+F12, 在路径后边加上 mvn spring-boot:run 回车
或者在cmd, 项目根目录下键入 mvn spring-boot:run
集成mybatis
不用说,先配置pom文件,导入jar包,最终的pom内容:
<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/maven-v4_0_0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.xu</groupId> <artifactId>testboot</artifactId> <packaging>war</packaging> <version>1.0-SNAPSHOT</version> <name>testboot Maven Webapp</name> <url>http://maven.apache.org</url> <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>1.4.0.RELEASE</version> <relativePath/> <!-- lookup parent from repository --> </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>junit</groupId> <artifactId>junit</artifactId> <version>3.8.1</version> <scope>test</scope> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <!--支持使用 JDBC 访问数据库--> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-jdbc</artifactId> </dependency> <!--Mybatis--> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>1.2.2</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.2.8</version> </dependency> <!--Mysql / DataSource--> <dependency> <groupId>org.apache.tomcat</groupId> <artifactId>tomcat-jdbc</artifactId> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> </dependency> <!--Json Support--> <dependency> <groupId>com.alibaba</groupId> <artifactId>fastjson</artifactId> <version>1.1.43</version> </dependency> <!-- https://mvnrepository.com/artifact/log4j/log4j --> <dependency> <groupId>log4j</groupId> <artifactId>log4j</artifactId> <version>1.2.17</version> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> </plugin> </plugins> </build> </project>
接下来配置数据源,在resource下新建文件
application.properties
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=gbk&zeroDateTimeBehavior=convertToNull spring.datasource.username=root spring.datasource.password=root spring.datasource.driver-class-name=com.mysql.jdbc.Driver server.address=127.0.0.1 server.port=9090
在Application.java中配置DataSource，SqlSeesion. 最终的Application.class内容:
import org.apache.ibatis.session.SqlSessionFactory; import org.apache.log4j.Logger; import org.apache.tomcat.jdbc.pool.DataSource; import org.mybatis.spring.SqlSessionFactoryBean; import org.mybatis.spring.annotation.MapperScan; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; import org.springframework.boot.context.properties.ConfigurationProperties; import org.springframework.context.annotation.Bean; import org.springframework.core.io.support.PathMatchingResourcePatternResolver; import org.springframework.jdbc.datasource.DataSourceTransactionManager; import org.springframework.transaction.PlatformTransactionManager; //@EnableAutoConfiguration //@Configuration //@ComponentScan @SpringBootApplication @MapperScan("com.xu.boot.mapper") public class Application { private static Logger logger = Logger.getLogger(Application.class); //DataSource配置 @Bean @ConfigurationProperties(prefix="spring.datasource") public DataSource dataSource() { return new DataSource(); } //提供SqlSeesion @Bean public SqlSessionFactory sqlSessionFactoryBean() throws Exception { SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean(); sqlSessionFactoryBean.setDataSource(dataSource()); PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver(); sqlSessionFactoryBean.setMapperLocations(resolver.getResources("classpath:/mybatis/*.xml")); return sqlSessionFactoryBean.getObject(); } @Bean public PlatformTransactionManager transactionManager() { return new DataSourceTransactionManager(dataSource()); } /** * Main Start */ public static void main(String[] args) { SpringApplication.run(Application.class, args); logger.info("============= SpringBoot Start Success ============="); } }
其中:
如果目录结构和springboot推荐的一样,那么只加@SpringBootApplication这一个注解就可以.
这个不用多说,mapper的映射路径
这个spring.datasource是和properties文件前缀匹配.
这个是xml的映射.
最终的目录结构:
这个yml文件是空的, 里边也可以配置内容,但一般我们都习惯在properties里面配置.
接下来是controller,service,mapper, 也可以用mybatis-generator自动生成
首先，UserController.java
import com.alibaba.fastjson.JSONArray; import com.xu.boot.model.User; import com.xu.boot.service.UserService; import org.apache.catalina.servlet4preview.http.HttpServletRequest; import org.apache.log4j.Logger; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.ResponseBody; import org.springframework.web.bind.annotation.RestController; @RestController public class UserController { private Logger logger = Logger.getLogger(UserController.class); @Autowired private UserService userService; @RequestMapping("/getUserById") @ResponseBody public User getUserById(HttpServletRequest request) { int id = Integer.parseInt(request.getParameter("id")); User user = userService.getUserById(id); if(user!=null){ logger.info(JSONArray.toJSON(user)); } return user; } }
然后是UserService.java
import com.xu.boot.model.User; public interface UserService { User getUserById(int id); }
然后UserServiceImpl.java
import com.xu.boot.mapper.UserMapper; import com.xu.boot.model.User; import com.xu.boot.service.UserService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; @Service public class UserServiceImpl implements UserService { @Autowired UserMapper mapper; @Override public User getUserById(int id) { return mapper.getUserById(id); } }
然后UserMapper.java
import com.xu.boot.model.User; public interface UserMapper { User getUserById(int id); }
然后UserMapper.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.xu.boot.mapper.UserMapper"> <select id="getUserById" resultType="com.xu.boot.model.User" parameterType="java.lang.Integer"> select name, age,password from user WHERE id=#{id,jdbcType=INTEGER}; </select> </mapper>
接下来启动Application, 运行main方法.在浏览器输入http://localhost:9090/getUserById?id=1
