mysql和eclipse用户管理系统,Student 完整的学生管理系统项目源代码:运用eclipse编程软件和MySQL数据库进行设计 - 下载 - 搜珍网...

Student/Student/.classpath

Student/Student/.mymetadata

Student/Student/.project

Student/Student/.settings/.jsdtscope

Student/Student/.settings/com.genuitec.eclipse.core.prefs

Student/Student/.settings/org.eclipse.core.resources.prefs

Student/Student/.settings/org.eclipse.jdt.core.prefs

Student/Student/.settings/org.eclipse.wst.common.component

Student/Student/.settings/org.eclipse.wst.common.project.facet.core.xml

Student/Student/.settings/org.eclipse.wst.jsdt.ui.superType.container

Student/Student/.settings/org.eclipse.wst.jsdt.ui.superType.name

Student/Student/src/cla2sub/servlet/AddCla2SubServlet.java

Student/Student/src/cla2sub/servlet/DeleteCla2SubServlet.java

Student/Student/src/cla2sub/servlet/ExportCal_subServlet.java

Student/Student/src/cla2sub/servlet/GetCountPageServlet.java

Student/Student/src/cla2sub/servlet/PlanAddCla2SubSevlet.java

Student/Student/src/cla2sub/servlet/SearcCla2SubServlet.java

Student/Student/src/cla2sub/servlet/SearchCla2Sub_exServlet.java

Student/Student/src/classes/servlet/AddClassesServlet.java

Student/Student/src/classes/servlet/DeleteClassesServlet.java

Student/Student/src/classes/servlet/EditClassesServlet.java

Student/Student/src/classes/servlet/GetCountPageServlet.java

Student/Student/src/classes/servlet/PlanAddClassesServlet.java

Student/Student/src/classes/servlet/SearchClassesServlet.java

Student/Student/src/classes/servlet/UpdateClassesServlet.java

Student/Student/src/dao/ICla2Sub.java

Student/Student/src/dao/IClasses.java

Student/Student/src/dao/ILogin.java

Student/Student/src/dao/IMajor.java

Student/Student/src/dao/IOperator.java

Student/Student/src/dao/IPicture.java

Student/Student/src/dao/IPrivilege.java

Student/Student/src/dao/IRole.java

Student/Student/src/dao/IScore.java

Student/Student/src/dao/IStudent.java

Student/Student/src/dao/ISubject.java

Student/Student/src/dao/ITeacher.java

Student/Student/src/entity/Cla2Sub.java

Student/Student/src/entity/Classes.java

Student/Student/src/entity/Major.java

Student/Student/src/entity/Operator.java

Student/Student/src/entity/Privilege.java

Student/Student/src/entity/Role.java

Student/Student/src/entity/Score.java

Student/Student/src/entity/Student.java

Student/Student/src/entity/Subject.java

Student/Student/src/entity/Teacher.java

Student/Student/src/filter/EnCodeFilter.java

Student/Student/src/filter/LoginFilter.java

Student/Student/src/impl/Cla2SubImpl.java

Student/Student/src/impl/ClassesImpl.java

Student/Student/src/impl/LoginImpl.java

Student/Student/src/impl/MajorImpl.java

Student/Student/src/impl/OperatorImpl.java

Student/Student/src/impl/PictureImpl.java

Student/Student/src/impl/PrivilegeImpl1.java

Student/Student/src/impl/RoleImpl.java

Student/Student/src/impl/ScoreImpl.java

Student/Student/src/impl/StudentImpl.java

Student/Student/src/impl/SubjectImpl.java

Student/Student/src/impl/TeacherImpl.java

Student/Student/src/login/servlet/LoginServlet.java

Student/Student/src/major/servlet/AddMajorServlet.java

Student/Student/src/major/servlet/DeleteMajorServlet.java

Student/Student/src/major/servlet/EditMajorServlet.java

Student/Student/src/major/servlet/GetCountPageServlet.java

Student/Student/src/major/servlet/SearchMajorServlet.java

Student/Student/src/major/servlet/UpdateMajorServlet.java

