前提
数据库,数据库表就不一一列出,具体可以模仿。
环境IDEA2021.3
开始
查看项目结构
项目结构
example
controller
- hellocontroller
- Logincontroller
dao
- BookDao
- UserDao
- DepartmentDao
- BookDaoimpl
- UserDaoimpl
- BookDaoimpl
service
- BookService
- UserService
- DeptService
entity
- Book
- User
- Department
result
- Result
编写实体类,代码如下
实体类的字段就是数据库字段
Book
package com.example.springmysqldemo.entity;
public class Book {
private String userId;
private String username;
private String ustatus;
public String getUserId() {
return userId;
}
public void setUserId(String userId) {
this.userId = userId;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getUstatus() {
return ustatus;
}
public void setUstatus(String ustatus) {
this.ustatus = ustatus;
}
@Override
public String toString() {
return "Book{" +
"userId='" + userId + '\'' +
", username='" + username + '\'' +
", ustatus='" + ustatus + '\'' +
'}';
}
}
User
package com.example.springmysqldemo.entity;
public class User {
private String username;
private String password;
private String id;
private Department department;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public Department getDepartment() {
return department;
}
public void setDepartment(Department department) {
this.department = department;
}
@Override
public String toString() {
return "User{" +
"username='" + username + '\'' +
", password='" + password + '\'' +
", id='" + id + '\'' +
", department=" + department +
'}';
}
}
Department
package com.example.springmysqldemo.entity;
public class Department {
private String d_id;
private String d_name;
private String d_peo;
public String getD_id() {
return d_id;
}
public void setD_id(String d_id) {
this.d_id = d_id;
}
public String getD_name() {
return d_name;
}
public void setD_name(String d_name) {
this.d_name = d_name;
}
public String getD_peo() {
return d_peo;
}
public void setD_peo(String d_peo) {
this.d_peo = d_peo;
}
@Override
public String toString() {
return "Department{" +
"d_id='" + d_id + '\'' +
", d_name='" + d_name + '\'' +
", d_peo='" + d_peo + '\'' +
'}';
}
}
4 条评论
谢谢支持
滴!学生卡!打卡时间:上午8:38:01,请上车的乘客系好安全带~
写得好好哟,我要给你生猴子!::funny:04::
滴!学生卡!打卡时间:下午1:14:42,请上车的乘客系好安全带~