Tuesday, March 17, 2009

Jdbc get the data from database example



import java.sql.*;
class GetData
{
public static void main(String[] args) throws Exception
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection
("jdbc:oracle:thin:@localhost:1521:xe","system","chandru");
System.out.println(" Connected 2 DB.....");
//FARWARD_ONLY resultset is the default resultset
Statement stmt=con.createStatement();
String vsql="select * from emp4";
ResultSet rs=stmt.executeQuery(vsql);
while(rs.next())
{
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
}



}
}



0 comments:

Post a Comment