Berbagi teknologi

Sistem manajemen siswa JavaFx MySql

2024-07-12

한어Русский языкEnglishFrançaisIndonesianSanskrit日本語DeutschPortuguêsΕλληνικάespañolItalianoSuomalainenLatina

Kata pengantar:

Saya belajar javafx dan database mysql bulan lalu, jadi saya menulis sistem manajemen siswa. Karena saya sedang mereview bulan lalu dan ada beberapa hal yang harus dilakukan, saya cukup sibuk, jadi saya tidak mengupdate blog Agak sederhana, kurang lebih sama, isinya relatif sederhana, jadi sekarang saya akan berbagi dengan Anda sistem manajemen siswa saya, saya berharap siswa yang tertarik dengan aspek ini dapat memberikan bantuan.

🥰个人主页:hati.c

🤓文章专题:sistem manajemen javafx+mysql

👐欢迎大家点赞👍 收藏😽

 

9a7940c627094e34946debbd787da24e.jpg

487ac90190f44b238ebafae9d457463b.png

 

Daftar isi

Tampilan halaman:

Pembuatan paket:

antarmuka masuk:

Antarmuka login siswa:

Penyelidikan informasi siswa:

Sunting

Penyelidikan kinerja siswa:

Antarmuka masuk administrator:

Antarmuka manajemen informasi siswa administrator:

Antarmuka manajemen informasi kursus administrator:

Antarmuka manajemen informasi skor administrator:

Ubah antarmuka siswa:

Tampilan kode:

Jendela utama (endView):

Antarmuka login dan jendela prompt (otherView):

murid:

Antarmuka siswa (studentView):

Pernyataan Siswa Dao:

utilDao:

mahasiswaDao*:

administrator:

Antarmuka administrator (magView):

Alat administrator:

pelajar(siswaUtil):

Kursus(kursusUtil):

Skor (skorUtil):

Kelas alat penilaian (judgeUtil):

Kelas Administrator Dao:

utilDao:

mahasiswaDao*:

kursusDao:

skorDao:

hakimDao:

domain (kelas objek):

murid:

kursus:

skor:

akhir

 

 

Tampilan halaman:

Pembuatan paket:

(Di sini saya menggunakan beberapa struktur framework MVC. Walaupun saya tidak memiliki banyak kode, menurut saya menulis dengan cara ini dapat membuat kode kita lebih ringkas, mudah dipahami, dan sangat terstruktur)

4033c3dc2d754754a7b3f2454d5e9845.png

antarmuka masuk:

Mengenai antarmuka login (tentang antarmuka login, saya menulis beberapa penilaian tentang kotak input teks--Penilaian basis data benar dan beberapa penilaian bukan nol--)

55d6138971d64cfbb14cf719a47454e5.png

Antarmuka login siswa:

87787ba5c3924a76a98926dd8515df68.png

Penyelidikan informasi siswa:

8e9905fc895a44c982abbc457be7a80a.png

Penyelidikan kinerja siswa:

97cefd35d8ad47399c72b79e965a7d4d.png

Antarmuka masuk administrator:

a5114f0d903747b197c0ad925c424043.png

Antarmuka manajemen informasi siswa administrator:

49cd3ef4185041aa8d83bb07e3cc417e.png

Antarmuka manajemen informasi kursus administrator:

d7d32fcf511e4703a0701d4b44141a7f.png

Antarmuka manajemen informasi skor administrator:

584f66d36cdf4bb8a2c0bb845fb20d84.png

Ubah antarmuka siswa:

(Saya pikir semua halaman ini serupa, jadi saya hanya menampilkan antarmuka untuk menambahkan siswa di sini)

9f338156d1d740fca1f060ce0ede42c8.png

 

Tampilan kode:

 

Jendela utama (endView):

Mengenai jendela utama, saya mendefinisikan tahap statis sebagai tahap utama saya, dan menetapkan nilai tahap dalam metode awal saya ke tahap statis. Tujuan pengaturan tahap ini adalah untuk mengintegrasikan metode lain yang saya tulis, seperti antarmuka login, dll. Adegan dalam metode ini ditempatkan di panggung statis saya, sehingga ketika kode saya dieksekusi, halaman saya selalu dapat menggunakan panggung utama dan antarmuka tidak akan tampak berantakan.

  1. public class endView extends Application {
  2.  
  3.     public static Stage stage;
  4.     public static student student0;
  5.     public static course course0;
  6.     public static score score0;
  7.     @Override
  8.     public void start(Stage stage) {
  9.         endView.stage=stage;//这里将主舞台赋值给静态舞台
  10.         stage.setTitle("学生管理系统");
  11.         stage.setResizable(false);
  12.         otherView.login();
  13.         endView.stage.show();
  14.     }
  15.  
  16.     public static void main(String[] args) {
  17.         launch(args);
  18.     }
  19.  
  20. }

Antarmuka login dan jendela prompt (otherView):

  1. //设置登录界面
  2.     public static void login() {
  3.         //创建网格面板
  4.         GridPane gp=new GridPane();
  5.         gp.setVgap(10);
  6.         gp.setHgap(10);
  7.         //创建标签
  8.         Label idL=new Label("id");
  9.         Label passwordL=new Label("密码");
  10.         //创建输入框
  11.         TextField tf=new TextField();
  12.         PasswordField pf=new PasswordField();
  13.         tf.setPromptText("请输入您的id号");
  14.         pf.setPromptText("请输入6位数密码");
  15.         //创建单选按钮
  16.         RadioButton stuB=new RadioButton("学生");
  17.         RadioButton teaB=new RadioButton("管理员");
  18.         //创建单选按钮组
  19.         ToggleGroup tg=new ToggleGroup();
  20.         stuB.setToggleGroup(tg);
  21.         teaB.setToggleGroup(tg);
  22.  
  23.         //创建单行面板
  24.         HBox hBox1=new HBox();
  25.         hBox1.setAlignment(Pos.CENTER);
  26.         hBox1.setSpacing(10);
  27.         hBox1.getChildren().addAll(stuB,teaB);
  28.         //创建登录注册按钮
  29.         Button loginB=new Button("登录");
  30.  
  31.         //给单选按钮组添加监听事件
  32.         tg.selectedToggleProperty().addListener(((observableValue, toggle, t1) -> {
  33.             if(t1.equals(stuB)){
  34.                 idL.setText("id");
  35.             }else if(t1.equals(teaB)){
  36.                 idL.setText("姓名");
  37.  
  38.             }
  39.         }));
  40.  
  41.         loginB.setOnAction(actionEvent -> {
  42.             // 如果内容不为空
  43.             try {
  44.                 String idS=tf.getText().trim();
  45.                 String passwordS=pf.getText().trim();
  46.                 Toggle selectedToggle = tg.getSelectedToggle(); // 获取选中的单选按钮
  47.                 if (selectedToggle != null && selectedToggle.equals(stuB)) { // 检查选中的按钮是否为学生按钮
  48.                     if (studentDao.login(idS,passwordS)) {
  49.                         studentView.stu_login(Integer.parseInt(idS));
  50.                     }else if((idS.isEmpty()||passwordS.isEmpty())){
  51.                         tipJframe("id或密码不能为空");
  52.                     }else{
  53.                         tipJframe("id或密码输入错误");
  54.                     }
  55.                 }
  56.                 else if(selectedToggle !=null && selectedToggle.equals(teaB)){
  57.                     if(judgeDao.magLogin(idS,passwordS)){
  58.                         magView.mag_login();
  59.                     }else  if((idS.isEmpty()||passwordS.isEmpty())){
  60.                         tipJframe("姓名或密码不可为空");
  61.                     }else {
  62.                         tipJframe("姓名或密码输入错误");
  63.                     }
  64.                 }else {
  65.                     tipJframe("你是什么人");
  66.                 }
  67.             } catch (Exception e) {
  68.                 e.printStackTrace();
  69.             }
  70.         });
  71.  
  72.         HBox hBox2=new HBox();
  73.         hBox2.setAlignment(Pos.CENTER);
  74.         hBox2.setSpacing(10);
  75.         hBox2.getChildren().add(loginB);
  76.         //将节点添加到面板当中
  77.         gp.add(idL,0,0);
  78.         gp.add(passwordL,0,1);
  79.         gp.add(tf,1,0);
  80.         gp.add(pf,1,1);
  81.         gp.add(hBox1,1,2);
  82.         gp.add(hBox2,1,3);
  83.         gp.setAlignment(Pos.BASELINE_LEFT);
  84.         //设置面板内边距
  85.         gp.setPadding(new Insets(40,20,10,70));
  86.         //设置面板垂直间距
  87.         gp.setVgap(16);
  88.         Scene scene=new Scene(gp,360,240);
  89.         endView.stage.setScene(scene);
  90.  
  91.     }
  92.     //增加弹出界面
  93.     public static void tipJframe(String str){
  94.         Label label=new Label(str);
  95.         Button rebackB=new Button("返回");
  96.         VBox vBox=new VBox(label,rebackB);
  97.         vBox.setSpacing(10);
  98.         vBox.setAlignment(Pos.CENTER);
  99.         Scene scene=new Scene(vBox,150,100);
  100.         Stage stage1=new Stage();
  101.         stage1.setScene(scene);
  102.         stage1.setTitle("提示");
  103.         stage1.show();
  104.         rebackB.setOnAction(actionEvent -> {
  105.             stage1.close();
  106.         });
  107.  
  108.     }

murid:

Antarmuka siswa (studentView):

Di bawah ini adalah tiga antarmuka yang saya tulis. Dibandingkan dengan gambar login siswa di atas, keduanya sesuai dengan total tiga metode. Tentu saja, dua metode terakhir (kueri skor dan kueri informasi) akan ditempatkan di metode stu_login pertama aksi monitor tombol dan fungsinya

  1. //学生登录后界面
  2.     public static void stu_login(int stu_Id){
  3.         Label label=new Label("学生查询系统");
  4.         Button informationB=new Button("个人信息");
  5.         Button gradeB=new Button("成绩查询");
  6.         Button returnLogin=new Button("返回登录");
  7.  
  8.         //设置按钮字体颜色
  9.         informationB.setTextFill(Color.BLUE);
  10.         gradeB.setTextFill(Color.BLUE);
  11.         returnLogin.setTextFill(Color.BLUE);
  12.  
  13.         //设置字体样式
  14.         Font font = Font.font("Comic Sans MS", FontWeight.BOLD, FontPosture.REGULAR, 20);
  15.         label.setFont(font);
  16.         informationB.setFont(font);
  17.         gradeB.setFont(font);
  18.         returnLogin.setFont(font);
  19.  
  20.         //为按钮添加监听事件
  21.         //信息查询
  22.         informationB.setOnAction(actionEvent -> {
  23.             try {
  24.                 informationInquire(stu_Id);
  25.             } catch (Exception e) {
  26.                 e.printStackTrace();
  27.             }
  28.         });
  29.         //成绩查询
  30.         gradeB.setOnAction(actionEvent -> {
  31.             try {
  32.                 gradeInquire(stu_Id);
  33.             } catch (Exception e) {
  34.                 throw new RuntimeException(e);
  35.             }
  36.         });
  37.         //返回登录
  38.         returnLogin.setOnAction(actionEvent -> otherView.login());
  39.  
  40.         //添加竖直方向面板
  41.         VBox vBox=new VBox(20,label,informationB,gradeB,returnLogin);
  42.         vBox.setAlignment(Pos.CENTER);
  43.         Scene scene=new Scene(vBox,400,300);
  44.         endView.stage.setScene(scene);
  45.  
  46.     }
  47.     //学生信息查询
  48.     public static void informationInquire(int stu_Id) throws Exception {
  49.         //调用inquiry的返回值student
  50.         student student= studentDao.returnStudent(stu_Id);
  51.         Label idL=new Label("学号:"+student.getStu_id());
  52.         Label classL=new Label("班级:"+student.getStu_class());
  53.         Label nameL=new Label("姓名:"+student.getStu_name());
  54.         Label genderL=new Label("性别:"+student.getStu_gender());
  55.         Label birthL=new Label("出生日期:"+student.getStu_birth());
  56.         Label majorL=new Label("专业:"+student.getStu_major());
  57.         //设置字体样式
  58.         Font font = Font.font("Comic Sans MS", FontWeight.BOLD, FontPosture.REGULAR, 20);
  59.         idL.setFont(font);
  60.         classL.setFont(font);
  61.         nameL.setFont(font);
  62.         genderL.setFont(font);
  63.         birthL.setFont(font);
  64.         majorL.setFont(font);
  65.  
  66.         Button backB=new Button("返回");
  67.         backB.setOnAction(actionEvent -> {
  68.             stu_login(stu_Id);
  69.         });
  70.  
  71.         VBox vBox=new VBox(10);
  72.         vBox.getChildren().addAll(idL,classL,nameL,genderL,birthL,majorL,backB);
  73.         vBox.setAlignment(Pos.CENTER);
  74.         vBox.setSpacing(10);
  75.         Scene scene=new Scene(vBox,360,340);
  76.         endView.stage.setScene(scene);
  77.  
  78.     }
  79.     //学生成绩查询
  80.     public static void gradeInquire(int stu_Id) throws Exception {
  81.         int grade=studentDao.gradeOneself(stu_Id);
  82.         Label gradeL=new Label("您的总学分为："+grade);
  83.         Font font = Font.font("Comic Sans MS", FontWeight.BOLD, FontPosture.REGULAR, 20);
  84.         gradeL.setFont(font);
  85.         VBox vBox=new VBox();
  86.         vBox.setAlignment(Pos.CENTER);
  87.         vBox.setPadding(new Insets(0,0,20,0));
  88.         Button back=new Button("返回");
  89.         back.setMinWidth(50);
  90.         back.setMinHeight(30);
  91.         back.setOnAction(actionEvent -> {
  92.             stu_login(stu_Id);
  93.         });
  94.         vBox.getChildren().addAll(gradeL,back);
  95.         Scene scene=new Scene(vBox,340,150);
  96.         endView.stage.setScene(scene);
  97.     }

Pernyataan Siswa Dao:

utilDao:

  1. private static final String URL = "jdbc:mysql:///studentMs";
  2.     private static final String USER = "root";
  3.     private static final String PASSWORD = "123321";
  4.  
  5.     //获取连接对象
  6.     public static Connection getCon() {
  7.         try {
  8.             return DriverManager.getConnection(URL, USER, PASSWORD);
  9.         } catch (SQLException e) {
  10.             e.printStackTrace();
  11.             return null;
  12.         }
  13.  
  14.     }
  15.  
  16.     //关闭资源
  17.     public static void close(ResultSet rs, PreparedStatement ps, Connection con) {
  18.  
  19.         try {
  20.             if (rs != null) {
  21.                 rs.close();
  22.             }
  23.             if (ps != null) {
  24.                 ps.close();
  25.             }
  26.             if (con != null) {
  27.                 con.close();
  28.             }
  29.         } catch (SQLException e) {
  30.             e.printStackTrace();
  31.         }
  32.  
  33.     }
  34.  
  35.     //执行mysql
  36.     public static boolean exeUpdate(String sql, Object... params) {
  37.         //获取连接对象
  38.         Connection con = getCon();
  39.         PreparedStatement ps = null;
  40.         try {
  41.             //获取编译对象
  42.             ps = con.prepareStatement(sql);
  43.             //判断参数是否为空
  44.             if (Objects.nonNull(params)) {
  45.                 for (int i = 0; i < params.length; i++) {
  46.                     //实现占位赋值
  47.                     ps.setObject(i + 1, params[i]);
  48.                 }
  49.             }
  50.             //执行更新
  51.             return ps.executeUpdate() > 0;
  52.         } catch (Exception e) {
  53.             e.printStackTrace();
  54.         } finally {
  55.             close(null, ps, con);
  56.         }
  57.         return false;
  58.     }

mahasiswaDao*:

di atasHanya pernyataan jdbc tentang login siswa yang ditampilkan, tidak semua pernyataan di studentDao saya, ini ditulis untuk memperjelas idenya. Jika menurut Anda sangat sederhana, Anda dapat melihat kode total saya di bawah ini.

  1. //学生登录判断
  2.     public static boolean login(String idStr, String passwordStr) throws Exception {
  3.  
  4.         String sql = "select * from student where stuID =? and stuPassword=?";
  5.         PreparedStatement ps = utilDao.getCon().prepareStatement(sql);
  6.         ps.setString(1,idStr);
  7.         ps.setString(2, passwordStr);
  8.         ResultSet rs = ps.executeQuery();
  9.  
  10.         if (rs.next()) {
  11.             utilDao.close(rs,ps, utilDao.getCon());
  12.             return true;
  13.         } else {
  14.             utilDao.close(rs,ps,utilDao.getCon());
  15.             return false;
  16.         }
  17.  
  18.  
  19.     }
  20.  
  21.     //学生查询自己成绩
  22.     public static Integer gradeOneself(int stu_id) throws Exception {
  23.         String sql = "SELECT SUM(credit) AS gradesum FROM score WHERE stuID=?";
  24.  
  25.         try (Connection connection =utilDao.getCon();
  26.              PreparedStatement ps = connection.prepareStatement(sql)) {
  27.  
  28.             ps.setInt(1, stu_id);
  29.             try (ResultSet rs = ps.executeQuery()) {
  30.                 if (rs.next()) {
  31.                     int gradesum = rs.getInt("gradesum");
  32.                     return gradesum;
  33.                 } else {
  34.                     // 如果没有查询到结果，可以返回 null 或者其他合适的值
  35.                     return null;
  36.                 }
  37.             }
  38.         }
  39.     }
  40.  
  41.     //返回学生信息
  42.     public static student returnStudent(int stu_id)throws Exception{
  43.  
  44.         student student=new student();
  45.         String sql="select stuID,stuClass,stuName,stuSex,stuBirth,stuMajor,stuPassword from student where stuID=?";
  46.         PreparedStatement ps=utilDao.getCon().prepareStatement(sql);
  47.         //过滤其他的只留下ID为1的学生
  48.         ps.setString(1,String.valueOf(stu_id));
  49.         ResultSet rs=ps.executeQuery();
  50.         if(rs.next()){
  51.             student.setStu_id(rs.getInt("stuID"));
  52.             student.setStu_class(rs.getString("stuClass"));
  53.             student.setStu_name(rs.getString("stuName"));
  54.             student.setStu_gender(rs.getString("stuSex"));
  55.             student.setStu_birth(rs.getString("stuBirth"));
  56.             student.setStu_major(rs.getString("stuMajor"));
  57.             student.setStu_password(rs.getString("stuPassword"));
  58.         }
  59.         rs.close();
  60.         ps.close();
  61.         return student;
  62.     }

---Ini adalah kode untuk login siswa---

administrator:

Antarmuka administrator (magView):

