Java后端完成保存或更新功能笔记整理

清疚 2022-09-16 00:30 192阅读 0赞

本文只是一个项目开发过程中的整理笔记，主要介绍两种后台保存数据思路。  
总体架构Spring+SpringMVC+Hibernate+Shiro+Oracle

# 思路一： #

实体类  
AACMyfocusTab

@Entity
    @Table(name="AAC_MYFOCUS_TAB")
    //我的关注
    public class AACMyfocusTab implements Serializable{ 
        private String id;//主键id
        private String adnum;//域账号
        private String wfcode;//流程编号
        private String updateTime;//更新时间
        private String formSource;//所属系统
        private String shortName;// 具体名称 
        private String type;//所属领域 
    
        public AACMyfocusTab() { 
        }
        
        @Id
        @Column(name = "ID", unique = true, length = 100)
        public String getId() { 
            return id;
        }
    
        public void setId(String id) { 
            this.id = id;
        }
        @Column(name = "ADNUM", length = 100)
        public String getAdnum() { 
            return adnum;
        }
    
        public void setAdnum(String adnum) { 
            this.adnum = adnum;
        }
        @Column(name = "WFCODE", length = 100)
        public String getWfcode() { 
            return wfcode;
        }
    
        public void setWfcode(String wfcode) { 
            this.wfcode = wfcode;
        }
        @Column(name = "UPDATETIME", length = 100)
        public String getUpdateTime() { 
            return updateTime;
        }
    
        public void setUpdateTime(String updateTime) { 
            this.updateTime = updateTime;
        }
        @Column(name = "FORM_SOURCE", length = 100)
        public String getFormSource() { 
            return formSource;
        }
    
        public void setFormSource(String formSource) { 
            this.formSource = formSource;
        }
        @Column(name = "SHORT_NAME", length = 100)
        public String getShortName() { 
            return shortName;
        }
    
        public void setShortName(String shortName) { 
            this.shortName = shortName;
        }
        @Column(name = "TYPE", length = 100)
        public String getType() { 
            return type;
        }
    
        public void setType(String type) { 
            this.type = type;
        }
    }

onTheWayFocus.jsp

//将关注信息保存到数据库表AAC_MYFOCUS_TAB中
    var selectedRows = window.frames[0].$("#dg").datagrid('getChecked');
    var formSource = [];
    var wfcode = [];
    var shortName = [];
    var type = [];
    for(i=0;i<selectedRows.length;i++){ 
           formSource.push(selectedRows[i].BELONGSYSTEM||"");
           wfcode.push(selectedRows[i].PROCESSNUMBER||"");
    	   shortName.push(selectedRows[i].PROCESSNAME||"");
    	   type.push(selectedRows[i].BELONGSFIELD||"");
    }
    				 
    $.ajax({ 
    			url : '${pageContext.request.contextPath}/bpmportal/BpmMyFocusController/focus.action',
    			data : { 
    					formSource:formSource,
    					wfcode:wfcode,
    					shortName:shortName,
    					type:type
    				   },
    			type : 'post',
    			async : false,
    			dataType : 'json',
    			success : function(data) { 
    						 if(data.state){ 
    						      	$("#Dlg_Position").dialog("close");
    						       	$.messager.alert({ title:"提示",msg:"保存关注成功！"});  
    						 }else{ 
    						       	$.messager.alert({ title:"提示",msg:"保存关注出错，请联系管理员！"});  
    						      }     
    					  },
    			error : function() { 
    						$.messager.alert({ title:"提示",msg:"保存出错，请联系管理员！"});
    							}
    					});

BpmMyFocusController

@Controller
    @RequestMapping("/bpmportal/BpmMyFocusController")
    public class BpmMyFocusController extends BaseWebController { 
    	private static final Logger LOG = LoggerFactory.getLogger(BpmMyFocusController.class);
    	@Autowired
    	private BpmMyFocusService bpmMyFocusService;
    
    	// 我的关注保存功能
    	@RequestMapping("/focus")
    	@ResponseBody
    	public Map<String, Object> MyFocus(@RequestParam("formSource[]") List<String> formSource,
    			@RequestParam("wfcode[]") List<String> wfcode, @RequestParam("shortName[]") List<String> shortName,
    			@RequestParam("type[]") List<String> type) { 
    		Map<String, Object> results = new HashMap<String, Object>();
    		try { 
    			bpmMyFocusService.saveOrUpdateFocus(formSource, wfcode, shortName, type);
    			results.put("state", true);
    			results.put("msg", "我的关注保存成功！");
    		} catch (Exception e) { 
    			e.printStackTrace();
    			results.put("state", false);
    			results.put("msg", "我的关注保存失败：" + e.getMessage());
    		}
    		return results;
    	}
    }

BpmMyFocusService

@Service
    public class BpmMyFocusService extends BaseDataService { 
    	// 保存我的关注
    	public void saveOrUpdateFocus(List<String> formSource, List<String> wfcode, List<String> shortName,List<String> type) { 
    		//String userName = (String) SecurityUtils.getSubject().getSession().getAttribute(HttpSessionKey.CURRENT_USER_NUM);//empid
    		String userName = (String) SecurityUtils.getSubject().getSession().getAttribute(HttpSessionKey.CURRENT_USER_NAME);//adNum
    		SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");// 设置日期格式
    		String dateTime = df.format(new Date());// 获取当前日期
    		List<AACMyfocusTab> data = new ArrayList<>();
    		for (int i = 0; i < formSource.size(); i++) { 
    			AACMyfocusTab  aacMyfocusTab= new AACMyfocusTab();
    			String uuid = UUID.randomUUID().toString().replace("-", "");
    			aacMyfocusTab.setId(uuid);
    			aacMyfocusTab.setAdnum(userName);
    			if (!formSource.isEmpty()) { 
    				aacMyfocusTab.setFormSource(formSource.get(i));
    			} else { 
    				aacMyfocusTab.setFormSource("");
    			}
    			if (!shortName.isEmpty()) { 
    				aacMyfocusTab.setShortName(shortName.get(i));
    			} else { 
    				aacMyfocusTab.setShortName("");
    			}
    			
                if (!type.isEmpty()) { 
                	aacMyfocusTab.setType(type.get(i));
    			} else { 
    				aacMyfocusTab.setType("");
    			}
    			
                if (!wfcode.isEmpty()) { 
                	aacMyfocusTab.setWfcode(wfcode.get(i));
    			} else { 
    				aacMyfocusTab.setWfcode("");
    			}
                aacMyfocusTab.setUpdateTime(dateTime);
                //不保存已经关注过的流程
    			String sql = "select * from AAC_MYFOCUS_TAB where WFCODE = '"+wfcode.get(i)+"' " +" and ADNUM = '"+userName+"'";
                List list = gdao.executeJDBCSqlQuery(sql);
    			if(list.size() <= 0){ 
    				data.add(aacMyfocusTab);
    			}
    		}
    		gdao.save(data);
    	}
    }

# 思路二： #

onTheWayFocus.jsp

