im tr table only 2 column exist , first1 time period of text type nd 2nd is rate ,i.e also text type,my code is
try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:DRIVER=Microsoft Access DRIVER (*.mdb);DBQ=trrelation.mdb");
String tp=(String)mTimePd.getElementAt(cTimePd.getSelectedIndex());
PreparedStatement ps=con.prepareStatement("select Rate from tr where TimePeriod=?");
ResultSet rs=ps.executeQuery();
ps.setString(1,tp);
while(rs.next()){
tRate.setText(rs.getString(2));
}
con.close();
}
catch(Exception ex){
System.out.println(ex.toString());
}