一、从零搭建环境
springboot,插件选LomBok,
<!--Web必要的-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!--spring data jpa-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<!-- MySQL的java驅動 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
配置yml文件
#服务端容器的配置
server:
port: 8887
#数据库配置
spring:
datasource:
username: 填写自己的
password: 填写自己的
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://填写自己的机器:3306/填写自己的库?useUnicode=true&characterEncoding=utf-8&serverTimezone=UTC
# JPA配置
jpa:
hibernate:
ddl-auto: update
show-sql: true
# formatSQL得这样写
properties:
hibernate:
format_sql: true
准备好数据库,表,字段
准备写entity,实体类
写一个User实体
ackage com.zhongfucheng.example.demo.domain;
import lombok.Data;
import org.hibernate.annotations.GenericGenerator;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;
import java.io.Serializable;
import java.util.Date;
/**
* 存储用户的信息
*
* @author ozc
* @version 1.0
*/
@Entity // jpa的注解,需要加
@Table(name = "table_user") // 指定数据库的表名
@Data // lombok
public class User implements Serializable {
@Id
@GeneratedValue(generator = "system-uuid")
@GenericGenerator(name = "system-uuid", strategy = "uuid")
private String userId;
private String userNickname;
private String userPassword;
private String userEmail;
private Integer actiState;
//激活成功与激活失败常量
public static final int ACTIVATION_SUCCESSFUL = 1;
public static final int ACTIVATION_UNSUCCESSFUL = 0;
private String actiCode;
private Date tokenExptime;
}
写一个接口,写一个UserRepository
UserRepository是dao层的东西了,相当于UserDao/UserMapper,只是叫法不一样而已。比如在Struts2喜欢将名字取成xxxAction,而在SpringMVC喜欢将名字取成xxxxController。
一般地,我们将UserRepository继承JpaRepository就可以有对应的增删改查方法:
请看Spring Data JPA的Repository接口讲解接口内容,在Repositity里构造一个继承的接口,
注意尖括号里写的是<类名,id的数据类型>
public interface UserRepository extends JpaRepository<User, Integer> {
}
写一个UserService
// 接口
public interface UserService {
List<User> getAllUser();
}
// 实现
@Service
public class UserServiceImpl implements UserService {
@Autowired
private UserRepository userRepository;
@Override
public List<User> getAllUser() {
return userRepository.findAll();
}
}
写一个controller
UserController调用一下service的方法,看是否能返回成功,如果能返回成功,那说明我们的环境已经是ok的了。
UserController代码如下:
@RestController
public class UserController {
@Autowired
private UserService userService;
/**
* 得到所有用户
*/
@GetMapping(value = "/user", produces = {"application/json;charset=UTF-8"})
public void getAllUser () {
List<User> allUser = userService.getAllUser();
for (User user : allUser) {
System.out.println(user);
}
}
}
测试一下看是否能返回数据