SpringBoot集成Redis并给key添加前缀
SpringBoot集成Redis 1. 这里注意的是我原来使用redis都没开启密码,开启密码要在redis.conf下修改 requirepass redis密码 2. 添加jedis依赖: <…
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.2</version>
</dependency>
#mybatis
mybatis.type-aliases-package=com.liuyao.miaosha.domain
mybatis.configuration.map-underscore-to-camel-case=true
mybatis.configuration.default-fetch-size=100
mybatis.configuration.default-statement-timeout=30
mybatis.mapper-locations=classpath:com/liuyao/miaosha/dao/*.xml
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.10</version>
</dependency>
# druid
spring.datasource.url=jdbc:mysql://localhost:3306/miaosha?useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&useSSL=false
spring.datasource.username=root
spring.datasource.password=
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.filters=stat
spring.datasource.maxActive=2
spring.datasource.initialSize=1
spring.datasource.maxWait=60000
spring.datasource.minIdle=1
spring.datasource.timeBetweenEvictionRunsMillis=60000
spring.datasource.minEvictableIdleTimeMillis=300000
spring.datasource.validationQuery=select 'x'
spring.datasource.testWhileIdle=true
spring.datasource.testOnBorrow=false
spring.datasource.testOnReturn=false
spring.datasource.poolPreparedStatements=true
spring.datasource.maxOpenPreparedStatements=20
测试UserDao(sql语句可以直接写在方法上)
import com.liuyao.miaosha.domain.User;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
@Mapper
public interface UserDao {
@Select("select * from user where id = #{id}")
public User getById(@Param("id") int id);
@Insert("insert into user(id,name) values(#{id},#{name})")
int insert(User user);
}
测试事务:
@Transactional
public boolean tx() {
User user1 = new User();
user1.setId(2);
user1.setName("bbb");
userDao.insert(user1);
User user2 = new User();
user2.setId(1);
user2.setName("ccc");
userDao.insert(user2);
return true;
}
插入一个在数据库中已经存在的用户,将会导致回滚
SpringBoot集成Redis 1. 这里注意的是我原来使用redis都没开启密码,开启密码要在redis.conf下修改 requirepass redis密码 2. 添加jedis依赖: <…
Zookeeper简介 中间件,提供协调服务 作用于分布式系统,发挥其优势,可以为大数据服务 支持Java,提供Java语言和C语言的客户端api 什么是分布式系统 很多台计算机组成一个整体,…