Originally Posted by peter_budo

First thing, please do not use JSP to connect to database. Pass data to servlet for validation, or use JavaScript to valildate them in JSP, and setup connection inside servlet and then by the needs go back to previous page to pick up correct/new data or move to nex page
this is usual peace of code which I re-use often

Help with Code Tags

(Toggle Plain Text)

public class SomeClassName extends HttpServlet
{
Connection conn;
Statement stmt;
	
public void init() throws ServletException
{
	try
	{
		Class.forName("com.mysql.jdbc.Driver").newInstance();
	}
	catch (Exception ex)
	{
		System.out.println("Exception is : " + ex.toString() );
	}
}
	
public void doPost( HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException
{
	try
	{
		conn = DriverManager.getConnection("jdbc:mysql://localhost/" 
													+ "database_name?user=my_username&password=my_password");
		stmt = conn.createStatement();
	}
	catch(SQLException ex)
	{
		System.out.println("SQLException : " + ex.getMessage() );
	}

public class SomeClassName extends HttpServlet { Connection conn; Statement stmt; public void init() throws ServletException { try { Class.forName("com.mysql.jdbc.Driver").newInstance(); } catch (Exception ex) { System.out.println("Exception is : " + ex.toString() ); } } public void doPost( HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { try { conn = DriverManager.getConnection("jdbc:mysql://localhost/" + "database_name?user=my_username&password=my_password"); stmt = conn.createStatement(); } catch(SQLException ex) { System.out.println("SQLException : " + ex.getMessage() ); }

PS: I will request this post to be move to JSP section, it is where it actualy belong and where you can find more similar questions and answers