Answer Posted / mukundvishy

Hashtable mapTable = new Hashtable();
Connection sqlCon = null ;
PreparedStatement pStmnt = null ;
ResultSet rSet = null;
try
{
// getConnection() method below should get connection from
pool etc.
sqlCon = getConnection();
pStmnt = sqlCon.prepareStatement( "SELECT * from tab" );
rSet = pStmnt.executeQuery();
while( rSet.next() )
{
mapTable.put( rSet.getString(1), rSet.getString(2));
}

}
catch( SQLException ex )
{
ex.printStackTrace();
}
finally
{
// The below method should close all resources peacefully
closeResources( sqlCon, pStmnt, rSet );
}

What are jdbc?

953

---

What does the connection object represents?

1057

---

What happens if we don't close the connection in jdbc?

880

---

What are the new features added to JDBC 4.0?

951

---

Name the method, which is used to prepare a callablestatement.

906

---

What is a rollback in jdbc?

935

---

Is jdbc a web technology?

884

---

Which jdbc driver type s is are the jdbc odbc bridge?

875

---

What is type 4 jdbc driver?

847

---

Does jdbc require oracle client?

925

---

What are different parts of a url?

977

---

What does jdbc do?

1024

---

What are types of resultset?

989

---

How many locking systems are there in jdbc?

1019

---

If I use the JDBC API, do I have to use ODBC underneath?

1033

---