从数据库中删除名称

Question

我有一个jsp网页。我需要删除用户名从数据库当我按删除按钮从网页。我尝试了下面的代码，但是我不能删除名称，而是在用户名数据库中插入一个新行和一个空值。

unblockServlet.java：

受保护的void doPost（HttpServletRequest请求,HttpServletResponse响应）抛出ServletException,IOException{//TODO自动生成的方法存根

字符串username=request.getParameter（“username”）；

System.out.println("username="+username);


CustomerInfor unblockUser = new CustomerInfor();


unblockUser.setUsername(username);




CustomerInforDBAO unblockuserdb = new CustomerInforDBAO();


String status = unblockuserdb.blockUser(unblockUser);
System.out.println("Deleted user from blocked:" + status);

if (status== "success"){
    dispatch(request,response,"/success.jsp");  

}

else{
    dispatch(request,response,"/error.jsp");    

customerInfordBao.java：

public String unblockUser(CustomerInfor unblockUser){
    Connection con = getConnection(true);
    PreparedStatement stmt = null;
    int status=1;
    String select = "DELETE * FROM paybuddy.blocked where username=?";
    try{
        stmt = con.prepareStatement(select);
        stmt.setInt(1,unblockUser.getId());
        stmt.setString(2,unblockUser.getUsername());

        status = stmt.executeUpdate();
    } catch (Exception e){
        e.printStackTrace();
        unblockUser = null;
    } finally {
        try{
            if (stmt != null) stmt.close();
            if (con != null) con.close();
        }catch (SQLException e) {}
    }
    if(status!=1)
        return "error";
    else
        return "success";

        }

Answer 1

public String unblockUser(CustomerInfor unblockUser){
Connection con = getConnection(true);
PreparedStatement stmt = null;
int status=1;
String select = "DELETE  FROM paybuddy.blocked where username=?"; // no *
try{
    stmt = con.prepareStatement(select);
    //stmt.setInt(1,unblockUser.getId()); is this needed?
    stmt.setString(1,unblockUser.getUsername());

    status = stmt.executeUpdate();
} catch (Exception e){
    e.printStackTrace();
    unblockUser = null;
} finally {
    try{
        if (stmt != null) stmt.close();
        if (con != null) con.close();
    }catch (SQLException e) {}
}
if(status!=1)
    return "error";
else
    return "success";

    }

并检查ur是否调用了上面正确的函数。

String status = unblockuserdb.blockUser(unblockUser);

应该是吗

String status = unblockuserdb.unblockUser(unblockUser);