Guest User

Untitled

a guest
Apr 30th, 2018
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. public Component createComponents(){
  2. Panel pane = new Panel();
  3. try{
  4. Connection myConn = DriverManager.getConnection("jdbc:mysql://localhost:3306/tonydb?useSSL=false&useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC","root","1234");
  5. Statement myStmt = myConn.createStatement();
  6. ResultSet myRs = myStmt.executeQuery("select * from activeemployees");
  7. ResultSet myRs2 = null;
  8. while (myRs.next()) {
  9. myRs2 = myStmt.executeQuery("SELECT * FROM employee WHERE ID="+myRs.getString("IDnumber"));
  10. pane.add(new Label(myRs2.getString("firstName")+","+myRs.getString("lastName"),20,20));
  11. }
  12. }catch(Exception e){
  13. JOptionPane.showMessageDialog(null, e.getMessage());
  14. }
  15. return pane;
  16. }
Add Comment
Please, Sign In to add comment