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 );
}

How can we execute stored procedures using callablestatement?

934

---

Why we use jdbc instead of odbc?

983

---

How to connect html page to database using jdbc?

896

---

Which is best database for java?

987

---

What is use of connection pooling?

963

---

What are restrictions on triggers?

2232

---

What is jndi lookup?

934

---

Briefly tell about the jdbc architecture.

998

---

What is jdbc and jpa?

1007

---

What does setautocommit do?

971

---

What does adapter class provide?

944

---

What is jdbc driver for sql server?

1004

---

Can I get a null resultset?

1025

---

Is jdbc open source?

863

---

Is odbc an api?

1041

---