sql

  public ActionForward execute(ActionMapping mapping, ActionForm form,
   HttpServletRequest request, HttpServletResponse response) {

  // TODO Auto-generated method stub
  AddUserForm addUserForm = (AddUserForm) form;
  String password = addUserForm.getPassword();
  String username = addUserForm.getUsername();

  try {

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

   Connection conn = DriverManager.getConnection(
     "jdbc:mysql://192.168.2.220:3306/test", "test", "test");
   Statement stmt = conn.createStatement();

   String sql = "select password from usertable where username='"
     + username + "'";
   ResultSet rs = stmt.executeQuery(sql);
   if (rs.next() != false) {

    rs.close();
    stmt.close();
    conn.close();
    System.out.println("user   /"" + username
      + "/"   is already in using..");
    return (mapping.findForward("addfail"));
   } else if (rs.next() == false) {
    String insertsql = "insert into usertable(username,password) values('"
      + username + "'," + "'" + password + "')";
    stmt.execute(insertsql);
    rs.close();
    stmt.close();
    conn.close();
    System.out.println("user   /"" + username
      + "/"    is added ok.....");
    return (mapping.findForward("success"));
   }
   /*
    * javax.sql.DataSource ds =
    * getDataSource(servletRequest,"dataSource");
    *
    * Connection conn = ds.getConnection(); Statement
    * stmt=conn.createStatement();
    *
    * String sql= "select password from user where username ='"
    * +loginForm.getUsername()+"'"; ResultSet
    * rs=stmt.executeQuery(sql);
    *
    */

  } catch (Throwable e) {
   e.printStackTrace();
  }

  throw new java.lang.UnsupportedOperationException(
    "Method $execute() not yet implemented.");
 }
}