Resultset_Demo

Опубликовано: 11 Апрель 2026
на канале: KD_Tarpara

Result_set_Demo.java code goole Drive link :
https://drive.google.com/file/d/1wVoe...
Result_set_Demo.java code:

import java.sql.*;
public class Result_set_Demo {

public static void main(String[] args) {

try
{

Class.forName("com.mysql.jdbc.Driver");
System.out.println("Class/Driver Loaded");

String url="jdbc:mysql://localhost:3306/hjd";
String user="root";
String pass="";
Connection conn = DriverManager.getConnection(url,user,pass);
System.out.println("Conncetion Doned");

Statement stmt =conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
System.out.println("Statement Created");

// rs.moveToInsertRow();
ResultSet rs=stmt.executeQuery("SELECT *FROM student");
// rs.last();
// rs.deleteRow();
// System.out.println("RECORD DELETE");

rs.next();
// int sno = rs.getInt("sno");
// sno = sno + 50;
rs.updateInt("SNO",12);
rs.updateString("sname","sname+*");
rs.updateString("scity","Resultcity");
rs.updateRow();
rs.moveToCurrentRow();

System.out.println("SNO\tSNMAE\tSCITY");
while(rs.next())
{
System.out.println(rs.getInt(1)+"\t"+rs.getString(2)+"\t"+rs.getString(3));
}
//System.out.println("Row Efectted : "+n);

rs.close();
stmt.close();
conn.close();
}
catch(Exception e)
{
System.out.println("Error : "+e.toString());
}

}

}