JDBC - execute method in jdbc for select and non-select queries
For Explanation Watch Video ::
Creation of table::
SQL> create table test2(eid int,ename varchar2(10));
Table created.
SQL> insert into test2 values(1,'vijay');
1 row created.
SQL> insert into test2 values(2,'rajesh');
1 row created.
SQL> select * from test2;
EID ENAME
---------- ----------
1 vijay
2 rajesh
SQL> commit;
Commit complete.
JDBC code::
package com.test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Scanner;
class Test
{
public static void main(String arg[])throws Exception{
//generate the connection
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","system","tiger");
//create statement Object
Statement st = con.createStatement();
//get query from user
Scanner scn = new Scanner(System.in);
System.out.println("Enter the select or non-select Query: ");
String query = scn.nextLine();
//execute the query
boolean flag = st.execute(query);
if(flag==true) {
//set query
ResultSet rs = st.getResultSet();
while(rs.next()) {
System.out.println(rs.getString(1)+" "+rs.getString(2));
}
}else {
//non-select query
int count = st.getUpdateCount();
if(count==0) {
System.out.println("No record Updated");
}else {
System.out.println("No of records Affected: "+count);
}
}
con.close();
}
}
o/p: for select Query
Enter the select or non-select Query:
select * from test2
1 vijay
2 rajesh
for Non-select Query:
Enter the select or non-select Query:
update test2 set ename='allu' where eid=1
No of records Affected: 1
Comments
Post a Comment