再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;
}
}
}