Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class ReaderMainController{
- ...//
- @Override
- public void initialize(URL arg0, ResourceBundle arg1) {
- //show general login information
- try {
- try {
- showGeneralInfo();
- } catch (IOException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- //load borrowed book
- BorrowedBookData= FXCollections.observableArrayList();
- BorrowedBook.BorrowedBookConnection(con.Connector(), BorrowedBookData);
- BorrowedBookTable.setItems(BorrowedBookData);
- BorrowedBookIDColumn.setCellValueFactory(cellData -> cellData.getValue().BorrowedBookIDProperty());
- BorrowedBookNameColumn.setCellValueFactory(cellData -> cellData.getValue().BorrowedBookNameProperty());
- BorrowedDateColumn.setCellValueFactory(cellData -> cellData.getValue().BorrowedTimeProperty());
- ExpireDateColumn.setCellValueFactory(cellData -> cellData.getValue().ExpireTimeProperty());}
- //show general information
- private void showGeneralInfo() throws SQLException, IOException{
- String username= LoginViewController.getUsername();
- GeneralReaderUserName.setText(username);
- Connection connection= Mysql.Connector();
- Statement statement= connection.createStatement();
- ResultSet rst1= statement.executeQuery("SELECT * FROM library.readerinfo WHERE readerUSERNAME= '"+GeneralReaderUserName.getText()+"'");
- while(rst1.next()){
- GeneralReaderID.setText(rst1.getString("readerID"));
- GeneralReaderName.setText(rst1.getString("readerNAME"));
- GeneralReaderAddress.setText(rst1.getString("readerADDRESS"));
- GeneralReaderPhoneNumber.setText(rst1.getString("readerPHONENUMBER"));
- GeneralReaderEmail.setText(rst1.getString("readerEMAIL"));
- ReaderPassword= rst1.getString("readerPASSWORD");
- InputStream is= rst1.getBinaryStream("readerIMAGE");
- OutputStream os= new FileOutputStream(new File("photo.jpg"));
- byte[] content= new byte[1024];
- int size=0;
- while((size= is.read(content)) != -1){
- os.write(content, 0, size);
- }
- os.close();
- is.close();
- GeneralImage.setImage(new Image("file:photo.jpg"));
- }
- public Class BorrowedBook{
- private final StringProperty BorrowedBookID;
- private final StringProperty BorrowedBookName;
- private final StringProperty BorrowedReaderID;
- private final StringProperty BorrowedTime;
- private final StringProperty ExpireTime;
- public BorrowedBook(){
- this(null, null, null, null, null);
- }
- public BorrowedBook(String BorrowedBookID, String BorrowedBookName, String BorrowedReaderID, String BorrowedTime, String ExpireTime) {
- // TODO Auto-generated constructor stub
- this.BorrowedBookID= new SimpleStringProperty(BorrowedBookID);
- this.BorrowedBookName= new SimpleStringProperty(BorrowedBookName);
- this.BorrowedReaderID= new SimpleStringProperty(BorrowedReaderID);
- this.BorrowedTime= new SimpleStringProperty(BorrowedTime);
- this.ExpireTime= new SimpleStringProperty(ExpireTime);
- }
- ...//some getters and setters
- //connection to database
- public static void BorrowedBookConnection(Connection connection, ObservableList<BorrowedBook>Data){
- try {
- Statement statement= connection.createStatement();
- ResultSet rst= statement.executeQuery("SELECT * FROM library.borrowinfo");
- while(rst.next()){
- Data.add(new BorrowedBook(
- rst.getString("BookID"),
- rst.getString("BookName"),
- rst.getString("ReaderID"),
- rst.getString("BorrowTime"),
- rst.getString("ExpireTime")));
- }
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement