# classRegister

**Repository Path**: fswan/class-register

## Basic Information

- **Project Name**: classRegister
- **Description**: Class register 
- **Primary Language**: Java
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2023-04-10
- **Last Updated**: 2023-05-05

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# classRegister

## 1. Introduce

This is a class register system, designed by zhiwen and Xu.

Zhiwen is responsible for the application structure and model, Xu responsible Views and Controllers.

There are three role.

Git address for this probject is: git@gitee.com:fswan/class-register.git.

1. admin
   Add user (teacher) only, reset password.
2. teacher
   Add user(student), and add class, reset password.
3. student
   Register class of a teacher and reset password.

## 2. System Architecture

All data store with mysql database.
Use javaFX do all view functions.

### 2.1 Structure of folder
```
├─document      -- save the files link in readme.md
├─src           -- source code
│  ├─main
│  │  ├─java    -- java file
│  │  │  └─com
│  │  │      └─swan
│  │  │          ├─bean  --- POJO bean folder
│  │  │          ├─controllers   -- controller folder 
│  │  │          ├─exception   --- exception folder
│  │  │          ├─models    --- model folder
│  │  │          ├─util    -- some util tool
│  │  │          └─views   --- view folder
│  │  └─resources --- save fxml files
│  │      └─com
│  │          └─swan
│  └─test      --- unit test case
│      └─java
│          └─com
│              └─swan
│          ├─util
│          └─view
```
### 2.2 E-R Diagram



The DB connection information save into the file db.properties.
The file db.sql in folder resources used to init database structure.

![ER diagram](document/ER.svg)

## 3.     System Implementation

### 3.1 login page

#### 3.1.1 GUI
![login page](document/login.png)

Login: type the correct account and password , press login button , then login the system.

![login success](document/login_success.png)
#### 3.1.2 Source code

##### 3.1.2.1 view

```java
package com.swan.views;

import java.io.IOException;

import com.swan.App;

import javafx.application.Application;
import javafx.fxml.FXMLLoader;
import javafx.scene.layout.Pane;
import javafx.stage.Stage;
import javafx.scene.Scene;

/**
 * LoginApplication
 * @author xyh
 * @param <T>
 * @date 20230426
 *
 */
public class LoginApplication extends Application{
	
	@Override
    public void start(Stage stage) throws IOException {
		Pane Login = FXMLLoader.load(App.class.getResource("Login.fxml"));
        Scene login = new Scene(Login);
        stage.setTitle("Please Login ");
        stage.setScene(login);
        stage.show();
    }
 
    public static void main(String[] args) {
        launch(args);
    }
    
    public void changePwd() throws IOException {
    	Pane Login = FXMLLoader.load(App.class.getResource("ChangePwd.fxml"));
        Scene login = new Scene(Login);
        Stage stage = new Stage();
        stage.setTitle("Please Change Your Password ");
        stage.setScene(login);
        stage.show();
    }

    
    public void login() throws IOException {
    	Pane Login = FXMLLoader.load(App.class.getResource("Login.fxml"));
        Scene login = new Scene(Login);
        Stage stage = new Stage();
        stage.setTitle("Please Login ");
        stage.setScene(login);
        stage.show();
    }
}

```

resources/com/swan/login.fxml

```xml
<?xml version="1.0" encoding="UTF-8"?>

        <?import javafx.scene.control.Button?>
        <?import javafx.scene.control.Label?>
        <?import javafx.scene.control.PasswordField?>
        <?import javafx.scene.control.TextField?>
        <?import javafx.scene.layout.Pane?>
        <?import javafx.scene.text.Font?>

<Pane maxHeight="-Infinity" maxWidth="-Infinity" minHeight="-Infinity" minWidth="-Infinity" prefHeight="400.0" prefWidth="600.0" xmlns="http://javafx.com/javafx/17" xmlns:fx="http://javafx.com/fxml/1" fx:controller="com.swan.controllers.LoginController">
<children>
<Label contentDisplay="CENTER" layoutX="145.0" layoutY="47.0" prefHeight="37.0" prefWidth="404.0" text="Welcome to Class Management System!" textAlignment="CENTER" textFill="#064090">
<font>
<Font name="Arial" size="20.0" />
</font>
</Label>
<Label layoutX="168.0" layoutY="158.0" prefHeight="15.0" prefWidth="71.0" text="account:">
<font>
<Font size="14.0" />
</font>
</Label>
<Label layoutX="163.0" layoutY="210.0" prefHeight="15.0" prefWidth="82.0" text="password:">
<font>
<Font size="14.0" />
</font>
</Label>
<TextField fx:id="AccountTextField" layoutX="256.0" layoutY="156.0" />
<PasswordField fx:id="PasswordPasswordField" layoutX="256.0" layoutY="208.0" />
<Button fx:id="LoginButton" layoutX="255.0" layoutY="279.0" mnemonicParsing="false" onAction="#loginButtonClick" prefHeight="23.0" prefWidth="90.0" text="Login" />
<Label fx:id="MessageLabel" layoutX="175.0" layoutY="93.0" prefHeight="46.0" prefWidth="273.0" />
</children>
</Pane>
```
##### 3.1.2.2 Controller

java/com/swan/controllers/LoginController.java
```java
package com.swan.controllers;

import java.io.IOException;

import javafx.event.ActionEvent;
import javafx.stage.Stage;
import javafx.fxml.FXML;
import javafx.scene.control.Button;
import javafx.scene.control.Label;
import javafx.scene.control.PasswordField;
import javafx.scene.control.TextField;

import com.swan.beans.UserBean;
import com.swan.beans.UserInfo;
import com.swan.exceptions.CustomerException;
import com.swan.models.LoginDao;
import com.swan.models.UserDao;
import com.swan.views.MainApplication;

/**
 * LoginController
 * 
 * @author xyh
 * @param <T>
 * @date 20230426
 *
 */

public class LoginController {
	@FXML
	private TextField AccountTextField;
	@FXML
	private PasswordField PasswordPasswordField;
	@FXML
	private Label MessageLabel;
	@FXML
	private Button LoginButton;

	@FXML
	private PasswordField oldPwdField;

	@FXML
	private PasswordField newPwdField;

	@FXML
	private PasswordField newPwdAgainField;

	private LoginDao dao = new LoginDao();

	private UserDao daoUser = new UserDao();

	public void loginButtonClick(ActionEvent event) throws IOException {
		String account = AccountTextField.getText();
		String password = PasswordPasswordField.getText();
		System.out.println("account:" + account + ",password:" + password);

		if (account != null && !account.equals("") && password != null && !password.equals("")) {
			try {
				int login = dao.login(account, password);
				if (login > 0) {

					MessageLabel.setText("login success!");

					// save login information
					UserInfo.getInstace(account, login);

					UserBean userBean = daoUser.getUserById(login);
					String role = userBean.getRole();

					Stage primaryStage = (Stage) LoginButton.getScene().getWindow();
					primaryStage.close();
					MainApplication mainApplication = new MainApplication();

					switch (role) {
					case "ADMIN":
						mainApplication.mainStage("Admin");
						break;

					case "TEACHER":
						mainApplication.mainStage("Teacher");
						break;

					case "STUDENT":
						mainApplication.mainStage("Student");
						break;

					}
				}
			} catch (CustomerException e) {
				MessageLabel.setText("error account or password!");
			}
		} else {
			MessageLabel.setText("type your account or password!");
		}
	}

	public void changePwd(ActionEvent event) throws IOException {
		String oldPwd = oldPwdField.getText();
		String newPwd = newPwdField.getText();
		String newPwdAgain = newPwdAgainField.getText();
		if (oldPwd != null && !oldPwd.equals("") && newPwd != null && !newPwd.equals("") && newPwdAgain != null
				&& !newPwdAgain.equals("")) {
			if (newPwd.equals(newPwdAgain)) {
				UserInfo loginUser = UserInfo.getLoginUser();
				if (loginUser != null) {
					String userName = loginUser.getUserName();
					int login = dao.login(userName, oldPwd);
					if (login > 0) {
						dao.changePassword(userName, oldPwd, newPwd);
						MessageLabel.setText("new password has been set !");
					} else {
						MessageLabel.setText("old password is wrong!");
					}
				}
			} else {
				MessageLabel.setText("new password not equals new password again!");
			}
		} else {
			MessageLabel.setText("can not null!");
		}

	}

}

```

##### 3.1.2.3 model

com.swan.models.LoginDao

```java
package com.swan.models;

import java.sql.ResultSet;
import java.sql.SQLException;

import com.swan.exceptions.CustomerException;

public class LoginDao {
    public int login(String loginId, String password) {
        try (DBUtil db = new DBUtil()) {
            ResultSet rs = db.preparedStatement("select * from login where login_id = ? and password = ?", loginId, password);
            if (rs.next())
                return rs.getInt("user_id");
            else
                throw new CustomerException("Login id or password invalid.");
        } catch (SQLException e) {
            throw new CustomerException(e);
        }
    }

    public boolean changePassword(String name, String oldPassword, String newPassword) {
        try (DBUtil db = new DBUtil()) {
            return db.updateWithoutGeneratedKey("update login set password = ? where login_id = ? and password = ?", newPassword, name, oldPassword) == 1;
        }
    }
}

```

### 3.2 Administrator Home page

#### 3.2.1 GUI

![](document/admin_homepage.png)

#### 3.2.2 Source Code

##### 3.2.2.1 View

com.swan.views.MainApplication

```java
package com.swan.views;

import java.io.IOException;

import com.swan.App;

import javafx.fxml.FXMLLoader;
import javafx.scene.Scene;
import javafx.scene.layout.Pane;
import javafx.stage.Stage;

/**
 * MainApplication
 * @author xyh
 * @date 20230426
 *
 */
public class MainApplication {

	public void mainStage(String mainStage) throws IOException {
		Pane root = FXMLLoader.load(App.class.getResource(mainStage+"Main.fxml"));
		Scene scene = new Scene(root);
		Stage stage = new Stage();
		stage.setTitle("Class Management System");
		stage.setScene(scene);
		stage.show();
	}

}

```

resources/com/swan/AdminMain.fxml

```xml
<?xml version="1.0" encoding="UTF-8"?>

<?import javafx.scene.control.Button?>
<?import javafx.scene.control.Hyperlink?>
<?import javafx.scene.control.Label?>
<?import javafx.scene.control.Separator?>
<?import javafx.scene.layout.Pane?>
<?import javafx.scene.text.Font?>

<Pane maxHeight="-Infinity" maxWidth="-Infinity" minHeight="-Infinity" minWidth="-Infinity" prefHeight="400.0" prefWidth="600.0" xmlns="http://javafx.com/javafx/17" xmlns:fx="http://javafx.com/fxml/1" fx:controller="com.swan.controllers.MainController">
   <children>
      <Button fx:id="UserMgtBtn" layoutX="101.0" layoutY="160.0" mnemonicParsing="false" onAction="#toUserMgt" prefHeight="81.0" prefWidth="145.0" text="User Mgt">
         <font>
            <Font size="18.0" />
         </font>
      </Button>
      <Button fx:id="SeasonMgtBtn" layoutX="355.0" layoutY="160.0" mnemonicParsing="false" onAction="#toSeasonMgt" prefHeight="81.0" prefWidth="145.0" text="Season Mgt">
         <font>
            <Font size="18.0" />
         </font>
      </Button>
      <Label layoutX="31.0" layoutY="29.0" />
      <Label layoutX="31.0" layoutY="29.0" prefHeight="47.0" prefWidth="245.0" text="Welcome Admin User !" textFill="#064090">
         <font>
            <Font size="14.0" />
         </font>
      </Label>
      <Label contentDisplay="CENTER" layoutX="423.0" layoutY="349.0" prefHeight="37.0" prefWidth="163.0" text="Class Management System" textAlignment="CENTER" textFill="#064090" underline="true">
         <font>
            <Font name="Arial" size="10.0" />
         </font>
      </Label>
      <Separator layoutX="26.0" layoutY="80.0" prefHeight="23.0" prefWidth="548.0" />
      <Label fx:id="UserInfoLabel" alignment="CENTER_RIGHT" contentDisplay="RIGHT" layoutX="381.0" layoutY="48.0" prefHeight="19.0" prefWidth="193.0" text="hi , Richard" textFill="#064090">
         <font>
            <Font size="14.0" />
         </font>
      </Label>
      <Hyperlink alignment="CENTER_RIGHT" layoutX="464.0" layoutY="69.0" onAction="#toChangePwd" prefHeight="21.0" prefWidth="113.0" text="Change Password" />
      <Hyperlink fx:id="logoutHyper" alignment="CENTER_RIGHT" layoutX="334.0" layoutY="70.0" onAction="#toLogout" prefHeight="21.0" prefWidth="121.0" text="Logout" />
      <Separator layoutX="455.0" layoutY="73.0" orientation="VERTICAL" prefHeight="15.0" prefWidth="17.0" />
   </children>
</Pane>

```

##### 3.2.2.2 Controller

com.swan.controllers.MainController

```java
package com.swan.controllers;

import java.io.IOException;

import com.swan.beans.UserInfo;
import com.swan.views.ClassMgtApplication;
import com.swan.views.ClassRegistrationApplication;
import com.swan.views.CourseSchedulingApplication;
import com.swan.views.LoginApplication;
import com.swan.views.SeasonMgtApplication;
import com.swan.views.UserMgtApplication;
import com.swan.views.StudentClassRegApplication;

import javafx.event.ActionEvent;
import javafx.fxml.FXML;
import javafx.scene.control.Hyperlink;
import javafx.scene.control.Label;
import javafx.stage.Stage;

/**
 * MainController
 * 
 * @author xyh
 * @date 20230426
 *
 */

public class MainController {

	@FXML
	private Label UserInfoLabel;
	
	@FXML
	private Hyperlink logoutHyper;

	@FXML
	public void toUserMgt(ActionEvent event) throws IOException {
		UserMgtApplication app = new UserMgtApplication();
		app.showStage();
	}

	@FXML
	public void toSeasonMgt(ActionEvent event) throws IOException {
		SeasonMgtApplication app = new SeasonMgtApplication();
		app.showStage();
	}

	@FXML
	public void toClassMgt(ActionEvent event) throws IOException {
		ClassMgtApplication app = new ClassMgtApplication();
		app.showStage();
	}

	@FXML
	public void toCourseScheduling(ActionEvent event) throws IOException {
		CourseSchedulingApplication app = new CourseSchedulingApplication();
		app.showStage();
	}
	

	public void toStudentClassReg() throws IOException {
		StudentClassRegApplication app = new StudentClassRegApplication();
		app.showStage();
	}
	
	
	@FXML
	public void toClassRegistration(ActionEvent event) throws IOException {
		ClassRegistrationApplication app = new ClassRegistrationApplication();
		app.showStage();
	}
	
	@FXML
	public void toChangePwd(ActionEvent event) throws IOException {
		LoginApplication app = new LoginApplication();
		app.changePwd();
	}
	
	@FXML
	public void toLogout(ActionEvent event) throws IOException {
		UserInfo.cleanUserSession();
		Stage primaryStage = (Stage) logoutHyper.getScene().getWindow();
		primaryStage.close();
		LoginApplication app = new LoginApplication();
		app.login();
	}

	@FXML
	private void initialize() {
		UserInfoLabel.setText("Hi , " + UserInfo.getLoginUser().getUserName());
	}
}
```

##### 3.2.2.3 Model

None

### 3.3 User management

#### 3.3.1 GUI

![](document/user_management.png)

![](document/user_delete.png)

#### 3.3.2 Source Code

##### 3.3.2.1 View

com.swan.views.UserMgtApplication

```java
package com.swan.views;

import java.io.IOException;

import com.swan.App;

import javafx.application.Application;
import javafx.fxml.FXMLLoader;
import javafx.scene.Scene;
import javafx.scene.layout.Pane;
import javafx.stage.Stage;

/**
 * UserMgtApplication
 * @author xyh
 * @param <T>
 * @date 20230426
 *
 */
public class UserMgtApplication extends Application{
	
	public void showStage() throws IOException {
		Pane root = FXMLLoader.load(App.class.getResource("UserMgt.fxml"));
		Scene scene = new Scene(root);
		Stage stage = new Stage();
		// set title
		stage.setTitle("Class Management System");
		stage.setScene(scene);
		stage.show();
	}

	@Override
	public void start(Stage arg0) throws Exception {
		showStage();
		
	}
	
	 public static void main(String[] args) {
	        launch(args);
	    }

	
}

```

resources/com/swan/userMgt.xml

```xml
<?xml version="1.0" encoding="UTF-8"?>
<?import javafx.geometry.Insets?>
<?import javafx.scene.control.Button?>
<?import javafx.scene.control.ChoiceBox?>
<?import javafx.scene.control.Label?>
<?import javafx.scene.control.TableColumn?>
<?import javafx.scene.control.TableView?>
<?import javafx.scene.control.TextField?>
<?import javafx.scene.layout.AnchorPane?>
<?import javafx.scene.layout.HBox?>
<?import javafx.scene.text.Font?>

<AnchorPane maxHeight="-Infinity" maxWidth="-Infinity" minHeight="-Infinity" minWidth="-Infinity" prefHeight="742.0" prefWidth="850.0" xmlns="http://javafx.com/javafx/17" xmlns:fx="http://javafx.com/fxml/1" fx:controller="com.swan.controllers.UserMgtController">
   <children>
      <TableView fx:id="UserTableView" layoutX="25.0" layoutY="176.0" prefHeight="459.0" prefWidth="801.0">
        <columns>
            <TableColumn fx:id="SelectTableColumn" prefWidth="95.0" text="select" />
	        <TableColumn fx:id="IdTableColumn" prefWidth="104.5" text="id" />
	        <TableColumn fx:id="NameTableColumn" prefWidth="218.0" text="name" />
            <TableColumn fx:id="PhoneTableColumn" minWidth="8.0" prefWidth="244.0" text="phone" />
            <TableColumn fx:id="RoleTableColumn" prefWidth="138.5" text="role" />
        </columns>
      </TableView>
      <Label layoutX="26.0" layoutY="14.0" prefHeight="39.0" prefWidth="801.0" text="User Management" textFill="#064090">
         <font>
            <Font size="18.0" />
         </font></Label>
      <HBox layoutX="25.0" layoutY="643.0" prefHeight="49.0" prefWidth="801.0">
         <children>
            <TextField fx:id="NameTextField" prefHeight="49.0" prefWidth="161.0" promptText="name">
               <HBox.margin>
                  <Insets right="5.0" />
               </HBox.margin>
            </TextField>
            <TextField fx:id="PhoneTextField" prefHeight="49.0" prefWidth="161.0" promptText="phone">
               <HBox.margin>
                  <Insets right="5.0" />
               </HBox.margin>
            </TextField>
            <ChoiceBox fx:id="RoleChoiceBox" prefHeight="50.0" prefWidth="150.0">
               <HBox.margin>
                  <Insets right="5.0" />
               </HBox.margin>
            </ChoiceBox>
            <Button fx:id="AddBtn" alignment="CENTER" contentDisplay="CENTER" mnemonicParsing="false" onAction="#onAdd" prefHeight="49.0" prefWidth="109.0" text="Add">
               <HBox.margin>
                  <Insets left="20.0" />
               </HBox.margin>
            </Button>
         </children>
      </HBox>
      <HBox layoutX="25.0" layoutY="118.0" prefHeight="49.0" prefWidth="801.0">
         <children>
            <Button fx:id="DelBtn" alignment="CENTER" mnemonicParsing="false" onAction="#onDelete" prefHeight="49.0" prefWidth="109.0" text="Delete" />
         </children>
      </HBox>
   </children>
</AnchorPane>

```

##### 3.3.2.2 Controller

```java
package com.swan.controllers;

import java.util.List;
import java.util.Optional;

import com.swan.beans.UserBean;
import com.swan.models.UserDao;
import com.swan.utils.CellFactory;

import javafx.beans.property.SimpleBooleanProperty;
import javafx.beans.value.ChangeListener;
import javafx.beans.value.ObservableValue;
import javafx.collections.FXCollections;
import javafx.collections.ObservableList;
import javafx.event.ActionEvent;
import javafx.fxml.FXML;
import javafx.scene.control.Alert;
import javafx.scene.control.Button;
import javafx.scene.control.ButtonType;
import javafx.scene.control.ChoiceBox;
import javafx.scene.control.TableColumn;
import javafx.scene.control.TableView;
import javafx.scene.control.TextField;
import javafx.scene.control.cell.PropertyValueFactory;
import javafx.util.Callback;

/**
 * UserMgtController
 * 
 * @author xyh
 * @param <T>
 * @date 20230426
 *
 */

public class UserMgtController {
	@FXML
	private Button DelBtn;

	@FXML
	private TableView<UserBean> UserTableView;

	@FXML
	private TextField NameTextField;

	@FXML
	private TextField PhoneTextField;

	@FXML
	private ChoiceBox<String> RoleChoiceBox;

	private String[] roles = { "TEACHER", "STUDENT" };

	@FXML
	private TableColumn<UserBean, Boolean> SelectTableColumn;

	@FXML
	private TableColumn<UserBean, Integer> IdTableColumn;

	@FXML
	private TableColumn<UserBean, String> NameTableColumn;

	@FXML
	private TableColumn<UserBean, String> PhoneTableColumn;

	@FXML
	private TableColumn<UserBean, String> RoleTableColumn;

	@FXML
	private TableColumn<UserBean, String> StatusTableColumn;

	private final ObservableList<UserBean> data = FXCollections.observableArrayList();

	private UserDao dao = new UserDao();

	@FXML
	public void onDelete(ActionEvent event) {
		delete();
	}

	@FXML
	public void onAdd(ActionEvent event) {
		if (NameTextField.getText() != null && PhoneTextField.getText() != null) {
			System.out.println(NameTextField.getText());

			String name = NameTextField.getText();
			String phone = PhoneTextField.getText();
			String role = RoleChoiceBox.getValue();
			String status = "ENABLE";

			UserBean row = new UserBean(name, phone, role, status);
			dao.addUser(row);
			if (row.getId() > 0) {
				System.out.println("add user success!");
				data.add(row);
			}

			NameTextField.clear();
			PhoneTextField.clear();
		}
	}

	private boolean delete() {
		int size = data.size();
		if (size <= 0) {
			return false;
		}
		for (int i = size - 1; i >= 0; i--) {
			UserBean row = data.get(i);
			if (row.getSelected()) {
				// cannot delete admin
				if (row.getName().equals("admin")) {
					Alert alert = new Alert(Alert.AlertType.WARNING);
					alert.setContentText("admin can not be delete!");
					alert.show();
				} else {
					// confirm delete
					Alert alert = new Alert(Alert.AlertType.CONFIRMATION);
					alert.setContentText("confirm delete user ?");
					Optional<ButtonType> showAndWait = alert.showAndWait();
					if (showAndWait.get() == ButtonType.OK) {
						data.remove(row);
						if (row.getId() > 0) {
							dao.removeUser(row.getId());
							System.out.println("delete user success!");
						}
					}
				}
			}
		}
		return true;
	}

	@FXML
	private void initialize() {
		// table view
		// set select column ui
		SelectTableColumn
				.setCellFactory(CellFactory.tableCheckBoxColumn(new Callback<Integer, ObservableValue<Boolean>>() {
					@Override
					public ObservableValue<Boolean> call(Integer index) {
						final UserBean row = UserTableView.getItems().get(index);
						ObservableValue<Boolean> ret = new SimpleBooleanProperty(row, "selected", row.getSelected());
						ret.addListener(new ChangeListener<Boolean>() {
							@Override
							public void changed(ObservableValue<? extends Boolean> observable, Boolean oldValue,
									Boolean newValue) {
								row.setSelected(newValue);
							}
						});
						return ret;
					}
				}));

		// set column value
		SelectTableColumn.setCellValueFactory(new PropertyValueFactory<UserBean, Boolean>("selected"));
		IdTableColumn.setCellValueFactory(new PropertyValueFactory<UserBean, Integer>("id"));
		NameTableColumn.setCellValueFactory(new PropertyValueFactory<UserBean, String>("name"));
		PhoneTableColumn.setCellValueFactory(new PropertyValueFactory<UserBean, String>("phone"));
		RoleTableColumn.setCellValueFactory(new PropertyValueFactory<UserBean, String>("role"));

		// set table view
		List<UserBean> list = dao.list();
		System.out.println("list user success!");
		data.addAll(list);

		UserTableView.setItems(data);
		UserTableView.setEditable(true);

		// new row form
		RoleChoiceBox.getItems().addAll(roles);
		RoleChoiceBox.getSelectionModel().select(0);
		RoleChoiceBox.setOnAction(this::getRole);

	}

	public String getRole(ActionEvent event) {
		String role = RoleChoiceBox.getValue();
		return role;
	}

}

```

##### 3.3.2.3 Model

com.swan.models.UserDao

```java
package com.swan.models;

import com.swan.beans.RoleEnum;
import com.swan.beans.StatusEnum;
import com.swan.beans.UserBean;
import com.swan.exceptions.CustomerException;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

public class UserDao {
    /**
     * default password of the system.
     */
    private static final String DEFAULT_PASSWORD = "123456";

    public void addUser(UserBean userBean) {
        try (DBUtil db = new DBUtil()) {
            ResultSet rs = db.preparedStatement("select count(0) from account where name = ?", userBean.getName());
            if (rs.next() && rs.getInt(1) > 0) {
                throw new CustomerException("Account exists.");
            }
            rs = db.preparedStatement("select count(0) from login where login_id = ?", userBean.getName());
            if (rs.next() && rs.getInt(1) > 0) {
                throw new CustomerException("Account exists.");
            }
            db.updateWithMode("insert into account (name,phone,role,status) values (?,?,?,?)", Statement.RETURN_GENERATED_KEYS, userBean.getName(), userBean.getPhone(), RoleEnum.valueOf(userBean.getRole()).getRole(), StatusEnum.ENABLE.getStatus());
            int userId = db.getGeneratedKey();
            db.updateWithMode("insert into login (login_id,password,user_id) values (?,?,?)", Statement.RETURN_GENERATED_KEYS, userBean.getName(), DEFAULT_PASSWORD, userId);
//            userBean.setId(db.getGeneratedKey());
            userBean.setId(userId);
        } catch (SQLException e) {
            throw new CustomerException(e);
        }
    }

    public UserBean getUserById(int userId) {
        try (DBUtil db = new DBUtil()) {
            ResultSet rs = db.preparedStatement("select * from account where id = ?", userId);
            if (rs.next()) {
                return retrieveUser(rs);
            } else {
                throw new CustomerException("User isn't exists.");
            }
        } catch (SQLException e) {
            throw new CustomerException(e);
        }
    }

    public boolean updateStatus(int userId, StatusEnum status) {
        return DBUtil.doSomething(db ->
                db.updateWithoutGeneratedKey("update account set status = ? where id = ?", status.getStatus(), userId) == 1);
    }

    public boolean removeUser(int userId) {
        return DBUtil.doSomething(db -> {
            db.updateWithoutGeneratedKey("delete from login where user_id = ?", userId);
            return db.updateWithoutGeneratedKey("delete from account where id = ?", userId) == 1;
        });
    }

    public List<UserBean> list() {
        List<UserBean> list = new ArrayList<>();
        try (DBUtil db = new DBUtil()) {
            ResultSet rs = db.preparedStatement("select * from account where status = ?", StatusEnum.ENABLE.getStatus());
            while (rs.next()) {
                list.add(retrieveUser(rs));
            }
        } catch (SQLException e) {
            throw new CustomerException(e);
        }
        return list;
    }

    private UserBean retrieveUser(ResultSet rs) throws SQLException {
        UserBean ret = new UserBean();
        ret.setId(rs.getInt("id"));
        ret.setPhone(rs.getString("phone"));
        ret.setName(rs.getString("name"));
        ret.setRole(rs.getInt("role"));
        return ret;
    }
}

```



### 3.4 Season management

#### 3.4.1 GUI

![image-20230502190749436](document/season.png)

#### 3.4.2 Source Code

##### 3.4.2.1 View

com.swan.views.SeasonMgtApplication

```java
package com.swan.views;

import java.io.IOException;

import com.swan.App;

import javafx.application.Application;
import javafx.fxml.FXMLLoader;
import javafx.scene.Scene;
import javafx.scene.layout.Pane;
import javafx.stage.Stage;

/**
 * SeasonMgtApplication
 * @author xyh
 * @param <T>
 * @date 20230426
 *
 */
public class SeasonMgtApplication extends Application{
	
	public void showStage() throws IOException {
		Pane root = FXMLLoader.load(App.class.getResource("SeasonMgt.fxml"));
		Scene scene = new Scene(root);
		Stage stage = new Stage();
		// set title
		stage.setTitle("Class Management System");
		stage.setScene(scene);
		stage.show();
	}

	@Override
	public void start(Stage arg0) throws Exception {
		showStage();
		
	}
	
	 public static void main(String[] args) {
	        launch(args);
	    }

	
}

```

src/main/resources/com/swan/SeasonMgt.fxml

