Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public Component createComponents(){
- Panel pane = new Panel();
- try{
- Connection myConn = DriverManager.getConnection("jdbc:mysql://localhost:3306/tonydb?useSSL=false&useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC","root","1234");
- Statement myStmt = myConn.createStatement();
- ResultSet myRs = myStmt.executeQuery("select * from activeemployees");
- ResultSet myRs2 = null;
- while (myRs.next()) {
- myRs2 = myStmt.executeQuery("SELECT * FROM employee WHERE ID="+myRs.getString("IDnumber"));
- pane.add(new Label(myRs2.getString("firstName")+","+myRs.getString("lastName"),20,20));
- }
- }catch(Exception e){
- JOptionPane.showMessageDialog(null, e.getMessage());
- }
- return pane;
- }
Add Comment
Please, Sign In to add comment