Partage de technologie

Système de gestion des étudiants JavaFx MySql

2024-07-12

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

Avant-propos :

J'ai appris les bases de données javafx et mysql le mois dernier, j'ai donc écrit un système de gestion des étudiants. Parce que j'étais en train de réviser le mois dernier et que j'avais des choses à faire, j'étais assez occupé, donc je n'ai pas mis à jour le blog. C'est un peu simple, c'est à peu près la même chose. Le contenu est relativement simple, je vais donc maintenant partager avec vous mon système de gestion des étudiants. J'espère que les étudiants intéressés par cet aspect pourront m'aider.

🥰个人主页:coeur.c

🤓文章专题:système de gestion javafx+mysql

👐欢迎大家点赞👍 收藏😽

 

9a7940c627094e34946debbd787da24e.jpg

487ac90190f44b238ebafae9d457463b.png

 

Table des matières

Affichage des pages :

Création du package :

interface de connexion :

Interface de connexion étudiant :

Demande d'informations sur les étudiants :

Modifier

Enquête sur les performances des étudiants :

Interface de connexion administrateur :

Interface de gestion des informations sur les étudiants administrateurs :

Interface de gestion des informations de cours administrateur :

Interface de gestion des informations sur les scores de l'administrateur :

Modifier l'interface étudiant :

Affichage des codes :

Fenêtre principale (endView) :

Interface de connexion et fenêtre d'invite (otherView) :

étudiant:

Interface étudiant (studentView) :

Déclaration de l'étudiant Dao :

utilDao:

étudiantDao*:

administrateur:

Interface administrateur (magView) :

Outils d'administration :

étudiant (étudiantUtil):

Cours(courseUtil):

Score(scoreUtil) :

Classe d'outils de jugement (judgeUtil) :

Classe Administrateur Dao :

utilDao:

étudiantDao*:

coursDao:

scoreDao:

jugeDao:

domaine (classe d'objet) :

étudiant:

cours:

score:

fin

 

 

Affichage des pages :

Création du package :

(Ici, j'utilise certaines structures de framework MVC. Bien que je n'aie pas beaucoup de code, je pense qu'écrire de cette façon peut rendre notre code plus concis, facile à comprendre et hautement structuré)

4033c3dc2d754754a7b3f2454d5e9845.png

interface de connexion :

Concernant l'interface de connexion (à propos de l'interface de connexion, j'ai écrit quelques jugements sur la zone de saisie de texte--Le jugement de la base de données est correct et certains jugements non nuls--)

55d6138971d64cfbb14cf719a47454e5.png

Interface de connexion étudiant :

87787ba5c3924a76a98926dd8515df68.png

Demande d'informations sur les étudiants :

8e9905fc895a44c982abbc457be7a80a.png

Enquête sur les performances des étudiants :

97cefd35d8ad47399c72b79e965a7d4d.png

Interface de connexion administrateur :

a5114f0d903747b197c0ad925c424043.png

Interface de gestion des informations sur les étudiants administrateurs :

49cd3ef4185041aa8d83bb07e3cc417e.png

Interface de gestion des informations de cours administrateur :

d7d32fcf511e4703a0701d4b44141a7f.png

Interface de gestion des informations sur les scores de l'administrateur :

584f66d36cdf4bb8a2c0bb845fb20d84.png

Modifier l'interface étudiant :

(Je pensais que ces pages étaient toutes similaires, donc je montre ici uniquement une interface pour ajouter des étudiants)

9f338156d1d740fca1f060ce0ede42c8.png

 

Affichage des codes :

 

Fenêtre principale (endView) :

Concernant la fenêtre principale, j'ai défini une étape statique comme étant ma scène principale et j'ai attribué la valeur d'étape dans ma méthode de démarrage à l'étape statique. Le but de définir cette étape est d'intégrer d'autres méthodes que j'ai écrites, telles que l'interface de connexion, etc. La scène de la méthode est placée dans ma scène statique, de sorte que lorsque mon code est exécuté, ma page puisse toujours utiliser la scène principale et l'interface ne semble pas compliquée. C'est également très pratique et facile à comprendre.

  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. }

Interface de connexion et fenêtre d'invite (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.     }

étudiant:

Interface étudiant (studentView) :

Voici les trois interfaces que j'ai écrites. Par rapport à l'image de connexion des étudiants ci-dessus, elles correspondent à trois méthodes au total, bien entendu, les deux dernières méthodes (requête de score et requête d'informations) seront placées dans la première méthode stu_login. l'action du bouton moniteur et fonction

  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.     }

Déclaration de l'étudiant 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.     }

étudiantDao*:

au-dessus deSeules les déclarations jdbc concernant la connexion des étudiants sont affichées, pas toutes les déclarations de mon studentDao, ceci est écrit pour rendre l'idée plus claire. Si vous pensez que c'est très simple, vous pouvez voir mon code total ci-dessous.

  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.     }

