java课程设计-员工工资管理系统-IDEA+MySQL数据库-javafx前端

package com.example.salarysystem; import bean.Employee; import bean.Manager; import bean.User; import dao.EmpDao; import dao.ManagerDao; import dao.UserDao; import javafx.application.Application; import javafx.event.ActionEvent; import javafx.event.EventHandler; import javafx.geometry.Insets; import javafx.scene.Scene; import javafx.scene.control.*; import javafx.scene.image.Image; import javafx.scene.image.ImageView; import javafx.scene.layout.GridPane; import javafx.scene.layout.StackPane; import javafx.scene.layout.VBox; import javafx.scene.paint.Color; import javafx.scene.text.Font; import javafx.scene.text.FontPosture; import javafx.scene.text.FontWeight; import javafx.stage.Stage; import util.DBManager; import java.net.PasswordAuthentication; import java.sql.*; import java.time.LocalDate; import java.time.format.DateTimeFormatter; import java.time.format.DateTimeParseException; import java.util.List; public class Login extends Application { static Connection conn = null; static PreparedStatement ps = null; static ResultSet rs = null; public EmpDao empDao = new EmpDao(); public ManagerDao managerDao = new ManagerDao(); public UserDao userDao = new UserDao(); public Alert alert = new Alert(Alert.AlertType.INFORMATION); String contentText = ""; Stage stage = new Stage(); //主界面 GridPane mainPane = new GridPane(); Scene mainScene = new Scene(mainPane, 600, 500); //管理员界面 GridPane managerPane = new GridPane(); Scene managerScene = new Scene(managerPane, 600, 500); //管理员修改密码界面 GridPane managerModifyPwPane = new GridPane(); Scene managerModifyPwScene = new Scene(managerModifyPwPane, 600, 500); //菜单界面 GridPane employeeMenuPane = new GridPane(); Scene employeeMenuScene = new Scene(employeeMenuPane, 600, 500); //添加人员信息 GridPane addPane = new GridPane(); Scene addScene = new Scene(addPane, 600, 500); DatePicker datePicker = new DatePicker(); //修改人员信息 GridPane prePane = new GridPane(); Scene preScene = new Scene(prePane,600,500); GridPane modifyPane = new GridPane(); Scene modifyScene = new Scene(modifyPane, 600, 500); //删除人员信息 GridPane deletePane = new GridPane(); Scene deleteScene = new Scene(deletePane, 600, 500); //搜索人员信息 GridPane preSearchPane = new GridPane(); Scene preSearchScene = new Scene(preSearchPane,600,500); GridPane searchPane = new GridPane(); Scene searchScene = new Scene(searchPane, 600, 500); //员工登陆界面 GridPane userPane = new GridPane(); Scene userScene = new Scene(userPane, 600, 500); //员工更改密码界面 GridPane userModifyPwPane = new GridPane(); Scene userModifyPwScene = new Scene(userModifyPwPane, 600, 500); //显示员工个人信息界面 GridPane personalInfoPane = new GridPane(); Scene personalInfoScene = new Scene(personalInfoPane, 600, 500); StackPane root = new StackPane(); @Override public void start(Stage stage) throws Exception { choose(); managerLogin(); // managerModifyPw(); userLogin(); userModifyPw(); menu(); addEmployee(); preModifyEmployee(); modifyEmployee(); deleteEmployee(); preSearchEmployee(); stage.setScene(mainScene); stage.setTitle("员工工资管理系统"); stage.setResizable(false); stage.show(); } //选择角色 void choose(){ Label title = new Label("欢迎进入系统"); title.setFont(Font.font("T", FontWeight.LIGHT, FontPosture.ITALIC, 30)); Label warn = new Label("账号或密码错误"); warn.setTextFill(Color.RED); warn.setVisible(false); warn.setFont(Font.font("T", FontPosture.ITALIC, 20)); Button managerButton = new Button("管理员"); managerButton.setTranslateX(100); managerButton.setTranslateY(320); Button userButton = new Button("员工"); userButton.setTranslateX(320); userButton.setTranslateY(320); mainPane.setHgap(20); mainPane.setVgap(20); mainPane.setPadding(new Insets(0, 10, 10, 30)); mainPane.add(title,4,3); mainPane.add(warn,4,6); mainPane.getChildren().addAll(managerButton,userButton); mainPane.setStyle("-fx-background-image: url(" + "file:src/image/mist.jpg" + "); " + "-fx-background-position: center center; " + "-fx-background-repeat: stretch;" + "-fx-background-color: transparent;" + "-fx-background-size: 850px;"); managerButton.setOnAction(new EventHandler<ActionEvent>() { @Override public void handle(ActionEvent event) { stage.setScene(managerScene); stage.show(); } }); userButton.setOnAction(new EventHandler<ActionEvent>() { @Override public void handle(ActionEvent event) { stage.setScene(userScene); stage.show(); } }); } //管理员登录 默认密码1234 void managerLogin(){ Label title = new Label("欢迎管理员进入"); Label manId = new Label("账号"); manId.setFont(Font.font("T",FontWeight.LIGHT, FontPosture.ITALIC, 15)); Label password = new Label("密码："); password.setFont(Font.font("T",FontWeight.LIGHT, FontPosture.ITALIC, 15)); title.setFont(Font.font("T", FontWeight.LIGHT, FontPosture.ITALIC, 20)); Label warn = new Label("密码错误！"); warn.setTextFill(Color.RED); warn.setVisible(false); warn.setFont(Font.font("T", FontPosture.ITALIC, 20)); TextField id = new TextField(); PasswordField pw = new PasswordField(); Button ok = new Button("确认"); ok.setTranslateX(100); ok.setTranslateY(320); Button change = new Button("更改密码"); change.setTranslateX(320); change.setTranslateY(320); Button back = new Button("返回"); back.setTranslateX(210); back.setTranslateY(320); managerPane.setHgap(20); managerPane.setVgap(20); managerPane.setPadding(new Insets(20,10,10,100)); managerPane.add(title,1,0); managerPane.add(manId,1,3); managerPane.add(id,2,3); managerPane.add(password, 1, 4); managerPane.add(pw,2,4); managerPane.add(warn, 4, 6); managerPane.getChildren().addAll(ok, change,back); managerPane.setStyle("-fx-background-image: url(" + "file:src/image/mist.jpg" + "); " + "-fx-background-position: center center; " + "-fx-background-repeat: stretch;" + "-fx-background-color: transparent;" + "-fx-background-size: 850px;"); //管理员登录确认 ok.setOnAction(new EventHandler<ActionEvent>() { @Override public void handle(ActionEvent event) { String manId_1 = id.getText(); String password = pw.getText(); Manager manager = managerDao.findByManAndPassword(manId_1,password); if (manager != null){ stage.setScene(employeeMenuScene); stage.setTitle("员工工资管理系统"); }else{ contentText = "账号或密码错误！"; alert.setContentText(contentText); alert.show(); } } }); //更改密码事件 change.setOnAction(new EventHandler<ActionEvent>() { @Override