Berikut ini adalah metode antarmuka saya untuk pengaturan administrator. Ada total empat antarmuka utama administrator, yang sesuai dengan empat login administrator pertama di tampilan halaman. Total ada 7 metode di bawah ini. Mengenai metode createTableView, saya menulisnya dan menggunakannya milikku. Objek seperti siswa ditambahkan ke bagian kode dalam tampilan tabel. Itu hanya menghilangkan dan mendefinisikan ulang suatu metode empat login administrator pertama di tampilan halaman. Empat metode pertama digunakan untuk membuat antarmuka. Salah satunya adalah metode antarmuka setelah login, dan tiga metode terakhir adalah metode yang dipanggil oleh pemantauan tindakan dari tiga tombol pertama di panel setelahnya. Gabung.

  1.  //管理员登录界面
  2.     public static void mag_login(){
  3.         Label magL=new Label("管理员查询系统");
  4.         VBox vBox=new VBox();
  5.         vBox.setAlignment(Pos.CENTER);
  6.         vBox.setSpacing(30);
  7.         Button informationB= new Button("查询学生信息");
  8.         Button courseB=new Button("查看课程");
  9.         Button gradeB=new Button("查看学生成绩");
  10.         Button rebackB=new Button("返回登录界面");
  11.         rebackB.setOnAction(actionEvent -> {
  12.             otherView.login();
  13.         });
  14.         informationB.setOnAction(actionEvent -> {
  15.             try {
  16.                 magStudent();
  17.             } catch (Exception e) {
  18.                 e.printStackTrace();
  19.             }
  20.         });
  21.  
  22.         courseB.setOnAction(actionEvent -> {
  23.             try {
  24.                 magCourse();
  25.             } catch (Exception e) {
  26.                 e.printStackTrace();
  27.             }
  28.         });
  29.         gradeB.setOnAction(actionEvent -> {
  30.             try {
  31.                 magScore();
  32.             } catch (Exception e) {
  33.                 e.printStackTrace();
  34.             }
  35.         });
  36.         rebackB.setOnAction(actionEvent -> {
  37.             try {
  38.                 otherView.login();
  39.             } catch (Exception e) {
  40.                 e.printStackTrace();
  41.             }
  42.         });
  43.         Font font = Font.font("Comic Sans MS", FontWeight.BOLD, FontPosture.REGULAR, 20);
  44.         magL.setFont(font);
  45.         informationB.setFont(font);
  46.         courseB.setFont(font);
  47.         gradeB.setFont(font);
  48.         rebackB.setFont(font);
  49.         magL.setTextFill(Color.BLACK);
  50.         informationB.setTextFill(Color.BLUE);
  51.         courseB.setTextFill(Color.BLUE);
  52.         gradeB.setTextFill(Color.BLUE);
  53.         rebackB.setTextFill(Color.BLUE);
  54.         vBox.getChildren().addAll(magL,informationB,courseB,gradeB,rebackB);
  55.         Scene scene=new Scene(vBox,360,400);
  56.         endView.stage.setScene(scene);
  57.  
  58.  
  59.     }
  60.  
  61.     //管理员查看学生信息界面
  62.     public static void magStudent() throws Exception {
  63.         BorderPane bp=new BorderPane();
  64.  
  65.         TableView<student> tableView = createTableView1();
  66.  
  67.         Label studentL=new Label("学生信息管理");
  68.         Button addB=new Button("添加学生");
  69.         Button updateB=new Button("修改学生");
  70.         Button deleteB=new Button("删除学生");
  71.         Button backB=new Button("返回");
  72.         addB.setOnAction(actionEvent -> {
  73.             try {
  74.                 studentUtil.studentAdd();
  75.             } catch (Exception e) {
  76.                 throw new RuntimeException(e);
  77.             }
  78.         });
  79.         updateB.setOnAction(actionEvent -> {
  80.             try {
  81.                 studentUtil.studentUpdate();
  82.             } catch (Exception e) {
  83.                 throw new RuntimeException(e);
  84.             }
  85.         });
  86.         deleteB.setOnAction(actionEvent -> {
  87.             try {
  88.                 studentUtil.studentDelete();
  89.             } catch (Exception e) {
  90.                 throw new RuntimeException(e);
  91.             }
  92.         });
  93.         backB.setOnAction(actionEvent -> {
  94.             mag_login();
  95.         });
  96.  
  97.         addB.setMinWidth(70);
  98.         updateB.setMinWidth(70);
  99.         deleteB.setMinWidth(70);
  100.         addB.setMinHeight(35);
  101.         updateB.setMinHeight(35);
  102.         deleteB.setMinHeight(35);
  103.         addB.setTextFill(Color.INDIANRED);
  104.         updateB.setTextFill(Color.INDIANRED);
  105.         deleteB.setTextFill(Color.INDIANRED);
  106.         backB.setTextFill(Color.INDIANRED);
  107.         addB.setBorder(Border.stroke(Color.LIGHTPINK));
  108.         updateB.setBorder(Border.stroke(Color.LIGHTPINK));
  109.         deleteB.setBorder(Border.stroke(Color.LIGHTPINK));
  110.         backB.setBorder(Border.stroke(Color.LIGHTPINK));
  111.         backB.setOnAction(actionEvent -> {
  112.             mag_login();
  113.         });
  114.         Font font = Font.font("Comic Sans MS", FontWeight.BOLD, FontPosture.REGULAR, 20);
  115.         studentL.setFont(font);
  116.         studentL.setTextFill(Color.RED);
  117.  
  118.         VBox vBox=new VBox();
  119.         vBox.getChildren().addAll(studentL,addB,updateB,deleteB,backB);
  120.         vBox.setAlignment(Pos.CENTER);
  121.         vBox.setSpacing(20);
  122.         vBox.setPadding(new Insets(50));
  123.  
  124.         BorderPane bp1=new BorderPane();
  125.         bp1.setTop(vBox);
  126.         BorderPane bp2=new BorderPane();
  127.         bp2.setRight(tableView);
  128.  
  129.         // 获取学生列表,将集合转换成ObservableList
  130.         ArrayList<student> students = studentDao.initStudent();
  131.         // 将学生列表转换为ObservableList
  132.         ObservableList<student> stuObs = FXCollections.observableArrayList(students);
  133.         // 将 ObservableList 设置为 TableView 的数据源
  134.         tableView.setItems(stuObs);
  135.  
  136.  
  137.         bp.setLeft(bp1);
  138.         bp.setCenter(bp2);
  139.  
  140.         Scene scene = new Scene(bp, 650, 350);
  141.         endView.stage.setScene(scene);
  142.  
  143.     }
  144.     //绑定学生面板
  145.     public static TableView<student> createTableView1() {
  146.  
  147.         TableView<student> tableView = new TableView<>();
  148.  
  149.         TableColumn<student, Integer> idCol = new TableColumn<>("ID");
  150.         idCol.setCellValueFactory(cellData -> new SimpleIntegerProperty(cellData.getValue().getStu_id()).asObject());
  151.  
  152.         TableColumn<student, String> classCol = new TableColumn<>("班级");
  153.         classCol.setCellValueFactory(cellData -> new SimpleStringProperty(cellData.getValue().getStu_class()));
  154.  
  155.         TableColumn<student, String> nameCol = new TableColumn<>("姓名");
  156.         nameCol.setCellValueFactory(cellData -> new SimpleStringProperty(cellData.getValue().getStu_name()));
  157.  
  158.         TableColumn<student, String> sexCol = new TableColumn<>("性别");
  159.         sexCol.setCellValueFactory(cellData -> new SimpleStringProperty(cellData.getValue().getStu_gender()));
  160.  
  161.         TableColumn<student, String> birthCol = new TableColumn<>("出生日期");
  162.         birthCol.setCellValueFactory(cellData -> new SimpleStringProperty(cellData.getValue().getStu_birth()));
  163.  
  164.         TableColumn<student, String> majorCol = new TableColumn<>("所在班级");
  165.         majorCol.setCellValueFactory(cellData -> new SimpleStringProperty(cellData.getValue().getStu_major()));
  166.  
  167.         // 添加其他表格列...
  168.  
  169.         tableView.getColumns().addAll(idCol, classCol, nameCol,sexCol,birthCol,majorCol);
  170.  
  171.         return tableView;
  172.     }
  173.  
  174.     //管理员查看课程界面
  175.     public static void magCourse() throws Exception {
  176.         //创建面板
  177.         BorderPane bp=new BorderPane();
  178.         //创建第二面板
  179.         TableView<course> tableView = createTableView2();
  180.  
  181.         Label studentL=new Label("学生课程管理");
  182.         Button addB=new Button("添加课程");
  183.         Button updateB=new Button("修改课程");
  184.         Button deleteB=new Button("删除课程");
  185.         Button backB=new Button("返回");
  186.         addB.setOnAction(actionEvent -> {
  187.             try {
  188.                 courseUtil.courseAdd();
  189.             } catch (Exception e) {
  190.                 throw new RuntimeException(e);
  191.             }
  192.         });
  193.         updateB.setOnAction(actionEvent -> {
  194.             courseUtil.courseUpdate();
  195.         });
  196.         deleteB.setOnAction(actionEvent -> {
  197.             courseUtil.courseDelete();
  198.         });
  199.         backB.setOnAction(actionEvent -> {
  200.             mag_login();
  201.         });
  202.  
  203.         addB.setMinWidth(70);
  204.         updateB.setMinWidth(70);
  205.         deleteB.setMinWidth(70);
  206.         addB.setMinHeight(35);
  207.         updateB.setMinHeight(35);
  208.         deleteB.setMinHeight(35);
  209.         addB.setTextFill(Color.INDIANRED);
  210.         updateB.setTextFill(Color.INDIANRED);
  211.         deleteB.setTextFill(Color.INDIANRED);
  212.         backB.setTextFill(Color.INDIANRED);
  213.         addB.setBorder(Border.stroke(Color.LIGHTPINK));
  214.         updateB.setBorder(Border.stroke(Color.LIGHTPINK));
  215.         deleteB.setBorder(Border.stroke(Color.LIGHTPINK));
  216.         backB.setBorder(Border.stroke(Color.LIGHTPINK));
  217.  
  218.         Font font = Font.font("Comic Sans MS", FontWeight.BOLD, FontPosture.REGULAR, 20);
  219.         studentL.setFont(font);
  220.         studentL.setTextFill(Color.RED);
  221.  
  222.         VBox vBox=new VBox();
  223.         vBox.getChildren().addAll(studentL,addB,updateB,deleteB,backB);
  224.         vBox.setAlignment(Pos.CENTER);
  225.         vBox.setSpacing(20);
  226.         vBox.setPadding(new Insets(50));
  227.  
  228.         BorderPane bp1=new BorderPane();
  229.         bp1.setTop(vBox);
  230.         BorderPane bp2=new BorderPane();
  231.         bp2.setRight(tableView);
  232.  
  233.         // 获取学生列表
  234.         ArrayList<course> courses = courseDao.initCourse();
  235.         // 将学生列表转换为ObservableList
  236.         ObservableList<course> stuObs = FXCollections.observableArrayList(courses);
  237.         // 将 ObservableList 设置为 TableView 的数据源
  238.         tableView.setItems(stuObs);
  239.  
  240.         bp.setLeft(bp1);
  241.         bp.setCenter(bp2);
  242.         Scene scene = new Scene(bp, 700, 350);
  243.         endView.stage.setScene(scene);
  244.  
  245.     }
  246.     //绑定课程面板
  247.     public static TableView<course> createTableView2() {
  248.  
  249.         TableView<course> tableView = new TableView<>();
  250.  
  251.         TableColumn<course, Integer> idCol = new TableColumn<>("课程号");
  252.         idCol.setCellValueFactory(cellData -> new SimpleIntegerProperty(cellData.getValue().getCou_id()).asObject());
  253.  
  254.         TableColumn<course, String> majorCol = new TableColumn<>("所属专业");
  255.         majorCol.setCellValueFactory(cellData -> new SimpleStringProperty(cellData.getValue().getCou_major()));
  256.  
  257.         TableColumn<course, String> nameCol = new TableColumn<>("课程名称");
  258.         nameCol.setCellValueFactory(cellData -> new SimpleStringProperty(cellData.getValue().getCou_name()));
  259.  
  260.         TableColumn<course, String> typeCol = new TableColumn<>("课程类型");
  261.         typeCol.setCellValueFactory(cellData -> new SimpleStringProperty(cellData.getValue().getCou_type()));
  262.  
  263.         TableColumn<course, String> beginCol = new TableColumn<>("开课学期");
  264.         beginCol.setCellValueFactory(cellData -> new SimpleStringProperty(cellData.getValue().getCou_beginTime()));
  265.  
  266.         TableColumn<course, Integer> studyCol = new TableColumn<>("学时数");
  267.         studyCol.setCellValueFactory(cellData -> new SimpleIntegerProperty(cellData.getValue().getCou_studyTime()).asObject());
  268.  
  269.         TableColumn<course, Integer> scoreCol = new TableColumn<>("学分");
  270.         scoreCol.setCellValueFactory(cellData -> new SimpleIntegerProperty(cellData.getValue().getCou_score()).asObject());
  271.  
  272.  
  273.         tableView.getColumns().addAll(idCol, majorCol, nameCol,typeCol,beginCol,studyCol,scoreCol);
  274.  
  275.         return tableView;
  276.     }
  277.  
  278.     //管理员查看学生成绩界面
  279.     public static void magScore() throws Exception {
  280.         BorderPane bp=new BorderPane();
  281.         TableView<score> tableView = createTableView3();
  282.  
  283.         Label studentL=new Label("学生成绩管理");
  284.         Button addB=new Button("添加成绩");
  285.         Button updateB=new Button("修改成绩");
  286.         Button deleteB=new Button("删除成绩");
  287.         Button rebackB=new Button("返回");
  288.         addB.setOnAction(actionEvent -> {
  289.             scoreUtil.scoreAdd();
  290.         });
  291.         updateB.setOnAction(actionEvent -> {
  292.             scoreUtil.scoreUpdate();
  293.         });
  294.  
  295.         deleteB.setOnAction(actionEvent -> {
  296.             scoreUtil.scoreDelete();
  297.         });
  298.         rebackB.setOnAction(actionEvent -> {
  299.             mag_login();
  300.         });
  301.  
  302.  
  303.         addB.setMinWidth(70);
  304.         updateB.setMinWidth(70);
  305.         deleteB.setMinWidth(70);
  306.         addB.setMinHeight(35);
  307.         updateB.setMinHeight(35);
  308.         deleteB.setMinHeight(35);
  309.         addB.setTextFill(Color.INDIANRED);
  310.         updateB.setTextFill(Color.INDIANRED);
  311.         deleteB.setTextFill(Color.INDIANRED);
  312.         rebackB.setTextFill(Color.INDIANRED);
  313.         addB.setBorder(Border.stroke(Color.LIGHTPINK));
  314.         updateB.setBorder(Border.stroke(Color.LIGHTPINK));
  315.         deleteB.setBorder(Border.stroke(Color.LIGHTPINK));
  316.         rebackB.setBorder(Border.stroke(Color.LIGHTPINK));
  317.         Font font = Font.font("Comic Sans MS", FontWeight.BOLD, FontPosture.REGULAR, 20);
  318.         studentL.setFont(font);
  319.         studentL.setTextFill(Color.RED);
  320.  
  321.         VBox vBox=new VBox();
  322.         vBox.getChildren().addAll(studentL,addB,updateB,deleteB,rebackB);
  323.         vBox.setAlignment(Pos.CENTER);
  324.         vBox.setSpacing(10);
  325.         vBox.setPadding(new Insets(40));
  326.  
  327.         BorderPane bp1=new BorderPane();
  328.         bp1.setTop(vBox);
  329.         BorderPane bp2=new BorderPane();
  330.         bp2.setRight(tableView);
  331.  
  332.         // 获取学生列表
  333.         ArrayList<score> scores = scoreDao.initScore();
  334.         // 将学生列表转换为ObservableList
  335.         ObservableList<score> stuObs = FXCollections.observableArrayList(scores);
  336.         // 将 ObservableList 设置为 TableView 的数据源
  337.         tableView.setItems(stuObs);
  338.  
  339.         bp.setLeft(bp1);
  340.         bp.setCenter(bp2);
  341.  
  342.         Scene scene = new Scene(bp, 450, 300);
  343.         endView.stage.setScene(scene);
  344.  
  345.     }
  346.     //绑定成绩面板
  347.     public static TableView<score> createTableView3() {
  348.  
  349.         TableView<score> tableView = new TableView<>();
  350.  
  351.         TableColumn<score, Integer> stuCol = new TableColumn<>("学号");
  352.         stuCol.setCellValueFactory(cellData -> new SimpleIntegerProperty(cellData.getValue().getScore_id()).asObject());
  353.  
  354.         TableColumn<score, Integer> idCol = new TableColumn<>("课程号");
  355.         idCol.setCellValueFactory(cellData -> new SimpleIntegerProperty(cellData.getValue().getScore_cid()).asObject());
  356.  
  357.         TableColumn<score, String> studyCol = new TableColumn<>("学数");
  358.         studyCol.setCellValueFactory(cellData -> new SimpleStringProperty(cellData.getValue().getSocre_score()));
  359.  
  360.         TableColumn<score, String> scoreCol = new TableColumn<>("学分");
  361.         scoreCol.setCellValueFactory(cellData -> new SimpleStringProperty(cellData.getValue().getScore_credit()));
  362.  
  363.         tableView.getColumns().addAll(stuCol,idCol,studyCol,scoreCol);
  364.  
  365.         return tableView;
  366.     }
  367. }

Alat administrator:

Alat administrator kelas digunakan untuk menambah siswa, mengubah siswa, menghapus siswa, menambah mata kuliah... di halaman operasi.

