信息与计算科学专业Java所有课上作业

package edu.cgt.java; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import javafx.application.Application; import javafx.geometry.Insets; import javafx.scene.Node; import javafx.scene.Scene; import javafx.scene.control.Button; import javafx.scene.control.Label; import javafx.scene.control.TextField; import javafx.scene.layout.GridPane; import javafx.scene.layout.HBox; import javafx.stage.Stage; public class ResultSetTest extends Application { Connection conn = null; Statement stmt = null; ResultSet rst = null; String sql = "select * from student"; Button first = new Button("第一条"); Button next = new Button("下一条"); Button prior = new Button("前一条"); Button last = new Button("最后一条"); Button insert = new Button("插入"); Button delete = new Button("删除"); Button update = new Button("修改"); TextField sno = new TextField(); TextField sname = new TextField(); TextField sex = new TextField(); TextField age = new TextField(); TextField score = new TextField(); public ResultSetTest() { } public void init() { try { Class.forName("com.mysql.jdbc.Driver"); this.conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/ssm", "root", "root"); this.stmt = this.conn.createStatement(1005, 1008); this.rst = this.stmt.executeQuery(this.sql); this.rst.first(); this.reset(); } catch (ClassNotFoundException var2) { var2.printStackTrace(); } catch (SQLException var3) { var3.printStackTrace(); } } private void reset() { try { this.sno.setText(this.rst.getString(1)); this.sname.setText(this.rst.getString(2)); this.sex.setText(this.rst.getString(3)); this.age.setText(String.valueOf(this.rst.getInt(4))); this.score.setText(String.valueOf(this.rst.getDouble(5))); } catch (SQLException var2) { var2.printStackTrace(); } } public void start(Stage stage) { GridPane rootNode = new GridPane(); rootNode.setHgap(10.0D); rootNode.setVgap(10.0D); rootNode.setPadding(new Insets(10.0D, 10.0D, 10.0D, 10.0D)); rootNode.add(new Label("学号"), 0, 0); rootNode.add(this.sno, 1, 0); rootNode.add(new Label("姓名"), 2, 0); rootNode.add(this.sname, 3, 0); rootNode.add(new Label("性别"), 0, 1); rootNode.add(this.sex, 1, 1); rootNode.add(new Label("年龄"), 2, 1); rootNode.add(this.age, 3, 1); rootNode.add(new Label("成绩"), 0, 2); rootNode.add(this.score, 1, 2); HBox hbox = new HBox(); hbox.setSpacing(10.0D); hbox.getChildren().addAll(new Node[]{this.first, this.prior, this.next, this.last, this.insert, this.delete, this.update}); rootNode.add(hbox, 0, 4, 4, 1); this.first.setOnAction((e) -> { try { this.rst.first(); this.reset(); } catch (Exception var3) { var3.printStackTrace(); } }); this.prior.setOnAction((e) -> { try { this.rst.previous(); this.reset(); } catch (Exception var3) { var3.printStackTrace(); } }); this.next.setOnAction((e) -> { try { this.rst.next(); this.reset(); } catch (Exception var3) { var3.printStackTrace(); } }); this.last.setOnAction((e) -> { try { this.rst.last(); this.reset(); } catch (Exception var3) { var3.printStackTrace(); } }); this.insert.setOnAction((e) -> { try { this.insert(); } catch (Exception var3) { var3.printStackTrace(); } }); this.update.setOnAction((e) -> { try { this.update(); } catch (Exception var3) { var3.printStackTrace(); } }); this.delete.setOnAction((e) -> { try { this.rst.deleteRow(); } catch (Exception var3) { var3.printStackTrace(); } }); Scene scene = new Scene(rootNode, 450.0D, 180.0D); stage.setTitle("访问数据库"); stage.setScene(scene); stage.show(); } private void update() { try { String number = this.sno.getText(); String name = this.sname.getText(); String gender = this.sex.getText(); int sage = Integer.parseInt(this.age.getText()); double grade = Double.parseDouble(this.score.getText()); this.rst.updateString(1, number); this.rst.updateString(2, name); this.rst.updateString(3, gender); this.rst.updateInt(4, sage); this.rst.updateDouble(5, grade); this.rst.updateRow(); } catch (SQLException var7) { var7.printStackTrace(); } } private void insert() { try { String number = this.sno.getText(); String name = this.sname.getText(); String gender = this.sex.getText(); int sage = Integer.parseInt(this.age.getText()); double grade = Double.parseDouble(this.score.getText()); this.rst.moveToInsertRow(); this.rst.updateString(1, number); this.rst.updateString(2, name); this.rst.updateString(3, gender); this.rst.updateInt(4, sage); this.rst.updateDouble(5, grade); this.rst.insertRow(); this.rst.moveToCurrentRow(); } catch (SQLException var7) { var7.printStackTrace(); } } public static void main(String[] args) { Application.launch(args); } }