bonjour,
i've been stuck on this for a couple of days.
i'm trying to get the data from my jlist, (which is populated from an oracle database through a defaultlistmodel) and get it into my 7 jtextfields when i click on each item... i'm not sure how to go about doing this.
here's my jlist
Code:public void loadList(){ String ll; String toAdd; try { Statement stmt = conn.createStatement(); ll = "select * from Packages"; ResultSet rs = stmt.executeQuery(ll); //while the ResultSet has a next(){ while(rs.next()){ //get all the bits of data out of the ResultSet row toAdd = rs.getString("PKGNAME") + rs.getString("PACKAGEID") + rs.getString("PKGSTARTDATE") + rs.getString("PKGENDDATE") + rs.getString("PKGDESC") + rs.getString("PKGBASEPRICE") + rs.getString("PKGAGENCYCOMMISSION"); //add() them to the DefaultListModel dlm.addElement(toAdd); } } catch (SQLException e2) { // TODO Auto-generated catch block e2.printStackTrace(); }




Reply With Quote
