What is a Connection?
Answer / devarathnam c,kotagudibanda(po
Hi...Actually Connection is an interface in JDBC API.
Which provides the communication b/n the frontend and
backend
Is This Answer Correct ? | 2 Yes | 0 No |
Hi my doubt is that preparedStatement is a interface means which has no implemenation.plz go thru the code below String sql = "SELECT * FROM movies WHERE year_made = ?"; prest = con.prepareStatement(sql); prest.setInt(1,2002); ResultSet rs1 = prest.executeQuery(); Now setInt and executeQuery how it works since it is interface it does not have implementation how it works, how executeQuery returns result from database as executequery method has no implementation even in Statement interface.
4 Answers Cybermate, Hexaware,
Where is jdbc url mysql?
What is jdbc? Describe the steps needed to execute a sql query using jdbc.
What is odbc and jdbc in dbms?
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"); } } }
What is jdbc oracle thin?
What is jdbc and why is it required?
How do java applications access the database using jdbc?
all Java qts are imp ?
What is jdbc thin client?
What are the sailent features of JDBC 2.0?
What are types of resultset?