JDBC

JDBC Projects

JDBC Project 1

JDBC Using PreparedStatement example–Select all records from database table:-
Previous Home Next
/*This example shows to how to fetch all the rows from the
database table using JDBC PreparedStatement.*/

package r4r;
import java.sql.*;
public class AllDataFetch {
public static void main(String[] args) 
{
try
{
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" );
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 updated");
}
con.close();
}
catch(Exception e)
{
System.out.println(e);
}
}
}

 

output:

vineet 2 noida m
swarna 5 Goa f
sashi 3 gr8noida m
gaurav 1 noida m
raghav 4 ghaziabad m
harsh 5 delhi m
rajesh 7 noida m
successfully fetched
Previous Home Next

Tolal:0 Click:

Show All Comments

Did not find what you were looking for leave your name and message. We will revert within 24 hours
Name:
eMail:
Comment / Feedback: