SpringBoot秒杀系统实战04-集成Mybatis与druid

文章目录

• 1.在pom.xml文件中添加pom依赖
• 2.在application.properties添加mybatis配置项
• 3.配置数据源和连接池druid
• 4.引入jdbc和druid的依赖
• 5.测试

1.在pom.xml文件中添加pom依赖

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

2.在application.properties添加mybatis配置项

#mybatis
#是否打印sql语句
#spring.jpa.show-sql= true
mybatis.type-aliases-package=com.ljs.miaosha.domain
#mybatis.type-handlers-package=com.example.typehandler
#下划线转换为驼峰
mybatis.configuration.map-underscore-to-camel-case=true
mybatis.configuration.default-fetch-size=100
#ms --3000ms--->3s
mybatis.configuration.default-statement-timeout=3000
#mybatis配置文件路径
#mapperLocaitons
mybatis.mapper-locaitons=classpath:com/ljs/miaosha/dao/*.xml

注意：光有mybatis还是不能访问数据库，还需要数据源。

3.配置数据源和连接池druid

#druid连接池
spring.datasource.url=jdbc:mysql://localhost/miaosha?useUnicode=true&characterEncoding=utf8&useSSL=false
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.filters=stat
# 初始化大小，最小，最大数据源
spring.datasource.initialSize=100
spring.datasource.minIdle=500
spring.datasource.maxActive=1000
spring.datasource.maxWait=60000
spring.datasource.timeBetweenEvictionRunsMillis=60000
spring.datasource.minEvictableIdleTimeMillis=30000
spring.datasource.validationQuery=select 'x'
spring.datasource.testWhileIdle=true
spring.datasource.testOnBorrow=false
spring.datasource.testOnReturn=false
spring.datasource.poolPreparedStatements=true
spring.datasource.maxPoolPreparedStatementPerConnectionSize=20

4.引入jdbc和druid的依赖

 <dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.0.5</version>
</dependency>

5.测试

• 新建miaosha数据库,创建测试表t_user,并写入两条数据。

	create table t_user
	(
	id BIGINT(20) primary key not null auto_increment,
	name varchar(16) DEFAULT NULL
	);

• 在controller里面写一个请求测试,创建一个UserService，并且注入到controller里面

@Controller
@RequestMapping("/demo")//注意！！！加了一个路径
public class DemoController {
	@Autowired
	UserService userService;
	@RequestMapping("/db/get")
	@ResponseBody
	public Result<User> dbGet() {//0代表成功		
		User user=userService.getById(1);
		System.out.println("res:"+user.getName());
		return Result.success(user);
	}
}

• Service代码，UserService 里面注入userDao

@Service
public class UserService {
@Autowired
UserDao userDao;
public User getById(int id) {
    return userDao.getById(id);
}   
//使用事务
@Transactional
public boolean tx() {
    User user=new User();
    user.setId(3);
    user.setName("ljs");
    userDao.insert(user);       
    User user1=new User();
    user1.setId(1);
    user1.setName("ljs2");
    userDao.insert(user1);          //这里出问题则回滚  
    return true;
   }
}

• userDao代码，直接使用注解，不需要再去配置xml文件。

@Mapper
public interface UserDao {
@Select("select * from t_user where id=#{id}")//@Param("id")进行引用
public User getById(@Param("id")int id);    
@Insert("insert into t_user(id,name) values(#{id},#{name})")  //id为自增的，所以可以不用设置id
public void insert(User user);
}

• User Bean

public class User {
private int id;
private String name;
public User() {
}
public User(int id,String name) {
    this.id=id;
    this.name=name;
}
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;
}
}