i just wondering somebody could give me suggestion or correct my mistake in this programming because i cannot displaying information from database.
this is my prog but it did not complete yet.i hope somebody could tell me how to retrieve , store data in variable from database and diplaying in text area
ublic class nazrie extends JFrame {
static {
try {
// step 1 load driver
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//DriverManager.registerDriver (new sun.jdbc.odbc.JdbcOdbcDriver());
} catch (ClassNotFoundException ex) {
System.out.println(ex.getMessage());
System.exit(0);
}
}
public static void main(String args[]) {
String r1=null, r2=null,r3=null,r4=null,r5=null,r6=null,r7=null,r8 =null, r9=null,r10=null,r11=null,r12=null;
String ar[] = new String[500];
int n=1;
int count=0;
dat1 re1= new dat1();
dat1 re2= new dat1();
dat1 re3= new dat1();
dat1 re4= new dat1();
dat1 re5= new dat1();
dat1 re6= new dat1();
JTextArea textArea = new JTextArea();
JFrame frame = new JFrame();
try {
// step 2 : create connection
Connection con = DriverManager.getConnection("jdbc

dbc:ODBC_HIST") ;
// step 3 : For queries create a statement to execute SELECT statements
Statement st = con.createStatement();
// step 4 : execute a SELECT query and obtain a ResultSet
String Query = "Select dtmast.dt_name,dtmast.dt_addr1,dtmast.dt_addr2,dtm ast.dt_addr3,dtmast.dt_addr4,dtmast.dt_code,invhis t.inv_num,invhist.inv_date,vesmast.ves_name,invhis t.scn,vestype.ves_type_descr,vestype.ves_type_desc r,vesmast.loa,vesvoyhist.act_date_arv,terminal.ter m_name,vesmast.grt,vesvoyhist.act_time_arv"+
" FROM invhist, invitemhist, dtmast,vesvoyhist,vesmast,terminal,vestype "+
" where invhist.inv_num = 'VI0000000101'AND invhist.inv_num=invitemhist.inv_num AND invhist.dt_code=dtmast.dt_code AND invhist.scn=vesvoyhist.scn AND vesvoyhist.ves_code= vesmast.ves_code AND vesvoyhist.term_code=terminal.term_code AND vesmast.ves_type=vestype.ves_type ";
String Query1 = "Select dtmast.dt_name,dtmast.dt_addr1,dtmast.dt_addr2,dtm ast.dt_addr3,dtmast.dt_addr4,dtmast.dt_code,invhis t.inv_num,invhist.inv_date,vesmast.ves_name,invhis t.scn,vestype.ves_type_descr,vestype.ves_type_desc r,vesmast.loa,vesvoyhist.act_date_arv,terminal.ter m_name,vesmast.grt,vesvoyhist.act_time_arv,invitem hist.inv_descr1,invitemhist.inv_descr2,invitemhist .inv_descr3,vesvoyhist.term_code,invitemhist.inv_r ate"+
" FROM invhist, invitemhist, dtmast,vesvoyhist,vesmast,terminal,vestype "+
" where invhist.inv_num = 'VI0000000101'AND invhist.inv_num=invitemhist.inv_num AND invhist.dt_code=dtmast.dt_code AND invhist.scn=vesvoyhist.scn AND vesvoyhist.ves_code= vesmast.ves_code AND vesvoyhist.term_code=terminal.term_code AND vesmast.ves_type=vestype.ves_type ";
// String Query = "SELECT * FROM EMPLOYEES";
ResultSet record1=st.executeQuery(Query1);
// step 5 : loop through all records
while(record1.next())
{
n=1;
r1=record1.getString(1);