excecuteUpdate() not working in java
<p>public class insert extends HttpServlet {</p>

<pre><code>protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException, ClassNotFoundException, SQLException {
    response.setContentType("text/html;charset=UTF-8");
    PrintWriter out = response.getWriter();
    try {

    String user= request.getParameter("user");
    String pass=request.getParameter("password");
    String pool=request.getParameter("pool");
    String manager=request.getParameter("manager");
    String role=request.getParameter("role");

    Class.forName("com.mysql.jdbc.Driver");
    Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase","root","root");
  con.setAutoCommit(false);
    Statement stmt = (Statement) con.createStatement();
  String query="INSERT INTO mydatabase.register VALUES ("+"'', '" +user+"', '" +pass+"', '" +pool+"', '" +manager+"', '" +role+"', '" +"')";
  out.println(query);
 int i= stmt.executeUpdate(query);
       stmt.close();
con.commit();
out.println(i);
  out.println("Insert successful!  Thanks for registration!");



    } finally {
        out.close();
    }
} 
</code></pre>

<p>Can anyone please guide me why executeUpdate(query) is not compiled or not executed.? </p>
