@Entity
public class User {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Long id;
@Column(nullable = false, unique = true)
private String user_name;
@Column
private String user_password;
public User(Long id, String user_name, String user_password){
this.id = id;
this.user_name = user_name;
this.user_password = user_password;
}
public User(String user_name, String user_password){
this.user_name = user_name;
this.user_password = user_password;
}
public User(){
};
public Long getId() {
return id;
}
public void setId(Long id) {
this.id = id;
}
public String getUser_name() {
return user_name;
}
public void setUser_name(String user_name) {
this.user_name = user_name;
}
public String getUser_password() {
return user_password;
}
public void setUser_password(String user_password) {
this.user_password = user_password;
}
}
UserRepository类,继承JpaRepository类,具有简单的操作数据库函数
public interface UserRepository extends JpaRepository<User, Long> {
}
创建UserCOntroller,并注入UserRepository
@RestController
@RequestMapping("test")
public class UserController {
@Autowired
private UserRepository userRepository;
@GetMapping("/saveUser")
public void saveUser(String userName, String userPassword){
User user = new User(userName, userPassword);
userRepository.save(user);
}
@GetMapping("/updateUser")
public void updateUser(Long id, String userName, String userPassword){
User user = new User(id, userName, userPassword);
userRepository.save(user);
}
@GetMapping("/deleteUser")
public void deleteUser(Long id){
userRepository.deleteById(id);
}
@GetMapping("/getUserById")
public Optional<User> getUserById(Long id){
return userRepository.findById(id);
}
}