```xml
<?xml version="1.0" encoding="UTF-8"?>

<?import javafx.geometry.Insets?>
<?import javafx.scene.control.Button?>
<?import javafx.scene.control.Label?>
<?import javafx.scene.control.TableColumn?>
<?import javafx.scene.control.TableView?>
<?import javafx.scene.control.TextField?>
<?import javafx.scene.layout.AnchorPane?>
<?import javafx.scene.layout.HBox?>
<?import javafx.scene.text.Font?>

<AnchorPane maxHeight="-Infinity" maxWidth="-Infinity" minHeight="-Infinity" minWidth="-Infinity" prefHeight="742.0" prefWidth="850.0" xmlns="http://javafx.com/javafx/17" xmlns:fx="http://javafx.com/fxml/1" fx:controller="com.swan.controllers.SeasonMgtController">
   <children>
      <TableView fx:id="TableView" layoutX="25.0" layoutY="176.0" prefHeight="459.0" prefWidth="801.0">
        <columns>
            <TableColumn fx:id="SelectTableColumn" prefWidth="123.0" text="select" />
	        <TableColumn fx:id="NameTableColumn" prefWidth="677.0" text="name" />
        </columns>
      </TableView>
      <Label layoutX="26.0" layoutY="14.0" prefHeight="39.0" prefWidth="801.0" text="Season Management" textFill="#064090">
         <font>
            <Font size="18.0" />
         </font></Label>
      <HBox layoutX="25.0" layoutY="643.0" prefHeight="49.0" prefWidth="801.0">
         <children>
            <TextField fx:id="NameTextField" prefHeight="49.0" prefWidth="307.0" promptText="name">
               <HBox.margin>
                  <Insets right="5.0" />
               </HBox.margin>
            </TextField>
            <Button fx:id="AddBtn" alignment="CENTER" contentDisplay="CENTER" mnemonicParsing="false" onAction="#onAdd" prefHeight="49.0" prefWidth="109.0" text="Add">
               <HBox.margin>
                  <Insets left="20.0" />
               </HBox.margin>
            </Button>
         </children>
      </HBox>
      <HBox layoutX="25.0" layoutY="118.0" prefHeight="49.0" prefWidth="801.0">
         <children>
            <Button fx:id="DelBtn" alignment="CENTER" mnemonicParsing="false" onAction="#onDelete" prefHeight="49.0" prefWidth="109.0" text="Delete" />
         </children>
      </HBox>
   </children>
</AnchorPane>

```



##### 3.4.2.2 Controller

com.swan.controllers.SeasonController

```java
package com.swan.controllers;

import com.swan.models.SeasonDao;

public class SeasonController {
    public boolean addSeason(String name){
        SeasonDao seasonDao = new SeasonDao();
        return seasonDao.addSeason(name);
    }

    public boolean removeSeason(String name){
        SeasonDao seasonDao = new SeasonDao();
        return seasonDao.removeSeason(name);
    }


}

```



##### 3.4.2.3 Model

com.swan.models.SeasonDao

```java
package com.swan.models;

import com.swan.beans.SeasonBean;
import com.swan.exceptions.CustomerException;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class SeasonDao {

    public boolean addSeason(String seasonName) {
        return DBUtil.doSomething(db ->
                db.updateWithoutGeneratedKey("insert into season (name) values (?)", seasonName) == 1);
    }

    public boolean removeSeason(String seasonName) {
        return DBUtil.doSomething(db ->
                db.updateWithoutGeneratedKey("delete from season where name = ?", seasonName) == 1);
    }

    public List<SeasonBean> list() {
        try (DBUtil db = new DBUtil()) {
            ResultSet rs = db.preparedStatement("select * from season");
            ArrayList<SeasonBean> ret = new ArrayList<>();
            while (rs.next()) {
                ret.add(getSeason(rs));
            }
            return ret;
        } catch (SQLException e) {
            throw new CustomerException(e);
        }
    }

    public SeasonBean getByName(String seasonName) {
        try (DBUtil db = new DBUtil()) {
            ResultSet rs = db.preparedStatement("select * from season where name = ?", seasonName);
            if (rs.next()) {
                return getSeason(rs);
            } else {
                return null;
            }
        } catch (SQLException e) {
            throw new CustomerException(e);
        }
    }

    public SeasonBean getById(int seasonId) {
        try (DBUtil db = new DBUtil()) {
            ResultSet rs = db.preparedStatement("select * from season where id = ?", seasonId);
            if (rs.next()) {
                return getSeason(rs);
            } else {
                return null;
            }
        } catch (SQLException e) {
            throw new CustomerException(e);
        }
    }

    private SeasonBean getSeason(ResultSet rs) throws SQLException {
        return new SeasonBean().setId(rs.getInt("id")).setName(rs.getString("name"));
    }
}

```



### 3.5 Teacher homepage

#### 3.5.1 GUI
![3.5.1teacher_main](document/3.5.1teacher_main.jpg)

#### 3.5.2 Source Code

##### 3.5.2.1 View

src/main/java/com/swan/views/MainApplication.java

src/main/resources/com/swan/TeacherMain.fxml

```xml
<?xml version="1.0" encoding="UTF-8"?>

<?import javafx.scene.control.Button?>
<?import javafx.scene.control.Hyperlink?>
<?import javafx.scene.control.Label?>
<?import javafx.scene.control.Separator?>
<?import javafx.scene.layout.Pane?>
<?import javafx.scene.text.Font?>

<Pane maxHeight="-Infinity" maxWidth="-Infinity" minHeight="-Infinity" minWidth="-Infinity" prefHeight="400.0" prefWidth="600.0" xmlns="http://javafx.com/javafx/17" xmlns:fx="http://javafx.com/fxml/1" fx:controller="com.swan.controllers.MainController">
   <children>
      <Button fx:id="ClassMgtBtn" layoutX="42.0" layoutY="131.0" mnemonicParsing="false" onAction="#toClassMgt" prefHeight="81.0" prefWidth="239.0" text="Class Mgt">
         <font>
            <Font size="18.0" />
         </font>
      </Button>
      <Label layoutX="31.0" layoutY="29.0" />
      <Label layoutX="31.0" layoutY="29.0" prefHeight="47.0" prefWidth="245.0" text="Welcome Teacher User !" textFill="#064090">
         <font>
            <Font size="14.0" />
         </font>
      </Label>
      <Label contentDisplay="CENTER" layoutX="433.0" layoutY="359.0" prefHeight="37.0" prefWidth="163.0" text="Class Management System" textAlignment="CENTER" textFill="#064090" underline="true">
         <font>
            <Font name="Arial" size="10.0" />
         </font>
      </Label>
      <Separator layoutX="36.0" layoutY="90.0" prefHeight="23.0" prefWidth="548.0" />
      <Label fx:id="UserInfoLabel" alignment="CENTER_RIGHT" contentDisplay="RIGHT" layoutX="379.0" layoutY="58.0" prefHeight="19.0" prefWidth="193.0" text="hi , Richard" textFill="#064090">
         <font>
            <Font size="14.0" />
         </font>
      </Label>
      <Hyperlink alignment="CENTER_RIGHT" layoutX="464.0" layoutY="80.0" onAction="#toChangePwd" prefHeight="21.0" prefWidth="113.0" text="Change Password" />
      <Hyperlink fx:id="logoutHyper" alignment="CENTER_RIGHT" layoutX="334.0" layoutY="81.0" onAction="#toLogout" prefHeight="21.0" prefWidth="121.0" text="Logout" />
      <Separator layoutX="455.0" layoutY="84.0" orientation="VERTICAL" prefHeight="15.0" prefWidth="17.0" />
      <Button fx:id="CourseSchedulingBtn" layoutX="330.0" layoutY="131.0" mnemonicParsing="false" onAction="#toCourseScheduling" prefHeight="81.0" prefWidth="239.0" text="Course Scheduling">
         <font>
            <Font size="18.0" />
         </font>
      </Button>
      <Button fx:id="StudentClassRegBtn" layoutX="42.0" layoutY="250.0" mnemonicParsing="false" onAction="#toStudentClassReg" prefHeight="81.0" prefWidth="528.0" text="Student Class Registration">
         <font>
            <Font size="18.0" />
         </font>
      </Button>
   </children>
</Pane>

```



##### 3.5.2.2 Controller



```java
package com.swan.controllers;

import java.io.IOException;

import com.swan.beans.UserInfo;
import com.swan.views.ClassMgtApplication;
import com.swan.views.ClassRegistrationApplication;
import com.swan.views.CourseSchedulingApplication;
import com.swan.views.LoginApplication;
import com.swan.views.SeasonMgtApplication;
import com.swan.views.UserMgtApplication;
import com.swan.views.StudentClassRegApplication;

import javafx.event.ActionEvent;
import javafx.fxml.FXML;
import javafx.scene.control.Hyperlink;
import javafx.scene.control.Label;
import javafx.stage.Stage;

/**
 * MainController
 * 
 * @author xyh
 * @date 20230426
 *
 */

public class MainController {

	@FXML
	private Label UserInfoLabel;
	
	@FXML
	private Hyperlink logoutHyper;

	@FXML
	public void toUserMgt(ActionEvent event) throws IOException {
		UserMgtApplication app = new UserMgtApplication();
		app.showStage();
	}

	@FXML
	public void toSeasonMgt(ActionEvent event) throws IOException {
		SeasonMgtApplication app = new SeasonMgtApplication();
		app.showStage();
	}

	@FXML
	public void toClassMgt(ActionEvent event) throws IOException {
		ClassMgtApplication app = new ClassMgtApplication();
		app.showStage();
	}

	@FXML
	public void toCourseScheduling(ActionEvent event) throws IOException {
		CourseSchedulingApplication app = new CourseSchedulingApplication();
		app.showStage();
	}
	

	public void toStudentClassReg() throws IOException {
		StudentClassRegApplication app = new StudentClassRegApplication();
		app.showStage();
	}
	
	
	@FXML
	public void toClassRegistration(ActionEvent event) throws IOException {
		ClassRegistrationApplication app = new ClassRegistrationApplication();
		app.showStage();
	}
	
	@FXML
	public void toChangePwd(ActionEvent event) throws IOException {
		LoginApplication app = new LoginApplication();
		app.changePwd();
	}
	
	@FXML
	public void toLogout(ActionEvent event) throws IOException {
		UserInfo.cleanUserSession();
		Stage primaryStage = (Stage) logoutHyper.getScene().getWindow();
		primaryStage.close();
		LoginApplication app = new LoginApplication();
		app.login();
	}

	@FXML
	private void initialize() {
		UserInfoLabel.setText("Hi , " + UserInfo.getLoginUser().getUserName());
	}
}
```



##### 3.5.2.3 Model



### 3.6 Class management

#### 3.6.1 GUI
![3.6.1class_mange.jpg](document/3.6.1class_management.jpg)

#### 3.6.2 Source Code

##### 3.6.2.1 View

com.swan.views.ClassMgtApplication

#### 

```java
package com.swan.views;

import java.io.IOException;

import com.swan.App;

import javafx.application.Application;
import javafx.fxml.FXMLLoader;
import javafx.scene.Scene;
import javafx.scene.layout.Pane;
import javafx.stage.Stage;

/**
 * ClassMgtApplication
 * @author xyh
 * @param <T>
 * @date 20230426
 *
 */
public class ClassMgtApplication extends Application{
	
	public void showStage() throws IOException {
		Pane root = FXMLLoader.load(App.class.getResource("ClassMgt.fxml"));
		Scene scene = new Scene(root);
		Stage stage = new Stage();
		// set title
		stage.setTitle("Class Management System");
		stage.setScene(scene);
		stage.show();
	}

	@Override
	public void start(Stage arg0) throws Exception {
		showStage();
		
	}
	
	 public static void main(String[] args) {
	        launch(args);
	    }

	
}

```

src/main/resources/com/swan/ClassMgt.fxml

```xml
<?xml version="1.0" encoding="UTF-8"?>

<?import javafx.geometry.Insets?>
<?import javafx.scene.control.Button?>
<?import javafx.scene.control.Label?>
<?import javafx.scene.control.TableColumn?>
<?import javafx.scene.control.TableView?>
<?import javafx.scene.control.TextField?>
<?import javafx.scene.layout.AnchorPane?>
<?import javafx.scene.layout.HBox?>
<?import javafx.scene.text.Font?>

<AnchorPane maxHeight="-Infinity" maxWidth="-Infinity" minHeight="-Infinity" minWidth="-Infinity" prefHeight="782.0" prefWidth="1391.0" xmlns="http://javafx.com/javafx/17" xmlns:fx="http://javafx.com/fxml/1" fx:controller="com.swan.controllers.ClassMgtController">
   <children>
      <TableView fx:id="TableView" layoutX="25.0" layoutY="176.0" prefHeight="459.0" prefWidth="1336.0">
        <columns>
            <TableColumn fx:id="SelectTableColumn" prefWidth="50.5" text="select" />
            <TableColumn fx:id="IdTableColumn" prefWidth="44.5" text="id" />
            <TableColumn fx:id="TitleTableColumn" prefWidth="147.5" text="title" />
            <TableColumn fx:id="SubjectTableColumn" minWidth="0.0" prefWidth="172.0" text="subject" />
            <TableColumn fx:id="DescriptionTableColumn" prefWidth="177.5" text="description" />
            <TableColumn fx:id="CourseNoTableColumn" prefWidth="93.0" text="course no" />
            <TableColumn fx:id="SectionTableColumn" prefWidth="56.5" text="section" />
            <TableColumn fx:id="HoursTableColumn" prefWidth="45.0" text="hours" />
            <TableColumn fx:id="CrnTableColumn" prefWidth="44.0" text="crn" />
            <TableColumn fx:id="TermTableColumn" prefWidth="51.5" text="term" />
            <TableColumn fx:id="InstructorTableColumn" prefWidth="78.0" text="instructor" />
            <TableColumn fx:id="SeatsTableColumn" prefWidth="61.5" text="seats" />
            <TableColumn fx:id="TimeFrameTableColumn" prefWidth="103.0" text="time frame" />
            <TableColumn fx:id="CampusTableColumn" prefWidth="104.0" text="campus" />
            <TableColumn fx:id="AttrTableColumn" maxWidth="4968.0" prefWidth="106.5" text="attr" />
        </columns>
      </TableView>
      <Label layoutX="26.0" layoutY="14.0" prefHeight="39.0" prefWidth="801.0" text="Course Scheduling" textFill="#064090">
         <font>
            <Font size="18.0" />
         </font></Label>
      <HBox layoutX="25.0" layoutY="643.0" prefHeight="49.0" prefWidth="1336.0">
         <children>
            <TextField fx:id="TitleTextField" prefHeight="49.0" prefWidth="277.0" promptText="title">
               <HBox.margin>
                  <Insets right="5.0" />
               </HBox.margin>
            </TextField>
            <TextField fx:id="SubjectTextField" prefHeight="49.0" prefWidth="221.0" promptText="subject">
               <HBox.margin>
                  <Insets right="5.0" />
               </HBox.margin>
            </TextField>
            <TextField fx:id="DescriptionTextField" layoutX="123.0" layoutY="10.0" prefHeight="49.0" prefWidth="257.0" promptText="description">
               <HBox.margin>
                  <Insets right="5.0" />
               </HBox.margin>
            </TextField>
            <TextField fx:id="CourseNoTextField" layoutX="413.0" layoutY="10.0" prefHeight="49.0" prefWidth="130.0" promptText="course no">
               <HBox.margin>
                  <Insets right="5.0" />
               </HBox.margin>
            </TextField>
            <TextField fx:id="SectionTextField" layoutX="574.0" layoutY="10.0" prefHeight="49.0" prefWidth="116.0" promptText="section">
               <HBox.margin>
                  <Insets right="5.0" />
               </HBox.margin>
            </TextField>
            <TextField fx:id="HoursTextField" layoutX="665.0" layoutY="10.0" prefHeight="49.0" prefWidth="103.0" promptText="hours">
               <HBox.margin>
                  <Insets right="5.0" />
               </HBox.margin>
            </TextField>
            <TextField fx:id="CrnTextField" layoutX="686.0" layoutY="10.0" prefHeight="49.0" prefWidth="96.0" promptText="crn">
               <HBox.margin>
                  <Insets right="5.0" />
               </HBox.margin>
            </TextField>
            <TextField fx:id="TermTextField" layoutX="701.0" layoutY="10.0" prefHeight="49.0" prefWidth="97.0" promptText="term">
               <HBox.margin>
                  <Insets right="5.0" />
               </HBox.margin>
            </TextField>
            <TextField fx:id="InstructorTextField" layoutX="714.0" layoutY="10.0" prefHeight="49.0" prefWidth="134.0" promptText="instructor">
               <HBox.margin>
                  <Insets right="5.0" />
               </HBox.margin>
            </TextField>
            <TextField fx:id="SeatsTextField" layoutX="723.0" layoutY="10.0" prefHeight="49.0" prefWidth="94.0" promptText="seats">
               <HBox.margin>
                  <Insets right="5.0" />
               </HBox.margin>
            </TextField>
            <TextField fx:id="TimeFrameTextField" layoutX="731.0" layoutY="10.0" prefHeight="49.0" prefWidth="132.0" promptText="time frame">
               <HBox.margin>
                  <Insets right="5.0" />
               </HBox.margin>
            </TextField>
            <TextField fx:id="CampusTextField" layoutX="738.0" layoutY="10.0" prefHeight="57.0" prefWidth="161.0" promptText="campus">
               <HBox.margin>
                  <Insets right="5.0" />
               </HBox.margin>
            </TextField>
            <TextField fx:id="AttrTextField" layoutX="677.0" layoutY="10.0" prefHeight="57.0" prefWidth="161.0" promptText="attr" />
         </children>
      </HBox>
      <HBox layoutX="25.0" layoutY="118.0" prefHeight="49.0" prefWidth="801.0">
         <children>
            <Button fx:id="DelBtn" alignment="CENTER" mnemonicParsing="false" onAction="#onDelete" prefHeight="49.0" prefWidth="109.0" text="Delete" />
         </children>
      </HBox>
      <HBox layoutX="26.0" layoutY="693.0" prefHeight="49.0" prefWidth="1336.0">
         <children>
            <Button fx:id="AddBtn" alignment="CENTER" contentDisplay="CENTER" mnemonicParsing="false" onAction="#onAdd" prefHeight="49.0" prefWidth="109.0" text="Add" />
         </children>
         <padding>
            <Insets top="5.0" />
         </padding>
      </HBox>
   </children>
</AnchorPane>

```



##### 3.6.2.2 Controller

com.swan.controllers.ClassController

```java
package com.swan.controllers;

import com.swan.beans.ClassBase;
import com.swan.beans.SeasonBean;
import com.swan.models.ClassDao;
import com.swan.models.SeasonDao;

public class ClassController {

    public boolean addClass(ClassBase classBase){
        ClassDao classDao = new ClassDao();
        return classDao.addClass(classBase);
    }

    public boolean removeClass(int classId){
        ClassDao classDao = new ClassDao();
        return classDao.removeClass(classId);
    }

    public boolean bindSeason(int classId,int seasonId){
        ClassDao classDao = new ClassDao();
        classDao.unBindSeasonClass(seasonId,classId);
        return true;
    }

    public boolean unbindSeason(int classId,int seasonId){
        ClassDao classDao = new ClassDao();
        classDao.unBindSeasonClass(seasonId,classId);
        return true;
    }

    public boolean unregisterClass(int userId,int seasonClassId){
        ClassDao classDao = new ClassDao();
        classDao.removeRegisterClass(userId,seasonClassId);
        return true;
    }

    public boolean classRegister(int userId,int seasonClassId){
        ClassDao classDao = new ClassDao();
        classDao.registerClass(userId, seasonClassId);
        return true;
    }



}

```



##### 3.6.2.3 Model

com.swan.models.ClassDao

```java
package com.swan.models;

import com.swan.beans.ClassBase;
import com.swan.beans.ClassRegister;
import com.swan.beans.StudentClassReg;
import com.swan.beans.SeasonClass;
import com.swan.exceptions.CustomerException;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

public class ClassDao {

    public boolean addClass(ClassBase classBase) {
        return DBUtil.doSomething(db -> {
            int val = db.updateWithMode("insert into class_base " +
                            "(title, subject, description, course_number, `section`, hours, crn, term, instructor, seats,time_frame, campus, attribute)\n" +
                            "values (?,?,?,?,?,?,?,?,?,?,?,?,?)", Statement.RETURN_GENERATED_KEYS, classBase.getTitle(), classBase.getSubject(), classBase.getDescription(),
                    classBase.getCourseNumber(), classBase.getSection(), classBase.getHours(), classBase.getCrn(),
                    classBase.getTerm(), classBase.getInstructor(), classBase.getSeats(), classBase.getTimeFrame(),
                    classBase.getCampus(), classBase.getAttribute()
            );
            classBase.setId(db.getGeneratedKey());
            return val == 1;
        });
    }

    public void bindSeasonClass(int seasonId, int classId) {
        DBUtil.doSomething(db -> {
            try {
                ResultSet rs = db.preparedStatement("select * from season_class where season_id = ? and class_id = ? ", seasonId, classId);
                if (rs.next())
                    throw new CustomerException("Class had been relate to the season");
                return db.updateWithoutGeneratedKey("insert into season_class (season_id,class_id) values (?,?)", seasonId, classId) == 1;
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        });
    }

    public void unBindSeasonClass(int seasonId, int classId) {
        DBUtil.doSomething(db -> {
            try {
                ResultSet rs = db.preparedStatement("select * from season_class where season_id = ? and class_id = ? ", seasonId, classId);
                if (rs.next()) {
                    return db.updateWithoutGeneratedKey("delete from season_class where id = ?", rs.getInt("id"));
                } else
                    throw new CustomerException("Class isn't bind to the season");
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        });
    }
    
    
    

    public void registerClass(int userId, int seasonClassId) {
        DBUtil.doSomething(db -> {
            try {
                ResultSet rs = db.preparedStatement("select * from class_register where user_id = ? and season_class_id = ? ", userId, seasonClassId);
                if (rs.next())
                    throw new CustomerException("User had registered the class.");
                return db.updateWithoutGeneratedKey("insert into class_register (user_id,season_class_id) values (?,?)", userId, seasonClassId) == 1;
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        });
    }

    public void removeRegisterClass(int userId, int seasonClassId) {
        DBUtil.doSomething(db -> {
            try {
                ResultSet rs = db.preparedStatement("select * from class_register where user_id = ? and season_class_id = ? ", userId, seasonClassId);
                if (rs.next()) {
                    return db.updateWithoutGeneratedKey("delete from class_register where id = ?", rs.getInt("id"));
                } else
                    throw new CustomerException("User haven't register the class.");
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        });
    }

    public boolean removeClass(int id) {
        return DBUtil.doSomething(db -> db.updateWithoutGeneratedKey("delete from class_base where id = ?", id) == 1);
    }

    public List<ClassBase> list() {
        return DBUtil.doSomething(db -> {
            try {
                ResultSet rs = db.preparedStatement("select * from class_base");
                ArrayList<ClassBase> ret = new ArrayList<>();
                while (rs.next()) {
                    ret.add(getClassBase(rs));
                }
                return ret;
            } catch (SQLException e) {
                throw new CustomerException(e);
            }
        });
    }
    
    public List<SeasonClass> listSeasonClass() {
        return DBUtil.doSomething(db -> {
            try {
                ResultSet rs = db.preparedStatement("select sc.id ,s.name,s.id as seasonId,cb.title,cb.id as classId from season_class sc,class_base cb,season s where sc.class_id =cb.id and sc.season_id =s.id ");
                ArrayList<SeasonClass> ret = new ArrayList<>();
                while (rs.next()) {
                    ret.add(getSeasonClass(rs));
                }
                return ret;
            } catch (SQLException e) {
                throw new CustomerException(e);
            }
        });
    }
    
    public List<ClassRegister> listClassRegister(int userId) {
        return DBUtil.doSomething(db -> {
            try {
            	String sql="select cr.id,sc.id as season_class_id,s.name,title, subject, description, course_number, `section`, hours, crn, term, instructor, seats, time_frame, campus, `attribute`,cr.user_id \r\n"
            			+ "from season_class sc \r\n"
            			+ "left join season s on sc.season_id =s.id \r\n"
            			+ "left join class_base cb on sc.class_id =cb.id \r\n"
            			+ "left join class_register cr on sc.id =cr.season_class_id and cr.user_id = ?\r\n"
            			+ "";
                ResultSet rs = db.preparedStatement(sql,userId);
                ArrayList<ClassRegister> ret = new ArrayList<>();
                while (rs.next()) {
                    ret.add(getClassRegister(rs));
                }
                return ret;
            } catch (SQLException e) {
                throw new CustomerException(e);
            }
        });
    }
    
    public List<StudentClassReg> listStudentClassReg() {
        return DBUtil.doSomething(db -> {
            try {
            	String sql="select a.name as user_name ,s.name as season_name ,cb.title as class_title\r\n"
            			+ "from class_register cr \r\n"
            			+ "left join account a on cr.user_id =a.id \r\n"
            			+ "left join season_class sc on cr.season_class_id =sc.id \r\n"
            			+ "left join season s on sc.season_id =s.id \r\n"
            			+ "left join class_base cb on sc.class_id =cb.id ";
                ResultSet rs = db.preparedStatement(sql);
                ArrayList<StudentClassReg> ret = new ArrayList<>();
                while (rs.next()) {
                    ret.add(getStudentClassReg(rs));
                }
                return ret;
            } catch (SQLException e) {
                throw new CustomerException(e);
            }
        });
    }
    

    public List<ClassBase> getByTitle(String classTitle) {
        try (DBUtil db = new DBUtil()) {
            ResultSet rs = db.preparedStatement("select * from class_base where title = ?", classTitle);
            List<ClassBase> ret = new ArrayList<>();
            while (rs.next()) {
                ret.add(getClassBase(rs));
            }
            return ret;
        } catch (SQLException e) {
            throw new CustomerException(e);
        }
    }

    public ClassBase getById(String id) {
        return DBUtil.doSomething(db -> {
            try {
                ResultSet rs = db.preparedStatement("select * from class_base where id = ?", id);
                if (rs.next())
                    return getClassBase(rs);
                else
                    return null;
            } catch (SQLException ex) {
                throw new CustomerException(ex);
            }
        });
    }

    private ClassBase getClassBase(ResultSet rs) {
        try {
            return new ClassBase().setId(rs.getInt("id"))
                    .setTitle(rs.getString("title"))
                    .setSubject(rs.getString("subject"))
                    .setDescription(rs.getString("description"))
                    .setCrn(rs.getInt("crn"))
                    .setCampus(rs.getString("campus"))
                    .setAttribute(rs.getString("attribute"))
                    .setHours(rs.getInt("hours"))
                    .setCourseNumber(rs.getString("course_number"))
                    .setInstructor(rs.getString("instructor"))
                    .setSection(rs.getInt("section"))
                    .setSeats(rs.getInt("seats"))
                    .setTerm(rs.getInt("term"))
                    .setTimeFrame(rs.getString("time_frame"))
                    ;
        } catch (SQLException ex) {
            throw new CustomerException(ex);
        }
    }

    
    private SeasonClass getSeasonClass(ResultSet rs) {
    	 try {
             return new SeasonClass().setId(rs.getInt("id"))
                     .setName(rs.getString("name"))
                     .setTitle(rs.getString("title"))
                     .setSeasonId(rs.getInt("seasonId"))
                     .setClassId(rs.getInt("classId"))
                     ;
         } catch (SQLException ex) {
             throw new CustomerException(ex);
         }
    }
    
    private ClassRegister getClassRegister(ResultSet rs) {
        try {
            return new ClassRegister().setId(rs.getInt("id"))
            		.setSeasonClassId(rs.getInt("season_class_id"))
                    .setName(rs.getString("name"))
                    .setTitle(rs.getString("title"))
                    .setSubject(rs.getString("subject"))
                    .setDescription(rs.getString("description"))
                    .setCrn(rs.getInt("crn"))
                    .setCampus(rs.getString("campus"))
                    .setAttribute(rs.getString("attribute"))
                    .setHours(rs.getInt("hours"))
                    .setCourseNumber(rs.getString("course_number"))
                    .setInstructor(rs.getString("instructor"))
                    .setSection(rs.getInt("section"))
                    .setSeats(rs.getInt("seats"))
                    .setTerm(rs.getInt("term"))
                    .setTimeFrame(rs.getString("time_frame"))
                    .setUserId(rs.getInt("user_id"))
                    .setReg(rs.getInt("user_id")==0?"NO":"YES")
                    ;
        } catch (SQLException ex) {
            throw new CustomerException(ex);
        }
    }
    
    private StudentClassReg getStudentClassReg(ResultSet rs) {
        try {
            return new StudentClassReg().setUserName(rs.getString("user_name"))
                    .setSeasonName(rs.getString("season_name"))
                    .setClassTitle(rs.getString("class_title"))
                    ;
        } catch (SQLException ex) {
            throw new CustomerException(ex);
        }
    }
}

```

### 3.7 Course management

#### 3.7.1 GUI
![3.7.1Course_management.jpg](document/3.7.1Course_management.jpg)

#### 3.7.2 Source Code

##### 3.7.2.1 View

com.swan.views.CourseSchedulingApplication

```java
package com.swan.views;

import java.io.IOException;

import com.swan.App;

import javafx.application.Application;
import javafx.fxml.FXMLLoader;
import javafx.scene.Scene;
import javafx.scene.layout.Pane;
import javafx.stage.Stage;

/**
 * CourseSchedulingApplication
 * @author xyh
 * @param <T>
 * @date 20230426
 *
 */
public class CourseSchedulingApplication extends Application{
	
	public void showStage() throws IOException {
		Pane root = FXMLLoader.load(App.class.getResource("CourseScheduling.fxml"));
		Scene scene = new Scene(root);
		Stage stage = new Stage();
		// set title
		stage.setTitle("Class Management System");
		stage.setScene(scene);
		stage.show();
	}

	@Override
	public void start(Stage arg0) throws Exception {
		showStage();
		
	}
	
	 public static void main(String[] args) {
	        launch(args);
	    }

	
}

```



resources/com/swan/CourseScheduling.fxml

