hey friends....

plz me to solve this question...

I have used the following code for retrieving data fromm two tables : first table having fields: bookid,name,phno second table having field: seat-id

But the data is not retrieved:why so???

1)first -.java file

package pack;

public class admin {

private int Book_id;


private String name;

public int getBook_id() {
    return Book_id;
}

public void setBook_id(int Book_id) {
    this.Book_id = Book_id;
}

public String getName() {
    return name;
}

public void setName(String name) {
    this.name = name;
}

public int getPh_no() {
    return ph_no;
}

public void setPh_no(int ph_no) {
    this.ph_no = ph_no;
}
private int ph_no;

}

2). .java file

package pack; import java.sql.*;

import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.logging.Level; import java.util.logging.Logger;

public class admindao { Connection con; public admindao(){ try { Class.forName("com.mysql.jdbc.Driver"); con = DriverManager.getConnection("jdbc:mysql://localhost:3306/ips?user=root&password=mysql"); } catch (SQLException ex) { Logger.getLogger(admindao.class.getName()).log(Level.SEVERE, null, ex); } catch (ClassNotFoundException ex) { Logger.getLogger(admindao.class.getName()).log(Level.SEVERE, null, ex); }

} public ArrayList getadmin() { ArrayList list = new ArrayList();

    try {

        Statement stmt = con.createStatement();
        ResultSet rs = stmt.executeQuery("select B.book_id,B.name,B.phoneno   from booking_table B");
        while (rs.next()) {
            admin u1 = new admin();
            u1.setBook_id(rs.getInt(1));
            u1.setName(rs.getString(2));
            u1.setPh_no(rs.getInt(3));
           // u1.setSeat_no(rs.getInt(2));
            list.add(u1);
        }

    } catch (SQLException ex) {
        Logger.getLogger(admindao.class.getName()).log(Level.SEVERE, null, ex);
    }


  return list;

} }

3).second .java file for getting data from second table-

package pack;

public class table2 { private int seat_no;

public int getSeat_no() {
    return seat_no;
}

public void setSeat_no(int seat_no) {
    this.seat_no = seat_no;
}

} 4)..java for second table_

package pack; import java.sql.*; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.logging.Level; import java.util.logging.Logger;

public class table2dao{ Connection con1; public table2dao(){ try { Class.forName("com.mysql.jdbc.Driver"); con1 = DriverManager.getConnection("jdbc:mysql://localhost:3306/ips?user=root&password=mysql"); } catch (SQLException ex) { Logger.getLogger(table2dao.class.getName()).log(Level.SEVERE, null, ex); } catch (ClassNotFoundException ex) { Logger.getLogger(table2dao.class.getName()).log(Level.SEVERE, null, ex); }

} public ArrayList gettable2 (){ ArrayList list1 = new ArrayList();

    try {

        Statement stmt = con1.createStatement();
        ResultSet rs1 = stmt.executeQuery("select seat_id from booked_table ");

        while (rs1.next()) {
            table2 u1 = new table2();
            u1.setSeat_no(rs1.getInt(2));


            list1.add(u1);
        }

    } catch (SQLException ex) {
        Logger.getLogger(table2dao.class.getName()).log(Level.SEVERE, null, ex);
    }


  return list1;

} }

5)..jsp file-

<%@page import="java.util.*"%> <%@page import="java.util.ArrayList"%> <%@page import="pack.*"%> <%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>