Advertisement
Guest User

Untitled

a guest
Mar 3rd, 2019
126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.22 KB | None | 0 0
  1. JFrame f8 = new JFrame("Schedule");
  2. f8.setVisible(true);
  3. f8.setSize(1000, 1000);
  4. JPanel jpa1 = new JPanel(new GridBagLayout());
  5.  
  6. String query = "SELECT * FROM Location";
  7. DefaultListModel model = new DefaultListModel();
  8. DefaultListModel model1 = new DefaultListModel();
  9. try {
  10. Class.forName("oracle.jdbc.driver.OracleDriver");
  11. Statement stmt = null;
  12. ResultSet rs;
  13. Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1/SPL", "root", "PWD");
  14. stmt = (Statement) conn.createStatement();
  15. rs = stmt.executeQuery(query);
  16. while (rs.next()) {
  17. String stadium = rs.getString("Stadium");
  18. String city = rs.getString("City");
  19. model.addElement(stadium);
  20. model1.addElement(city);
  21. }
  22. JList list = new JList(model);
  23. JList list1 = new JList(model1);
  24. f8.add(jpa1);
  25. jpa1.add(list);
  26. list.setSelectionMode(ListSelectionModel.SINGLE_INTERVAL_SELECTION);
  27. list.setLayoutOrientation(JList.HORIZONTAL_WRAP);
  28. list.setVisibleRowCount(1);
  29. JScrollPane listScroller = new JScrollPane(list);
  30. } catch (SQLException e) {
  31. System.out.println("Message : " + e.getMessage());
  32. }
  33.  
  34. JScrollPane listScroller = new JScrollPane(list);
  35.  
  36. jpa1.add(new JScrollPane(list));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement