JDBC Using Prepared Statement example–Select record using name
/* This program shows you how to fetch a row by providing the
unique name from the database table using JDBC
PreparedStatement.*/
package r4r;
import java.sql.*;
import java.util.*;
public class FetchData
{
public static void main(String args[])
{
try
{
Scanner s=new Scanner(System.in);
System.out.println("Enter your name:-");
String s1=s.nextLine();
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection
("jdbc:oracle:thin:@localhost:1521:xe","system","oracle");
PreparedStatement stmt=con.prepareStatement("select *
from user5 where name=?");
stmt.setString(1, s1);
ResultSet rset=stmt.executeQuery();
while(rset.next())
{
System.out.println
(rset.getString(1)+"\t"+rset.getInt(2)+"\t"+rset.getString(3)+
"\t"+rset.getString(4));
System.out.println("successfully fetched");
}
con.close();
}
catch(Exception e)
{
System.out.println(e);
}
}
}
output:
Enter your name:-
gaurav
gaurav 1 noida m
successfully fetched
