再Web服务端开发中,会经常有对数据库的新增、编辑等操作,简化程序是件非常重要的事情;
1、首先分层,dao、service、controller、bean;
2、对于经常出现的代码进行封装;
2、多写工具类,空指针判断,各种取时间;
贴下简化后的代码:
/** * 添加/修改 信息保存 * @param adver 广告信息 * @return 成功/失败 */ @RequestMapping(value = "/saveAdver") @ResponseBody public JSONObject saveAdver(HttpServletRequest request, AdverTisement adver, String overTime){ Integer res = 0; try { adver.setOver_time(Common.fromDateY(overTime)); adver.setThumbnail(adver.getImage()); if (adver.getId() != 0) {// 修改 res = adverTisementServiceImpl.updateArchiveTisement(adver); res = (res > 0 ? 2 : 0); } else {// 添加 res = adverTisementServiceImpl.insertArchiveTisement(adver); } } catch (Exception e) { e.printStackTrace(); } String returnCode = Common.getReturnCode(res, res); return JSONObject.fromObject(returnCode); } 首先这个方法能新增、编辑,并对返回值进行统一处理: /** * * @Description 根据条件获取返回结果 * @author <p style="color:#8e8e8e;font-family:微软雅黑;font-size=16px;font-weight:bold;">Cloud</p> * @date <p style="color:#000;font-family:微软雅黑;font-size=16px;">2016-12-5下午4:53:10</p> * @param type 返回类型 1、添加 2、修改 3、删除 4、审核 5、付款 默认 操作失败 * @param status 返回影响行数 * @return */ public static String getReturnCode(int type, int status){ String returnCode = null; switch (type) { case 1: if (status > 0) { returnCode = new String(ReturnCode.SAVE_SUCCESS.toString()); } else { returnCode = new String(ReturnCode.SAVE_ERROR.toString()); } break; case 2: if (status > 0) { returnCode = new String(ReturnCode.UPDATE_SUCCESS.toString()); } else { returnCode = new String(ReturnCode.UPDATE_ERROR.toString()); } break; case 3: if (status > 0) { returnCode = new String(ReturnCode.DELETE_SUCCESS.toString()); } else { returnCode = new String(ReturnCode.DELETE_ERROR.toString()); } break; case 4: if (status > 0) { returnCode = ReturnCode.AUDITING_SUCCESS.toString(); } else { returnCode = ReturnCode.AUDITING_ERROR.toString(); } break; case 5: if(status > 0){ returnCode = new String(ReturnCode.FINANCE_PAY_SUCCESS.toString()); }else{ returnCode = new String(ReturnCode.FINANCE_PAY_ERROR.toString()); } break; default: returnCode = new String(ReturnCode.OPERATE_ERROR.toString()); break; } return returnCode; }
返回值工具类:
package com.chinadatapay.util; import java.io.UnsupportedEncodingException; public enum ReturnCode { SAVE_SUCCESS("0001","保存成功"), SAVE_ERROR("0002","保存失败"), UPDATE_SUCCESS("0003","修改成功"), UPDATE_ERROR("0004","修改失败"), DELETE_SUCCESS("0005","删除成功"), DELETE_ERROR("0006","删除失败"), USERORPWD_ERROR("0007","用户名或者密码不正确"), CODE_ERROR("0008","验证码不正确"), HAVE_SUB_INTERFACE("0009","该接口包含子接口,删除失败"), USER_EXIST_ERROR("0010","帐号已存在"), ROLE_POWER_SUCCESS("0011","权限分配成功"), ROLE_POWER_ERROR("0012","权限分配失败"), UPLOAD_SUCCESS("0013","上传图片成功"), UPLOAD_ERROR("0014","上传图片失败"), ACCOUNT_NONENTITY("0015","帐号不存在"), USER_DIMISSION("0016","用户已离职"), INTERCALATE_SUCCESS("0017","设置成功"), INTERCALATE_ERROR("0018","设置失败"), BUY_SUCCESS("0019","购买成功"), BUY_ERROR("0020","购买失败"), PAY_SUCCESS("0023","支付成功"), PAY_ERROR("0022","支付失败"), OPERATE_SUCCESS("0024","操作成功"), OPERATE_ERROR("0025","操作失败"), COLLECT_ERROR("0026","收藏失败"), COLLECT_SUCCESS("0027","已加入收藏"), AUDITING_SUCCESS("0028","审核成功"), AUDITING_ERROR("0029","审核失败"), UPLOADFILE_SUCCESS("0030","上传文件成功"), UPLOAFILE_ERROR("0031","上传文件失败"), CANCEL_SUCCESS("32","取消成功"), CANCEL_ERROR("33","取消失败"), ORIGINAL_ERROR("0034","原始密码输入错误"), BLANCE_LESSTHAT("0035","余额不足,请选择其他方式支付"), NOTPAID_ORDER("0036", "未支付订单"), USER_LOGIN_SUCCESS("0","登陆成功"), ROLE_USER_ERROR("0037","删除失败,请先删除角色下用户"), UPLOAD_ASTRICT("0038","只能上传图片"), ADDINTERFACE_ERROR("0039","有相同的接口名称"), ENTERING_SUCCESS("0040","录入成功"), ENTERING_ERROR("0041","录入失败"), MOBILE_EXIST_ERROR("0042", "手机号码已存在"), Email_EXIST_ERROR("0043", "邮箱已存在"), EMAIL_FORMAT_ERROR("0044","电子邮箱格式错误"), MOBILE_FORMAT_ERROR("0045","手机号码格式错误"), ACCOUNT_FREEZE_ERROR("0046","帐号已冻结,请联系管理员"), HAVE_SUB_CATEGORY("0047","该类别包含子类别,删除失败"), UPLOAD_ERRORSIZE("0048","图片大小不可超出2M"), CATEGORY_INCLUDE_INTERFACE("0049", "该类别包含上架接口,删除失败"), NOT_CATEGORY_URL("0050","接口类别方法名为空,保存接口失败"), EXPORT_SUCCESS("0051","导出成功"), EXPORT_ERROR("0052","导出失败"), DEOXIDIZE_SUCCESS("0053","还原成功"), DEOXIDIZE_ERROR("0054","还原失败"), FINANCE_PAY_SUCCESS("0055","付款成功"), FINANCE_PAY_ERROR("0056","付款失败"), LEADINGIN_SUCCESS("0057","导入成功"), LEADINGIN_ERROR("0058","导入失败"), UPLOAD_FILE_ASTRICT("0059","只能导入Excel文件"), FILE_NULL("0060","没有导入数据"), FINANCE_DELETE_ERROR("0061","该记录财务已确认,删除失败"), FINANCE_CECONFIRM_SUCCESS("0062","财务确认成功"), FINANCE_CECONFIRM_ERROR("0063","财务驳回成功"), ADJUST_DELETE_ERROR("0064","该记录已审核,删除失败"), LOGIN_ERROR("0065", "登陆超时,请重新登陆"), PARAM_INPUT_ERROR("0066","参数错误"), ROLE_EXIST_ERROR("0067", "角色已存在"); private String code; private String message; private ReturnCode(String code, String message) { this.code = code; this.message = message; } public String getCode() { return code; } public void setCode(String code) { this.code = code; } public String getMessage() { return message; } public void setMessage(String message) { this.message = message; } @SuppressWarnings("finally") @Override public String toString() { String result = "{\"code\":"+"\""+this.code+"\""+",\"message\":"+"\""+this.message+"\""+"}"; try { result = new String(result.getBytes("utf-8"), "utf-8"); } catch (UnsupportedEncodingException e) { result = e.getMessage(); e.printStackTrace(); } finally{ return result; } } }