Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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");
- }
- 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); //f8=frame name,jpa1=panel name
- 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());
- }
- public class Stadium {
- private String name;
- private String city;
- public Stadium(String name, String city){...}
- //toString()-method to make it display in a meaningful way in the JList
- public String toString(){ return name + " - " + city; }
- }
- ...
- DefaultListModel listModel = new DefaultListModel();
- while (rs.next()) {
- String name = rs.getString("Stadium");
- String city = rs.getString("City");
- Stadium stadium = new Stadium(name, city)
- listModel.addElement(stadium);
- }
- JList list = new JList(listModel);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement