2024/1/24日 日志 期末考试案例回顾与分析---》综合案例（3）

以下为数据库层面准备
sql:

点击查看代码

create table ft_user(
	id int primary key auto_increment,
	username varchar(30),
	password varchar(30),
	identify varchar(100)
);

create table ft_dailyReport(
	id INT NOT NULL PRIMARY KEY  AUTO_INCREMENT,
  publishDate varCHAR(20) NOT NULL,
  stuno int,
  name VARCHAR(255),
	spenttime int,
  codeamount int,
  blogsnumber int,
  knowledgePoints varchar(100),
  state varchar(20) NOT NULL,
  dailyscore int,
  stateReason varchar(100)
	
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4,
AUTO_INCREMENT = 2024001;

CREATE TABLE ft_internalMessage (
  id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
  category varchar(20),
  senderName VARCHAR(255),
  senderNo varCHAR(8),
  receiverName VARCHAR(255),
  receiverNo varCHAR(8),
  content varchar(100),
  state varchar(100)
  
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4,
AUTO_INCREMENT = 202401;

CREATE TABLE ft_userInfo (
  userID INT not null PRIMARY KEY AUTO_INCREMENT,
  userName VARCHAR(255),
  userCategory varchar(20) NOT NULL,
  groupno INT DEFAULT 0
	
)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4,
AUTO_INCREMENT = 20240001;

pojo类
DailyReport

点击查看代码

package com.Moonbeams.pojo;

public class DailyReport {
    private Integer id;
    private String publishDate;
    private Integer stuno;
    private String name;
    private Integer spentTime;
    private Integer codeamount;
    private Integer blogsnumber;
    private String knowledgePoints;
    private String state;
    private Integer dailyScore;
    private String stateReason;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getPublishDate() {
        return publishDate;
    }

    public void setPublishDate(String publishDate) {
        this.publishDate = publishDate;
    }

    public Integer getStuno() {
        return stuno;
    }

    public void setStuno(Integer stuno) {
        this.stuno = stuno;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Integer getSpentTime() {
        return spentTime;
    }

    public void setSpentTime(Integer spentTime) {
        this.spentTime = spentTime;
    }

    public Integer getCodeamount() {
        return codeamount;
    }

    public void setCodeamount(Integer codeamount) {
        this.codeamount = codeamount;
    }

    public Integer getBlogsnumber() {
        return blogsnumber;
    }

    public void setBlogsnumber(Integer blogsnumber) {
        this.blogsnumber = blogsnumber;
    }

    public String getKnowledgePoints() {
        return knowledgePoints;
    }

    public void setKnowledgePoints(String knowledgePoints) {
        this.knowledgePoints = knowledgePoints;
    }

    public String getState() {
        return state;
    }

    public void setState(String state) {
        this.state = state;
    }

    public Integer getDailyScore() {
        return dailyScore;
    }

    public void setDailyScore(Integer dailyScore) {
        this.dailyScore = dailyScore;
    }

    public String getStateReason() {
        return stateReason;
    }

    public void setStateReason(String stateReason) {
        this.stateReason = stateReason;
    }

    @Override
    public String toString() {
        return "DailyReport{" +
                "id=" + id +
                ", publishDate='" + publishDate + '\'' +
                ", stuno=" + stuno +
                ", name='" + name + '\'' +
                ", spentTime=" + spentTime +
                ", codeamount=" + codeamount +
                ", blogsnumber=" + blogsnumber +
                ", knowledgePoints='" + knowledgePoints + '\'' +
                ", state='" + state + '\'' +
                ", dailyScore=" + dailyScore +
                ", stateReason='" + stateReason + '\'' +
                '}';
    }
}

InternalMessage

点击查看代码

package com.Moonbeams.pojo;

public class InternalMessage {
    private Integer id;
    private String category;
    private String senderName;
    private String senderNo;
    private String receiverName;
    private String receiverNo;
    private String content;
    private String state;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getCategory() {
        return category;
    }

    public void setCategory(String category) {
        this.category = category;
    }

    public String getSenderName() {
        return senderName;
    }

    public void setSenderName(String senderName) {
        this.senderName = senderName;
    }

    public String getSenderNo() {
        return senderNo;
    }

    public void setSenderNo(String senderNo) {
        this.senderNo = senderNo;
    }

    public String getReceiverName() {
        return receiverName;
    }

    public void setReceiverName(String receiverName) {
        this.receiverName = receiverName;
    }

    public String getReceiverNo() {
        return receiverNo;
    }

    public void setReceiverNo(String receiverNo) {
        this.receiverNo = receiverNo;
    }

    public String getContent() {
        return content;
    }

    public void setContent(String content) {
        this.content = content;
    }

    public String getState() {
        return state;
    }

    public void setState(String state) {
        this.state = state;
    }

    @Override
    public String toString() {
        return "InternalMessage{" +
                "id=" + id +
                ", category='" + category + '\'' +
                ", senderName='" + senderName + '\'' +
                ", senderNo='" + senderNo + '\'' +
                ", receiverName='" + receiverName + '\'' +
                ", receiverNo='" + receiverNo + '\'' +
                ", content='" + content + '\'' +
                ", state='" + state + '\'' +
                '}';
    }
}

User

点击查看代码

package com.Moonbeams.pojo;

public class User {
    private Integer id;
    private String username;
    private String password;
    private String identify;

    public Integer getId() {
        return id;
    }

    public void setId(Integer 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 String getIdentify() {
        return identify;
    }

    public void setIdentify(String identify) {
        this.identify = identify;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                ", identify='" + identify + '\'' +
                '}';
    }
}

UserInfo

点击查看代码

package com.Moonbeams.pojo;

public class UserInfo {
    private Integer userID;
    private String userName;
    private String userCategory;
    private Integer groupno;

    public Integer getUserID() {
        return userID;
    }

    public void setUserID(Integer userID) {
        this.userID = userID;
    }

    public String getUserName() {
        return userName;
    }

    public void setUserName(String userName) {
        this.userName = userName;
    }

    public String getUserCategory() {
        return userCategory;
    }

    public void setUserCategory(String userCategory) {
        this.userCategory = userCategory;
    }

    public Integer getGroupno() {
        return groupno;
    }

    public void setGroupno(Integer groupno) {
        this.groupno = groupno;
    }

    @Override
    public String toString() {
        return "UserInfo{" +
                "userID=" + userID +
                ", userName='" + userName + '\'' +
                ", userCategory='" + userCategory + '\'' +
                ", groupno=" + groupno +
                '}';
    }
}