hm i have this bit of code that kind of gives me what i want.. but it's initiated by typing an ID in a textfield
would it be possible to modify this somehow without having to type input in a textfield?
here's the info for my databaseCode:Statement stmt = conn.createStatement(); s1 = "select * from Packages where PACKAGEID=" + jTextFieldID.getText(); ResultSet rs = stmt.executeQuery(s1); if(rs.next()){ jTextFieldName.setText(rs.getString(2)); jTextFieldStartDate.setValue(rs.getDate(3)); jTextFieldEndDate.setValue(rs.getDate(4)); jTextFieldDesc.setText(rs.getString(5)); jTextFieldBasePrice.setText(rs.getString(6)); jTextFieldAgencyComm.setText(rs.getString(7));
PACKAGEID NUMBER 10 (pk)
PKGNAME VARCHAR2 100
PKGSTARTDATE DATE
PKGENDDATE DATE
PKGDESC VARCHAR2 100
PKGBASEPRICE NUMBER 19 4 (0)
PKGAGENCYCOMMISSION NUMBER




Reply With Quote
