初试Springboot+Mybatis

大致目录

1.pom添加关键依赖

<parent>
   <groupId>org.springframework.boot</groupId>
   <artifactId>spring-boot-starter-parent</artifactId>
   <version>1.5.10.RELEASE</version>
   <relativePath/> <!-- lookup parent from repository -->
</parent>

<dependency>
   <groupId>org.mybatis.spring.boot</groupId>
   <artifactId>mybatis-spring-boot-starter</artifactId>
   <version>1.3.1</version>
</dependency>

2.使用generator插件生成生成 Mapper、model、Mapper.xml

3.删除application.properties文件，新增application.yml文件，内容如下

server:
  port: 8080

spring:
  datasource:
    name: datasource
    url: jdbc:mysql://192.168.4.xx:3306/mytest
    username: root
    password: xxxxxx
    type: com.alibaba.druid.pool.DruidDataSource
    driver-class-name: com.mysql.jdbc.Driver
    filters: stat
    maxActive: 20
    initialSize: 1
    maxWait: 60000
    minIdle: 1
    timeBetweenEvictionRunsMillis: 60000
    minEvictableIdleTimeMillis: 300000
    validationQuery: select 'x'
    testWhileIdle: true
    testOnBorrow: false
    testOnReturn: false
    poolPreparedStatements: true
    maxOpenPreparedStatements: 20

mybatis:
  mapper-locations: classpath:sqlmap/*.xml
  type-aliases-package: com.mytest.demo0227

#pagehelper��ҳ���
pagehelper:
  helperDialect: mysql
  reasonable: true
  supportMethodsArguments: true
  params: count=countSql

其中mybatis配置项

       mapper-locations：配置到生成的Mapper.xml路径

       type-aliases-package:配置到包

4.编辑service

public interface UserService {

    boolean checkUserByName(String username);
}

@Service括号内为给该服务起的名称

@Service("aaa")
public class UserServiceImpl implements UserService{

    @Resource
    private NewuserMapper newuserMapper;

    @Override
    public boolean checkUserByName(String username){
        boolean b=false;
        NewuserExample newuserExample=new NewuserExample();
        NewuserExample.Criteria criteria=newuserExample.createCriteria();
        criteria.andNameEqualTo(username);
        List<Newuser> newusers = newuserMapper.selectByExample(newuserExample);

        if (!CollectionUtils.isEmpty(newusers)){
            b=true;
        }
        return  b;
    }
}

5.编辑Controller，此处注入的aaa即为上面为service起的名字

@RestController
@RequestMapping(value ="/user")
public class UserController {

    @Autowired
    private UserService aaa;

    @RequestMapping(value = "/usercheck", produces = {"application/json;charset=UTF-8"})
    public String checkUser(@RequestParam(value = "username", defaultValue = "") String username){
        String s="404";
        boolean b = aaa.checkUserByName(username);
        if (b){
            s="200";
        }
        return s;
    }
}

6.编辑主函数

主要是添加注解@MapperScan("com.mytest.demo0227.mapper")  引号内为Mapper所在包路径，指定扫描位置

@SpringBootApplication
@MapperScan("com.mytest.demo0227.mapper")
public class Demo0227Application {

   public static void main(String[] args) {
      SpringApplication.run(Demo0227Application.class, args);
   }
}

7.执行主函数，访问Controller路径