Hi,
I found that using the init() method to set up a database connection
then trying to instantiate a ServletContext object and forward to a jsp
page didn't work.
If placed the database connection code in the doPost() then it DID,
The 2 code sets are attached,
can anyone tell me why?
thanks,
kind regards,
Luke
--
"when my computer smiles, I'm happy"
===.~ ~,
Luke Vanderfluit |'/']
Mobile: 0421 276 282\~/`
/* A servlet to display the contents Bookmarks database */
import java.io.*;
import java.sql.*;
import java.text.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class CodeSet1 extends HttpServlet
{
Connection dbcon; // Connection
public String getServletInfo()
{
return "Servlet connects to PostgreSQL";
}
// "init" sets up a database connection
public void init(ServletConfig config) throws ServletException
{
String loginUser = "luke";
String loginPasswd = "";
String loginUrl = "jdbc:postgresql:bookmarks";
// Load the PostgreSQL driver
try
{
Class.forName("org.postgresql.Driver");
dbcon = DriverManager.getConnection(loginUrl, loginUser, loginPasswd);
}
catch (ClassNotFoundException ex)
{
System.err.println("ClassNotFoundException: " + ex.getMessage());
throw new ServletException("Class not found Error");
}
catch (SQLException ex)
{
System.err.println("SQLException: " + ex.getMessage());
}
} // end init()
// == POST ==
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws IOException, ServletException
{
String loginUser = "luke";
String loginPasswd = "";
String loginUrl = "jdbc:postgresql:bookmarks";
/*// Load the PostgreSQL driver
try
{
Class.forName("org.postgresql.Driver");
dbcon = DriverManager.getConnection(loginUrl, loginUser, loginPasswd);
}
catch (ClassNotFoundException ex)
{
System.err.println("ClassNotFoundException: " + ex.getMessage());
throw new ServletException("Class not found Error");
}
catch (SQLException ex)
{
System.err.println("SQLException: " + ex.getMessage());
}
*/
String title = request.getParameter("title");
String url = request.getParameter("url");
String descr = request.getParameter("descr");
try
{
// Declare statement
Statement statement = dbcon.createStatement();
String query = "insert into bookmark values('"
+ title + "', '" + url + "', '" + descr + "')";
// Perform update
statement.executeUpdate(query);
statement.close();
}
catch(Exception ex){}
try{ dbcon.close(); } catch(SQLException ignored) {}
ServletContext context = getServletContext();
RequestDispatcher rd = context.getRequestDispatcher("/marksMain.jsp");
rd.forward(request, response);
} //end doPost
}
/* A servlet to display the contents Bookmarks database */
import java.io.*;
import java.sql.*;
import java.text.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class CodeSet2 extends HttpServlet
{
Connection dbcon; // Connection
public String getServletInfo()
{
return "Servlet connects to PostgreSQL";
}
/* // "init" sets up a database connection
public void init(ServletConfig config) throws ServletException
{
String loginUser = "luke";
String loginPasswd = "";
String loginUrl = "jdbc:postgresql:bookmarks";
// Load the PostgreSQL driver
try
{
Class.forName("org.postgresql.Driver");
dbcon = DriverManager.getConnection(loginUrl, loginUser, loginPasswd);
}
catch (ClassNotFoundException ex)
{
System.err.println("ClassNotFoundException: " + ex.getMessage());
throw new ServletException("Class not found Error");
}
catch (SQLException ex)
{
System.err.println("SQLException: " + ex.getMessage());
}
} // end init()
*/// == POST ==
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws IOException, ServletException
{
String loginUser = "luke";
String loginPasswd = "";
String loginUrl = "jdbc:postgresql:bookmarks";
// Load the PostgreSQL driver
try
{
Class.forName("org.postgresql.Driver");
dbcon = DriverManager.getConnection(loginUrl, loginUser, loginPasswd);
}
catch (ClassNotFoundException ex)
{
System.err.println("ClassNotFoundException: " + ex.getMessage());
throw new ServletException("Class not found Error");
}
catch (SQLException ex)
{
System.err.println("SQLException: " + ex.getMessage());
}
String title = request.getParameter("title");
String url = request.getParameter("url");
String
