Java Reference
In-Depth Information
Listing 12-3:
Login servlet
import java.io.*;
import java.sql.*;
import javax.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class DataSourceLoginServlet extends HttpServlet{
private static String dbUserName = "sa";
private static String dbPassword = "dba";
private Connection con = null;
private DataSource ds = null;
public void init(ServletConfig config) throws ServletException{
super.init(config);
try{
Class.forName("com.inet.pool.PoolDriver").newInstance();
com.inet.tds.TdsDataSource tds = new com.inet.tds.TdsDataSource();
tds.setServerName( "JUPITER" );
tds.setDatabaseName( "MEMBERS" );
tds.setUser( dbUserName );
tds.setPassword( dbPassword );
ds = tds;
}
catch(Exception e){
System.err.println(e.getMessage());
}
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
doPost(request,response);
}
public void doPost(HttpServletRequest request, HttpServletResponse
response)
throws ServletException, IOException
{
response.setContentType("text/html");
PrintWriter out = new PrintWriter(response.getWriter());
int id = -1;
