sql

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.");
 }
}

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值