pelajar(siswaUtil):

  1.     //添加学生信息
  2.     public static void studentAdd() throws Exception {
  3.         //添加面板
  4.         GridPane gp=new GridPane();
  5.         Label idL=new Label("学号");
  6.         Label classL=new Label("班级");
  7.         Label nameL=new Label("姓名");
  8.         Label sexL=new Label("性别");
  9.         Label birthL=new Label("出生日期");
  10.         Label majorL=new Label("所在专业");
  11.         Label passwordL=new Label("密码");
  12.         //添加按钮
  13.         Button admitB=new Button("提交");
  14.         Button backB=new Button("返回");
  15.         //设置字体样式
  16.         Font font = Font.font("Comic Sans MS", FontWeight.BOLD, FontPosture.REGULAR, 15);
  17.         idL.setFont(font);
  18.         classL.setFont(font);
  19.         nameL.setFont(font);
  20.         sexL.setFont(font);
  21.         birthL.setFont(font);
  22.         majorL.setFont(font);
  23.         //添加输入框
  24.         TextField idT=new TextField(String.valueOf(judgeDao.maxID()+1));
  25.         TextField classT=new TextField();
  26.         TextField nameT=new TextField();
  27.         TextField sexT=new TextField();
  28.         TextField birthT=new TextField();
  29.         TextField majorT=new TextField();
  30.         TextField passwordT=new TextField();
  31.         //将组件添加到面板当中
  32.         gp.add(idL,0,0);
  33.         gp.add(idT,1,0);
  34.         gp.add(classL,0,1);
  35.         gp.add(classT,1,1);
  36.         gp.add(nameL,0,2);
  37.         gp.add(nameT,1,2);
  38.         gp.add(sexL,0,3);
  39.         gp.add(sexT,1,3);
  40.         gp.add(birthL,0,4);
  41.         gp.add(birthT,1,4);
  42.         gp.add(majorL,0,5);
  43.         gp.add(majorT,1,5);
  44.         gp.add(passwordL,0,6);
  45.         gp.add(passwordT,1,6);
  46.         gp.add(admitB,0,7);
  47.         gp.add(backB,1,7);
  48.         //设置面板样式
  49.         gp.setPadding(new Insets(30));
  50.         gp.setVgap(20);
  51.         gp.setHgap(10);
  52.         Scene scene=new Scene(gp,300,400);
  53.         Stage stage=new Stage();
  54.         stage.setScene(scene);
  55.         stage.setTitle("添加学生信息");
  56.         stage.show();
  57.         backB.setOnAction(actionEvent -> {
  58.             try {
  59.                 stage.close();
  60.             } catch (Exception e) {
  61.                 throw new RuntimeException(e);
  62.             }
  63.         });
  64.         //给提交按钮添加监听事件
  65.         admitB.setOnAction(actionEvent -> {
  66.             try {
  67.                 // 获取文本框中的内容并去除首尾空白
  68.                 String id = idT.getText().trim();
  69.                 String clazz = classT.getText().trim();
  70.                 String name = nameT.getText().trim();
  71.                 String sex = sexT.getText().trim();
  72.                 String birth = birthT.getText().trim();
  73.                 String major = majorT.getText().trim();
  74.                 String password = passwordT.getText().trim();
  75.  
  76.                 // 首先进行基本的非空验证，如果有任何一个字段为空，则不进行添加操作
  77.                 if (id.isEmpty() || clazz.isEmpty() || name.isEmpty() || sex.isEmpty() || birth.isEmpty() || major.isEmpty() || password.isEmpty()) {
  78.                     otherView.tipJframe("字段不能为空");
  79.                     return;
  80.                 }else if(!((sex.equals("男")||sex.equals("女")))){
  81.                     otherView.tipJframe("请输入正常性别");
  82.                     return;
  83.                 }else if(!judgeUtil.isValidDate(birth)){
  84.                     otherView.tipJframe("日期格式不正确,请重新输入");
  85.                     return;
  86.                 }else if(!clazz.equals(judgeUtil.isClass(id))){
  87.                     otherView.tipJframe("班级格式不正确,请重新输入");
  88.                     return;
  89.                 }else if(!password.equals(judgeUtil.isPassword(id))){
  90.                     otherView.tipJframe("密码格式错误,请重新输入");
  91.                     return;
  92.                 }
  93.                 int studentId = Integer.parseInt(id);
  94.  
  95.                 // 调用Dao层方法尝试添加学生信息
  96.                 if (studentDao.addStudent(studentId, clazz, name, sex, birth, major, password)) {
  97.                     // 添加成功后的操作
  98.                     studentDao.initStudent();
  99.                     magView.magStudent();
  100.                     otherView.tipJframe("添加成功");
  101.                 }else {
  102.                     otherView.tipJframe("添加失败");
  103.                 }
  104.             } catch (Exception e) {
  105.                 // 捕获其他异常并打印堆栈信息
  106.                 e.printStackTrace();
  107.                 otherView.tipJframe("操作失败：" + e.getMessage()); // 提示操作失败，并显示具体的异常信息
  108.             }
  109.         });
  110.  
  111.     }
  112.     //修改学生信息
  113.     public static void studentUpdate(){
  114.  
  115.         //创建第一个面板
  116.         GridPane gp = new GridPane();
  117.         Label idl = new Label("ID");
  118.         TextField idt = new TextField();
  119.  
  120.         //创建第一个界面的按钮
  121.         Button admitb = new Button("提交");
  122.         Button backb = new Button("返回");
  123.  
  124.         gp.add(idl,0,0);
  125.         gp.add(idt,1,0);
  126.         gp.add(admitb,0,1);
  127.         gp.add(backb,0,2);
  128.         gp.setHgap(20);
  129.         gp.setVgap(10);
  130.         gp.setAlignment(Pos.CENTER);
  131.         Scene scene=new Scene(gp,240,140);
  132.         //创建第一个舞台
  133.         Stage stage=new Stage();
  134.         stage.setScene(scene);
  135.         stage.setResizable(false);
  136.         stage.setTitle("修改学生信息");
  137.         stage.show();
  138.         backb.setOnAction(actionEvent -> {
  139.             try {
  140.                 stage.close();
  141.             } catch (Exception e) {
  142.                 throw new RuntimeException(e);
  143.             }
  144.         });
  145.  
  146.         // 创建第二个舞台
  147.         Stage stage1 = new Stage();
  148.  
  149.         //创建只能存储一个字符的字符串
  150.         final int[] id = new int[1];
  151.         final String[] clas = new String[1];
  152.         final String[] names = new String[1];
  153.         final String[] sexs = new String[1];
  154.         final String[] births = new String[1];
  155.         final String[] majors = new String[1];
  156.         final String[] passwords=new String[1];
  157.  
  158.         GridPane gp1=new GridPane();
  159.         Label idL=new Label("学号");
  160.         Label classL=new Label("班级");
  161.         Label nameL=new Label("姓名");
  162.         Label sexL=new Label("性别");
  163.         Label birthL=new Label("出生日期");
  164.         Label majorL=new Label("所在专业");
  165.         Label passwordL=new Label("密码");
  166.  
  167.         Button admitB=new Button("提交");
  168.         Button rebackB=new Button("返回");
  169.         rebackB.setOnAction(actionEvent -> {
  170.             stage1.close();
  171.         });
  172.  
  173.         //创建显示信息文本框
  174.         TextField idT=new TextField(String.valueOf(id[0]));
  175.         TextField classT=new TextField(clas[0]);
  176.         TextField nameT=new TextField(names[0]);
  177.         TextField sexT=new TextField(sexs[0]);
  178.         TextField birthT=new TextField(births[0]);
  179.         TextField majorT=new TextField(majors[0]);
  180.         TextField passwordT=new TextField(passwords[0]);
  181.  
  182.         Font font = Font.font("Comic Sans MS", FontWeight.BOLD, FontPosture.REGULAR, 15);
  183.         idL.setFont(font);
  184.         classL.setFont(font);
  185.         nameL.setFont(font);
  186.         sexL.setFont(font);
  187.         birthL.setFont(font);
  188.         majorL.setFont(font);
  189.  
  190.  
  191.         gp1.add(idL,0,0);
  192.         gp1.add(idT,1,0);
  193.         gp1.add(classL,0,1);
  194.         gp1.add(classT,1,1);
  195.         gp1.add(nameL,0,2);
  196.         gp1.add(nameT,1,2);
  197.         gp1.add(sexL,0,3);
  198.         gp1.add(sexT,1,3);
  199.         gp1.add(birthL,0,4);
  200.         gp1.add(birthT,1,4);
  201.         gp1.add(majorL,0,5);
  202.         gp1.add(majorT,1,5);
  203.         gp1.add(passwordL,0,6);
  204.         gp1.add(passwordT,1,6);
  205.         gp1.add(admitB,0,7);
  206.         gp1.add(rebackB,1,7);
  207.  
  208.         gp1.setPadding(new Insets(30));
  209.         gp1.setVgap(20);
  210.         gp1.setHgap(10);
  211.         Scene scene1=new Scene(gp1,300,400);
  212.         stage1.setScene(scene1);
  213.         stage1.setResizable(false);
  214.         stage1.setTitle("修改学生信息");
  215.         stage1.close();
  216.  
  217.         //第一个界面的提交按钮
  218.         admitb.setOnAction(actionEvent -> {
  219.             String idText = idt.getText().trim();
  220.             if (!idText.isEmpty()) {
  221.                 try {
  222.                     if (studentDao.isStudent(Integer.parseInt(idText))) {
  223.                         endView.student0=studentDao.returnStudent(Integer.parseInt(idText));
  224.                         id[0] = endView.student0.getStu_id();
  225.                         clas[0] = endView.student0.getStu_class();
  226.                         names[0] = endView.student0.getStu_name();
  227.                         sexs[0] = endView.student0.getStu_gender();
  228.                         births[0] = endView.student0.getStu_birth();
  229.                         majors[0] = endView.student0.getStu_major();
  230.                         passwords[0]=endView.student0.getStu_password();
  231.  
  232.                         // 将值设置到文本框中
  233.                         idT.setText(String.valueOf(id[0]));
  234.                         classT.setText(clas[0]);
  235.                         nameT.setText(names[0]);
  236.                         sexT.setText(sexs[0]);
  237.                         birthT.setText(births[0]);
  238.                         majorT.setText(majors[0]);
  239.                         passwordT.setText(passwords[0]);
  240.  
  241.                         // 显示舞台
  242.                         stage1.show();
  243.                     } else {
  244.                         otherView.tipJframe("不存在该学生");
  245.                     }
  246.                 } catch (Exception e) {
  247.                     throw new RuntimeException(e);
  248.                 }
  249.             } else {
  250.                 otherView.tipJframe("ID不能为空");
  251.             }
  252.         });
  253.  
  254.         //第二个界面的提交按钮
  255.         admitB.setOnAction(actionEvent -> {
  256.             try {
  257.                 String idd = idT.getText().trim();
  258.                 String clazz = classT.getText().trim();
  259.                 String name = nameT.getText().trim();
  260.                 String sex = sexT.getText().trim();
  261.                 String birth = birthT.getText().trim();
  262.                 String major = majorT.getText().trim();
  263.                 String password=passwordT.getText().trim();
  264.  
  265.                 // 首先进行基本的非空验证，如果有任何一个字段为空，则不进行添加操作
  266.                 if (idd.isEmpty() || clazz.isEmpty() || name.isEmpty() || sex.isEmpty() || birth.isEmpty() || major.isEmpty()) {
  267.                     otherView.tipJframe("所有字段不能为空");
  268.                     return;
  269.                 }else if(!((sex.equals("男")||sex.equals("女")))){
  270.                     otherView.tipJframe("请输入正常性别");
  271.                     return;
  272.                 }else if(!judgeUtil.isValidDate(birth)){
  273.                     otherView.tipJframe("日期格式不正确,请重新输入");
  274.                     return;
  275.                 }else if(!clazz.equals(judgeUtil.isClass(idd))){
  276.                     otherView.tipJframe("班级格式不正确,请重新输入");
  277.                     return;
  278.                 }else if(!password.equals(judgeUtil.isPassword(idd))){
  279.                     otherView.tipJframe("密码格式错误,请重新输入");
  280.                     return;
  281.                 }
  282.                 int studentId = Integer.parseInt(idd);
  283.                 //判断如果学号发生改变,则进行添加学生操作,否者进行修改操作
  284.                 //如果发生修改
  285.                 if(id[0]!=Integer.valueOf(idT.getText().trim())){
  286.                     if (studentDao.addStudent(studentId, clazz, name, sex, birth, major,password)) {
  287.                         // 添加成功后的操作
  288.                         if(studentDao.deleteStudent(id[0])){
  289.                             studentDao.initStudent();
  290.                             magView.magStudent();
  291.                             otherView.tipJframe("修改成功");
  292.                         }
  293.                     } else {
  294.                         otherView.tipJframe("修改失败");
  295.                     }
  296.                 }
  297.                 //如果没有发生修改,那么进行修改操作
  298.                 else {
  299.                     if (studentDao.updateStudent(studentId, clazz, name, sex, birth, major,password)) {
  300.                         // 添加成功后的操作
  301.                         studentDao.initStudent();
  302.                         magView.magStudent();
  303.                         otherView.tipJframe("修改成功");
  304.                     } else {
  305.                         otherView.tipJframe("修改失败");
  306.                     }
  307.                 }
  308.             } catch (Exception e) {
  309.                 e.printStackTrace();
  310.                 otherView.tipJframe("操作失败：" + e.getMessage());
  311.             }
  312.         });
  313.  
  314.     }
  315.     //删除学生信息
  316.     public static void studentDelete(){
  317.         GridPane gp = new GridPane();
  318.         Label idL = new Label("ID");
  319.         TextField idT = new TextField();
  320.         Button admitB = new Button("提交");
  321.         Button backB = new Button("返回");
  322.  
  323.         // 将按钮事件处理移到这里，确保在点击按钮时获取最新的文本框内容
  324.  
  325.         gp.add(idL, 0, 0);
  326.         gp.add(idT, 1, 0);
  327.         gp.add(admitB, 0, 1);
  328.         gp.add(backB, 1, 1);
  329.         gp.setAlignment(Pos.CENTER);
  330.         gp.setHgap(10);
  331.         gp.setVgap(30);
  332.         //创建一个删除学生的界面舞台
  333.         Stage stage = new Stage();
  334.         Scene scene = new Scene(gp, 240, 100);
  335.         stage.setScene(scene);
  336.         stage.setTitle("删除学生信息");
  337.         stage.setResizable(false);
  338.         stage.show();
  339.         //如果舞台退出,则界面关闭
  340.         backB.setOnAction(actionEvent -> {
  341.             try {
  342.                 stage.close();
  343.             } catch (Exception e) {
  344.                 throw new RuntimeException(e);
  345.             }
  346.         });
  347.         //对按钮添加点击事件
  348.         admitB.setOnAction(actionEvent -> {
  349.             String ids = idT.getText().trim();
  350.             if (!ids.isEmpty()) {
  351.                 try {
  352.                     int id = Integer.parseInt(ids);
  353.                     if (studentDao.isStudent(id)) {
  354.                         if (studentDao.deleteStudent(id)) {
  355.                             otherView.tipJframe("学生删除成功");
  356.                             //更新数据库信息
  357.                             studentDao.initStudent();
  358.                             //更新面板信息
  359.                             magView.magStudent();
  360.                         } else {
  361.                             otherView.tipJframe("学生删除失败");
  362.                         }
  363.                     } else {
  364.                         otherView.tipJframe("未找到该学生");
  365.                     }
  366.                 } catch (NumberFormatException e) {
  367.                     otherView.tipJframe("请输入有效的数字ID");
  368.                 } catch (Exception e) {
  369.                     e.printStackTrace();
  370.                     otherView.tipJframe("数据库操作失败");
  371.                 }
  372.             } else {
  373.                 otherView.tipJframe("请输入学生ID");
  374.             }
  375.         });
  376.  
  377.     }
  378.

