Thursday, 23 April 2009

How to use JDBC APIs

Connection dbConn;

String user = "nv_icp";
String pwd = "nv_icp";
String dbName = "jdbc:oracle:thin:@192.168.64.125:1521:ORCL132";
               DriverManager.registerDriver((java.sql.Driver)Class.forName("oracle.jdbc.OracleDriver").newInstance());
 dbConn = DriverManager.getConnection(dbName, user, pwd);

PreparedStatement ps = dbConn.prepareStatement("select * from emp where empname = ?");

ps.setString(1, "narendra");

ResultSet rs = ps.executeQuery();

while (rs.next ())
 {
        System.out.println("Message : "+ rs.getString(1) );

 }

 }

No comments:

Post a Comment