引入依赖
<dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.3.3</version> </dependency> <dependency> <groupId>commons-dbcp</groupId> <artifactId>commons-dbcp</artifactId> <version>1.4</version> </dependency> <dependency> <groupId>com.oracle</groupId> <artifactId>ojdbc6</artifactId> <version>6.0</version> </dependency
编写dao和service
public interface UserDao { List<User> selectUser(); } public interface UserService { List<User> findUser(); } @Service @Transactional public class UserServiceImpl implements UserService { @Autowired private UserDao userDao; @Override public List<User> findUser() { return userDao.selectUser(); } }
编写配置文件
spring: mvc: view: prefix: / suffix: .html static-path-pattern: /public/** # 数据源配置 datasource: type: org.apache.commons.dbcp.BasicDataSource username: root url: jdbc:mysql://localhost:3306/table_name password: root driver-class-name: com.mysql.jdbc.Driver # mybatis配置 mybatis: mapper-locations: classpath:com/hp/mapper/*Mapper.xml #指定mapper配置文件位置 type-aliases-package: com.hp.entity #指定起别名来的类
编写启动类,指定dao接口的位置
@SpringBootApplication @MapperScan("com.hp.dao") public class App { public static void main(String[] args) { SpringApplication.run(App.class, args); } }