Write a program JDBCcode forfetching student database with SQL.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More JDBC Interview Questions

How to find the column count in resultset?

1 Answers   Wipro,


How do you know which driver is connected to a database?

3 Answers  


how to retrieve sql exceptions

2 Answers   Bosch,


What is JDBC DataSource and what are it’s benefits?

0 Answers  


What does Class.forName return?

8 Answers   IBM,






Explain the two tier and three tier architecture of jdbc.

0 Answers  


How do we call a stored procedure from jdbc?

0 Answers  


How many packages are available in jdbc api?

0 Answers  


Explain about DSN?

0 Answers   Infosys,


What does jdbc setmaxrows method do?

0 Answers  


Which is better jpa or jdbc?

0 Answers  


java.lang.ClassNotFoundException:oracle.jdbc.driver.OracleDr iver? I get this error at run time.I used oracle10G. I set CLASS PATH:C:\oraclexe\app\oracle\product\10.2.0 \server\jdbc\lib\ojdbc14.jar; I write JDBC PROGRAM like import java.sql.*; class Example { public static void main(String args[]) { try { Class.forName ("oracle.jdbc.driver.OracleDriver"); System.out.println("Driver Loaded"); Connection con=DriverManager.getConnection ("jdbc:oracle:thin:@localhost:1521:xe","system","salmas"); System.out.println("Driver Connected"); Statement st=con.createStatement(); ResultSet rs=st.executeQuery("select * from emp"); while(rs.next()) { System.out.println(rs.getInt(1)); System.out.println(rs.getString(2)); System.out.println(rs.getString(3)); } st.close(); con.close(); } catch(Exception e) { System.out.println(e); } finally { System.out.println("it's finally block executed"); } } }

6 Answers   CTS,


Categories