eclipse下整合springboot和mybatis
1.新建maven專案
先新建一個maven專案,勾選上creat a simple project,填寫groupid,artifactid
2.建立專案結構
3.新增依賴
<parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>2.0.3.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>org.springframework.boot</groupId> <artifactId>spring-boot-starter</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.3.2</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> </plugin> </plugins> </build>
4.程式碼編寫
在包的最外層新增啟動類
package com.lee.test; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; import org.springframework.cache.annotation.EnableCaching; @SpringBootApplication @EnableCaching public class Application { public static void main(String[] args) { SpringApplication.run(Application.class, args); } }
實體類
package com.lee.test.pojo; import org.springframework.stereotype.Component; @Component public class User { private int id; private String name; private String telephone; public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getTelephone() { return telephone; } public void setTelephone(String telephone) { this.telephone = telephone; } }
mapper介面
package com.lee.test.mapper; import java.util.List; import org.apache.ibatis.annotations.Mapper; import com.lee.test.pojo.User; @Mapper public interface UserMapper { List<User> getUser(int id); }
service介面
package com.lee.test.service; import java.util.List; import com.lee.test.pojo.User; public interface UserService { public List<User> getUser(int id); }
service介面實現
package com.lee.test.service.impl; import java.util.List; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import com.lee.test.mapper.UserMapper; import com.lee.test.pojo.User; import com.lee.test.service.UserService; @Service public class UserServiceImpl implements UserService { @Autowired private UserMapper userMapper; @Override public List<User> getUser(int id) { return userMapper.getUser(id); } }
controller層
package com.lee.test.controller; import java.util.List; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.RestController; import com.lee.test.pojo.User; import com.lee.test.service.UserService; @RestController public class UserController { @Autowired private UserService userService; @RequestMapping("/getUser") public List<User> getUser(@RequestParam("id") int id) { return userService.getUser(id); } }
還有mapper.xml的實現
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://www.mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.lee.test.mapper.UserMapper"> <select id="getUser" parameterType="java.lang.Integer" resultType="com.lee.test.pojo.User"> select * from t_user where id = #{id} </select> </mapper>
最後是一些配置在application.properties中
spring.datasource.driverClassName=com.mysql.jdbc.Driver spring.datasource.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8 spring.datasource.username=root spring.datasource.password=root mybatis.mapper-locations: classpath:mapper/*.xml