springboot集成mybatis实例代码
springboot如何配置web项目请参考前一章,在此基础上集成mybatis。
在pom文件中添加mybatis的依赖:
org.mybatis.spring.boot mybatis-spring-boot-starter 1.2.0
添加mysql驱动:
mysql mysql-connector-java
添加druid和fastjson依赖,使用阿里巴巴druid连接池
com.alibaba druid 1.0.28 com.alibaba fastjson 1.2.30
配置数据源,在application.yml中:
spring: datasource: name:test url:jdbc:mysql://127.0.0.1:3306/test username:root password:111111 #使用druid数据源 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和model扫描路径:
mybatis: mapperLocations:classpath:mapper/*.xml typeAliasesPackage:com.yingxinhuitong.demo.model #更多配置请参见:http://www.mybatis.org/spring-boot-starter/mybatis-spring-boot-autoconfigure/
接下来我们新建userMapper.xml,UserEntity以及UserDao:
UserEntity.class
packagecom.yingxinhuitong.demo.model; /** *Createdbyjackon2017/4/20. */ publicclassUserEntity{ privateLongid; privateStringusername; privateStringpassword; publicLonggetId(){ returnid; } publicvoidsetId(Longid){ this.id=id; } publicStringgetUsername(){ returnusername; } publicvoidsetUsername(Stringusername){ this.username=username; } publicStringgetPassword(){ returnpassword; } publicvoidsetPassword(Stringpassword){ this.password=password; } }
UserDao
packagecom.yingxinhuitong.demo.dao; importcom.yingxinhuitong.demo.model.UserEntity; importorg.apache.ibatis.annotations.Mapper; importjava.util.List; /** *Createdbyjackon2017/4/20. */ @Mapper publicinterfaceUserDao{ ListsearchAll(); }
UserMapper.xml
select*fromtab_user
创建一个控制器,注入UserDao,测试一下可不可以查询数据了:
@RestController publicclassTestController{ @Resource UserDaouserDao; @RequestMapping("/getusers") publicStringtest(){ Listusers=userDao.searchAll(); StringusersJson=JSON.toJSONString(users); returnusersJson; } }
运行Application.class,启动成功后访问:http://localhost:9000/demo/getusers,输出内容如下:
[{"id":1,"password":"000000","username":"test"},{"id":2,"password":"111111","username":"test1"},{"id":3,"password":"222222","username":"test2"}]
至此,springboot已完成对mybatis的集成。
以上就是本文的全部内容,希望对大家的学习有所帮助,也希望大家多多支持毛票票。