Mybatis的使用
- 项目结构
- 第一步导入依赖:
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.6</version>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.0.0</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-redis</artifactId>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.10</version>
</dependency>
</dependencies>
- 第二步:修改SpringBoot配置文件application.yml
spring:
datasource:
url: jdbc:mysql://localhost:3306/springboot?serverTimezone=GMT%2B8
username: root
password: 123
driver-class-name: com.mysql.cj.jdbc.Driver
type: com.alibaba.druid.pool.DruidDataSource
- 第三步:创建实体bean User类
@Data
@AllArgsConstructor
@NoArgsConstructor
public class User {
private Integer id;
private String name;
private Integer age;
}
- 第四步:创建Dao接口,使用mybatis注解
@Mapper
public interface UserDao {
/**
* 增加用户
* @param user
*/
@Insert("insert into user(name,age) value(#{name},#{age})")
public void save(User user);
/**
* 修改用户
* @param user
*/
@Update("update user set name=#{name},age=#{age} where id=#{id}")
void update(User user);
/**
* 根据id删除
* @param id
*/
@Delete("delete from user where id=#{id}")
void delete(Integer id);
/**
* 查询所有用户
* @return
*/
@Select("select * from user")
List<User> getAll();
/**
* 查询单个用户
* @param id
* @return
*/
@Select("select * from user where id=#{id}")
User getOne(Integer id);
}
- 第五步:创建Service接口:
public interface UserService {
public void save(User user);
void update(User user);
void delete(Integer id);
List<User> getAll();
User getOne(Integer id);
}
- 第六步:创建Service实现类
@Service
public class UserServiceImpl implements UserService {
@Autowired
UserDao userDao;
@Override
public void save(User user) {
userDao.save(user);
}
@Override
public void update(User user) {
userDao.update(user);
}
@Override
public void delete(Integer id) {
userDao.delete(id);
}
@Override
public List<User> getAll() {
List<User> all = userDao.getAll();
return all;
}
@Override
public User getOne(Integer id) {
User one = userDao.getOne(id);
return one;
}
}
- 第七步:创建Controller:
@RestController
@RequestMapping("/user")
public class UserController {
@Autowired
UserService userService;
@GetMapping("/")
public List<User> getAll(){
return userService.getAll();
}
@GetMapping("/{id}")
public User getOne(@PathVariable("id") Integer id){
return userService.getOne(id);
}
@PostMapping("/")
public Map save(@RequestBody User user){
userService.save(user);
Map map=new HashMap();
map.put("success",true);
map.put("meassge","增加成功");
return map;
}
@DeleteMapping("/{id}")
public Map delete(@PathVariable("id") Integer id){
userService.delete(id);
Map map=new HashMap();
map.put("success",true);
map.put("meassge","删除成功");
return map;
}
@PutMapping("/")
public Map update(@RequestBody User user){
userService.update(user);
Map map=new HashMap();
map.put("success",true);
map.put("meassge","修改成功");
return map;
}
}
- 第八步:修改SpringBoot程序主启动类,增加扫描dao接口:
@SpringBootApplication
@MapperScan("com.offcn.springbootmybatis.dao")
public class SprimngbootMybatisApplication {
public static void main(String[] args) {
SpringApplication.run(SprimngbootMybatisApplication.class, args);
}
}
SpringBoot使用Redis
SpringBoot使用Redis十分简单。
- 首先开启远程Redis远程连接,可以远程访问
- 第一步:添加启动器(增加依赖):
- 第二部,修改配置文件: