精通Structs中addressbook:删除功能的怎么实现?
前提xml中各组件已连上了,个常量也对应好了下面的代码可是不能删除啊???
1.
package addressbook.forms;

import javax.servlet.http.HttpServletRequest;
import org.apache.struts.action.ActionMessage;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionMapping;

public final class DelForm extends ActionForm {

private String name = null;
private String phone = null;
private String address = null;
private String hunk = null;
private String delId = null;


public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}

public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}

public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String getHunk() {
return address;
}
public void setHunk(String hunk) {
this.hunk = hunk;
}


public String getDelId() {
return delId;
}


public void reset(ActionMapping mapping, HttpServletRequest request) {

//name = null;
//phone = null;
//address = null;
}
public void setDelId(String delId) {
this.delId = delId;
}

public ActionErrors validate(ActionMapping mapping,
HttpServletRequest request) {

ActionErrors errors = new ActionErrors();
if (((delId == null)))
errors.add( "name ", new ActionMessage( "error.name.required "));
// if(((phone == null)|| (phone.length() < 1)))

// errors.add( "phone ", new ActionMessage( "error.phone.required "));
//if(((address == null)|| (address.length() < 1)))
// errors.add( "address ", new ActionMessage( "error.address.required "));

return errors;

}

2.
2.

import addressbook.Constants;
包都蹈进了....
public final class DelAction extends AbstActionBase {

private Log log =
LogFactory.getLog(this.getClass().getName());

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

Locale locale = getLocale(request);
MessageResources messages = getResources(request);

ActionMessages errors = new ActionMessages();
String name =((DelForm) form).getName();
String delId = ((DelForm) form).getDelId();//
//String deleteId = "8 ";
String phone = ((DelForm) form).getPhone();
String address=((DelForm)form).getAddress();
String hunk = ((DelForm) form).getHunk();

if (!errors.isEmpty()) {
//saveErrors(request, errors);
return (new ActionForward(mapping.getInput()));
}

String strSql = new String( "delete FROM " + Constants.TABLENAME + " WHERE ");
//error:IOException:java.sql.SQLException: Can not issue data manipulation statements with executeQuery()

//if (!name.equals( " "))
strSql = strSql + "name = "+ name + " ";//id + delId +
//if (!phone.equals( " "))
//strSql = strSql + " phone LIKE ' "+ phone + "% ' AND ";
//if (!address.equals( " "))
//strSql = strSql + " address LIKE ' "+ address + "% ' ";
//else
//strSql = strSql.substring(0,strSql.length()-3);

//strSql = strSql + "ORDER by ID "; //java.lang.NullPointerException
strSql = strSql.substring(0,strSql.length());//删除

//try
//{

AddressBookBean bean=new AddressBookBean(delId,phone,address,hunk,delId);

//bean.delete(strSql);
AddressBookBean.delete(strSql);//访问静态??
//}
//catch(Exception ex)
//{
// ex.printStackTrace(System.out);
// errors.add(ActionMessages.GLOBAL_MESSAGE,
// new ActionMessage( 'error.ioException '));
// }


HttpSession session = request.getSession(); //??????????
if (log.isDebugEnabled()) {
log.debug( "SearchAction session = " + session);
log.debug( "SearchAction strSql = " + strSql);

}


session.setAttribute(Constants.SQLSTMT_KEY, strSql);//SQLSTMT_KEY = "sqlstatement "????????

return (mapping.findForward(Constants.FORWARD_DELOK));//FORWARD_SUCCESS

}
}
}


[解决办法]
struts config 文件呢？