INTERVIEW QUESTIONS J2EE JAVA DETAILS

Question: What is JDBC? Describe the steps needed to execute a SQL query using JDBC.

Answer: The JDBC is a pure Java API used to execute SQL statements. It provides a set of classes and interfaces that can be used by developers to write database applications.
The steps needed to execute a SQL query using JDBC:
1. Open a connection to the database.
2. Execute a SQL statement.
3. Process th results.
4. Close the connection to the database.

The JDBC is a pure Java API used to execute SQL statements. It provides a set of classes and interfaces that can be used by developers to write database applications.
The steps needed to execute a SQL query using JDBC:
1. Open a connection to the database.
2. Execute a SQL statement.
3. Process th results.
4. Close the connection to the database. Source: CoolInterview.com

Hi...
JDBC: JDBC is a specification which allows the developers to communicating from front end(java) to back end(oracle,sybase...).
The standard steps to connecting the database as follows:
try{
1: Loading the drivers
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
2:Getting the connection
Connection con=DriverManager.getConnection("jdbc:odbc:datasourcename","scott","tiger");
3:Create the Statement
Statement st=con.createStatement();
4:Execute the Statement
ResultSet rs=st.executeQuery("select * from emp");
5:Accessing the data from the backend
while(rs.next())
System.out.println(rs.getString(1));
System.out.println(rs.getInt(2));
System.out.println(rs.getString(3));
6:close the connection
}catch(SQLException se)
{ se.printStackTrace();
}
finally{
con.close();
rs.close();
st.close();
}
Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

• There should not be any Spelling Mistakes.
• There should not be any Gramatical Errors.
• Answers must not contain any bad words.
• Answers should not be the repeat of same answer, already approved.
• Answer should be complete in itself.

Name :*
Email Id :*
Answer :*
Verification Code	Not readable? Load New Code
Enter the above shown code: *
	Inform me about updated answers to this question