driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://localhost:3306/db0711?serverTimezone=UTC
username: root
password: root
jpa:
hibernate:
#ddl-auto: create
ddl-auto: update
show-sql: true
eureka:
client:
service-url:
defaultZone: http://localhost:8761/eureka/
创建Student.java,完成创建表、设置自增、设置数据库字段等等;
- 在导Id的包时应导入:import javax.persistence.*;
- 注意使用@Entity声明为实体类
/**
- Created by Kak on 2020/9/25.
*/
@Data
@NoArgsConstructor
@AllArgsConstructor
@Entity //声明为实体类
@Table(name = “TB_STUDENT”)
public class Student implements Serializable{
@Id
//创建自增
@GeneratedValue(strategy = GenerationType.IDENTITY)
//数据库字段
@Column(name = “ss_id”)
private Integer ssId;
@Column(name = “ss_name”)
private String ssname;
//默认数据库字段与该字段一致
private String sex;
private String age;
}
/**
-
dao接口
-
Repository 顶级接口 空
-
CrudRepository 派生 默认实现了CRUD
-
PagingAndSortingRepository 继续派生 增加了分页和排序功能
-
JpaRepository 继续派生 增加了批量处理功能
-
Created by Kak on 2020/9/25.
*/
@Repository
public interface StudentRepository extends JpaRepository<Student,Integer>{
}
3.4.1 StudentService接口
/**
- Created by Kak on 2020/9/25.
*/
public interface StudentService {
/**
-
查询全部学生信息
-
@return 学生信息
*/
public List findAllStudent();
/**
-
通过id查询学生信息
-
@param sid 传入的id
-
@return 学生对象
*/
public Student findStuById(Integer sid);
/**
-
添加记录到数据表
-
@param student 无主键
-
@return student 有主键
*/
public Student addStudent(Student student);
/**
-
@param student 修改的对象信息(必须有主键)<