```xml
<?xml version="1.0" encoding="UTF-8"?>

<?import javafx.geometry.Insets?>
<?import javafx.scene.control.Button?>
<?import javafx.scene.control.ChoiceBox?>
<?import javafx.scene.control.Label?>
<?import javafx.scene.control.TableColumn?>
<?import javafx.scene.control.TableView?>
<?import javafx.scene.layout.AnchorPane?>
<?import javafx.scene.layout.HBox?>
<?import javafx.scene.text.Font?>

<AnchorPane maxHeight="-Infinity" maxWidth="-Infinity" minHeight="-Infinity" minWidth="-Infinity" prefHeight="742.0" prefWidth="850.0" xmlns="http://javafx.com/javafx/17" xmlns:fx="http://javafx.com/fxml/1" fx:controller="com.swan.controllers.CourseSchedulingController">
   <children>
      <TableView fx:id="TableView" layoutX="25.0" layoutY="176.0" prefHeight="459.0" prefWidth="801.0">
        <columns>
            <TableColumn fx:id="SelectTableColumn" prefWidth="123.0" text="select" />
	        <TableColumn fx:id="NameTableColumn" prefWidth="274.0" text="name" />
	        <TableColumn fx:id="TitleTableColumn" prefWidth="403.0" text="title" />
        </columns>
      </TableView>
      <Label layoutX="26.0" layoutY="14.0" prefHeight="39.0" prefWidth="801.0" text="Course Scheduling" textFill="#064090">
         <font>
            <Font size="18.0" />
         </font></Label>
      <HBox layoutX="25.0" layoutY="643.0" prefHeight="49.0" prefWidth="801.0">
         <children>
            <ChoiceBox fx:id="SeasonChoiceBox" prefHeight="50.0" prefWidth="150.0">
               <HBox.margin>
                  <Insets right="5.0" />
               </HBox.margin>
            </ChoiceBox>
            <ChoiceBox fx:id="ClassChoiceBox" prefHeight="49.0" prefWidth="150.0">
               <HBox.margin>
                  <Insets right="5.0" />
               </HBox.margin>
            </ChoiceBox>
            <Button fx:id="AddBtn" alignment="CENTER" contentDisplay="CENTER" mnemonicParsing="false" onAction="#onAdd" prefHeight="49.0" prefWidth="109.0" text="Add">
               <HBox.margin>
                  <Insets left="20.0" />
               </HBox.margin>
            </Button>
         </children>
      </HBox>
      <HBox layoutX="25.0" layoutY="118.0" prefHeight="49.0" prefWidth="801.0">
         <children>
            <Button fx:id="DelBtn" alignment="CENTER" mnemonicParsing="false" onAction="#onDelete" prefHeight="49.0" prefWidth="109.0" text="Delete" />
         </children>
      </HBox>
   </children>
</AnchorPane>

```



##### 3.7.2.2 Controller

com.swan.controllers.CourseSchedulingController

```java
package com.swan.controllers;

import java.util.List;
import java.util.Optional;

import com.swan.beans.ClassBase;
import com.swan.beans.SeasonBean;
import com.swan.beans.SeasonClass;
import com.swan.models.ClassDao;
import com.swan.models.SeasonDao;
import com.swan.utils.CellFactory;
import com.swan.utils.ChoiceConvert;

import javafx.beans.property.SimpleBooleanProperty;
import javafx.beans.value.ChangeListener;
import javafx.beans.value.ObservableValue;
import javafx.collections.FXCollections;
import javafx.collections.ObservableList;
import javafx.event.ActionEvent;
import javafx.fxml.FXML;
import javafx.scene.control.Alert;
import javafx.scene.control.Button;
import javafx.scene.control.ButtonType;
import javafx.scene.control.ChoiceBox;
import javafx.scene.control.SingleSelectionModel;
import javafx.scene.control.TableColumn;
import javafx.scene.control.TableView;
import javafx.scene.control.cell.PropertyValueFactory;
import javafx.util.Callback;
import javafx.util.StringConverter;

/**
 * CourseSchedulingController
 * 
 * @author xyh
 * @param <T>
 * @date 20230426
 *
 */

public class CourseSchedulingController {
	@FXML
	private Button DelBtn;

	// add class fields
	@FXML
	private ChoiceBox<ChoiceConvert> SeasonChoiceBox;

	private ObservableList<ChoiceConvert> seasonChoiceList = FXCollections.observableArrayList();

	@FXML
	private ChoiceBox<ChoiceConvert> ClassChoiceBox;

	private ObservableList<ChoiceConvert> classChoiceList = FXCollections.observableArrayList();

	@FXML
	private TableView<SeasonClass> TableView;

	// Table view fields

	@FXML
	private TableColumn<SeasonClass, Boolean> SelectTableColumn;

	@FXML
	private TableColumn<SeasonClass, Integer> IdTableColumn;

	@FXML
	private TableColumn<SeasonClass, String> NameTableColumn;

	@FXML
	private TableColumn<SeasonClass, String> TitleTableColumn;

	private final ObservableList<SeasonClass> data = FXCollections.observableArrayList();

	private ClassDao dao = new ClassDao();

	private SeasonDao daoSeason = new SeasonDao();

	@FXML
	public void onDelete(ActionEvent event) {
		delete();
	}

	@FXML
	public void onAdd(ActionEvent event) {
		ChoiceConvert seasonChoice = SeasonChoiceBox.getValue();
		ChoiceConvert classChoice = ClassChoiceBox.getValue();

		if (seasonChoice.getName() != null && classChoice.getName() != null) {
			System.out.println(seasonChoice.getName() + "----" + seasonChoice.getValue());
			System.out.println(classChoice.getName() + "----" + classChoice.getValue());

			String seasonName = seasonChoice.getName();
			int seasonId = seasonChoice.getValue();

			String classTitle = classChoice.getName();
			int classId = classChoice.getValue();

			SeasonClass row = new SeasonClass();
			row.setName(seasonName);
			row.setTitle(classTitle);
			row.setSeasonId(seasonId);
			row.setClassId(classId);

			dao.bindSeasonClass(seasonId, classId);
			System.out.println("add season-class success!");
			data.add(row);
		}
	}

	private boolean delete() {
		int size = data.size();
		if (size <= 0) {
			return false;
		}
		for (int i = size - 1; i >= 0; i--) {
			SeasonClass row = data.get(i);
			if (row.getSelected()) {
				// confirm delete
				Alert alert = new Alert(Alert.AlertType.CONFIRMATION);
				alert.setContentText("confirm delete season-class ?");
				Optional<ButtonType> showAndWait = alert.showAndWait();
				if (showAndWait.get() == ButtonType.OK) {
					data.remove(row);
					dao.unBindSeasonClass(row.getSeasonId(),row.getClassId());
					System.out.println("delete season-class success!");
				}
			}
		}
		return true;
	}

	@FXML
	private void initialize() {
		// table view
		// set select column ui
		SelectTableColumn
				.setCellFactory(CellFactory.tableCheckBoxColumn(new Callback<Integer, ObservableValue<Boolean>>() {
					@Override
					public ObservableValue<Boolean> call(Integer index) {
						final SeasonClass row = TableView.getItems().get(index);
						ObservableValue<Boolean> ret = new SimpleBooleanProperty(row, "selected", row.getSelected());
						ret.addListener(new ChangeListener<Boolean>() {
							@Override
							public void changed(ObservableValue<? extends Boolean> observable, Boolean oldValue,
									Boolean newValue) {
								row.setSelected(newValue);
							}
						});
						return ret;
					}
				}));

		// set column value
		SelectTableColumn.setCellValueFactory(new PropertyValueFactory<SeasonClass, Boolean>("selected"));
		NameTableColumn.setCellValueFactory(new PropertyValueFactory<SeasonClass, String>("name"));
		TitleTableColumn.setCellValueFactory(new PropertyValueFactory<SeasonClass, String>("title"));

		// set table view
		List<SeasonClass> list = dao.listSeasonClass();
		System.out.println("list season-class success!");
		data.addAll(list);

		TableView.setItems(data);
		TableView.setEditable(true);

		// init choice box
		// init class choice
		List<ClassBase> classList = dao.list();
		for (ClassBase cb : classList) {
			ChoiceConvert ccc = new ChoiceConvert(cb.getTitle(), cb.getId());
			classChoiceList.add(ccc);
		}
		ClassChoiceBox.setItems(classChoiceList);
		ClassChoiceBox.setConverter(new StringConverter<ChoiceConvert>() {
			@Override
			public String toString(ChoiceConvert object) {
				return object.getName();
			}

			@Override
			public ChoiceConvert fromString(String string) {
				System.out.println(string);
				return null;
			}
		});

		ClassChoiceBox.setSelectionModel(new SingleSelectionModel<ChoiceConvert>() {
			@Override
			protected ChoiceConvert getModelItem(int index) {
				System.out.println(index);
				ChoiceConvert choiceConvert = classChoiceList.get(index);
				return choiceConvert;
			}

			@Override
			protected int getItemCount() {
				return classChoiceList.size();
			}
		});

		// init season choice
		List<SeasonBean> seasonList = daoSeason.list();
		for (SeasonBean sb : seasonList) {
			ChoiceConvert scc = new ChoiceConvert(sb.getName(), sb.getId());
			seasonChoiceList.add(scc);
		}
		SeasonChoiceBox.setItems(seasonChoiceList);

		SeasonChoiceBox.setConverter(new StringConverter<ChoiceConvert>() {
			@Override
			public String toString(ChoiceConvert object) {
				return object.getName();
			}

			@Override
			public ChoiceConvert fromString(String string) {
				System.out.println(string);
				return null;
			}
		});

		SeasonChoiceBox.setSelectionModel(new SingleSelectionModel<ChoiceConvert>() {
			@Override
			protected ChoiceConvert getModelItem(int index) {
				System.out.println(index);
				ChoiceConvert choiceConvert = seasonChoiceList.get(index);
				return choiceConvert;
			}

			@Override
			protected int getItemCount() {
				return seasonChoiceList.size();
			}
		});
	}

}

```



##### 3.7.2.3 Model

```java
package com.swan.models;

import com.swan.beans.ClassBase;
import com.swan.beans.ClassRegister;
import com.swan.beans.StudentClassReg;
import com.swan.beans.SeasonClass;
import com.swan.exceptions.CustomerException;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

public class ClassDao {

    public boolean addClass(ClassBase classBase) {
        return DBUtil.doSomething(db -> {
            int val = db.updateWithMode("insert into class_base " +
                            "(title, subject, description, course_number, `section`, hours, crn, term, instructor, seats,time_frame, campus, attribute)\n" +
                            "values (?,?,?,?,?,?,?,?,?,?,?,?,?)", Statement.RETURN_GENERATED_KEYS, classBase.getTitle(), classBase.getSubject(), classBase.getDescription(),
                    classBase.getCourseNumber(), classBase.getSection(), classBase.getHours(), classBase.getCrn(),
                    classBase.getTerm(), classBase.getInstructor(), classBase.getSeats(), classBase.getTimeFrame(),
                    classBase.getCampus(), classBase.getAttribute()
            );
            classBase.setId(db.getGeneratedKey());
            return val == 1;
        });
    }

    public void bindSeasonClass(int seasonId, int classId) {
        DBUtil.doSomething(db -> {
            try {
                ResultSet rs = db.preparedStatement("select * from season_class where season_id = ? and class_id = ? ", seasonId, classId);
                if (rs.next())
                    throw new CustomerException("Class had been relate to the season");
                return db.updateWithoutGeneratedKey("insert into season_class (season_id,class_id) values (?,?)", seasonId, classId) == 1;
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        });
    }

    public void unBindSeasonClass(int seasonId, int classId) {
        DBUtil.doSomething(db -> {
            try {
                ResultSet rs = db.preparedStatement("select * from season_class where season_id = ? and class_id = ? ", seasonId, classId);
                if (rs.next()) {
                    return db.updateWithoutGeneratedKey("delete from season_class where id = ?", rs.getInt("id"));
                } else
                    throw new CustomerException("Class isn't bind to the season");
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        });
    }
    
    
    

    public void registerClass(int userId, int seasonClassId) {
        DBUtil.doSomething(db -> {
            try {
                ResultSet rs = db.preparedStatement("select * from class_register where user_id = ? and season_class_id = ? ", userId, seasonClassId);
                if (rs.next())
                    throw new CustomerException("User had registered the class.");
                return db.updateWithoutGeneratedKey("insert into class_register (user_id,season_class_id) values (?,?)", userId, seasonClassId) == 1;
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        });
    }

    public void removeRegisterClass(int userId, int seasonClassId) {
        DBUtil.doSomething(db -> {
            try {
                ResultSet rs = db.preparedStatement("select * from class_register where user_id = ? and season_class_id = ? ", userId, seasonClassId);
                if (rs.next()) {
                    return db.updateWithoutGeneratedKey("delete from class_register where id = ?", rs.getInt("id"));
                } else
                    throw new CustomerException("User haven't register the class.");
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        });
    }

    public boolean removeClass(int id) {
        return DBUtil.doSomething(db -> db.updateWithoutGeneratedKey("delete from class_base where id = ?", id) == 1);
    }

    public List<ClassBase> list() {
        return DBUtil.doSomething(db -> {
            try {
                ResultSet rs = db.preparedStatement("select * from class_base");
                ArrayList<ClassBase> ret = new ArrayList<>();
                while (rs.next()) {
                    ret.add(getClassBase(rs));
                }
                return ret;
            } catch (SQLException e) {
                throw new CustomerException(e);
            }
        });
    }
    
    public List<SeasonClass> listSeasonClass() {
        return DBUtil.doSomething(db -> {
            try {
                ResultSet rs = db.preparedStatement("select sc.id ,s.name,s.id as seasonId,cb.title,cb.id as classId from season_class sc,class_base cb,season s where sc.class_id =cb.id and sc.season_id =s.id ");
                ArrayList<SeasonClass> ret = new ArrayList<>();
                while (rs.next()) {
                    ret.add(getSeasonClass(rs));
                }
                return ret;
            } catch (SQLException e) {
                throw new CustomerException(e);
            }
        });
    }
    
    public List<ClassRegister> listClassRegister(int userId) {
        return DBUtil.doSomething(db -> {
            try {
            	String sql="select cr.id,sc.id as season_class_id,s.name,title, subject, description, course_number, `section`, hours, crn, term, instructor, seats, time_frame, campus, `attribute`,cr.user_id \r\n"
            			+ "from season_class sc \r\n"
            			+ "left join season s on sc.season_id =s.id \r\n"
            			+ "left join class_base cb on sc.class_id =cb.id \r\n"
            			+ "left join class_register cr on sc.id =cr.season_class_id and cr.user_id = ?\r\n"
            			+ "";
                ResultSet rs = db.preparedStatement(sql,userId);
                ArrayList<ClassRegister> ret = new ArrayList<>();
                while (rs.next()) {
                    ret.add(getClassRegister(rs));
                }
                return ret;
            } catch (SQLException e) {
                throw new CustomerException(e);
            }
        });
    }
    
    public List<StudentClassReg> listStudentClassReg() {
        return DBUtil.doSomething(db -> {
            try {
            	String sql="select a.name as user_name ,s.name as season_name ,cb.title as class_title\r\n"
            			+ "from class_register cr \r\n"
            			+ "left join account a on cr.user_id =a.id \r\n"
            			+ "left join season_class sc on cr.season_class_id =sc.id \r\n"
            			+ "left join season s on sc.season_id =s.id \r\n"
            			+ "left join class_base cb on sc.class_id =cb.id ";
                ResultSet rs = db.preparedStatement(sql);
                ArrayList<StudentClassReg> ret = new ArrayList<>();
                while (rs.next()) {
                    ret.add(getStudentClassReg(rs));
                }
                return ret;
            } catch (SQLException e) {
                throw new CustomerException(e);
            }
        });
    }
    

    public List<ClassBase> getByTitle(String classTitle) {
        try (DBUtil db = new DBUtil()) {
            ResultSet rs = db.preparedStatement("select * from class_base where title = ?", classTitle);
            List<ClassBase> ret = new ArrayList<>();
            while (rs.next()) {
                ret.add(getClassBase(rs));
            }
            return ret;
        } catch (SQLException e) {
            throw new CustomerException(e);
        }
    }

    public ClassBase getById(String id) {
        return DBUtil.doSomething(db -> {
            try {
                ResultSet rs = db.preparedStatement("select * from class_base where id = ?", id);
                if (rs.next())
                    return getClassBase(rs);
                else
                    return null;
            } catch (SQLException ex) {
                throw new CustomerException(ex);
            }
        });
    }

    private ClassBase getClassBase(ResultSet rs) {
        try {
            return new ClassBase().setId(rs.getInt("id"))
                    .setTitle(rs.getString("title"))
                    .setSubject(rs.getString("subject"))
                    .setDescription(rs.getString("description"))
                    .setCrn(rs.getInt("crn"))
                    .setCampus(rs.getString("campus"))
                    .setAttribute(rs.getString("attribute"))
                    .setHours(rs.getInt("hours"))
                    .setCourseNumber(rs.getString("course_number"))
                    .setInstructor(rs.getString("instructor"))
                    .setSection(rs.getInt("section"))
                    .setSeats(rs.getInt("seats"))
                    .setTerm(rs.getInt("term"))
                    .setTimeFrame(rs.getString("time_frame"))
                    ;
        } catch (SQLException ex) {
            throw new CustomerException(ex);
        }
    }

    
    private SeasonClass getSeasonClass(ResultSet rs) {
    	 try {
             return new SeasonClass().setId(rs.getInt("id"))
                     .setName(rs.getString("name"))
                     .setTitle(rs.getString("title"))
                     .setSeasonId(rs.getInt("seasonId"))
                     .setClassId(rs.getInt("classId"))
                     ;
         } catch (SQLException ex) {
             throw new CustomerException(ex);
         }
    }
    
    private ClassRegister getClassRegister(ResultSet rs) {
        try {
            return new ClassRegister().setId(rs.getInt("id"))
            		.setSeasonClassId(rs.getInt("season_class_id"))
                    .setName(rs.getString("name"))
                    .setTitle(rs.getString("title"))
                    .setSubject(rs.getString("subject"))
                    .setDescription(rs.getString("description"))
                    .setCrn(rs.getInt("crn"))
                    .setCampus(rs.getString("campus"))
                    .setAttribute(rs.getString("attribute"))
                    .setHours(rs.getInt("hours"))
                    .setCourseNumber(rs.getString("course_number"))
                    .setInstructor(rs.getString("instructor"))
                    .setSection(rs.getInt("section"))
                    .setSeats(rs.getInt("seats"))
                    .setTerm(rs.getInt("term"))
                    .setTimeFrame(rs.getString("time_frame"))
                    .setUserId(rs.getInt("user_id"))
                    .setReg(rs.getInt("user_id")==0?"NO":"YES")
                    ;
        } catch (SQLException ex) {
            throw new CustomerException(ex);
        }
    }
    
    private StudentClassReg getStudentClassReg(ResultSet rs) {
        try {
            return new StudentClassReg().setUserName(rs.getString("user_name"))
                    .setSeasonName(rs.getString("season_name"))
                    .setClassTitle(rs.getString("class_title"))
                    ;
        } catch (SQLException ex) {
            throw new CustomerException(ex);
        }
    }
}

```



