1 packagesample;2
3 importUtil.Constant;4 importUtil.DataBaseUtil;5 importUtil.DateUtils;6 import com.jfoenix.controls.*;7
8 importcom.jfoenix.controls.cells.editors.TextFieldEditorBuilder;9 importcom.jfoenix.controls.cells.editors.base.GenericEditableTreeTableCell;10 importcom.jfoenix.controls.datamodels.treetable.RecursiveTreeObject;11 importcom.jfoenix.validation.RequiredFieldValidator;12
13 importjavafx.beans.binding.Bindings;14 importjavafx.beans.property.SimpleStringProperty;15 importjavafx.beans.property.StringProperty;16 importjavafx.collections.FXCollections;17 importjavafx.collections.ObservableList;18 importjavafx.fxml.FXML;19 importjavafx.fxml.Initializable;20 import javafx.scene.control.*;21
22 importjavafx.scene.control.cell.PropertyValueFactory;23 importjavafx.scene.image.Image;24 importjavafx.scene.image.ImageView;25 importjavafx.scene.input.KeyCode;26 importjavafx.scene.input.KeyEvent;27 importjavafx.scene.layout.AnchorPane;28 import sample.entity.*;29
30 importjava.net.URL;31 importjava.text.SimpleDateFormat;32 importjava.util.ArrayList;33 importjava.util.Date;34 importjava.util.ResourceBundle;35
36 public class MainUiController implementsInitializable {37
38
39 privateMain myApp;40
41 private String myName="";42
43 @FXML44 privateAnchorPane treeview_test;45
46 //所有书目显示列表信息
47 @FXML48 private TableView tbv_book;//数目列表
49 @FXML50 privateTableColumn tb_column_book_id;51 @FXML52 privateTableColumn tb_column_book_name;53 @FXML54 privateTableColumn tb_column_book_type;55 @FXML56 privateTableColumn tb_column_book_author;57 @FXML58 privateTableColumn tb_column_book_translator;59 @FXML60 privateTableColumn tb_column_book_publisher;61 @FXML62 privateTableColumn tb_column_book_publishTime;63 @FXML64 privateTableColumn tb_column_book_price;65
66 //所有读者显示列表信息
67 @FXML68 private TableView tbv_reader;//读者列表
69 @FXML70 privateTableColumn tb_column_reader_id;71 @FXML72 privateTableColumn tb_column_reader_name;73 @FXML74 privateTableColumn tb_column_reader_type;75 @FXML76 privateTableColumn tb_column_reader_sex;77 @FXML78 privateTableColumn tb_column_reader_numbers;79 @FXML80 privateTableColumn tb_column_reader_days;81 @FXML82 privateTableColumn tb_column_reader_forfeit;83 @FXML84 privateTableColumn tb_column_reader_borrowed_books;85
86
87 //所有借阅记录显示列表
88 @FXML89 private TableView tbv_borrow;//借阅列表
90 @FXML91 privateTableColumn tb_column_borrow_id;92 @FXML93 privateTableColumn tb_column_borrow_bookId;94 @FXML95 privateTableColumn tb_column_borrow_readerId;96 @FXML97 privateTableColumn tb_column_borrow_borrowDate;98 @FXML99 privateTableColumn tb_column_borrow_backDate;100 @FXML101 privateTableColumn tb_column_borrow_isBack;102
103
104 //借书---图书信息
105 @FXML106 private JFXTextField tf_js_book_id;//图书编号
107 @FXML108 private JFXTextField tf_js_book_name;//图书名称
109 @FXML110 private JFXTextField tf_js_book_publisher;//出版社
111 @FXML112 private JFXTextField tf_js_book_publish_time;//出版时间113
114 //借书---读者信息
115 @FXML116 private JFXTextField tf_js_reader_id;//读者编号
117 @FXML118 private JFXTextField tf_js_reader_name;//读者名称
119 @FXML120 private JFXTextField tf_js_reader_type;//读者类别
121 @FXML122 private JFXTextField tf_js_reader_sex;//性别123
124 //借书---button
125 @FXML126 private JFXButton btn_jieshu_confirm;//确认按钮
127 @FXML128 private JFXButton btn_jieshu_clear;//清楚按钮129
130 //借书---label---日期
131 @FXML132 private Label lb_js_reader_jieshu_date;//借书时间
133 @FXML134 private Label lb_js_reader_huanshu_date;//还书时间135
136
137 //还书---表格信息
138 @FXML139 privateTableView tbv_huanshu_record;140 @FXML141 privateTableColumn tb_column_huanshu_bookId;142 @FXML143 privateTableColumn tb_column_huanshu_bookName;144 @FXML145 privateTableColumn tb_column_huanshu_borrowDate;146 @FXML147 privateTableColumn tb_column_huanshu_backDate;148
149 //还书----读者信息
150 @FXML151 privateJFXTextField tf_hs_reader_id;152 @FXML153 privateJFXTextField tf_hs_reader_name;154 @FXML155 privateJFXTextField tf_hs_reader_type;156 @FXML157 privateJFXTextField tf_hs_reader_sex;158
159 //还书----图书信息
160 @FXML161 privateJFXTextField tf_hs_book_id;162 @FXML163 privateJFXTextField tf_hs_book_name;164
165
166 //图书维护---添加
167 @FXML168 private JFXTextField tf_ts_add_book_id;//图书编号
169 @FXML170 private JFXTextField tf_ts_add_book_name;//图书名称
171 @FXML172 private JFXComboBox cb_ts_add_book_type;//图书类别
173 @FXML174 private JFXTextField tf_ts_add_book_author;//作者
175 @FXML176 private JFXTextField tf_ts_add_book_translator;//译者
177 @FXML178 private JFXTextField tf_ts_add_book_publisher;//出版社
179 @FXML180 private JFXDatePicker dp_ts_add_book_publish_time;//出版时间
181 @FXML182 private JFXTextField tf_ts_add_book_price;//图书价格
183 @FXML184 private JFXTextField tf_ts_add_book_stock;//库存容量
185
186 @FXML187 private JFXButton btn_ts_add_book_add;//确认添加按钮
188 @FXML189 private JFXButton btn_ts_add_book_clear;//清楚按钮190
191
192 //图书维护----修改
193 @FXML194 private JFXTextField tf_ts_alter_book_search_id;//搜索图书编号
195 @FXML196 private JFXTextField tf_ts_alter_book_id;//图书编号
197 @FXML198 private JFXTextField tf_ts_alter_book_name;//图书名称
199 @FXML200 private JFXComboBox cb_ts_alter_book_type;//图书类别
201 @FXML202 private JFXTextField tf_ts_alter_book_author;//作者
203 @FXML204 private JFXTextField tf_ts_alter_book_translator;//译者
205 @FXML206 private JFXTextField tf_ts_alter_book_publisher;//出版社
207 @FXML208 private JFXDatePicker tp_ts_alter_book_publish_time;//出版时间
209 @FXML210 private JFXTextField tf_ts_alter_book_price;//图书价格
211 @FXML212 private JFXTextField tf_ts_alter_book_stock;//库存容量
213
214 @FXML215 private JFXButton btn_ts_alter_book_alterBtn;//确认修改按钮
216 @FXML217 private JFXButton btn_ts_alter_book_clearBtn;//清楚按钮
218 @FXML219 private JFXButton btn_ts_alter_book_searchBtn;//查询按钮220
221
222 //图书维护----删除
223 @FXML224 private JFXTextField tf_ts_delete_book_search_id;//搜索图书编号
225 @FXML226 private JFXTextField tf_ts_delete_book_id;//图书编号
227 @FXML228 private JFXTextField tf_ts_delete_book_name;//图书名称
229 @FXML230 private JFXComboBox cb_ts_delete_book_type;//图书类别
231 @FXML232 private JFXTextField tf_ts_delete_book_author;//作者
233 @FXML234 private JFXTextField tf_ts_delete_book_translator;//译者
235 @FXML236 private JFXTextField tf_ts_delete_book_publisher;//出版社
237 @FXML238 private JFXTextField tf_ts_delete_book_publish_time;//出版时间
239 @FXML240 private JFXTextField tf_ts_delete_book_price;//图书价格
241 @FXML242 private JFXTextField tf_ts_delete_book_stock;//库存容量
243
244 @FXML245 private JFXButton btn_ts_delete_book_deleteBtn;//确认修改按钮
246 @FXML247 private JFXButton btn_ts_delete_book_clearBtn;//清楚按钮
248 @FXML249 private JFXButton btn_ts_delete_book_searchBtn;//查询按钮250
251
252
253 //读者维护---添加
254 @FXML255 private JFXTextField tf_rd_add_reader_id;//读者编号
256 @FXML257 private JFXTextField tf_rd_add_reader_name;//读者名称
258 @FXML259 private JFXComboBox cb_rd_add_reader_type;//读者类别
260 @FXML261 private JFXComboBox cb_rd_add_reader_sex;//性别
262 @FXML263 private JFXTextField tf_rd_add_reader_numbers;//可借数量
264 @FXML265 private JFXTextField tf_rd_add_reader_days;//可借天数
266
267 @FXML268 private JFXButton btn_rd_add_reader_addBtn;//确认添加按钮
269 @FXML270 private JFXButton btn_rd_add_reader_clearBtn;//清楚按钮271
272
273 //读者维护----修改
274 @FXML275 private JFXTextField tf_rd_alter_reader_search_id;//搜索读者编号
276 @FXML277 private JFXTextField tf_rd_alter_reader_id;//读者编号
278 @FXML279 private JFXTextField tf_rd_alter_reader_name;//读者名称
280 @FXML281 private JFXComboBox cb_rd_alter_reader_type;//读者类别
282 @FXML283 private JFXComboBox cb_rd_alter_reader_sex;//性别
284 @FXML285 private JFXTextField tf_rd_alter_reader_numbers;//可借数量
286 @FXML287 private JFXTextField tf_rd_alter_reader_days;//可借天数
288 @FXML289 private JFXToggleButton tgBtn_rd_alter_reader_password_reset;//初始化密码
290
291 @FXML292 private JFXButton btn_rd_alter_reader_alterBtn;//确认修改按钮
293 @FXML294 private JFXButton btn_rd_alter_reader_clearBtn;//清楚按钮295
296
297 //读者维护----删除
298 @FXML299 private JFXTextField tf_rd_delete_reader_search_id;//搜索读者编号
300 @FXML301 private JFXTextField tf_rd_delete_reader_id;//读者编号
302 @FXML303 private JFXTextField tf_rd_delete_reader_name;//读者名称
304 @FXML305 private JFXComboBox cb_rd_del