Sino maka help sakin nito... mali sgro query ko... help naman oh... public static void listbook(){ Connection conn = null; try{ String userName = "root"; String password = ""; String url = "jdbc:mysql://localhost/librarysystem"; Class.forName ("com.mysql.jdbc.Driver").newInstance (); conn = DriverManager.getConnection (url, userName, password); Statement se = conn.createStatement (); se.executeQuery ("SELECT book.Book_id, book.Book_isbn, book.Book_title, book.Book_author, book.Book_available,book.Book_description,book.Book_type,subject.Subject_name from book FULL OUTER JOIN subject ON book.Subject_Subject_id=subject.Subject_id"); ResultSet rs = se.getResultSet (); DefaultTableModel Book=new DefaultTableModel(); tlistbook=new JTable(Book); Book.addColumn("Book ID"); Book.addColumn("ISBN"); Book.addColumn("Title"); Book.addColumn("Author"); Book.addColumn("Copy Number"); Book.addColumn("Description"); Book.addColumn("Type"); Book.addColumn("Subject"); String bid,isbn,title,author,copy,desc,type,subject; while (rs.next ()) { bid=rs.getString(1); isbn=rs.getString(2); title=rs.getString(3); author=rs.getString(4); copy=rs.getString(5); desc=rs.getString(6); type=rs.getString(7); subject=rs.getString(8); Book.addRow(new Object[]{bid,isbn,title,author,copy,desc,type,subject}); } Book.addRow(new String[]{}); tlistbook.setColumnSelectionAllowed(false); //tliststudent.editingStopped(null); tlistbook.setRowSelectionAllowed(false); tlistbook.setCellSelectionEnabled(false); //tliststudent.setBounds(400, 50,300,150); scrollbook=new JScrollPane(tlistbook); scrollbook.setVisible(true); scrollbook.setBounds(350,50,600,250); // tliststudent.setPreferredScrollableViewportSize(new Dimension(500,150)); paddbook.add(scrollbook); } catch(Exception e){ } }
Posted on: Tue, 08 Oct 2013 10:46:26 +0000
Trending Topics
Recently Viewed Topics
© 2015