import javax.sql.*;
import javax.servlet.*;
import java.util.HashTable;
import java.io.IOException;
public class
ClassA
extends HttpServlet
{
public void
doGet (HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
Connection c = null;
DataSource ds = null;
PreparedStatement statement = null;
ResultSet result = null;
try {
java.util.Hashtable env = new java.util.Hashtable();
env.put (Context.INITIAL_CONTEXT_FACTORY, "com.ibm.ejs.ns.jndi.CNInitialContextFactory");
Context ctx = new InitialContext (env);
ds = (DataSource)ctx.lookup("jdbc/SAMPLE");
ctx.close();
c = ds.getConnection("db2admin", "db2admin");
stmt = c.prepareStatement("select * from sample.name");
result = stmt.executeQuery();
}
finally {
}
}
}
|
|