此案例使用的是 springboot
首先这是之前的表格
加入依赖
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
<version>2.7.1</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
</dependency>
接着编写配置文件
#mysql 的最新驱动类
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/数据库名称
spring.datasource.username=账号
spring.datasource.password=密码
spring.jpa.hibernate.ddl-auto=update
#这里推荐使用update 可选值有create(每次执行都会删除表重新创建表格后执行SQL语句) none(不创建表格,只执行SQL语句) update(有表格就执行sql语句 没有表格就创建表格后执行SQL语句)
然后编写实体类
import javax.persistence.*;
@Entity
@Data
@Table(name = "user")
public class User {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "id")
private Integer id;
@Column(name = "username")
private String username;
@Column(name = "password")
private String password;
public User(Integer id, String username, String password) {
this.id = id;
this.username = username;
this.password = password;
}
public User() {
}
}
顺手也把Repository也写了
import com.example.dao.mysql.domain.User;
import org.springframework.data.jpa.repository.JpaRepository;
public interface UserRepository extends JpaRepository<User,Integer> {
/*JpaRepository<User,Integer> User是实体类的名字 Integer是这个实体类的主键的类型*/
}