Answer Posted / paletipatisrinu

import java.io.*;
import java.sql.*;
inport javax.sql.*;
import javax,servlet.http.*;
public class connection extends HttpServlet
{
public void service(HttpServletRequest
req,HttpServletResponse res)throws ServletException,IOException
{
Connection con=makeConnectionPool();
Statement st =con.createStatement();

----------reqular code as like as jdbc--------









}
public void Connection makeConnectionPool()
{
Connection con=null;
try
{
InitialContext ic =new InitialContext();
DataSource ds =(DataSource)ic.lookUp(" jndi logical Name in
Application server");
con=ds.getcConnection();
}catch(Exception e)
{
e.printStackTrace();
}
return con;
}



Note:-First u create logical name of jndi in application
server and refer this api javax.sql.*

What is resultset?

940

---

How can we maintain the integrity of a database by using jdbc?

988

---

What is setautocommit in jdbc?

878

---

Give steps to connect to the db using jdbc?

972

---

Discuss the procedure of retrieving warnings?

927

---

What is a rollback in jdbc?

883

---

What are the three basic components of the odbc architecture?

869

---

How does a custom RowSetReader get called from a CachedRowSet?

1027

---

What are the main steps in java to make JDBC connectivity?

966

---

Is jdbc open source?

804

---

What is batch processing and how to perform batch processing in jdbc?

875

---

What are the higher level apis under development on top of jdbc currently?

899

---

What is createstatement method in java?

910

---

What is JDBC ResultSet?

1069

---

What is the fastest type of JDBC driver?

1006

---