import java.sql.*;

public class DemoResultSet {
    public static void main(String[] args) throws ClassNotFoundException, SQLException, InterruptedException{
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        Connection cn = DriverManager.getConnection("jdbc:sqlserver://localhost;DatabaseName=DeveloperApps;user=sa;Password=123456");
        if(cn != null) {
            System.out.println("Connection Successful!!");
            /*
            String createProcedure = "Create Procedure DISPLAY_PRODUCTS " +
                "as " + "SELECT * FROM ToppingDetails";
            Statement st = cn.createStatement();
            st.executeUpdate(createProcedure);*/

            /*
            CallableStatement csDetails = cn.prepareCall("{call DISPLAY_PRODUCTS}");

            ResultSet rs = csDetails.executeQuery();
            while(rs.next()){
                System.out.println(rs.getString("ToppingName") + " " + rs.getString("ToppingPrice"));
            }*/

            PreparedStatement cs = cn.prepareStatement("SELECT * FROM ToppingDetails", ResultSet.TYPE_FORWARD_ONLY);
            try (ResultSet rs = cs.executeQuery()) {
                rs.beforeFirst();
                //rs.absolute(2);
                while(rs.next()){
                    System.out.println(rs.getString("ToppingName") + " " + rs.getString("ToppingPrice"));
                }
                //Thread.sleep(10000);
                /*
                rs.moveToInsertRow();
                rs.updateString(1, "haloa");
                rs.updateString(2, "80");
                rs.insertRow();
                rs.beforeFirst();
                /*
                rs.updateString(1, "Aloha");
                rs.updateRow();*/
                /*
                while(rs.next()){
                    System.out.println(rs.getString("ToppingName") + " " + rs.getString("ToppingPrice"));
                }*/

            }
            cn.close();
        }

    }
}