Kursus(kursusUtil):

  1.  
  2.     //添加课程
  3.     public static void courseAdd() throws Exception {
  4.         //创建面板
  5.         GridPane gp=new GridPane();
  6.         Label cIDL=new Label("课程号");
  7.         Label cMajorL=new Label("所属专业");
  8.         Label cNameL=new Label("课程名称");
  9.         Label cTypeL=new Label("课程类型");
  10.         Label cBeginL=new Label("开课学期");
  11.         Label cStudyL=new Label("学时数");
  12.         Label cCreditL=new Label("学分");
  13.         //创建按钮
  14.         Button admitB=new Button("提交");
  15.         Button backB=new Button("返回");
  16.         //创建字体样式
  17.         Font font = Font.font("Comic Sans MS", FontWeight.BOLD, FontPosture.REGULAR, 15);
  18.         cIDL.setFont(font);
  19.         cMajorL.setFont(font);
  20.         cNameL.setFont(font);
  21.         cTypeL.setFont(font);
  22.         cBeginL.setFont(font);
  23.         cStudyL.setFont(font);
  24.         cCreditL.setFont(font);
  25.         //创建文本输入框
  26.         TextField cIDT=new TextField(String.valueOf(judgeDao.maxcID()+1));
  27.         TextField cMajorT=new TextField();
  28.         TextField cNameT=new TextField();
  29.         TextField cTypeT=new TextField();
  30.         TextField cBeginT=new TextField();
  31.         TextField cStudyT=new TextField();
  32.         TextField cCreditT=new TextField();
  33.         //将节点添加到面板当中
  34.         gp.add(cIDL,0,0);
  35.         gp.add(cIDT,1,0);
  36.         gp.add(cMajorL,0,1);
  37.         gp.add(cMajorT,1,1);
  38.         gp.add(cNameL,0,2);
  39.         gp.add(cNameT,1,2);
  40.         gp.add(cTypeL,0,3);
  41.         gp.add(cTypeT,1,3);
  42.         gp.add(cBeginL,0,4);
  43.         gp.add(cBeginT,1,4);
  44.         gp.add(cStudyL,0,5);
  45.         gp.add(cStudyT,1,5);
  46.         gp.add(cCreditL,0,6);
  47.         gp.add(cCreditT,1,6);
  48.         gp.add(admitB,0,7);
  49.         gp.add(backB,1,7);
  50.         //设置面板
  51.         gp.setPadding(new Insets(30));
  52.         gp.setVgap(20);
  53.         gp.setHgap(10);
  54.         Scene scene=new Scene(gp,350,400);
  55.         Stage stage=new Stage();
  56.         stage.setResizable(false);
  57.         stage.setTitle("添加课程");
  58.         stage.setScene(scene);
  59.         stage.show();
  60.         backB.setOnAction(actionEvent -> {
  61.             try {
  62.                 stage.close();
  63.             } catch (Exception e) {
  64.                 throw new RuntimeException(e);
  65.             }
  66.         });
  67.         admitB.setOnAction(actionEvent -> {
  68.             try {
  69.                 // 获取文本框中的内容并去除首尾空白
  70.                 String id = cIDT.getText().trim();
  71.                 String major = cMajorT.getText().trim();
  72.                 String name = cNameT.getText().trim();
  73.                 String type = cTypeT.getText().trim();
  74.                 String begin = cBeginT.getText().trim();
  75.                 String study = cStudyT.getText().trim();
  76.                 String credit = cCreditT.getText().trim();
  77.  
  78.                 // 首先进行基本的非空验证，如果有任何一个字段为空，则不进行添加操作
  79.                 if ((id.isEmpty() || major.isEmpty() || name.isEmpty() || type.isEmpty() || begin.isEmpty() || study.isEmpty() || credit.isEmpty())) {
  80.                     otherView.tipJframe("字段不能为空");
  81.                     return;
  82.                 }
  83.                 // 尝试将id和password转换为整数，如果格式不正确会抛出NumberFormatException
  84.                 int cId = Integer.parseInt(id);
  85.                 int studytime=Integer.parseInt(study);
  86.                 int creditt=Integer.parseInt(credit);
  87.  
  88.                 if (courseDao.addCourse(cId, major, name, type, begin, studytime, creditt)) {
  89.                     // 添加成功后的操作
  90.                     courseDao.initCourse();
  91.                     magView.magCourse();
  92.                     otherView.tipJframe("课程添加成功");
  93.                 } else {
  94.                     otherView.tipJframe("课程添加失败");
  95.                 }
  96.             } catch (Exception e) {
  97.                 // 捕获其他异常并打印堆栈信息
  98.                 e.printStackTrace();
  99.                 otherView.tipJframe("操作失败：" + e.getMessage());
  100.             }
  101.         });
  102.  
  103.     }
  104.     //修改课程
  105.     public static void courseUpdate(){
  106.         //创建第一个面板
  107.         GridPane gp = new GridPane();
  108.         Label idl = new Label("cID");
  109.         TextField idt = new TextField();
  110.         //创建第一个界面的按钮
  111.         Button admitb = new Button("提交");
  112.         Button backB = new Button("返回");
  113.  
  114.         gp.add(idl,0,0);
  115.         gp.add(idt,1,0);
  116.         gp.add(admitb,0,1);
  117.         gp.add(backB,0,2);
  118.         gp.setHgap(20);
  119.         gp.setVgap(10);
  120.         gp.setAlignment(Pos.CENTER);
  121.         Scene scene=new Scene(gp,250,140);
  122.         Stage stage=new Stage();
  123.         stage.setTitle("修改课程");
  124.         stage.setScene(scene);
  125.         stage.show();
  126.         backB.setOnAction(actionEvent -> {
  127.             try {
  128.                 stage.close();
  129.             } catch (Exception e) {
  130.                 throw new RuntimeException(e);
  131.             }
  132.         });
  133.  
  134.         //第二个舞台
  135.         Stage stage1 = new Stage();
  136.  
  137.         //创建只能存储一个字符串的数组
  138.         final int[] id = new int[1];
  139.         final String[] major = new String[1];
  140.         final String[] name = new String[1];
  141.         final String[] type = new String[1];
  142.         final String[] begin = new String[1];
  143.         final int[] studytime = new int[1];
  144.         final int[] credit = new int[1];
  145.  
  146.         // 创建显示信息文本框
  147.         TextField idT = new TextField(String.valueOf(id[0]));
  148.         TextField majorT = new TextField(major[0]);
  149.         TextField nameT = new TextField(name[0]);
  150.         TextField typeT = new TextField(type[0]);
  151.         TextField beginT = new TextField(begin[0]);
  152.         TextField studyTime = new TextField(String.valueOf(studytime[0]));
  153.         TextField creditT = new TextField(String.valueOf(credit[0]));
  154.  
  155.         //创建第二个面板
  156.         GridPane gp1=new GridPane();
  157.         Label cID=new Label("课程号");
  158.         Label cMajor=new Label("所属专业");
  159.         Label cName=new Label("课程名称");
  160.         Label cType=new Label("课程类型");
  161.         Label cBegin=new Label("开课学期");
  162.         Label cStudy=new Label("学时数");
  163.         Label cCredit=new Label("学分");
  164.  
  165.         Button admitB=new Button("提交");
  166.         Button rebackB=new Button("返回");
  167.         rebackB.setOnAction(actionEvent -> {
  168.             try {
  169.                 stage1.close();
  170.             } catch (Exception e) {
  171.                 throw new RuntimeException(e);
  172.             }
  173.         });
  174.         //创建字体样式
  175.         Font font = Font.font("Comic Sans MS", FontWeight.BOLD, FontPosture.REGULAR, 15);
  176.         cID.setFont(font);
  177.         cMajor.setFont(font);
  178.         cName.setFont(font);
  179.         cType.setFont(font);
  180.         cBegin.setFont(font);
  181.         cStudy.setFont(font);
  182.         cCredit.setFont(font);
  183.  
  184.  
  185.         gp1.add(cID,0,0);
  186.         gp1.add(idT,1,0);
  187.         gp1.add(cMajor,0,1);
  188.         gp1.add(majorT,1,1);
  189.         gp1.add(cName,0,2);
  190.         gp1.add(nameT,1,2);
  191.         gp1.add(cType,0,3);
  192.         gp1.add(typeT,1,3);
  193.         gp1.add(cBegin,0,4);
  194.         gp1.add(beginT,1,4);
  195.         gp1.add(cStudy,0,5);
  196.         gp1.add(studyTime,1,5);
  197.         gp1.add(cCredit,0,6);
  198.         gp1.add(creditT,1,6);
  199.         gp1.add(admitB,0,7);
  200.         gp1.add(rebackB,1,7);
  201.  
  202.         gp1.setPadding(new Insets(30));
  203.         gp1.setVgap(20);
  204.         gp1.setHgap(10);
  205.         Scene scene1=new Scene(gp1,300,400);
  206.         stage1.setScene(scene1);
  207.         stage1.setTitle("修改课程");
  208.         stage1.setResizable(false);
  209.         stage1.close();
  210.  
  211.         String idText = idt.getText().trim();
  212.         //创建第一个按钮的点击事件
  213.         admitb.setOnAction(actionEvent -> {
  214.  
  215.             if (idText.isEmpty()) {
  216.                 otherView.tipJframe("id不能为空");
  217.             }
  218.             else {
  219.                 try {
  220.                     if (courseDao.isCourse(Integer.parseInt(idText))) {
  221.                         endView.course0 = courseDao.returnCourse(Integer.parseInt(idText));
  222.                         //给数组字符串赋值
  223.                         id[0] = endView.course0.getCou_id();
  224.                         major[0] = endView.course0.getCou_major();
  225.                         name[0] = endView.course0.getCou_name();
  226.                         type[0] = endView.course0.getCou_type();
  227.                         begin[0] = endView.course0.getCou_beginTime();
  228.                         studytime[0] = endView.course0.getCou_studyTime();
  229.                         credit[0] = endView.course0.getCou_score();
  230.  
  231.                         // 更新界面元素，确保在JavaFX应用线程上更新
  232.                         Platform.runLater(() -> {
  233.                             idT.setText(String.valueOf(id[0]));
  234.                             majorT.setText(major[0]);
  235.                             nameT.setText(name[0]);
  236.                             typeT.setText(type[0]);
  237.                             beginT.setText(begin[0]);
  238.                             studyTime.setText(String.valueOf(studytime[0]));
  239.                             creditT.setText(String.valueOf(credit[0]));
  240.                         });
  241.                         // 显示舞台
  242.                         stage1.show();
  243.                     } else {
  244.                         otherView.tipJframe("不存在该课程");
  245.                     }
  246.                 } catch (Exception e) {
  247.                     otherView.tipJframe("发生异常: " + e.getMessage());
  248.                 }
  249.             }
  250.         });
  251.         //创建第二个面板的按钮的点击事件
  252.         admitB.setOnAction(actionEvent -> {
  253.             try {
  254.                 // 获取文本框中的内容并去除首尾空白
  255.                 String ids = idT.getText().trim();
  256.                 String majors = majorT.getText().trim();
  257.                 String names = nameT.getText().trim();
  258.                 String types = typeT.getText().trim();
  259.                 String begins = beginT.getText().trim();
  260.                 String studys = studyTime.getText().trim();
  261.                 String credits = creditT.getText().trim();
  262.  
  263.                 // 首先进行基本的非空验证，如果有任何一个字段为空，则不进行添加操作
  264.                 if (ids.isEmpty() || majors.isEmpty() || names.isEmpty() || types.isEmpty() || begins.isEmpty() || studys.isEmpty() || credits.isEmpty()) {
  265.                     otherView.tipJframe("字段不能为空");
  266.                     return;
  267.                 }
  268.                 int cId = Integer.parseInt(ids);
  269.                 int study=Integer.parseInt(studys);
  270.                 int creditt=Integer.parseInt(credits);
  271.  
  272.                 if(!(id[0]==Integer.valueOf(idText))){
  273.                     if(courseDao.addCourse(cId, majors, names, types, begins, study, creditt)){
  274.                         courseDao.deleteCourse(id[0]);
  275.                         courseDao.initCourse();
  276.                         magView.magCourse();
  277.                         otherView.tipJframe("课程修改成功");
  278.                     }else {
  279.                         // 添加失败的提示
  280.                         otherView.tipJframe("课程修改失败");
  281.                     }
  282.                 }else if(id[0]==Integer.valueOf(idText)){
  283.                     // 调用Dao层方法尝试添加学生信息
  284.                     if (courseDao.updateCourse(cId, majors, names, types, begins, study, creditt)) {
  285.                         // 添加成功后的操作
  286.                         courseDao.initCourse();
  287.                         magView.magCourse();
  288.                         otherView.tipJframe("课程修改成功");
  289.                     } else {
  290.                         // 添加失败的提示
  291.                         otherView.tipJframe("课程修改失败");
  292.                     }
  293.                 }
  294.  
  295.             } catch (Exception e) {
  296.                 e.printStackTrace();
  297.                 otherView.tipJframe("操作失败：" + e.getMessage()); // 提示操作失败，并显示具体的异常信息
  298.             }
  299.         });
  300.  
  301.  
  302.     }
  303.     //删除课程
  304.     public static void courseDelete(){
  305.         GridPane gp = new GridPane();
  306.         Label idL = new Label("ID");
  307.         TextField idT = new TextField();
  308.         Button admitB = new Button("提交");
  309.         Button backB = new Button("返回");
  310.  
  311.         gp.add(idL, 0, 0);
  312.         gp.add(idT, 1, 0);
  313.         gp.add(admitB, 0, 1);
  314.         gp.add(backB, 1, 1);
  315.         gp.setAlignment(Pos.CENTER);
  316.         gp.setHgap(10);
  317.         gp.setVgap(30);
  318.  
  319.         Stage stage = new Stage();
  320.         Scene scene = new Scene(gp, 240, 100);
  321.         stage.setTitle("删除课程");
  322.         stage.setScene(scene);
  323.         stage.show();
  324.         backB.setOnAction(actionEvent -> {
  325.             try {
  326.                 stage.close();
  327.             } catch (Exception e) {
  328.                 throw new RuntimeException(e);
  329.             }
  330.         });
  331.  
  332.         // 将按钮事件处理移到这里，确保在点击按钮时获取最新的文本框内容
  333.         admitB.setOnAction(actionEvent -> {
  334.             String ids = idT.getText().trim(); // 获取文本框内容
  335.             if (!ids.isEmpty()) {
  336.                 try {
  337.                     int id = Integer.parseInt(ids);
  338.                     if (courseDao.isCourse(id)) {
  339.                         if (courseDao.deleteCourse(id)) {
  340.                             otherView.tipJframe("课程删除成功");
  341.                             courseDao.initCourse(); // 更新数据
  342.                             magView.magCourse(); // 刷新界面信息
  343.                         } else {
  344.                             otherView.tipJframe("课程删除失败");
  345.                         }
  346.                     } else {
  347.                         otherView.tipJframe("未找到该课程");
  348.                     }
  349.                 } catch (Exception e) {
  350.                     e.printStackTrace();
  351.                     otherView.tipJframe("数据库操作失败");
  352.                 }
  353.             } else {
  354.                 otherView.tipJframe("请输入课程ID");
  355.             }
  356.         });
  357.  
  358.     }