### 3.8 Student Class Registation

#### 3.8.1 GUI
![3.8.1Student_Class_Registation.jpg](document/3.8.1Student_Class_Registation.jpg)

#### 3.8.2 Source Code

##### 3.8.2.1 View

com.swan.views.ClassRegistrationApplication

```java
package com.swan.views;

import java.io.IOException;

import com.swan.App;

import javafx.application.Application;
import javafx.fxml.FXMLLoader;
import javafx.scene.Scene;
import javafx.scene.layout.Pane;
import javafx.stage.Stage;

/**
 * ClassRegistrationApplication
 * @author xyh
 * @param <T>
 * @date 20230426
 *
 */
public class ClassRegistrationApplication extends Application{
	
	public void showStage() throws IOException {
		Pane root = FXMLLoader.load(App.class.getResource("ClassRegistration.fxml"));
		Scene scene = new Scene(root);
		Stage stage = new Stage();
		// set title
		stage.setTitle("Class Management System");
		stage.setScene(scene);
		stage.show();
	}

	@Override
	public void start(Stage arg0) throws Exception {
		showStage();
		
	}
	
	 public static void main(String[] args) {
	        launch(args);
	    }

	
}

```

src/main/resources/com/swan/ClassRegistration.fxml

```xml
<?xml version="1.0" encoding="UTF-8"?>

<?import javafx.geometry.Insets?>
<?import javafx.scene.control.Button?>
<?import javafx.scene.control.Label?>
<?import javafx.scene.control.TableColumn?>
<?import javafx.scene.control.TableView?>
<?import javafx.scene.layout.AnchorPane?>
<?import javafx.scene.layout.HBox?>
<?import javafx.scene.text.Font?>

<AnchorPane maxHeight="-Infinity" maxWidth="-Infinity" minHeight="-Infinity" minWidth="-Infinity" prefHeight="782.0" prefWidth="1490.0" xmlns="http://javafx.com/javafx/17" xmlns:fx="http://javafx.com/fxml/1" fx:controller="com.swan.controllers.ClassRegistrationController">
   <children>
      <TableView fx:id="TableView" layoutX="25.0" layoutY="176.0" prefHeight="459.0" prefWidth="1450.0">
        <columns>
            <TableColumn fx:id="SelectTableColumn" prefWidth="50.5" text="select" />
            <TableColumn fx:id="RegTableColumn" prefWidth="44.5" text="reg" />
            <TableColumn fx:id="NameTableColumn" prefWidth="147.5" text="name" />
            <TableColumn fx:id="TitleTableColumn" prefWidth="147.5" text="title" />
            <TableColumn fx:id="SubjectTableColumn" minWidth="0.0" prefWidth="172.0" text="subject" />
            <TableColumn fx:id="DescriptionTableColumn" prefWidth="177.5" text="description" />
            <TableColumn fx:id="CourseNoTableColumn" prefWidth="93.0" text="course no" />
            <TableColumn fx:id="SectionTableColumn" prefWidth="56.5" text="section" />
            <TableColumn fx:id="HoursTableColumn" prefWidth="45.0" text="hours" />
            <TableColumn fx:id="CrnTableColumn" prefWidth="44.0" text="crn" />
            <TableColumn fx:id="TermTableColumn" prefWidth="51.5" text="term" />
            <TableColumn fx:id="InstructorTableColumn" prefWidth="78.0" text="instructor" />
            <TableColumn fx:id="SeatsTableColumn" prefWidth="61.5" text="seats" />
            <TableColumn fx:id="TimeFrameTableColumn" prefWidth="103.0" text="time frame" />
            <TableColumn fx:id="CampusTableColumn" prefWidth="104.0" text="campus" />
            <TableColumn fx:id="AttrTableColumn" maxWidth="4968.0" prefWidth="69.0" text="attr" />
        </columns>
      </TableView>
      <Label layoutX="26.0" layoutY="14.0" prefHeight="39.0" prefWidth="801.0" text="Class Registration" textFill="#064090">
         <font>
            <Font size="18.0" />
         </font></Label>
      <HBox layoutX="25.0" layoutY="118.0" prefHeight="49.0" prefWidth="801.0">
         <children>
            <Button fx:id="regBtn" alignment="CENTER" mnemonicParsing="false" onAction="#onRegister" prefHeight="49.0" prefWidth="158.0" text="register class">
               <HBox.margin>
                  <Insets right="5.0" />
               </HBox.margin></Button>
            <Button fx:id="removeRegBtn" alignment="CENTER" mnemonicParsing="false" onAction="#onRemoveRegister" prefHeight="49.0" prefWidth="169.0" text="remove register class" />
         </children>
      </HBox>
   </children>
</AnchorPane>

```



##### 3.8.2.2 Controller

com.swan.controllers.ClassRegistrationController

```java
package com.swan.controllers;

import java.util.List;
import java.util.Optional;

import com.swan.beans.ClassRegister;
import com.swan.beans.UserInfo;
import com.swan.models.ClassDao;
import com.swan.utils.CellFactory;

import javafx.beans.property.SimpleBooleanProperty;
import javafx.beans.value.ChangeListener;
import javafx.beans.value.ObservableValue;
import javafx.collections.FXCollections;
import javafx.collections.ObservableList;
import javafx.event.ActionEvent;
import javafx.fxml.FXML;
import javafx.scene.control.Alert;
import javafx.scene.control.Button;
import javafx.scene.control.ButtonType;
import javafx.scene.control.TableColumn;
import javafx.scene.control.TableView;
import javafx.scene.control.cell.PropertyValueFactory;
import javafx.util.Callback;

/**
 * ClassRegistrationController
 * 
 * @author xyh
 * @param <T>
 * @date 20230426
 *
 */

public class ClassRegistrationController {
	@FXML
	private Button DelBtn;

	@FXML
	private TableView<ClassRegister> TableView;
	
	// Table view fields
	@FXML
	private TableColumn<ClassRegister, Boolean> SelectTableColumn;

	@FXML
	private TableColumn<ClassRegister, String> RegTableColumn;
	
	@FXML
	private TableColumn<ClassRegister, String> NameTableColumn;

	@FXML
	private TableColumn<ClassRegister, String> TitleTableColumn;

	@FXML
	private TableColumn<ClassRegister, String> SubjectTableColumn;

	@FXML
	private TableColumn<ClassRegister, String> DescriptionTableColumn;

	@FXML
	private TableColumn<ClassRegister, String> CourseNoTableColumn;

	@FXML
	private TableColumn<ClassRegister, Integer> SectionTableColumn;

	@FXML
	private TableColumn<ClassRegister, Integer> HoursTableColumn;

	@FXML
	private TableColumn<ClassRegister, Integer> CrnTableColumn;

	@FXML
	private TableColumn<ClassRegister, Integer> TermTableColumn;

	@FXML
	private TableColumn<ClassRegister, String> InstructorTableColumn;

	@FXML
	private TableColumn<ClassRegister, Integer> SeatsTableColumn;

	@FXML
	private TableColumn<ClassRegister, String> TimeFrameTableColumn;

	@FXML
	private TableColumn<ClassRegister, String> CampusTableColumn;

	@FXML
	private TableColumn<ClassRegister, String> AttrTableColumn;

	private final ObservableList<ClassRegister> data = FXCollections.observableArrayList();

	private ClassDao dao = new ClassDao();

	@FXML
	public boolean onRegister(ActionEvent event) {
		int size = data.size();
		if (size <= 0) {
			return false;
		}
		for (int i = size - 1; i >= 0; i--) {
			ClassRegister row = data.get(i);
			if (row.getSelected()) {
				Alert alert = new Alert(Alert.AlertType.CONFIRMATION);
				alert.setContentText("confirm  class register ?");
				Optional<ButtonType> showAndWait = alert.showAndWait();
				if (showAndWait.get() == ButtonType.OK) {
					if(row.getReg().equals("NO")) {
						row.setReg("YES");
						data.set(i, row);
						int userId=1;
						if(UserInfo.getLoginUser()!=null) {
							userId=UserInfo.getLoginUser().getUserId();
						}
						dao.registerClass(userId, row.getSeasonClassId());
						System.out.println("add  class register  success!");
					}
				}
			}
		}
		return true;
	}
	

	@FXML
	public boolean onRemoveRegister(ActionEvent event) {
		int size = data.size();
		if (size <= 0) {
			return false;
		}
		for (int i = size - 1; i >= 0; i--) {
			ClassRegister row = data.get(i);
			if (row.getSelected()) {
				Alert alert = new Alert(Alert.AlertType.CONFIRMATION);
				alert.setContentText("confirm remove class register ?");
				Optional<ButtonType> showAndWait = alert.showAndWait();
				if (showAndWait.get() == ButtonType.OK) {
					if(row.getReg().equals("YES")) {
						row.setReg("NO");
						data.set(i, row);
						int userId=1;
						if(UserInfo.getLoginUser()!=null) {
							userId=UserInfo.getLoginUser().getUserId();
						}
						dao.removeRegisterClass(userId,row.getSeasonClassId());
						System.out.println("remove  class register  success!");
					}
				}
			}
		}
		return true;
	}


	@FXML
	private void initialize() {
		// table view
		// set select column ui
		SelectTableColumn
				.setCellFactory(CellFactory.tableCheckBoxColumn(new Callback<Integer, ObservableValue<Boolean>>() {
					@Override
					public ObservableValue<Boolean> call(Integer index) {
						final ClassRegister row = TableView.getItems().get(index);
						ObservableValue<Boolean> ret = new SimpleBooleanProperty(row, "selected", row.getSelected());
						ret.addListener(new ChangeListener<Boolean>() {
							@Override
							public void changed(ObservableValue<? extends Boolean> observable, Boolean oldValue,
									Boolean newValue) {
								row.setSelected(newValue);
							}
						});
						return ret;
					}
				}));

		// set column value
		SelectTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, Boolean>("selected"));
		RegTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, String>("reg"));
		NameTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, String>("name"));
		TitleTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, String>("title"));
		SubjectTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, String>("subject"));
		DescriptionTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, String>("description"));
		CourseNoTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, String>("courseNumber"));
		SectionTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, Integer>("section"));
		HoursTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, Integer>("hours"));
		CrnTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, Integer>("crn"));
		TermTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, Integer>("term"));
		InstructorTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, String>("instructor"));
		SeatsTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, Integer>("seats"));
		TimeFrameTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, String>("timeFrame"));
		CampusTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, String>("campus"));
		AttrTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, String>("attribute"));

		// set table view
		int userId=1;
		if(UserInfo.getLoginUser()!=null) {
			userId=UserInfo.getLoginUser().getUserId();
		}
		System.out.println("userId is"+userId);
		List<ClassRegister> list = dao.listClassRegister(userId);
		System.out.println("list class register success!");
		data.addAll(list);

		TableView.setItems(data);
		TableView.setEditable(true);

	}

}

```



##### 3.8.2.3 Model

com.swan.models.ClassDao

```java
package com.swan.models;

import com.swan.beans.ClassBase;
import com.swan.beans.ClassRegister;
import com.swan.beans.StudentClassReg;
import com.swan.beans.SeasonClass;
import com.swan.exceptions.CustomerException;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

public class ClassDao {

    public boolean addClass(ClassBase classBase) {
        return DBUtil.doSomething(db -> {
            int val = db.updateWithMode("insert into class_base " +
                            "(title, subject, description, course_number, `section`, hours, crn, term, instructor, seats,time_frame, campus, attribute)\n" +
                            "values (?,?,?,?,?,?,?,?,?,?,?,?,?)", Statement.RETURN_GENERATED_KEYS, classBase.getTitle(), classBase.getSubject(), classBase.getDescription(),
                    classBase.getCourseNumber(), classBase.getSection(), classBase.getHours(), classBase.getCrn(),
                    classBase.getTerm(), classBase.getInstructor(), classBase.getSeats(), classBase.getTimeFrame(),
                    classBase.getCampus(), classBase.getAttribute()
            );
            classBase.setId(db.getGeneratedKey());
            return val == 1;
        });
    }

    public void bindSeasonClass(int seasonId, int classId) {
        DBUtil.doSomething(db -> {
            try {
                ResultSet rs = db.preparedStatement("select * from season_class where season_id = ? and class_id = ? ", seasonId, classId);
                if (rs.next())
                    throw new CustomerException("Class had been relate to the season");
                return db.updateWithoutGeneratedKey("insert into season_class (season_id,class_id) values (?,?)", seasonId, classId) == 1;
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        });
    }

    public void unBindSeasonClass(int seasonId, int classId) {
        DBUtil.doSomething(db -> {
            try {
                ResultSet rs = db.preparedStatement("select * from season_class where season_id = ? and class_id = ? ", seasonId, classId);
                if (rs.next()) {
                    return db.updateWithoutGeneratedKey("delete from season_class where id = ?", rs.getInt("id"));
                } else
                    throw new CustomerException("Class isn't bind to the season");
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        });
    }
    
    
    

    public void registerClass(int userId, int seasonClassId) {
        DBUtil.doSomething(db -> {
            try {
                ResultSet rs = db.preparedStatement("select * from class_register where user_id = ? and season_class_id = ? ", userId, seasonClassId);
                if (rs.next())
                    throw new CustomerException("User had registered the class.");
                return db.updateWithoutGeneratedKey("insert into class_register (user_id,season_class_id) values (?,?)", userId, seasonClassId) == 1;
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        });
    }

    public void removeRegisterClass(int userId, int seasonClassId) {
        DBUtil.doSomething(db -> {
            try {
                ResultSet rs = db.preparedStatement("select * from class_register where user_id = ? and season_class_id = ? ", userId, seasonClassId);
                if (rs.next()) {
                    return db.updateWithoutGeneratedKey("delete from class_register where id = ?", rs.getInt("id"));
                } else
                    throw new CustomerException("User haven't register the class.");
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        });
    }

    public boolean removeClass(int id) {
        return DBUtil.doSomething(db -> db.updateWithoutGeneratedKey("delete from class_base where id = ?", id) == 1);
    }

    public List<ClassBase> list() {
        return DBUtil.doSomething(db -> {
            try {
                ResultSet rs = db.preparedStatement("select * from class_base");
                ArrayList<ClassBase> ret = new ArrayList<>();
                while (rs.next()) {
                    ret.add(getClassBase(rs));
                }
                return ret;
            } catch (SQLException e) {
                throw new CustomerException(e);
            }
        });
    }
    
    public List<SeasonClass> listSeasonClass() {
        return DBUtil.doSomething(db -> {
            try {
                ResultSet rs = db.preparedStatement("select sc.id ,s.name,s.id as seasonId,cb.title,cb.id as classId from season_class sc,class_base cb,season s where sc.class_id =cb.id and sc.season_id =s.id ");
                ArrayList<SeasonClass> ret = new ArrayList<>();
                while (rs.next()) {
                    ret.add(getSeasonClass(rs));
                }
                return ret;
            } catch (SQLException e) {
                throw new CustomerException(e);
            }
        });
    }
    
    public List<ClassRegister> listClassRegister(int userId) {
        return DBUtil.doSomething(db -> {
            try {
            	String sql="select cr.id,sc.id as season_class_id,s.name,title, subject, description, course_number, `section`, hours, crn, term, instructor, seats, time_frame, campus, `attribute`,cr.user_id \r\n"
            			+ "from season_class sc \r\n"
            			+ "left join season s on sc.season_id =s.id \r\n"
            			+ "left join class_base cb on sc.class_id =cb.id \r\n"
            			+ "left join class_register cr on sc.id =cr.season_class_id and cr.user_id = ?\r\n"
            			+ "";
                ResultSet rs = db.preparedStatement(sql,userId);
                ArrayList<ClassRegister> ret = new ArrayList<>();
                while (rs.next()) {
                    ret.add(getClassRegister(rs));
                }
                return ret;
            } catch (SQLException e) {
                throw new CustomerException(e);
            }
        });
    }
    
    public List<StudentClassReg> listStudentClassReg() {
        return DBUtil.doSomething(db -> {
            try {
            	String sql="select a.name as user_name ,s.name as season_name ,cb.title as class_title\r\n"
            			+ "from class_register cr \r\n"
            			+ "left join account a on cr.user_id =a.id \r\n"
            			+ "left join season_class sc on cr.season_class_id =sc.id \r\n"
            			+ "left join season s on sc.season_id =s.id \r\n"
            			+ "left join class_base cb on sc.class_id =cb.id ";
                ResultSet rs = db.preparedStatement(sql);
                ArrayList<StudentClassReg> ret = new ArrayList<>();
                while (rs.next()) {
                    ret.add(getStudentClassReg(rs));
                }
                return ret;
            } catch (SQLException e) {
                throw new CustomerException(e);
            }
        });
    }
    

    public List<ClassBase> getByTitle(String classTitle) {
        try (DBUtil db = new DBUtil()) {
            ResultSet rs = db.preparedStatement("select * from class_base where title = ?", classTitle);
            List<ClassBase> ret = new ArrayList<>();
            while (rs.next()) {
                ret.add(getClassBase(rs));
            }
            return ret;
        } catch (SQLException e) {
            throw new CustomerException(e);
        }
    }

    public ClassBase getById(String id) {
        return DBUtil.doSomething(db -> {
            try {
                ResultSet rs = db.preparedStatement("select * from class_base where id = ?", id);
                if (rs.next())
                    return getClassBase(rs);
                else
                    return null;
            } catch (SQLException ex) {
                throw new CustomerException(ex);
            }
        });
    }

    private ClassBase getClassBase(ResultSet rs) {
        try {
            return new ClassBase().setId(rs.getInt("id"))
                    .setTitle(rs.getString("title"))
                    .setSubject(rs.getString("subject"))
                    .setDescription(rs.getString("description"))
                    .setCrn(rs.getInt("crn"))
                    .setCampus(rs.getString("campus"))
                    .setAttribute(rs.getString("attribute"))
                    .setHours(rs.getInt("hours"))
                    .setCourseNumber(rs.getString("course_number"))
                    .setInstructor(rs.getString("instructor"))
                    .setSection(rs.getInt("section"))
                    .setSeats(rs.getInt("seats"))
                    .setTerm(rs.getInt("term"))
                    .setTimeFrame(rs.getString("time_frame"))
                    ;
        } catch (SQLException ex) {
            throw new CustomerException(ex);
        }
    }

    
    private SeasonClass getSeasonClass(ResultSet rs) {
    	 try {
             return new SeasonClass().setId(rs.getInt("id"))
                     .setName(rs.getString("name"))
                     .setTitle(rs.getString("title"))
                     .setSeasonId(rs.getInt("seasonId"))
                     .setClassId(rs.getInt("classId"))
                     ;
         } catch (SQLException ex) {
             throw new CustomerException(ex);
         }
    }
    
    private ClassRegister getClassRegister(ResultSet rs) {
        try {
            return new ClassRegister().setId(rs.getInt("id"))
            		.setSeasonClassId(rs.getInt("season_class_id"))
                    .setName(rs.getString("name"))
                    .setTitle(rs.getString("title"))
                    .setSubject(rs.getString("subject"))
                    .setDescription(rs.getString("description"))
                    .setCrn(rs.getInt("crn"))
                    .setCampus(rs.getString("campus"))
                    .setAttribute(rs.getString("attribute"))
                    .setHours(rs.getInt("hours"))
                    .setCourseNumber(rs.getString("course_number"))
                    .setInstructor(rs.getString("instructor"))
                    .setSection(rs.getInt("section"))
                    .setSeats(rs.getInt("seats"))
                    .setTerm(rs.getInt("term"))
                    .setTimeFrame(rs.getString("time_frame"))
                    .setUserId(rs.getInt("user_id"))
                    .setReg(rs.getInt("user_id")==0?"NO":"YES")
                    ;
        } catch (SQLException ex) {
            throw new CustomerException(ex);
        }
    }
    
    private StudentClassReg getStudentClassReg(ResultSet rs) {
        try {
            return new StudentClassReg().setUserName(rs.getString("user_name"))
                    .setSeasonName(rs.getString("season_name"))
                    .setClassTitle(rs.getString("class_title"))
                    ;
        } catch (SQLException ex) {
            throw new CustomerException(ex);
        }
    }
}

```



### 3.9 Student homepage

#### 3.9.1 GUI
![3.9.1Student_homepage.jpg](document/3.9.1Student_homepage.jpg)

#### 3.9.2 Source Code

##### 3.9.2.1 View

com/swan/views/MainApplication.java

resources/com/swan/StudentMain.fxml

```xml
<?xml version="1.0" encoding="UTF-8"?>

<?import javafx.scene.control.Button?>
<?import javafx.scene.control.Hyperlink?>
<?import javafx.scene.control.Label?>
<?import javafx.scene.control.Separator?>
<?import javafx.scene.layout.Pane?>
<?import javafx.scene.text.Font?>

<Pane maxHeight="-Infinity" maxWidth="-Infinity" minHeight="-Infinity" minWidth="-Infinity" prefHeight="400.0" prefWidth="600.0" xmlns="http://javafx.com/javafx/17" xmlns:fx="http://javafx.com/fxml/1" fx:controller="com.swan.controllers.MainController">
   <children>
      <Button fx:id="ClassRegistrationBtn" layoutX="77.0" layoutY="160.0" mnemonicParsing="false" onAction="#toClassRegistration" prefHeight="81.0" prefWidth="467.0" text="Class Registration">
         <font>
            <Font size="18.0" />
         </font>
      </Button>
      <Label layoutX="31.0" layoutY="29.0" />
      <Label layoutX="31.0" layoutY="29.0" prefHeight="47.0" prefWidth="245.0" text="Welcome Student User !" textFill="#064090">
         <font>
            <Font size="14.0" />
         </font>
      </Label>
      <Label contentDisplay="CENTER" layoutX="433.0" layoutY="359.0" prefHeight="37.0" prefWidth="163.0" text="Class Management System" textAlignment="CENTER" textFill="#064090" underline="true">
         <font>
            <Font name="Arial" size="10.0" />
         </font>
      </Label>
      <Separator layoutX="36.0" layoutY="90.0" prefHeight="23.0" prefWidth="548.0" />
      <Label fx:id="UserInfoLabel" alignment="CENTER_RIGHT" contentDisplay="RIGHT" layoutX="388.0" layoutY="58.0" prefHeight="19.0" prefWidth="193.0" text="hi , Richard" textFill="#064090">
         <font>
            <Font size="14.0" />
         </font>
      </Label>
      <Hyperlink alignment="CENTER_RIGHT" layoutX="472.0" layoutY="80.0" onAction="#toChangePwd" prefHeight="21.0" prefWidth="113.0" text="Change Password" />
      <Hyperlink fx:id="logoutHyper" alignment="CENTER_RIGHT" layoutX="342.0" layoutY="81.0" onAction="#toLogout" prefHeight="21.0" prefWidth="121.0" text="Logout" />
      <Separator layoutX="463.0" layoutY="84.0" orientation="VERTICAL" prefHeight="15.0" prefWidth="17.0" />
   </children>
</Pane>

```



##### 3.9.2.2 Controller

com/swan/controllers/MainController.java

##### 3.9.2.3 Model

NONE

### 3.10 Class registation

#### 3.10.1 GUI
![3.10.1Class_registation.jpg](document/3.10.1Class_registation.jpg)

#### 3.10.2 Source Code

##### 3.10.2.1 View

com.swan.views.ClassRegistrationApplication

```java
package com.swan.views;

import java.io.IOException;

import com.swan.App;

import javafx.application.Application;
import javafx.fxml.FXMLLoader;
import javafx.scene.Scene;
import javafx.scene.layout.Pane;
import javafx.stage.Stage;

/**
 * ClassRegistrationApplication
 * @author xyh
 * @param <T>
 * @date 20230426
 *
 */
public class ClassRegistrationApplication extends Application{
	
	public void showStage() throws IOException {
		Pane root = FXMLLoader.load(App.class.getResource("ClassRegistration.fxml"));
		Scene scene = new Scene(root);
		Stage stage = new Stage();
		// set title
		stage.setTitle("Class Management System");
		stage.setScene(scene);
		stage.show();
	}

	@Override
	public void start(Stage arg0) throws Exception {
		showStage();
		
	}
	
	 public static void main(String[] args) {
	        launch(args);
	    }

	
}

```

com/swan/ClassRegistration.fxml

