Write a program JDBCcode forfetching student database with SQL.
No Answer is Posted For this Question
Be the First to Post Answer
How to find the column count in resultset?
How do you know which driver is connected to a database?
how to retrieve sql exceptions
What is JDBC DataSource and what are it’s benefits?
What does Class.forName return?
Explain the two tier and three tier architecture of jdbc.
How do we call a stored procedure from jdbc?
How many packages are available in jdbc api?
Explain about DSN?
What does jdbc setmaxrows method do?
Which is better jpa or jdbc?
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"); } } }