Skor (skorUtil):

  1.     //添加成绩
  2.     public static void scoreAdd(){
  3.         GridPane gp=new GridPane();
  4.         Label sID=new Label("学号");
  5.         Label sCID=new Label("课程号");
  6.         Label sStudy=new Label("成绩");
  7.         Label sCredit=new Label("学分");
  8.  
  9.         Button admitB=new Button("提交");
  10.         Button rebackB=new Button("返回");
  11.  
  12.         Font font = Font.font("Comic Sans MS", FontWeight.BOLD, FontPosture.REGULAR, 15);
  13.         sID.setFont(font);
  14.         sCID.setFont(font);
  15.         sStudy.setFont(font);
  16.         sCredit.setFont(font);
  17.  
  18.         TextField sIDT=new TextField();
  19.         TextField scIDT=new TextField();
  20.         TextField sStudyT=new TextField();
  21.         TextField sCreditT=new TextField();
  22.  
  23.         gp.add(sID,0,0);
  24.         gp.add(sIDT,1,0);
  25.         gp.add(sCID,0,1);
  26.         gp.add(scIDT,1,1);
  27.         gp.add(sStudy,0,2);
  28.         gp.add(sStudyT,1,2);
  29.         gp.add(sCredit,0,3);
  30.         gp.add(sCreditT,1,3);
  31.         gp.add(admitB,0,7);
  32.         gp.add(rebackB,1,7);
  33.  
  34.         gp.setPadding(new Insets(30));
  35.         gp.setVgap(20);
  36.         gp.setHgap(10);
  37.         Scene scene=new Scene(gp,280,300);
  38.         Stage stage1=new Stage();
  39.         stage1.setScene(scene);
  40.         stage1.setTitle("添加分数");
  41.         stage1.show();
  42.         rebackB.setOnAction(actionEvent -> {
  43.             try {
  44.                 stage1.close();
  45.             } catch (Exception e) {
  46.                 throw new RuntimeException(e);
  47.             }
  48.         });
  49.         admitB.setOnAction(actionEvent -> {
  50.             try {
  51.                 // 获取文本框中的内容并去除首尾空白
  52.                 String id = sIDT.getText().trim();
  53.                 String cid = scIDT.getText().trim();
  54.                 String study = sStudyT.getText().trim();
  55.                 String credit = sCreditT.getText().trim();
  56.  
  57.                 // 首先进行基本的非空验证，如果有任何一个字段为空，则不进行添加操作
  58.                 if ((id.isEmpty() || cid.isEmpty() || study.isEmpty() || credit.isEmpty())) {
  59.                     otherView.tipJframe("字段不能为空");
  60.                     return;
  61.                 }else if(!studentDao.isStudent(Integer.parseInt(id))){
  62.                     otherView.tipJframe("不存在该学生");
  63.                     return;
  64.                 }else if(!courseDao.isCourse(Integer.parseInt(cid))){
  65.                     otherView.tipJframe("不存在该课程");
  66.                     return;
  67.                 }
  68.                 int Id=Integer.parseInt(id);
  69.                 int cId = Integer.parseInt(cid);
  70.                 if (scoreDao.addScore(Id, cId, study, credit)&&scoreDao.isScore(Id,cId)) {
  71.                     scoreDao.initScore();
  72.                     magView.magScore();
  73.                     otherView.tipJframe("成绩添加成功");
  74.                 } else {
  75.                     // 添加失败的提示
  76.                     otherView.tipJframe("成绩添加失败");
  77.                 }
  78.             } catch (NumberFormatException e) {
  79.                 otherView.tipJframe("ID格式错误，请输入有效的整数");
  80.             } catch (Exception e) {
  81.                 // 捕获其他异常并打印堆栈信息
  82.                 e.printStackTrace();
  83.                 otherView.tipJframe("操作失败：" + e.getMessage());
  84.             }
  85.         });
  86.  
  87.     }
  88.     //修改成绩
  89.     public static void scoreUpdate(){
  90.         GridPane gp=new GridPane();
  91.  
  92.         Label idl = new Label("ID");
  93.         Label cidl=new Label("cID");
  94.         TextField idt = new TextField();
  95.         TextField cidt=new TextField();
  96.  
  97.         Button admitb = new Button("提交");
  98.         Button backB=new Button("返回");
  99.  
  100.         gp.add(idl,0,0);
  101.         gp.add(idt,1,0);
  102.         gp.add(cidl,0,1);
  103.         gp.add(cidt,1,1);
  104.         gp.add(admitb,0,2);
  105.         gp.add(backB,1,2);
  106.         gp.setHgap(10);
  107.         gp.setVgap(20);
  108.         gp.setAlignment(Pos.CENTER);
  109.         Scene scene=new Scene(gp,300,240);
  110.         //创建第一个舞台
  111.         Stage stage=new Stage();
  112.         stage.setScene(scene);
  113.         stage.setResizable(false);
  114.         stage.setTitle("修改分数");
  115.         stage.show();
  116.         backB.setOnAction(actionEvent -> {
  117.             stage.close();
  118.         });
  119.  
  120.         //创建第二个面板
  121.         GridPane gp1 = new GridPane();
  122.  
  123.         final int[] id = new int[1];
  124.         final int[] cid = new int[1];
  125.  
  126.         TextField sIDT=new TextField(String.valueOf(id[0]));
  127.         TextField scIDT=new TextField(String.valueOf(cid[0]));
  128.         TextField sStudyT=new TextField();
  129.         TextField sCreditT=new TextField();
  130.  
  131.         Label sID=new Label("学号");
  132.         Label sCID=new Label("课程号");
  133.         Label sStudy=new Label("成绩");
  134.         Label sCredit=new Label("学分");
  135.  
  136.         Button admitB=new Button("提交");
  137.         Button rebackB=new Button("返回");
  138.  
  139.         Font font = Font.font("Comic Sans MS", FontWeight.BOLD, FontPosture.REGULAR, 15);
  140.         sID.setFont(font);
  141.         sCID.setFont(font);
  142.         sStudy.setFont(font);
  143.         sCredit.setFont(font);
  144.  
  145.         gp1.add(sID,0,0);
  146.         gp1.add(sIDT,1,0);
  147.         gp1.add(sCID,0,1);
  148.         gp1.add(scIDT,1,1);
  149.         gp1.add(sStudy,0,2);
  150.         gp1.add(sStudyT,1,2);
  151.         gp1.add(sCredit,0,3);
  152.         gp1.add(sCreditT,1,3);
  153.         gp1.add(admitB,0,7);
  154.         gp1.add(rebackB,1,7);
  155.  
  156.         gp1.setPadding(new Insets(30));
  157.         gp1.setVgap(20);
  158.         gp1.setHgap(10);
  159.         Scene scene1=new Scene(gp1,280,300);
  160.         //创建第二个舞台
  161.         Stage stage1 = new Stage();
  162.         stage1.setScene(scene1);
  163.         stage1.setTitle("修改分数");
  164.         stage1.setResizable(false);
  165.         stage1.close();
  166.         rebackB.setOnAction(actionEvent -> {
  167.             try {
  168.                 stage1.close();
  169.             } catch (Exception e) {
  170.                 throw new RuntimeException(e);
  171.             }
  172.         });
  173.  
  174.         // 登录按钮的事件处理器
  175.         admitb.setOnAction(actionEvent -> {
  176.             String idText = idt.getText().trim();
  177.             String cidText = cidt.getText().trim();
  178.  
  179.             if (!(idText.isEmpty() || cidText.isEmpty())) {
  180.                 try {
  181.                     if (judgeUtil.isDigits(idText) && judgeUtil.isDigits(cidText)) {
  182.                         if (scoreDao.isScore(Integer.parseInt(idText), Integer.parseInt(cidText))) {
  183.                             endView.score0 = scoreDao.returnScore(Integer.parseInt(idText),Integer.parseInt(cidText));
  184.                             id[0] = endView.score0.getScore_id();
  185.                             cid[0] = endView.score0.getScore_cid();
  186.  
  187.                             // 更新TextField显示
  188.                             sIDT.setText(String.valueOf(id[0]));
  189.                             scIDT.setText(String.valueOf(cid[0]));
  190.  
  191.                             // 显示舞台
  192.                             stage1.show();
  193.                             stage.close();
  194.                         } else if (!studentDao.isStudent(Integer.parseInt(idText))) {
  195.                             otherView.tipJframe("不存在该学生");
  196.                         } else if (!courseDao.isCourse(Integer.parseInt(cidText))) {
  197.                             otherView.tipJframe("不存在该课程");
  198.                         } else {
  199.                             otherView.tipJframe("信息输入错误");
  200.                         }
  201.                     } else {
  202.                         otherView.tipJframe("格式错误");
  203.                     }
  204.                 } catch (Exception e) {
  205.                     throw new RuntimeException(e);
  206.                 }
  207.             } else {
  208.                 otherView.tipJframe("id不能为空");
  209.             }
  210.         });
  211.         //第二个按钮点击事件
  212.         admitB.setOnAction(actionEvent -> {
  213.             try {
  214.                 // 获取文本框中的内容并去除首尾空白
  215.                 String ids = sIDT.getText().trim();
  216.                 String cids = scIDT.getText().trim();
  217.                 String studys = sStudyT.getText().trim();
  218.                 String credits = sCredit.getText().trim();
  219.  
  220.                 // 首先进行基本的非空验证，如果有任何一个字段为空，则不进行添加操作
  221.                 if (ids.isEmpty() || cids.isEmpty() || studys.isEmpty() || credits.isEmpty()) {
  222.                     otherView.tipJframe("字段不能为空");
  223.                     return;
  224.                 }
  225.                 // 尝试将id和password转换为整数，如果格式不正确会抛出NumberFormatException
  226.                 int Id=Integer.parseInt(ids);
  227.                 int cId = Integer.parseInt(cids);
  228.                 // 调用Dao层方法尝试添加学生信息
  229.                 if (scoreDao.updateScore(Id, cId, studys, credits)) {
  230.                     // 添加成功后的操作
  231.                     scoreDao.initScore();
  232.                     magView.magScore();
  233.                     otherView.tipJframe("成绩添加成功");
  234.                 } else {
  235.                     otherView.tipJframe("成绩添加失败");
  236.                 }
  237.             } catch (NumberFormatException e) {
  238.                 otherView.tipJframe("ID格式错误，请输入有效的整数");
  239.             } catch (Exception e) {
  240.                 e.printStackTrace();
  241.                 otherView.tipJframe("操作失败：" + e.getMessage());
  242.             }
  243.         });
  244.  
  245.     }
  246.     //删除成绩
  247.     public static void scoreDelete(){
  248.         GridPane gp = new GridPane();
  249.         Label idL = new Label("ID");
  250.         Label cidL=new Label("cID");
  251.         TextField idT = new TextField();
  252.         TextField cidT=new TextField();
  253.         Button admitB = new Button("提交");
  254.         Button backB = new Button("返回");
  255.  
  256.         gp.add(idL, 0, 0);
  257.         gp.add(idT, 1, 0);
  258.         gp.add(cidL,0,1);
  259.         gp.add(cidT,1,1);
  260.         gp.add(admitB, 0, 2);
  261.         gp.add(backB, 1, 2);
  262.         gp.setAlignment(Pos.CENTER);
  263.         gp.setHgap(10);
  264.         gp.setVgap(30);
  265.  
  266.         Stage stage = new Stage();
  267.         Scene scene = new Scene(gp, 240, 200);
  268.         stage.setScene(scene);
  269.         stage.setTitle("删除分数");
  270.         stage.show();
  271.         backB.setOnAction(actionEvent -> {
  272.             try {
  273.                 stage.close();
  274.             } catch (Exception e) {
  275.                 throw new RuntimeException(e);
  276.             }
  277.         });
  278.         // 将按钮事件处理移到这里，确保在点击按钮时获取最新的文本框内容
  279.         admitB.setOnAction(actionEvent -> {
  280.             String ids = idT.getText().trim();
  281.             String cids=cidT.getText().trim();
  282.             if (!ids.isEmpty()) {
  283.                 try {
  284.                     int id = Integer.parseInt(ids);
  285.                     int cid=Integer.parseInt(cids);
  286.                     if (studentDao.isStudent(id)) {
  287.                         if (scoreDao.deleteScore(id,cid)) {
  288.                             otherView.tipJframe("课程删除成功");
  289.                             scoreDao.initScore();
  290.                             magView.magScore();
  291.                         } else {
  292.                             otherView.tipJframe("课程删除失败");
  293.                         }
  294.                     } else {
  295.                         otherView.tipJframe("未找到该课程");
  296.                     }
  297.                 } catch (NumberFormatException e) {
  298.                     otherView.tipJframe("请输入有效的数字ID");
  299.                 } catch (Exception e) {
  300.                     e.printStackTrace();
  301.                     otherView.tipJframe("数据库操作失败");
  302.                 }
  303.             } else {
  304.                 otherView.tipJframe("请输入课程ID");
  305.             }
  306.         });
  307.  
  308.  
  309.     }

Kelas alat penilaian (judgeUtil):

