Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- JFrame f8 = new JFrame("Schedule");
- f8.setVisible(true);
- f8.setSize(1000, 1000);
- JPanel jpa1 = new JPanel(new GridBagLayout());
- String query = "SELECT * FROM Location";
- DefaultListModel model = new DefaultListModel();
- DefaultListModel model1 = new DefaultListModel();
- try {
- Class.forName("oracle.jdbc.driver.OracleDriver");
- Statement stmt = null;
- ResultSet rs;
- Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1/SPL", "root", "PWD");
- stmt = (Statement) conn.createStatement();
- rs = stmt.executeQuery(query);
- while (rs.next()) {
- String stadium = rs.getString("Stadium");
- String city = rs.getString("City");
- model.addElement(stadium);
- model1.addElement(city);
- }
- JList list = new JList(model);
- JList list1 = new JList(model1);
- f8.add(jpa1);
- jpa1.add(list);
- list.setSelectionMode(ListSelectionModel.SINGLE_INTERVAL_SELECTION);
- list.setLayoutOrientation(JList.HORIZONTAL_WRAP);
- list.setVisibleRowCount(1);
- JScrollPane listScroller = new JScrollPane(list);
- } catch (SQLException e) {
- System.out.println("Message : " + e.getMessage());
- }
- JScrollPane listScroller = new JScrollPane(list);
- jpa1.add(new JScrollPane(list));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement