超市后台管理系统(当然,数据库记得自己建)

package Main; import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.FileWriter; import java.io.IOException; import java.io.UnsupportedEncodingException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import javafx.beans.property.SimpleStringProperty; import javafx.collections.FXCollections; import javafx.collections.ObservableList; import javafx.event.ActionEvent; import javafx.geometry.Insets; import javafx.geometry.Pos; import javafx.geometry.Rectangle2D; import javafx.scene.Group; import javafx.scene.Scene; import javafx.scene.control.Button; import javafx.scene.control.Label; import javafx.scene.control.TableCell; import javafx.scene.control.TableColumn; import javafx.scene.control.TableColumn.CellEditEvent; import javafx.scene.control.TableView; import javafx.scene.control.TextField; import javafx.scene.control.cell.PropertyValueFactory; import javafx.scene.image.ImageView; import javafx.scene.layout.HBox; import javafx.scene.layout.VBox; import javafx.scene.paint.Color; import javafx.scene.text.Font; import javafx.scene.text.Text; import javafx.stage.FileChooser; import javafx.stage.Screen; import javafx.stage.Stage; import javafx.util.Callback; public class GoodInfManger { //定义数据模型Data Model private SimpleStringProperty goodNo; private SimpleStringProperty goodClassId; private SimpleStringProperty goodName; private SimpleStringProperty goodUnit; private SimpleStringProperty goodModel; private SimpleStringProperty goodSpecs; private SimpleStringProperty goodPrice; private SimpleStringProperty goodPlace; private SimpleStringProperty goodMemo; private SimpleStringProperty goodAddTime; static int length=10; public GoodInfManger(String goodNo, String goodClassId, String goodName, String goodUnit, String goodModel, String goodSpecs, String goodPrice, String goodPlace, String goodMemo, String goodAddTime) { super(); this.goodNo = new SimpleStringProperty(goodNo); this.goodClassId = new SimpleStringProperty(goodClassId); this.goodName = new SimpleStringProperty(goodName); this.goodUnit = new SimpleStringProperty(goodUnit); this.goodModel = new SimpleStringProperty(goodModel); this.goodSpecs = new SimpleStringProperty(goodSpecs); this.goodPrice = new SimpleStringProperty(goodPrice); this.goodPlace = new SimpleStringProperty(goodPlace); this.goodMemo = new SimpleStringProperty(goodMemo); this.goodAddTime = new SimpleStringProperty(goodAddTime); } public static void goodInfManger(Stage stage) { final TableView<GoodInfManger> table = new TableView<>(); final ObservableList<GoodInfManger> data = FXCollections.observableArrayList(); final Text prompt=new Text(); //提示符 Screen screen = Screen.getPrimary(); Rectangle2D bounds = screen.getVisualBounds(); final Label label = new Label("商品信息表"); label.setFont(new Font("Arial", 20)); table.setEditable(true); table.setPrefHeight(bounds.getHeight()-200); //设置表格高度 Callback<TableColumn<GoodInfManger, String>, //实现失去焦点时提交对内容的编辑 TableCell<GoodInfManger, String>> cellFactory = (TableColumn<GoodInfManger, String> p) -> new EditingCell<GoodInfManger>(); TableColumn<GoodInfManger,String> goodNoCol = new TableColumn<>("商品编号"); goodNoCol.setPrefWidth(100); goodNoCol.setStyle("-fx-alignment: CENTER;"); goodNoCol.setCellValueFactory(new PropertyValueFactory<>("goodNo")); goodNoCol.setEditable(false); //设置商品编号不可编辑 TableColumn<GoodInfManger,String> goodClassIdCol = new TableColumn<>("商品类型"); goodClassIdCol.setPrefWidth(120); goodClassIdCol.setStyle("-fx-alignment: CENTER;"); goodClassIdCol.setCellValueFactory(new PropertyValueFactory<>("goodClassId")); goodClassIdCol.setCellFactory(cellFactory); //实现单元格编辑 goodClassIdCol.setOnEditCommit( (CellEditEvent<GoodInfManger, String> t) -> { ((GoodInfManger) t.getTableView().getItems().get( t.getTablePosition().getRow()) ).setGoodClassId(t.getNewValue()); }); TableColumn<GoodInfManger,String> goodNameCol = new TableColumn<>("商品名称"); goodNameCol.setPrefWidth(250); goodNameCol.setStyle("-fx-alignment: CENTER;"); goodNameCol.setCellValueFactory(new PropertyValueFactory<>("goodName")); goodNameCol.setCellFactory(cellFactory); //实现单元格编辑 goodNameCol.setOnEditCommit( (CellEditEvent<GoodInfManger, String> t) -> { ((GoodInfManger) t.getTableView().getItems().get( t.getTablePosition().getRow()) ).setGoodName(t.getNewValue()); }); TableColumn<GoodInfManger,String> goodUnitCol = new TableColumn<>("商品单位"); goodUnitCol.setPrefWidth(200); goodUnitCol.setStyle("-fx-alignment: CENTER;"); goodUnitCol.setCellValueFactory(new PropertyValueFactory<>("goodUnit")); goodUnitCol.setCellFactory(cellFactory); //实现单元格编辑 goodUnitCol.setOnEditCommit( (CellEditEvent<GoodInfManger, String> t) -> { ((GoodInfManger) t.getTableView().getItems().get( t.getTablePosition().getRow()) ).setGoodUnit(t.getNewValue()); }); TableColumn<GoodInfManger,String> goodModelCol = new TableColumn<>("商品型号"); goodModelCol.setPrefWidth(150); goodModelCol.setStyle("-fx-alignment: CENTER;"); goodModelCol.setCellValueFactory(new PropertyValueFactory<>("goodModel")); goodModelCol.setCellFactory(cellFactory); //实现单元格编辑 goodModelCol.setOnEditCommit( (CellEditEvent<GoodInfManger, String> t) -> { ((GoodInfManger) t.getTableView().getItems().get( t.getTablePosition().getRow()) ).setGoodModel(t.getNewValue()); }); TableColumn<GoodInfManger,String> goodSpecsCol = new TableColumn<>("商品规格"); goodSpecsCol.setPrefWidth(150); goodSpecsCol.setStyle("-fx-alignment: CENTER;"); goodSpecsCol.setCellValueFactory(new PropertyValueFactory<>("goodSpecs")); goodSpecsCol.setCellFactory(cellFactory); //实现单元格编辑 goodSpecsCol.setOnEditCommit( (CellEditEvent<GoodInfManger, String> t) -> { ((GoodInfManger) t.getTableView().getItems().get( t.getTablePosition().getRow()) ).setGoodSpecs(t.getNewValue()); }); TableColumn<GoodInfManger,String> goodPriceCol = new TableColumn<>("商品售价"); goodPriceCol.setPrefWidth(100); goodPriceCol.setStyle("-fx-alignment: CENTER;"); goodPriceCol.setCellValueFactory(new PropertyValueFactory<>("goodPrice")); goodPriceCol.setCellFactory(cellFactory); //实现单元格编辑 goodPriceCol.setOnEditCommit( (CellEditEvent<GoodInfManger, String> t) -> { ((GoodInfManger) t.getTableView().getItems().get( t.getTablePosition().getRow()) ).setGoodPrice(t.getNewValue()); }); TableColumn<GoodInfManger,String> goodPlaceCol = new TableColumn<>("商品产地"); goodPlaceCol.setPrefWidth(350); goodPlaceCol.setStyle("-fx-alignment: CENTER;");