Kelas alat ini digunakan untuk menilai string di beberapa kotak teks saat menambahkan data. Ini digunakan dalam tiga utilitas di atas.

  1.  //判断日期格式
  2.     public static boolean isValidDate(String dateStr) {
  3.         try {
  4.             DateTimeFormatter.ofPattern("yyyy-MM-dd").parse(dateStr);
  5.             return true;
  6.         } catch (DateTimeParseException e) {
  7.             return false;
  8.         }
  9.     }
  10.     //判断班级格式
  11.     public static String isClass(String s){
  12.         String numberString = s;
  13.         int numberOfCharsToTake = 6; // 指定你想截取的字符数量
  14.         String prefix = numberString.substring(0, numberOfCharsToTake);
  15.         return prefix;
  16.     }
  17.     //判断密码格式
  18.     public static String isPassword(String s){
  19.         String numberString = s;
  20.         int numberOfCharsToTake = 6; // 指定你想截取的字符数量从末尾开始
  21.         int startIndex = numberString.length() - numberOfCharsToTake;
  22.         String suffix = numberString.substring(startIndex);
  23.         return suffix;
  24.     }
  25.     //判断字符串是否为数字
  26.     public static boolean isDigits(String str) {
  27.         return str.matches("\d+");
  28.     }

Kelas Administrator Dao:

utilDao:

Karena Connection, close, dan exeupdate akan sering digunakan, saya akan menulis tiga metode langsung di sini.

  1. private static final String URL = "jdbc:mysql:///studentMs";
  2.     private static final String USER = "root";
  3.     private static final String PASSWORD = "123321";
  4.  
  5.     //获取连接对象
  6.     public static Connection getCon() {
  7.         try {
  8.             return DriverManager.getConnection(URL, USER, PASSWORD);
  9.         } catch (SQLException e) {
  10.             e.printStackTrace();
  11.             return null;
  12.         }
  13.  
  14.     }
  15.  
  16.     //关闭资源
  17.     public static void close(ResultSet rs, PreparedStatement ps, Connection con) {
  18.  
  19.         try {
  20.             if (rs != null) {
  21.                 rs.close();
  22.             }
  23.             if (ps != null) {
  24.                 ps.close();
  25.             }
  26.             if (con != null) {
  27.                 con.close();
  28.             }
  29.         } catch (SQLException e) {
  30.             e.printStackTrace();
  31.         }
  32.  
  33.     }
  34.  
  35.     //执行mysql
  36.     public static boolean exeUpdate(String sql, Object... params) {
  37.         //获取连接对象
  38.         Connection con = getCon();
  39.         PreparedStatement ps = null;
  40.         try {
  41.             //获取编译对象
  42.             ps = con.prepareStatement(sql);
  43.             //判断参数是否为空
  44.             if (Objects.nonNull(params)) {
  45.                 for (int i = 0; i < params.length; i++) {
  46.                     //实现占位赋值
  47.                     ps.setObject(i + 1, params[i]);
  48.                 }
  49.             }
  50.             //执行更新
  51.             return ps.executeUpdate() > 0;
  52.         } catch (Exception e) {
  53.             e.printStackTrace();
  54.         } finally {
  55.             close(null, ps, con);
  56.         }
  57.         return false;
  58.     }

mahasiswaDao*:

StudentDao berikut ini hanya terkait dengan operasi antarmuka administrator

  1.  //返回学生信息
  2.     public static student returnStudent(int stu_id)throws Exception{
  3.  
  4.         student student=new student();
  5.         String sql="select stuID,stuClass,stuName,stuSex,stuBirth,stuMajor,stuPassword from student where stuID=?";
  6.         PreparedStatement ps=utilDao.getCon().prepareStatement(sql);
  7.         //过滤其他的只留下ID为1的学生
  8.         ps.setString(1,String.valueOf(stu_id));
  9.         ResultSet rs=ps.executeQuery();
  10.         if(rs.next()){
  11.             student.setStu_id(rs.getInt("stuID"));
  12.             student.setStu_class(rs.getString("stuClass"));
  13.             student.setStu_name(rs.getString("stuName"));
  14.             student.setStu_gender(rs.getString("stuSex"));
  15.             student.setStu_birth(rs.getString("stuBirth"));
  16.             student.setStu_major(rs.getString("stuMajor"));
  17.             student.setStu_password(rs.getString("stuPassword"));
  18.         }
  19.         rs.close();
  20.         ps.close();
  21.         return student;
  22.     }
  23.  
  24.     //判断是否存在该学生
  25.     public static boolean isStudent(int stu_id) throws SQLException {
  26.         String sql="select stuID,stuClass,stuName,stuSex,stuBirth,stuMajor from student where stuID=?";
  27.         PreparedStatement ps=utilDao.getCon().prepareStatement(sql);
  28.         //过滤其他的只留下ID为1的学生
  29.         ps.setString(1,String.valueOf(stu_id));
  30.         ResultSet rs=ps.executeQuery();
  31.         if(rs.next()){
  32.             return true;
  33.         }
  34.         else {
  35.             return false;
  36.         }
  37.     }
  38.  
  39.     // 学生类信息初始化
  40.     public static ArrayList<student> initStudent() throws Exception {
  41.         ArrayList<student> students = new ArrayList<>();
  42.         String sql = "select * from student order by stuID asc";
  43.         PreparedStatement ps = utilDao.getCon().prepareStatement(sql);
  44.         ResultSet rs = ps.executeQuery();
  45.  
  46.         // 使用 while 循环遍历 ResultSet 中的所有行
  47.         while (rs.next()) {
  48.             student student = new student();
  49.             student.setStu_id(rs.getInt("stuID"));
  50.             student.setStu_class(rs.getString("stuClass"));
  51.             student.setStu_name(rs.getString("stuName"));
  52.             student.setStu_gender(rs.getString("stuSex"));
  53.             student.setStu_birth(rs.getString("stuBirth"));
  54.             student.setStu_major(rs.getString("stuMajor"));
  55.             students.add(student);
  56.         }
  57.  
  58.         // 关闭资源
  59.         rs.close();
  60.         ps.close();
  61.         return students;
  62.     }
  63.     //添加学生
  64.     public static boolean addStudent(int stuId,String stuClass,String stuName, String stuSex, String stuBirth, String stuMajor,String stuPassword)throws Exception{
  65.         String sql="insert into student(stuID,stuClass,stuName,stuSex,stuBirth,stuMajor,stuPassword )values (?,?,?,?,?,?,?) ";
  66.         return utilDao.exeUpdate(sql,stuId,stuClass,stuName,stuSex,stuBirth,stuMajor,stuPassword);
  67.     }
  68.     //修改学生
  69.     public static boolean updateStudent(int stuId,String stuClass,String stuName, String stuSex, String stuBirth, String stuMajor,String stuPassword)throws Exception{
  70.         String sql="update student set stuID=?,stuClass=?,stuName=?,stuSex=?,stuBirth=?,stuMajor=?,stuPassword=?";
  71.         return utilDao.exeUpdate(sql,stuId,stuClass,stuName,stuSex,stuBirth,stuMajor,stuPassword);
  72.     }
  73.     //删除学生
  74.     public static boolean deleteStudent(int stuId){
  75.         String sql="delete from student where stuID=?";
  76.         return utilDao.exeUpdate(sql,stuId);
  77.     }

kursusDao:

  1. //返回课程
  2.     public static course returnCourse(int cID)throws Exception{
  3.  
  4.         course course=new course();
  5.         String sql="select cID,cMajor,cName,cType,cStartTerm,cPeriod,cCredit from course where cID=?";
  6.         PreparedStatement ps=utilDao.getCon().prepareStatement(sql);
  7.         //过滤其他的只留下ID为1的学生
  8.         ps.setString(1,String.valueOf(cID));
  9.         ResultSet rs=ps.executeQuery();
  10.         if(rs.next()){
  11.             course.setCou_id(rs.getInt("cID"));
  12.             course.setCou_major(rs.getString("cMajor"));
  13.             course.setCou_name(rs.getString("cName"));
  14.             course.setCou_type(rs.getString("cType"));
  15.             course.setCou_beginTime(rs.getString("cStartTerm"));
  16.             course.setCou_studyTime(rs.getInt("cPeriod"));
  17.             course.setCou_score(rs.getInt("cCredit"));
  18.         }
  19.         rs.close();
  20.         ps.close();
  21.         return course;
  22.     }
  23.     //判断是否存在该课程
  24.     public static boolean isCourse(int cID) throws Exception {
  25.         String sql="select cID,cMajor,cName,cType,cStartTerm,cPeriod,cCredit from course where cID=?";
  26.         PreparedStatement ps=utilDao.getCon().prepareStatement(sql);
  27.         //过滤其他的只留下ID为1的学生
  28.         ps.setInt(1,cID);
  29.         ResultSet rs=ps.executeQuery();
  30.         if(rs.next()){
  31.             return true;
  32.         } else {
  33.             return false;
  34.         }
  35.     }
  36.  
  37.     // 学生类集合课程初始化
  38.     public static ArrayList<course> initCourse() throws Exception {
  39.         ArrayList<course> courses = new ArrayList<>();
  40.         String sql = "select * from course order by cID asc";
  41.         PreparedStatement ps = utilDao.getCon().prepareStatement(sql);
  42.         ResultSet rs = ps.executeQuery();
  43.  
  44.         // 使用 while 循环遍历 ResultSet 中的所有行
  45.         while (rs.next()) {
  46.             course course = new course();
  47.             course.setCou_id(rs.getInt("cID"));
  48.             course.setCou_major(rs.getString("cMajor"));
  49.             course.setCou_name(rs.getString("cName"));
  50.             course.setCou_type(rs.getString("cType"));
  51.             course.setCou_beginTime(rs.getString("cStartTerm"));
  52.             course.setCou_studyTime(rs.getInt("cPeriod"));
  53.             course.setCou_score(rs.getInt("cCredit"));
  54.  
  55.             courses.add(course);
  56.         }
  57.  
  58.         // 关闭资源
  59.         rs.close();
  60.         ps.close();
  61.         return courses;
  62.     }
  63.     //增加课程
  64.     public static boolean addCourse(int cID, String cMajor, String cName, String cType, String cStartTerm, int  cPeriod, int  cCredit){
  65.         String sql="insert into course(cID,cMajor,cName,cType,cStartTerm,cPeriod,cCredit)values (?,?,?,?,?,?,?) ";
  66.         return utilDao.exeUpdate(sql,cID,cMajor,cName,cType,cStartTerm,cPeriod,cCredit);
  67.  
  68.     }
  69.     //修改课程
  70.     public static boolean updateCourse(int cID, String cMajor, String cName, String cType, String cStartTerm, int  cPeriod, int cCredit){
  71.         String sql="update course set cID=?,cMajor=?,cName=?,cType=?,cStartTerm=?,cPeriod=?,cCredit=? ";
  72.         return utilDao.exeUpdate(sql,cID,cMajor,cName,cType,cStartTerm,cPeriod,cCredit);
  73.  
  74.     }
  75.     //删除课程
  76.     public static boolean deleteCourse(int cID){
  77.         String sql="delete from course where cID=?";
  78.         return utilDao.exeUpdate(sql,cID);
  79.     }

skorDao:

  1. //判断是否存在该成绩
  2.     public static boolean isScore(int stu_id,int cid) throws SQLException {
  3.         String sql="select * from score where stuID=? and cID=?";
  4.         PreparedStatement ps=utilDao.getCon().prepareStatement(sql);
  5.         //过滤其他的只留下ID为1的学生
  6.         ps.setString(1,String.valueOf(stu_id));
  7.         ps.setString(2,String.valueOf(cid));
  8.         ResultSet rs=ps.executeQuery();
  9.         if(rs.next()){
  10.             return true;
  11.         }
  12.         return false;
  13.     }
  14.  
  15.     // 学生类成绩初始化
  16.     public static ArrayList<score> initScore() throws Exception {
  17.         ArrayList<score> scores = new ArrayList<>();
  18.         String sql = "select * from score order by stuID asc ";
  19.         PreparedStatement ps = utilDao.getCon().prepareStatement(sql);
  20.         ResultSet rs = ps.executeQuery();
  21.  
  22.         // 使用 while 循环遍历 ResultSet 中的所有行
  23.         while (rs.next()) {
  24.             score score = new score();
  25.             score.setScore_id(rs.getInt("stuID"));
  26.             score.setScore_cid(rs.getInt("cID"));
  27.             score.setSocre_score(rs.getString("score"));
  28.             score.setScore_credit(rs.getString("credit"));
  29.             scores.add(score);
  30.         }
  31.  
  32.         // 关闭资源
  33.         rs.close();
  34.         ps.close();
  35.         return scores;
  36.     }
  37.  
  38.     //返回学生成绩
  39.     public static score returnScore(int stuID,int cID)throws Exception{
  40.         score score=new score();
  41.         String sql="select * from score where stuID=? and cID=? ";
  42.         PreparedStatement ps=utilDao.getCon().prepareStatement(sql);
  43.         //过滤其他的只留下ID为1的学生
  44.         ps.setString(1,String.valueOf(stuID));
  45.         ps.setString(2,String.valueOf(cID));
  46.         ResultSet rs=ps.executeQuery();
  47.         while (rs.next()){
  48.             score.setScore_id(rs.getInt("stuID"));
  49.             score.setScore_cid(rs.getInt("cID"));
  50.             score.setSocre_score(rs.getString("score"));
  51.             score.setScore_credit(rs.getString("credit"));
  52.         }
  53.         rs.close();
  54.         ps.close();
  55.         return score;
  56.     }
  57.  
  58.     //增加成绩
  59.     public static boolean addScore(int stuID,int cID,String score,String credit){
  60.         String sql="insert into score(stuID,cID,score,credit)values (?,?,?,?) ";
  61.         return utilDao.exeUpdate(sql,stuID,cID,score,credit);
  62.     }
  63.     //修改成绩
  64.     public static boolean updateScore(int stuID,int cID,String score,String credit){
  65.         String sql="update score set stuID=?,cID=?,score=?,credit=? ";
  66.         return utilDao.exeUpdate(sql,stuID,cID,score,credit);
  67.     }
  68.     //删除成绩
  69.     public static boolean deleteScore(int stuID,int cID){
  70.         String sql="delete from score where stuID=? and cID=?";
  71.         return utilDao.exeUpdate(sql,stuID,cID);
  72.     }