Student/Student/src/score/servlet/EditScoreServlet.java

Student/Student/src/score/servlet/GetCountPageServlet.java

Student/Student/src/score/servlet/ReportScoreServlet.java

Student/Student/src/score/servlet/SearchScoreServlet.java

Student/Student/src/score/servlet/UpdateScoreServlet.java

Student/Student/src/student/servlet/AddStudentServlet.java

Student/Student/src/student/servlet/DeleteStudentServlet.java

Student/Student/src/student/servlet/EditStudentServlet.java

Student/Student/src/student/servlet/GetCountPageServlet.java

Student/Student/src/student/servlet/InfoStudentServlet.java

Student/Student/src/student/servlet/PlanAddStudentServlet.java

Student/Student/src/student/servlet/SearchClassmatesServlet.java

Student/Student/src/student/servlet/SearchStudentServlet.java

Student/Student/src/student/servlet/SearchTeacherClassServlet.java

Student/Student/src/student/servlet/UpdateStudentServlet.java

Student/Student/src/subject/servlet/AddSubjectServlet.java

Student/Student/src/subject/servlet/DeleteSubjectServlet.java

Student/Student/src/subject/servlet/EditSubjectServlet.java

Student/Student/src/subject/servlet/GetCountPageServlet.java

Student/Student/src/subject/servlet/SearchSubjectServlet.java

Student/Student/src/subject/servlet/UpdateSubjectServlet.java

Student/Student/src/teacher/servlet/AddTeacherServlet.java

Student/Student/src/teacher/servlet/DeleteTeacherServlet.java

Student/Student/src/teacher/servlet/EditTeacherServlet.java

Student/Student/src/teacher/servlet/GetCountPageServlet.java

Student/Student/src/teacher/servlet/InfoTeacherServlet.java

Student/Student/src/teacher/servlet/SearchTeacherServlet.java

Student/Student/src/teacher/servlet/UpdateTeacherServlet.java

Student/Student/src/util/DB.java

Student/Student/student1.sql

Student/Student/WebRoot/css/add_class_subject.css

Student/Student/WebRoot/css/classmate.css

Student/Student/WebR