//将关注信息保存到数据库表AAC_MYFOCUS_TAB中
                var selectedRows = window.frames[0].$("#dg").datagrid('getChecked');
                var flag= 0;
                var hiddenArr = ['PU01','HR19','HR20','HR23','HR26']; //过滤敏感流程
    
                for(var i=0;i<selectedRows.length;i++){ 
                    if($.inArray(selectedRows[i].PROCESSNUMBER,hiddenArr) >= 0){ 
                        flag= 1;
                    }
                }
                if(selectedRows.length == 0 || flag == 1){ 
                    $.messager.alert({ 
                        title : '温馨提示',
                        msg : "请先勾选再操作且不能选择采购订单评审(PU01)、离职申请(HR19)、转正申请(HR20)、合同续签申请(HR23)、待录用人员信息系统(HR26)！"
                    });
                }else{ 
                    var list = [];
                    for(var i=0;i<selectedRows.length;i++){ 
                        var aacMyfocusTab = { };
                        var row = selectedRows[i];
                        aacMyfocusTab.formSource = row.BELONGSYSTEM||"";
                        aacMyfocusTab.wfcode = row.PROCESSNUMBER||"";
                        aacMyfocusTab.shortName = row.PROCESSNAME||"";
                        aacMyfocusTab.type = row.BELONGSFIELD||"";
                        list.push(aacMyfocusTab);
                    }
    
                    $.ajax({ 
                        url : '${pageContext.request.contextPath}/bpmportal/BpmMyFocusController/focus.action',
                        data : JSON.stringify(list),
                        type : 'post',
                        async : false,
                        dataType : 'json',
                        contentType : 'application/json;charset=utf-8',
                        success : function(data) { 
                            if(data.state){ 
                                $("#Dlg_Position").dialog("close");
                                $.messager.alert({ title:"提示",msg:"保存关注成功！"});
                            }else{ 
                                $.messager.alert({ title:"提示",msg:"保存关注出错，请联系管理员！"});
                            }
                        },
                        error : function() { 
                            $.messager.alert({ title:"提示",msg:"保存出错，请联系管理员！"});
                        }
                    });
    
                }

BpmMyFocusController

@Controller
    @RequestMapping("/bpmportal/BpmMyFocusController")
    public class BpmMyFocusController extends BaseWebController { 
    	private static final Logger LOG = LoggerFactory.getLogger(BpmMyFocusController.class);
    	@Autowired
    	private BpmMyFocusService bpmMyFocusService;
        private static final Logger LOG = LoggerFactory.getLogger(BpmMyFocusController.class);
        @Autowired
        private BpmMyFocusService bpmMyFocusService;
    
        // 我的关注保存功能
        @RequestMapping("/focus")
        @ResponseBody
        public Map<String, Object> MyFocus(@RequestBody List<AACMyfocusTab> AACMyfocusTabs) { 
            Map<String, Object> results = new HashMap<>();
            try { 
                bpmMyFocusService.saveOrUpdateFocus(AACMyfocusTabs);
                results.put("state", true);
                results.put("msg", "我的关注保存成功！");
            } catch (Exception e) { 
                e.printStackTrace();
                results.put("state", false);
                results.put("msg", "我的关注保存失败：" + e.getMessage());
            }
            return results;
        }
    }

BpmMyFocusService

@Service
    public class BpmMyFocusService extends BaseDataService { 
    // 保存我的关注
        public void saveOrUpdateFocus(List<AACMyfocusTab> AACMyfocusTabs) { 
            String userName = (String) SecurityUtils.getSubject().getSession().getAttribute(HttpSessionKey.CURRENT_USER_NAME);//adNum
            SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");// 设置日期格式
            String dateTime = df.format(new Date());// 获取当前日期
            for (int i = 0; i < AACMyfocusTabs.size(); i++) { 
                AACMyfocusTab aacMyfocusTab = AACMyfocusTabs.get(i);
                String formSource = aacMyfocusTab.getFormSource();
                String wfcode = aacMyfocusTab.getWfcode();
                String shortName = aacMyfocusTab.getShortName();
                String type = aacMyfocusTab.getType();
                String hql = "from AACMyfocusTab where adnum = '" + userName + "' and wfcode = '" + wfcode + "' and formSource = '" + formSource + "'";
                List<AACMyfocusTab> result = gdao.queryHQL(hql);
                if (result.size() > 0) { 
                    aacMyfocusTab = result.get(0);
                    aacMyfocusTab.setId(aacMyfocusTab.getId());
                } else { 
                    aacMyfocusTab = new AACMyfocusTab();
                    String uuid = UUID.randomUUID().toString().replace("-", "");
                    aacMyfocusTab.setId(uuid);
                }
                aacMyfocusTab.setAdnum(userName);
                aacMyfocusTab.setFormSource(formSource);
                aacMyfocusTab.setShortName(shortName);
                aacMyfocusTab.setType(type);
                aacMyfocusTab.setWfcode(wfcode);
                aacMyfocusTab.setUpdateTime(dateTime);
                gdao.saveOrUpdate(aacMyfocusTab);
              }
    }