---Voici le code de connexion des étudiants---

administrateur:

Interface administrateur (magView) :

Voici ma méthode d'interface pour les paramètres d'administrateur. Il y a quatre interfaces principales d'administrateur au total, qui correspondent aux quatre premières connexions d'administrateur dans l'affichage de la page. Il y a 7 méthodes au total ci-dessous concernant la méthode createTableView, je l'ai écrite et utilisée. le mien. L'objet tel que student est ajouté à une partie du code dans la tableview. Il supprime et redéfinit simplement une méthode. Vous n'avez pas besoin de vous en soucier. Par conséquent, les quatre autres méthodes de création de l'interface correspondent simplement. les quatre premières connexions d'administrateur dans l'affichage de la page. Les quatre premières méthodes sont utilisées pour créer l'interface. L'une est la méthode d'interface après la connexion, et les trois dernières sont les méthodes appelées par la surveillance des actions des trois premiers boutons du panneau après. se connecter.

  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. }

Outils d'administration :

La classe de l'outil administrateur permet d'ajouter des étudiants, de modifier des étudiants, de supprimer des étudiants, d'ajouter des cours... dans la page de fonctionnement.

étudiant (étudiantUtil):

  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.

Cours(courseUtil):

  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.     }

Score(scoreUtil) :

  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.     }

Classe d'outils de jugement (judgeUtil) :

Cette classe d'outils est utilisée pour juger les chaînes dans certaines zones de texte lors de l'ajout de données. Elle est utilisée dans les trois utilitaires ci-dessus.

  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.     }

Classe Administrateur Dao :

utilDao:

Étant donné que Connection, close et exeupdate seront fréquemment utilisés, j'écrirai trois méthodes directement ici.

  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.     }

étudiantDao*:

Le studentDao suivant est uniquement lié au fonctionnement de l'interface de l'administrateur

  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.     }

coursDao:

  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.     }

scoreDao:

  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.     }

jugeDao:

  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.     }

domaine (classe d'objet) :

étudiant:

  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.     }

cours:

  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.     }

score:

  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.     }

fin

J'ai fini de partager mon code ici. Merci à tous d'avoir regardé. Comme ma structure de code est relativement volumineuse, chacune des classes ci-dessus est complète ici, à l'exception de studentDao, qui est écrit séparément, je vais le réafficher ici. , tout le reste est identique et ne sera pas affiché.

 

étudiantDao (complet):

  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.     }

Merci à tous d'avoir regardé. S'il y a quelque chose que vous ne comprenez pas, laissez-moi un message Rush !!!

 

 

 

Profil personnel

Il se consacre à la recherche technologique depuis plus de 30 ans et maîtrise divers langages tels que java, linux, javascript, php, css, etc. Il a apporté de nombreuses contributions dans le domaine de l'open source. station de documentation pour les développeurs pour partager certains problèmes de développement technologique pour référence future.

mes coordonnées

Mail