Advertisement
Guest User

Untitled

a guest
Jul 20th, 2016
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.86 KB | None | 0 0
  1. public class ReaderMainController{
  2. ...//
  3. @Override
  4. public void initialize(URL arg0, ResourceBundle arg1) {
  5.  
  6. //show general login information
  7. try {
  8. try {
  9. showGeneralInfo();
  10. } catch (IOException e) {
  11. // TODO Auto-generated catch block
  12. e.printStackTrace();
  13. }
  14. } catch (SQLException e) {
  15. // TODO Auto-generated catch block
  16. e.printStackTrace();
  17. }
  18.  
  19. //load borrowed book
  20. BorrowedBookData= FXCollections.observableArrayList();
  21. BorrowedBook.BorrowedBookConnection(con.Connector(), BorrowedBookData);
  22. BorrowedBookTable.setItems(BorrowedBookData);
  23. BorrowedBookIDColumn.setCellValueFactory(cellData -> cellData.getValue().BorrowedBookIDProperty());
  24. BorrowedBookNameColumn.setCellValueFactory(cellData -> cellData.getValue().BorrowedBookNameProperty());
  25. BorrowedDateColumn.setCellValueFactory(cellData -> cellData.getValue().BorrowedTimeProperty());
  26. ExpireDateColumn.setCellValueFactory(cellData -> cellData.getValue().ExpireTimeProperty());}
  27.  
  28. //show general information
  29. private void showGeneralInfo() throws SQLException, IOException{
  30. String username= LoginViewController.getUsername();
  31. GeneralReaderUserName.setText(username);
  32. Connection connection= Mysql.Connector();
  33.  
  34. Statement statement= connection.createStatement();
  35. ResultSet rst1= statement.executeQuery("SELECT * FROM library.readerinfo WHERE readerUSERNAME= '"+GeneralReaderUserName.getText()+"'");
  36. while(rst1.next()){
  37. GeneralReaderID.setText(rst1.getString("readerID"));
  38. GeneralReaderName.setText(rst1.getString("readerNAME"));
  39. GeneralReaderAddress.setText(rst1.getString("readerADDRESS"));
  40. GeneralReaderPhoneNumber.setText(rst1.getString("readerPHONENUMBER"));
  41. GeneralReaderEmail.setText(rst1.getString("readerEMAIL"));
  42. ReaderPassword= rst1.getString("readerPASSWORD");
  43. InputStream is= rst1.getBinaryStream("readerIMAGE");
  44. OutputStream os= new FileOutputStream(new File("photo.jpg"));
  45. byte[] content= new byte[1024];
  46. int size=0;
  47. while((size= is.read(content)) != -1){
  48. os.write(content, 0, size);
  49. }
  50. os.close();
  51. is.close();
  52. GeneralImage.setImage(new Image("file:photo.jpg"));
  53. }
  54.  
  55. public Class BorrowedBook{
  56.  
  57. private final StringProperty BorrowedBookID;
  58. private final StringProperty BorrowedBookName;
  59. private final StringProperty BorrowedReaderID;
  60. private final StringProperty BorrowedTime;
  61. private final StringProperty ExpireTime;
  62.  
  63. public BorrowedBook(){
  64. this(null, null, null, null, null);
  65. }
  66.  
  67. public BorrowedBook(String BorrowedBookID, String BorrowedBookName, String BorrowedReaderID, String BorrowedTime, String ExpireTime) {
  68. // TODO Auto-generated constructor stub
  69. this.BorrowedBookID= new SimpleStringProperty(BorrowedBookID);
  70. this.BorrowedBookName= new SimpleStringProperty(BorrowedBookName);
  71. this.BorrowedReaderID= new SimpleStringProperty(BorrowedReaderID);
  72. this.BorrowedTime= new SimpleStringProperty(BorrowedTime);
  73. this.ExpireTime= new SimpleStringProperty(ExpireTime);
  74.  
  75. }
  76.  
  77. ...//some getters and setters
  78.  
  79. //connection to database
  80. public static void BorrowedBookConnection(Connection connection, ObservableList<BorrowedBook>Data){
  81. try {
  82. Statement statement= connection.createStatement();
  83. ResultSet rst= statement.executeQuery("SELECT * FROM library.borrowinfo");
  84. while(rst.next()){
  85. Data.add(new BorrowedBook(
  86. rst.getString("BookID"),
  87. rst.getString("BookName"),
  88. rst.getString("ReaderID"),
  89. rst.getString("BorrowTime"),
  90. rst.getString("ExpireTime")));
  91. }
  92.  
  93. } catch (SQLException e) {
  94. // TODO Auto-generated catch block
  95. e.printStackTrace();
  96. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement