Database connection in using J2EE servlets

Directory structure of the application would be something like this:

test.html

Servlet.java

/*

 * To change this template, choose Tools | Templates

 * and open the template in the editor.

 */

import java.io.IOException;

import java.io.PrintWriter;

import java.sql.*;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

/**

 *

 * @author Sunshine

 */

@WebServlet(name = "Servlet", urlPatterns = {"/Servlet"})

public class Servlet extends HttpServlet {

    /**

     * Processes requests for both HTTP

     * <code>GET</code> and

     * <code>POST</code> methods.

     *

     * @param request servlet request

     * @param response servlet response

     * @throws ServletException if a servlet-specific error occurs

     * @throws IOException if an I/O error occurs

     */

    protected void processRequest(HttpServletRequest request, HttpServletResponse response)

            throws ServletException, IOException {

        response.setContentType("text/html;charset=UTF-8");

        PrintWriter out = response.getWriter();

        Connection con=null;

        String name=null;

        try 

        {

            /* TODO output your page here. You may use following sample code. */

            name=request.getParameter("txtName");

            Class.forName("com.mysql.jdbc.Driver");

            con=DriverManager.getConnection("jdbc:mysql://localhost/test?user=root&password=ravi");

            Statement st=con.createStatement();

            int val=st.executeUpdate("insert into yes(name) values('"+name+"')");

        } 

        catch(Exception ex)

        {

            out.println(ex.getMessage());

        }

        

        finally 

        {            

            out.close();

        }

    }

    // <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">

    /**

     * Handles the HTTP

     * <code>GET</code> method.

     *

     * @param request servlet request

     * @param response servlet response

     * @throws ServletException if a servlet-specific error occurs

     * @throws IOException if an I/O error occurs

     */

    @Override

    protected void doGet(HttpServletRequest request, HttpServletResponse response)

            throws ServletException, IOException {

        processRequest(request, response);

    }

    /**

     * Handles the HTTP

     * <code>POST</code> method.

     *

     * @param request servlet request

     * @param response servlet response

     * @throws ServletException if a servlet-specific error occurs

     * @throws IOException if an I/O error occurs

     */

    @Override

    protected void doPost(HttpServletRequest request, HttpServletResponse response)

            throws ServletException, IOException {

        processRequest(request, response);

    }

    /**

     * Returns a short description of the servlet.

     *

     * @return a String containing servlet description

     */

    @Override

    public String getServletInfo() {

        return "Short description";

    }// </editor-fold>

}