以下是一个简单的学生信息管理系统的Java源代码,您可以在Eclipse中创建一个新的Java项目,将以下代码复制到您的Java类中: ``` import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import java.util.Scanner; public class StudentManagementSystem { private static final String URL = "jdbc:mysql://localhost:3306/students"; private static final String USERNAME = "root"; private static final String PASSWORD = "your_password"; private static Connection connection; private static PreparedStatement preparedStatement; public static void main(String[] args) { try { // 连接到MySQL数据库 connection = DriverManager.getConnection(URL, USERNAME, PASSWORD); System.out.println("Database connected!"); // 显示主菜单 displayMainMenu(); // 关闭数据库连接 connection.close(); System.out.println("Database disconnected!"); } catch (SQLException e) { System.err.println("Database connection failed!"); e.printStackTrace(); } } // 显示主菜单 private static void displayMainMenu() throws SQLException { Scanner scanner = new Scanner(System.in); int choice = 0; do { System.out.println("********** Student Management System **********"); System.out.println("1. Add a new student"); System.out.println("2. Update an existing student"); System.out.println("3. Delete a student"); System.out.println("4. View all students"); System.out.println("5. Exit"); System.out.print("Enter your choice (1-5): "); choice = scanner.nextInt(); switch (choice) { case 1: addStudent(); break; case 2: updateStudent(); break; case 3: deleteStudent(); break; case 4: viewAllStudents(); break; case 5: System.out.println("Exiting the system..."); break; default: System.out.println("Invalid choice! Please enter a valid choice (1-5)."); break; } } while (choice != 5); scanner.close(); } // 添加学生信息 private static void addStudent() throws SQLException { Scanner scanner = new Scanner(System.in); System.out.print("Enter the student's name: "); String name = scanner.nextLine(); System.out.print("Enter the student's age: "); int age = scanner.nextInt(); scanner.nextLine(); System.out.print("Enter the student's gender: "); String gender = scanner.nextLine(); System.out.print("Enter the student's email: "); String email = scanner.nextLine(); System.out.print("Enter the student's password: "); String password = scanner.nextLine(); // 将学生信息添加到数据库 String sql = "INSERT INTO students (name, age, gender, email, password) VALUES (?, ?, ?, ?, ?)"; preparedStatement = connection.prepareStatement(sql); preparedStatement.setString(1, name); preparedStatement.setInt(2, age); preparedStatement.setString(3, gender); preparedStatement.setString(4, email); preparedStatement.setString(5, password); int rowsInserted = preparedStatement.executeUpdate(); if (rowsInserted > 0) { System.out.println("A new student has been added successfully!"); } else { System.out.println("Failed to add a new student!"); } scanner.close(); } // 更新学生信息 private static void updateStudent() throws SQLException { Scanner scanner = new Scanner(System.in); System.out.print("Enter the student's email to update: "); String email = scanner.nextLine(); System.out.print("Enter the student's new name: "); String name = scanner.nextLine(); System.out.print("Enter the student's new age: "); int age = scanner.nextInt(); scanner.nextLine(); System.out.print("Enter the student's new gender: "); String gender = scanner.nextLine(); System.out.print("Enter the student's new password: "); String password = scanner.nextLine(); // 更新学生信息 String sql = "UPDATE students SET name = ?, age = ?, gender = ?, password = ? WHERE email = ?"; preparedStatement = connection.prepareStatement(sql); preparedStatement.setString(1, name); preparedStatement.setInt(2, age); preparedStatement.setString(3, gender); preparedStatement.setString(4, password); preparedStatement.setString(5, email); int rowsUpdated = preparedStatement.executeUpdate(); if (rowsUpdated > 0) { System.out.println("The student's information has been updated successfully!"); } else { System.out.println("Failed to update the student's information!"); } scanner.close(); } // 删除学生信息 private static void deleteStudent() throws SQLException { Scanner scanner = new Scanner(System.in); System.out.print("Enter the student's email to delete: "); String email = scanner.nextLine(); // 从数据库中删除学生信息 String sql = "DELETE FROM students WHERE email = ?"; preparedStatement = connection.prepareStatement(sql); preparedStatement.setString(1, email); int rowsDeleted = preparedStatement.executeUpdate(); if (rowsDeleted > 0) { System.out.println("The student's information has been deleted successfully!"); } else { System.out.println("Failed to delete the student's information!"); } scanner.close(); } // 查看所有学生信息 private static void viewAllStudents() throws SQLException { List<Student> students = new ArrayList<Student>(); // 从数据库中获取所有学生信息 String sql = "SELECT * FROM students"; preparedStatement = connection.prepareStatement(sql); ResultSet resultSet = preparedStatement.executeQuery(); while (resultSet.next()) { int id = resultSet.getInt("id"); String name = resultSet.getString("name"); int age = resultSet.getInt("age"); String gender = resultSet.getString("gender"); String email = resultSet.getString("email"); String password = resultSet.getString("password"); students.add(new Student(id, name, age, gender, email, password)); } if (students.size() > 0) { System.out.println("ID\tName\tAge\tGender\tEmail\t\t\tPassword"); for (Student student : students) { System.out.println(student.getId() + "\t" + student.getName() + "\t" + student.getAge() + "\t" + student.getGender() + "\t" + student.getEmail() + "\t" + student.getPassword()); } } else { System.out.println("No students found!"); } } } class Student { private int id; private String name; private int age; private String gender; private String email; private String password; public Student(int id, String name, int age, String gender, String email, String password) { this.id = id; this.name = name; this.age = age; this.gender = gender; this.email = email; this.password = password; } public int getId() { return id; } public String getName() { return name; } public int getAge() { return age; } public String getGender() { return gender; } public String getEmail() { return email; } public String getPassword() { return password; } } ``` 请注意,您需要将“your_password”替换为您的MySQL数据库密码。另外,此代码仅为演示目的,您需要根据您的需求进行修改和改进。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值