```xml
<?xml version="1.0" encoding="UTF-8"?>

<?import javafx.geometry.Insets?>
<?import javafx.scene.control.Button?>
<?import javafx.scene.control.Label?>
<?import javafx.scene.control.TableColumn?>
<?import javafx.scene.control.TableView?>
<?import javafx.scene.layout.AnchorPane?>
<?import javafx.scene.layout.HBox?>
<?import javafx.scene.text.Font?>

<AnchorPane maxHeight="-Infinity" maxWidth="-Infinity" minHeight="-Infinity" minWidth="-Infinity" prefHeight="782.0" prefWidth="1490.0" xmlns="http://javafx.com/javafx/17" xmlns:fx="http://javafx.com/fxml/1" fx:controller="com.swan.controllers.ClassRegistrationController">
   <children>
      <TableView fx:id="TableView" layoutX="25.0" layoutY="176.0" prefHeight="459.0" prefWidth="1450.0">
        <columns>
            <TableColumn fx:id="SelectTableColumn" prefWidth="50.5" text="select" />
            <TableColumn fx:id="RegTableColumn" prefWidth="44.5" text="reg" />
            <TableColumn fx:id="NameTableColumn" prefWidth="147.5" text="name" />
            <TableColumn fx:id="TitleTableColumn" prefWidth="147.5" text="title" />
            <TableColumn fx:id="SubjectTableColumn" minWidth="0.0" prefWidth="172.0" text="subject" />
            <TableColumn fx:id="DescriptionTableColumn" prefWidth="177.5" text="description" />
            <TableColumn fx:id="CourseNoTableColumn" prefWidth="93.0" text="course no" />
            <TableColumn fx:id="SectionTableColumn" prefWidth="56.5" text="section" />
            <TableColumn fx:id="HoursTableColumn" prefWidth="45.0" text="hours" />
            <TableColumn fx:id="CrnTableColumn" prefWidth="44.0" text="crn" />
            <TableColumn fx:id="TermTableColumn" prefWidth="51.5" text="term" />
            <TableColumn fx:id="InstructorTableColumn" prefWidth="78.0" text="instructor" />
            <TableColumn fx:id="SeatsTableColumn" prefWidth="61.5" text="seats" />
            <TableColumn fx:id="TimeFrameTableColumn" prefWidth="103.0" text="time frame" />
            <TableColumn fx:id="CampusTableColumn" prefWidth="104.0" text="campus" />
            <TableColumn fx:id="AttrTableColumn" maxWidth="4968.0" prefWidth="69.0" text="attr" />
        </columns>
      </TableView>
      <Label layoutX="26.0" layoutY="14.0" prefHeight="39.0" prefWidth="801.0" text="Class Registration" textFill="#064090">
         <font>
            <Font size="18.0" />
         </font></Label>
      <HBox layoutX="25.0" layoutY="118.0" prefHeight="49.0" prefWidth="801.0">
         <children>
            <Button fx:id="regBtn" alignment="CENTER" mnemonicParsing="false" onAction="#onRegister" prefHeight="49.0" prefWidth="158.0" text="register class">
               <HBox.margin>
                  <Insets right="5.0" />
               </HBox.margin></Button>
            <Button fx:id="removeRegBtn" alignment="CENTER" mnemonicParsing="false" onAction="#onRemoveRegister" prefHeight="49.0" prefWidth="169.0" text="remove register class" />
         </children>
      </HBox>
   </children>
</AnchorPane>

```



##### 3.10.2.2 Controller

com/swan/controllers/ClassRegistrationController.java

```java
package com.swan.controllers;

import java.util.List;
import java.util.Optional;

import com.swan.beans.ClassRegister;
import com.swan.beans.UserInfo;
import com.swan.models.ClassDao;
import com.swan.utils.CellFactory;

import javafx.beans.property.SimpleBooleanProperty;
import javafx.beans.value.ChangeListener;
import javafx.beans.value.ObservableValue;
import javafx.collections.FXCollections;
import javafx.collections.ObservableList;
import javafx.event.ActionEvent;
import javafx.fxml.FXML;
import javafx.scene.control.Alert;
import javafx.scene.control.Button;
import javafx.scene.control.ButtonType;
import javafx.scene.control.TableColumn;
import javafx.scene.control.TableView;
import javafx.scene.control.cell.PropertyValueFactory;
import javafx.util.Callback;

/**
 * ClassRegistrationController
 * 
 * @author xyh
 * @param <T>
 * @date 20230426
 *
 */

public class ClassRegistrationController {
	@FXML
	private Button DelBtn;

	@FXML
	private TableView<ClassRegister> TableView;
	
	// Table view fields
	@FXML
	private TableColumn<ClassRegister, Boolean> SelectTableColumn;

	@FXML
	private TableColumn<ClassRegister, String> RegTableColumn;
	
	@FXML
	private TableColumn<ClassRegister, String> NameTableColumn;

	@FXML
	private TableColumn<ClassRegister, String> TitleTableColumn;

	@FXML
	private TableColumn<ClassRegister, String> SubjectTableColumn;

	@FXML
	private TableColumn<ClassRegister, String> DescriptionTableColumn;

	@FXML
	private TableColumn<ClassRegister, String> CourseNoTableColumn;

	@FXML
	private TableColumn<ClassRegister, Integer> SectionTableColumn;

	@FXML
	private TableColumn<ClassRegister, Integer> HoursTableColumn;

	@FXML
	private TableColumn<ClassRegister, Integer> CrnTableColumn;

	@FXML
	private TableColumn<ClassRegister, Integer> TermTableColumn;

	@FXML
	private TableColumn<ClassRegister, String> InstructorTableColumn;

	@FXML
	private TableColumn<ClassRegister, Integer> SeatsTableColumn;

	@FXML
	private TableColumn<ClassRegister, String> TimeFrameTableColumn;

	@FXML
	private TableColumn<ClassRegister, String> CampusTableColumn;

	@FXML
	private TableColumn<ClassRegister, String> AttrTableColumn;

	private final ObservableList<ClassRegister> data = FXCollections.observableArrayList();

	private ClassDao dao = new ClassDao();

	@FXML
	public boolean onRegister(ActionEvent event) {
		int size = data.size();
		if (size <= 0) {
			return false;
		}
		for (int i = size - 1; i >= 0; i--) {
			ClassRegister row = data.get(i);
			if (row.getSelected()) {
				Alert alert = new Alert(Alert.AlertType.CONFIRMATION);
				alert.setContentText("confirm  class register ?");
				Optional<ButtonType> showAndWait = alert.showAndWait();
				if (showAndWait.get() == ButtonType.OK) {
					if(row.getReg().equals("NO")) {
						row.setReg("YES");
						data.set(i, row);
						int userId=1;
						if(UserInfo.getLoginUser()!=null) {
							userId=UserInfo.getLoginUser().getUserId();
						}
						dao.registerClass(userId, row.getSeasonClassId());
						System.out.println("add  class register  success!");
					}
				}
			}
		}
		return true;
	}
	

	@FXML
	public boolean onRemoveRegister(ActionEvent event) {
		int size = data.size();
		if (size <= 0) {
			return false;
		}
		for (int i = size - 1; i >= 0; i--) {
			ClassRegister row = data.get(i);
			if (row.getSelected()) {
				Alert alert = new Alert(Alert.AlertType.CONFIRMATION);
				alert.setContentText("confirm remove class register ?");
				Optional<ButtonType> showAndWait = alert.showAndWait();
				if (showAndWait.get() == ButtonType.OK) {
					if(row.getReg().equals("YES")) {
						row.setReg("NO");
						data.set(i, row);
						int userId=1;
						if(UserInfo.getLoginUser()!=null) {
							userId=UserInfo.getLoginUser().getUserId();
						}
						dao.removeRegisterClass(userId,row.getSeasonClassId());
						System.out.println("remove  class register  success!");
					}
				}
			}
		}
		return true;
	}


	@FXML
	private void initialize() {
		// table view
		// set select column ui
		SelectTableColumn
				.setCellFactory(CellFactory.tableCheckBoxColumn(new Callback<Integer, ObservableValue<Boolean>>() {
					@Override
					public ObservableValue<Boolean> call(Integer index) {
						final ClassRegister row = TableView.getItems().get(index);
						ObservableValue<Boolean> ret = new SimpleBooleanProperty(row, "selected", row.getSelected());
						ret.addListener(new ChangeListener<Boolean>() {
							@Override
							public void changed(ObservableValue<? extends Boolean> observable, Boolean oldValue,
									Boolean newValue) {
								row.setSelected(newValue);
							}
						});
						return ret;
					}
				}));

		// set column value
		SelectTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, Boolean>("selected"));
		RegTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, String>("reg"));
		NameTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, String>("name"));
		TitleTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, String>("title"));
		SubjectTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, String>("subject"));
		DescriptionTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, String>("description"));
		CourseNoTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, String>("courseNumber"));
		SectionTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, Integer>("section"));
		HoursTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, Integer>("hours"));
		CrnTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, Integer>("crn"));
		TermTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, Integer>("term"));
		InstructorTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, String>("instructor"));
		SeatsTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, Integer>("seats"));
		TimeFrameTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, String>("timeFrame"));
		CampusTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, String>("campus"));
		AttrTableColumn.setCellValueFactory(new PropertyValueFactory<ClassRegister, String>("attribute"));

		// set table view
		int userId=1;
		if(UserInfo.getLoginUser()!=null) {
			userId=UserInfo.getLoginUser().getUserId();
		}
		System.out.println("userId is"+userId);
		List<ClassRegister> list = dao.listClassRegister(userId);
		System.out.println("list class register success!");
		data.addAll(list);

		TableView.setItems(data);
		TableView.setEditable(true);

	}

}

```



##### 3.10.2.3 Model

com/swan/models/ClassDao.java

### 3.11 Change password

#### 3.11.1 GUI
![3.11.1Change_password.jpg](document/3.11.1Change_password.jpg)
#### 3.11.2 Source Code

##### 3.11.2.1 View

com.swan.views.LoginApplication

```java
package com.swan.views;

import java.io.IOException;

import com.swan.App;

import javafx.application.Application;
import javafx.fxml.FXMLLoader;
import javafx.scene.layout.Pane;
import javafx.stage.Stage;
import javafx.scene.Scene;

/**
 * LoginApplication
 * @author xyh
 * @param <T>
 * @date 20230426
 *
 */
public class LoginApplication extends Application{
	
	@Override
    public void start(Stage stage) throws IOException {
		Pane Login = FXMLLoader.load(App.class.getResource("Login.fxml"));
        Scene login = new Scene(Login);
        stage.setTitle("Please Login ");
        stage.setScene(login);
        stage.show();
    }
 
    public static void main(String[] args) {
        launch(args);
    }
    
    public void changePwd() throws IOException {
    	Pane Login = FXMLLoader.load(App.class.getResource("ChangePwd.fxml"));
        Scene login = new Scene(Login);
        Stage stage = new Stage();
        stage.setTitle("Please Change Your Password ");
        stage.setScene(login);
        stage.show();
    }

    
    public void login() throws IOException {
    	Pane Login = FXMLLoader.load(App.class.getResource("Login.fxml"));
        Scene login = new Scene(Login);
        Stage stage = new Stage();
        stage.setTitle("Please Login ");
        stage.setScene(login);
        stage.show();
    }
}

```

resources/com/swan/ChangePwd.fxml

```xml
<?xml version="1.0" encoding="UTF-8"?>

<?import javafx.scene.control.Button?>
<?import javafx.scene.control.Label?>
<?import javafx.scene.control.PasswordField?>
<?import javafx.scene.layout.Pane?>
<?import javafx.scene.text.Font?>

<Pane maxHeight="-Infinity" maxWidth="-Infinity" minHeight="-Infinity" minWidth="-Infinity" prefHeight="400.0" prefWidth="600.0" xmlns="http://javafx.com/javafx/17" xmlns:fx="http://javafx.com/fxml/1" fx:controller="com.swan.controllers.LoginController">
   <children>
      <Label contentDisplay="CENTER" layoutX="186.0" layoutY="47.0" prefHeight="37.0" prefWidth="363.0" text="Change Your Password" textAlignment="CENTER" textFill="#064090">
         <font>
            <Font name="Arial" size="20.0" />
         </font>
      </Label>
      
      <Label fx:id="MessageLabel" layoutX="175.0" layoutY="93.0" prefHeight="46.0" prefWidth="273.0" />
      
      <Label alignment="CENTER_RIGHT" layoutX="106.0" layoutY="160.0" prefHeight="19.0" prefWidth="149.0" text="old password:">
         <font>
            <Font size="14.0" />
         </font>
      </Label>
      <PasswordField fx:id="oldPwdField" layoutX="266.0" layoutY="158.0" />
      
      <Label alignment="CENTER_RIGHT" layoutX="106.0" layoutY="202.0" prefHeight="19.0" prefWidth="149.0" text="new password:">
         <font>
            <Font size="14.0" />
         </font>
      </Label>
      <PasswordField fx:id="newPwdField" layoutX="266.0" layoutY="200.0" />
      
      <Label alignment="CENTER_RIGHT" layoutX="94.0" layoutY="246.0" prefHeight="19.0" prefWidth="161.0" text="new password again:">
         <font>
            <Font size="14.0" />
         </font>
      </Label>
      <PasswordField fx:id="newPwdAgainField" layoutX="266.0" layoutY="244.0" />
      
      <Button fx:id="saveButton" layoutX="255.0" layoutY="310.0" mnemonicParsing="false" onAction="#changePwd" prefHeight="23.0" prefWidth="90.0" text="Save" />
   </children>
</Pane>

```



##### 3.11.2.2 Controller

com.swan.controllers.LoginController

##### 3.11.2.3 Model

com.swan.models.LoginDao

### 3.12 Logout

#### 3.12.1 GUI
![3.12.1Logout.jpg](document/3.12.1Logout.jpg)

#### 3.12.2 Source Code

##### 3.12.2.1 View

src/main/java/com/swan/views/MainApplication.java

src/main/resources/com/swan/AdminMain.fxml

##### 3.12.2.2 Controller

src/main/java/com/swan/controllers/MainController.java

##### 3.12.2.3 Model



## 4. Extra score

### 4.1 excellent GUI

![4.1.1.jpg](document/4.1.1.jpg)

<div style="page-break-after: always;"></div>

### 4.2 Class/User Case/E-R chart images

User Case

![document/user_case.png](document/user_case.png)

E-R

![](document/ER.svg)

<div style="page-break-after: always;"></div>

### 4.3 Database store

phpMyAdmin screenshot
![4.3.1mysqldata.jpg](document/4.3.1mysqldata.jpg)

This project use mysql to save all data.

<div style="page-break-after: always;"></div>

### 4.4 commit and revert

Summary data：

![](document/commit_revert.png)

Commit list

![](document/git_log.png)

### 4.5 password protected
Password store with MD5 mode. The following code used to encrypt password. 
When login and change password, use this function encrypt the string user key in, compare with the value that save in database.

```java
    public static String MD5(String source) {
        try {
            MessageDigest md = MessageDigest.getInstance("MD5");
            md.update(source.getBytes("utf-8"));
            byte[] b = md.digest();
            StringBuffer sb = new StringBuffer();
            for (byte c : b) {
                int val = ((int) c) & 0xff;
                if (val < 16)
                    sb.append("0");
                sb.append(Integer.toHexString(val));
            }
            return sb.toString().toUpperCase();
        } catch (NoSuchAlgorithmException e) {
            e.printStackTrace();
        } catch (UnsupportedEncodingException e) {
            e.printStackTrace();
        }
        return null;
    }
```
### 4.6 Gitee Repository

https://gitee.com/fswan/class-register

### 4.8 Executable jar file

The executable jar file will generate by maven command

```shell
mvn clean package
```



## Appendix 



### requirement

It needs a mysql database first.
Then modify the file db.properties change the connection information used to connect to mysql database.
Run db.sql in the table to init data.

You had install java 11 , git client and [maven](https://maven.apache.org/download.cgi) in your computer

#### maven install

Download [maven](https://maven.apache.org/download.cgi), unzip and set path to the bin folder.

[Install step](https://phoenixnap.com/kb/install-maven-windows)

And test the maven run 

```shell
mvn -version
```

### Run program

```shell
mvn clean javafx:run
```

### Build App

```shell
mvn clean javafx:jlink
cd target/image/bin
./hellofx
```