springboot集成mybatis实例代码

2024-02-25 08:27:03 56

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的集成。

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持毛票票。

springboot集成mybatis实例代码

热门推荐

随机推荐