insert前判断下要添加的记录是否在数据库中有了:
final String login_name = request.getParameter("login_name");
DataSet ds = DBToolUtil.openDataSet("select 1 from my_operator where login_name=?",new ParameterSetter(){
public void setValues(ParameterSetter arg0) throws SQLException {
arg0.setString(1, login_name);
}
});
if(ds.getRecordCount()>0){
request.setAttribute("message",new TipMessage(CONSTANTS.ERROR_CODE,"登陆名:"+login_name+"已经存在"));
return mapping.findForward("showMsg");
}