Java-学生管理系统
时间：2023-09-26 21:07:02
创建学校实体类College
package c02.s02.p02.bean; import java.sql.ResultSet; import java.sql.Time; import java.util.Date; /** * 功能： * 作者：hf * 日期：2022年 06月 11日 */ public class College {
private int id; private String username; private String password; private String telephone; private Time register_time; private String president; private String name; private ResultSet startTime; private String email; public int getId() {
return id; } public void setId(int 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 getTelephone() {
return telephone;
}
public void setTelephone(String telephone) {
this.telephone = telephone;
}
public Time getRegister_time() {
return register_time; }
public void setRegister_time(Time register_time) {
this.register_time = register_time; }
@Override
public String toString() {
return "User{" +
"id=" + id +
", username='" + username + '\'' +
", password='" + password + '\'' +
", telephone='" + telephone + '\'' +
", registerTime=" + register_time +
'}';
}
public void setPresident(String president) {
this.president = president;
}
public String getPresident() {
return president;
}
public void setName(String name) {
this.name = name;
}
public void setStartTime(Date start_time) {
}
public void setEmail(String email) {
}
public void setAddress(String address) {
}
public void setProfile(String profile) {
}
public String getName() {
return null;
}
public ResultSet getStartTime() {
return startTime;
}
public String getEmail() {
return email;
}
public String getProfile() {
return null;
}
}
创建状态实体类Status
package c02.s02.p02.bean;
/** * 功能： * 作者：hf * 日期：2022年 06月 11日 */
public class Status {
private int id;
private String college;
private String version;
private String author;
private String telephone;
private String address;
private String email;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getCollege() {
return college;
}
public void setCollege(String username) {
this.college = college;
}
public String getVersion() {
return version;
}
public void setVersion(String password) {
this.version = version;
}
public String getAuthor() {
return author;
}
public void setAuthor(String author) {
this.author = author;}
public String getTelephone() {
return telephone;
}
public void setTelephone(String telephone) {
this.telephone = telephone;
}
public String getAdress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email; }
@Override
public String toString() {
return "User{" +
"id=" + id +
", username='" + college + '\'' +
", password='" + version + '\'' +
", telephone='" + author + '\'' +
", telephone='" + telephone + '\'' +
", telephone='" + address + '\'' +
", registerTime=" + email +
'}';
}
public String getAddress() {
return null;
}
}
创建学生实体类Student
package c02.s02.p02.bean;
/** * 功能： * 作者：hf * 日期：2022年 06月 11日 */
public class Student {
private int id;
private String name;
private String sex;
private int age;
private String department;
private String t_class ;
private String telephone;
public Student() {
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getSex() {
return sex ; }
public void setSex(String sex) {
this.sex = sex;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
public String getDepartment() {
return department;
}
public void setDepartment(String department) {
this.department = department;
}
public String getT_class() {
return t_class ; }
public void setT_class(String t_class) {
this.sex = t_class;
}
public String getTelephone() {
return telephone ; }
public void setTelephone(String telephone) {
this.telephone = telephone; }
@Override
public String toString() {
return "User{" +
"id=" + id +
", username='" + name + '\'' +
", username='" + sex + '\'' +
", username='" + age + '\'' +
", username='" + department + '\'' +
", username='" + t_class + '\'' +
", username='" + telephone + '\'' +
'}';
}
}
创建用户实体类User
package c02.s02.p02.bean;
import java.util.Date;
/** * 功能：用户实体类 * 作者：hf * 日期：2022年 06月 11日 */
public class User {
private int id;
private String username;
private String password;
private String telephone;
private Date registerTime;
public int getId() {
return id;
}
public void setId(int 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 getTelephone() {
return telephone;
}
public void setTelephone(String telephone) {
this.telephone = telephone;
}
public Date getRegisterTime() {
return registerTime;
}
public void setRegisterTime(Date registerTime) {
this.registerTime = registerTime;
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", username='" + username + '\'' +
", password='" + password + '\'' +
", telephone='" + telephone + '\'' +
", registerTime=" + registerTime +
'}';
}
}
创建数据库连接管理类
package c02.s02.p02.dbutils;
import com.mysql.jdbc.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
/** * 功能：数据库连接管理类 * 作者：hf * 日期：2022年 06月 11日 */
public class ConnectionManager {
// 数据库连接属性
private static final String DRIVER = "com.mysql.jdbc.Driver";
private static final String URL = "jdbc:mysql://localhost:3306/student?useSSL=false";
private static final String USER = "root";
private static final String PASSWORD = "qian0717."; // 改成自己数据库的密码
/** * 私有化构造方法，拒绝实例化 */
private ConnectionManager() {
}
/** * 获取数据库连接静态方法 * * @return 数据库连接 */
public static Connection getConnection() {
// 定义数据库连接
Connection conn = null;
try {
// 安装数据库驱动
Class.forName(DRIVER);
// 获取数据库连接
conn = (Connection) DriverManager.getConnection(URL, USER, PASSWORD);
// 提示用户数据库连接成功
System.out.println("提示：数据库连接成功~");
} catch (ClassNotFoundException e) {
System.err.println("异常：数据库驱动程序未找到！");
} catch (SQLException e) {
System.err.println("异常：数据库连接失败！");
}
// 返回数据库连接
return conn;
}
/** * 关闭数据库连接静态方法 * * @param conn */
public static void closeConnection(Connection conn) {
// 判断连接是否为空
if (conn != null) {
try {
// 判断连接是否关闭
if (!conn.isClosed()) {
// 关闭数据库连接，释放资源
conn.close();
// 提示用户
System.out.println("提示：数据库连接关闭~");
}
} catch (SQLException e) {
System.err.println(e.getMessage());
}
}
}
/** * 主方法测试数据库连接 * * @param args */
public static void main(String[] args) {
// 获取数据库连接
Connection conn = getConnection();
// 关闭数据库连接
closeConnection(conn);
}
}
创建数据访问接口
package c02.s02.p02.dao;
import c02.s02.p02.bean.College;
/** * 功能：创建学校数据访问接口 * 作者：hf * 日期：2022年 06月 11日 */
public interface CollegeDao {
College findById(int id);
int update(College college);
}
package c02.s02.p02.dao;
import c02.s02.p02.bean.Status;
/** * 功能：创建状态数据访问接口 * 作者：hf * 日期：2022年 06月 11日 */
public interface StatusDao {
Status findById(int id);
int update(Status status);
}
package c02.s02.p02.dao;
import c02.s02.p02.bean.Student;
import java.util.List;
import java.util.Vector;
/** * 功能：创建学生数据访问接口 * 作者：hf * 日期：2022年 06月 11日 */
public interface StudentDao {
int insert(Student student);
int deleteById(String id);
int deleteByClass(String clazz);
int deleteByDepartment(String department);
int update(Student student);
Student findById(String id);
List<Student> findByName(String name);
List<Student> findByClass(String clazz);
List<Student> findByDepartment(String department);
List<Student> findAll();
Vector findRowsBySex();
Vector findRowsByClass();
Vector findRowsByDepartment();
}
package c02.s02.p02.dao;
import c02.s02.p02.bean.User;
import java.util.List;
/** * 功能：用户数据访问接口 * 作者：hf * 日期：2022年 06月 11日 */
public interface UserDao {
