import java.sql.*;

public class JdbcNestedResultset {

    public static void main(String args[]) {
        Connection con = null;
        Statement st1 = null;
        Statement st2 = null;
        ResultSet rs1 = null;
        ResultSet rs2 = null;

        String url = "jdbc:mysql://localhost:3306/";
        String db = "komal";
        String driver = "com.mysql.jdbc.Driver";
        String user = "root";
        String pass = "root";
        try {

            Class.forName(driver);
            con = DriverManager.getConnection(url + db, user, pass);

            st1 = con.createStatement();
            st2 = con.createStatement();

            String sql = "Select * from stu";
            rs1 = st1.executeQuery(sql);

            System.out.println("Id\tName\tClass\tLibno");
            while (rs1.next()) {
                String id = rs1.getString("id");

                System.out.print(id + "\t");
                System.out.print(rs1.getString("name") + "\t");
                System.out.print(rs1.getString("class") + "\t");

                rs2 = st2.executeQuery("select * from lib where id ='" + id + "'");
                while (rs2.next()) {
                    System.out.println(rs2.getString("libno") + "\t");
                }
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}