hakimDao:

  1. //找出最大学生id
  2.     public static int maxID() throws Exception {
  3.         String sql = "select max(stuID) as maxId from student";
  4.         PreparedStatement ps = utilDao.getCon().prepareStatement(sql);
  5.         ResultSet rs = ps.executeQuery();
  6.         // 默认值或者根据需求设定初始值
  7.         int maxId = 0;
  8.         //如果存在
  9.         if (rs.next()) {
  10.             maxId = rs.getInt("maxId"); // 从结果集中获取名为 maxId 的列的值
  11.         }
  12.         return maxId;
  13.  
  14.     }
  15.     //找出最大课程id
  16.     public static int maxcID()throws Exception{
  17.         String sql = "select max(cID) as maxId from course";
  18.         PreparedStatement ps = utilDao.getCon().prepareStatement(sql);
  19.         ResultSet rs = ps.executeQuery();
  20.  
  21.         int maxId = 0; // 默认值或者根据需求设定初始值
  22.         if (rs.next()) {
  23.             maxId = rs.getInt("maxId"); // 从结果集中获取名为 maxId 的列的值
  24.         }
  25.         return maxId;
  26.     }
  27.     //判断是否为管理员
  28.     public static boolean magLogin(String name,String password)throws Exception{
  29.         String sql="select * from manager where name=? and password=?";
  30.         PreparedStatement ps=utilDao.getCon().prepareStatement(sql);
  31.         ps.setString(1,name);
  32.         ps.setString(2,password);
  33.         ResultSet rs=ps.executeQuery();
  34.  
  35.         if (rs.next()) {
  36.             utilDao.close(rs,ps,utilDao.getCon());
  37.             return true;
  38.         } else {
  39.             utilDao.close(rs,ps,utilDao.getCon());
  40.             return false;
  41.         }
  42.  
  43.     }

domain (kelas objek):

murid:

  1. public class student {
  2.  
  3.     private int stu_id;
  4.     private String stu_class;
  5.     private String stu_name;
  6.     private String stu_gender;
  7.     private String stu_birth;
  8.     private String stu_major;
  9.     private String stu_password;
  10.  
  11.     public student() {
  12.     }
  13.  
  14.     public int getStu_id() {
  15.         return stu_id;
  16.     }
  17.  
  18.     public void setStu_id(int stu_id) {
  19.         this.stu_id = stu_id;
  20.     }
  21.  
  22.     public String getStu_class() {
  23.         return stu_class;
  24.     }
  25.  
  26.     public void setStu_class(String stu_class) {
  27.         this.stu_class = stu_class;
  28.     }
  29.  
  30.     public String getStu_name() {
  31.         return stu_name;
  32.     }
  33.  
  34.     public void setStu_name(String stu_name) {
  35.         this.stu_name = stu_name;
  36.     }
  37.  
  38.     public String getStu_gender() {
  39.         return stu_gender;
  40.     }
  41.  
  42.     public void setStu_gender(String stu_gender) {
  43.         this.stu_gender = stu_gender;
  44.     }
  45.  
  46.     public String getStu_birth() {
  47.         return stu_birth;
  48.     }
  49.  
  50.     public void setStu_birth(String stu_birth) {
  51.         this.stu_birth = stu_birth;
  52.     }
  53.  
  54.     public String getStu_major() {
  55.         return stu_major;
  56.     }
  57.  
  58.     public void setStu_major(String stu_major) {
  59.         this.stu_major = stu_major;
  60.     }
  61.  
  62.     public String getStu_password() {
  63.         return stu_password;
  64.     }
  65.  
  66.     public void setStu_password(String stu_password) {
  67.         this.stu_password = stu_password;
  68.     }

kursus:

  1. public class course {
  2.  
  3.     private int cou_id;
  4.     private String cou_major;
  5.     private String cou_name;
  6.     private String cou_type;
  7.     private String cou_beginTime;
  8.     private int cou_studyTime;
  9.     private int cou_score;
  10.  
  11.     public course() {
  12.     }
  13.  
  14.     public int getCou_id() {
  15.         return cou_id;
  16.     }
  17.     public void setCou_id(int cou_id) {
  18.         this.cou_id = cou_id;
  19.     }
  20.  
  21.     public String getCou_major() {
  22.         return cou_major;
  23.     }
  24.  
  25.     public void setCou_major(String cou_major) {
  26.         this.cou_major = cou_major;
  27.     }
  28.  
  29.     public String getCou_name() {
  30.         return cou_name;
  31.     }
  32.  
  33.     public void setCou_name(String cou_name) {
  34.         this.cou_name = cou_name;
  35.     }
  36.  
  37.     public String getCou_type() {
  38.         return cou_type;
  39.     }
  40.  
  41.     public void setCou_type(String cou_type) {
  42.         this.cou_type = cou_type;
  43.     }
  44.  
  45.     public String getCou_beginTime() {
  46.         return cou_beginTime;
  47.     }
  48.  
  49.     public void setCou_beginTime(String cou_beginTime) {
  50.         this.cou_beginTime = cou_beginTime;
  51.     }
  52.  
  53.     public int getCou_studyTime() {
  54.         return cou_studyTime;
  55.     }
  56.  
  57.     public void setCou_studyTime(int cou_studyTime) {
  58.         this.cou_studyTime = cou_studyTime;
  59.     }
  60.  
  61.     public void setCou_score(int cou_score) {
  62.         this.cou_score = cou_score;
  63.     }
  64.  
  65.     public int getCou_score() {
  66.         return cou_score;
  67.     }

skor:

  1. private int score_id;
  2.     private int score_cid;
  3.     private String socre_score;
  4.     private String score_credit;
  5.  
  6.     public score() {
  7.     }
  8.  
  9.     public int getScore_id() {
  10.         return score_id;
  11.     }
  12.  
  13.     public String getSocre_score() {
  14.         return socre_score;
  15.     }
  16.  
  17.     public void setSocre_score(String socre_score) {
  18.         this.socre_score = socre_score;
  19.     }
  20.  
  21.     public String getScore_credit() {
  22.         return score_credit;
  23.     }
  24.  
  25.     public void setScore_credit(String score_credit) {
  26.         this.score_credit = score_credit;
  27.     }
  28.  
  29.     public void setScore_id(int score_id) {
  30.         this.score_id = score_id;
  31.     }
  32.  
  33.     public int getScore_cid() {
  34.         return score_cid;
  35.     }

akhir

Saya telah selesai membagikan kode saya di sini. Terima kasih semuanya telah menonton. Karena struktur kode saya relatif besar, masing-masing kelas di atas telah selesai di sini. Kecuali untuk studentDao yang ditulis secara terpisah, saya akan menampilkannya kembali di sini , semuanya sama dan tidak akan ditampilkan.

 

pelajarDao (lengkap):

  1. //学生登录判断
  2.     public static boolean login(String idStr, String passwordStr) throws Exception {
  3.  
  4.         String sql = "select * from student where stuID =? and stuPassword=?";
  5.         PreparedStatement ps = utilDao.getCon().prepareStatement(sql);
  6.         ps.setString(1,idStr);
  7.         ps.setString(2, passwordStr);
  8.         ResultSet rs = ps.executeQuery();
  9.  
  10.         if (rs.next()) {
  11.             utilDao.close(rs,ps, utilDao.getCon());
  12.             return true;
  13.         } else {
  14.             utilDao.close(rs,ps,utilDao.getCon());
  15.             return false;
  16.         }
  17.  
  18.  
  19.     }
  20.  
  21.     //学生查询自己成绩
  22.     public static Integer gradeOneself(int stu_id) throws Exception {
  23.         String sql = "SELECT SUM(credit) AS gradesum FROM score WHERE stuID=?";
  24.  
  25.         try (Connection connection =utilDao.getCon();
  26.              PreparedStatement ps = connection.prepareStatement(sql)) {
  27.  
  28.             ps.setInt(1, stu_id);
  29.             try (ResultSet rs = ps.executeQuery()) {
  30.                 if (rs.next()) {
  31.                     int gradesum = rs.getInt("gradesum");
  32.                     return gradesum;
  33.                 } else {
  34.                     // 如果没有查询到结果，可以返回 null 或者其他合适的值
  35.                     return null;
  36.                 }
  37.             }
  38.         }
  39.     }
  40.  
  41.     //返回学生信息
  42.     public static student returnStudent(int stu_id)throws Exception{
  43.  
  44.         student student=new student();
  45.         String sql="select stuID,stuClass,stuName,stuSex,stuBirth,stuMajor,stuPassword from student where stuID=?";
  46.         PreparedStatement ps=utilDao.getCon().prepareStatement(sql);
  47.         //过滤其他的只留下ID为1的学生
  48.         ps.setString(1,String.valueOf(stu_id));
  49.         ResultSet rs=ps.executeQuery();
  50.         if(rs.next()){
  51.             student.setStu_id(rs.getInt("stuID"));
  52.             student.setStu_class(rs.getString("stuClass"));
  53.             student.setStu_name(rs.getString("stuName"));
  54.             student.setStu_gender(rs.getString("stuSex"));
  55.             student.setStu_birth(rs.getString("stuBirth"));
  56.             student.setStu_major(rs.getString("stuMajor"));
  57.             student.setStu_password(rs.getString("stuPassword"));
  58.         }
  59.         rs.close();
  60.         ps.close();
  61.         return student;
  62.     }
  63.  
  64.     //判断是否存在该学生
  65.     public static boolean isStudent(int stu_id) throws SQLException {
  66.         String sql="select stuID,stuClass,stuName,stuSex,stuBirth,stuMajor from student where stuID=?";
  67.         PreparedStatement ps=utilDao.getCon().prepareStatement(sql);
  68.         //过滤其他的只留下ID为1的学生
  69.         ps.setString(1,String.valueOf(stu_id));
  70.         ResultSet rs=ps.executeQuery();
  71.         if(rs.next()){
  72.             return true;
  73.         }
  74.         else {
  75.             return false;
  76.         }
  77.     }
  78.  
  79.     // 学生类信息初始化
  80.     public static ArrayList<student> initStudent() throws Exception {
  81.         ArrayList<student> students = new ArrayList<>();
  82.         String sql = "select * from student order by stuID asc";
  83.         PreparedStatement ps = utilDao.getCon().prepareStatement(sql);
  84.         ResultSet rs = ps.executeQuery();
  85.  
  86.         // 使用 while 循环遍历 ResultSet 中的所有行
  87.         while (rs.next()) {
  88.             student student = new student();
  89.             student.setStu_id(rs.getInt("stuID"));
  90.             student.setStu_class(rs.getString("stuClass"));
  91.             student.setStu_name(rs.getString("stuName"));
  92.             student.setStu_gender(rs.getString("stuSex"));
  93.             student.setStu_birth(rs.getString("stuBirth"));
  94.             student.setStu_major(rs.getString("stuMajor"));
  95.             students.add(student);
  96.         }
  97.  
  98.         // 关闭资源
  99.         rs.close();
  100.         ps.close();
  101.         return students;
  102.     }
  103.     //添加学生
  104.     public static boolean addStudent(int stuId,String stuClass,String stuName, String stuSex, String stuBirth, String stuMajor,String stuPassword)throws Exception{
  105.         String sql="insert into student(stuID,stuClass,stuName,stuSex,stuBirth,stuMajor,stuPassword )values (?,?,?,?,?,?,?) ";
  106.         return utilDao.exeUpdate(sql,stuId,stuClass,stuName,stuSex,stuBirth,stuMajor,stuPassword);
  107.     }
  108.     //修改学生
  109.     public static boolean updateStudent(int stuId,String stuClass,String stuName, String stuSex, String stuBirth, String stuMajor,String stuPassword)throws Exception{
  110.         String sql="update student set stuID=?,stuClass=?,stuName=?,stuSex=?,stuBirth=?,stuMajor=?,stuPassword=?";
  111.         return utilDao.exeUpdate(sql,stuId,stuClass,stuName,stuSex,stuBirth,stuMajor,stuPassword);
  112.     }
  113.     //删除学生
  114.     public static boolean deleteStudent(int stuId){
  115.         String sql="delete from student where stuID=?";
  116.         return utilDao.exeUpdate(sql,stuId);
  117.     }

Terima kasih telah menonton. Jika ada yang tidak Anda mengerti, silakan tinggalkan pesan kepada saya.

 

 

 

Profil pribadi

Ia telah mengabdikan dirinya untuk meneliti teknologi selama lebih dari 30 tahun, dan mahir dalam berbagai bahasa seperti java, linux, javascript, php, css, dll. Ia telah memberikan banyak kontribusi di bidang open source stasiun dokumentasi pengembang untuk berbagi beberapa masalah dalam pengembangan teknologi untuk referensi di masa mendatang. Semua orang memeriksanya

informasi kontak saya

Surat