oracle
weixin_39507514
面试就是在最好的时间内遇到最合适的彼此
展开
-
ssm调用存贮过程
service: /** * 修改状态 * @param receiveEntity * @return / public String[] updateStatus(ReceiveEntity receiveEntity){ String id = super.save(receiveEntity); Map<String,Object> map = new HashMap<S...原创 2019-01-23 10:43:34 · 432 阅读 · 0 评论 -
ssm调用存贮过程二
controller: ** * 批量計算 * @param orderdid * @return */ @ResponseBody @RequestMapping(value = “updateAllTB”, method = RequestMethod.POST, produces=“text/html;charset=UTF-8”) public String updateAllStatus...原创 2019-01-23 10:47:48 · 155 阅读 · 0 评论 -
oracle中的merge into,截取,金额格式化
MERGE INTO HSJG_TB_PULL_SCHEDUL tab1 USING (SELECT * FROM HSJG_TB_PRODUCTION_ORDER WHERE ID IN #{item} ) tab2 ON (tab1.PRODU...原创 2019-01-23 10:50:51 · 262 阅读 · 0 评论 -
自定义resultMap,使用wm_concat函数,创建索引
select A.orderid, wm_concat(A.prostatus3||'已'||A.sprocessname) softstatus from (select max(orderid...原创 2019-01-23 10:57:21 · 195 阅读 · 0 评论 -
通过后台,防止重复添加
service: //把工艺路线中的工序依次写入生产订单工序列里 StringBuffer Str = new StringBuffer(); for (int i=0;i&amp;lt;ids.length;i++){ Str.append(ids[i]); if(i != ids.length-1){ Str.append(&quot;,&quot;); } } StringBuffer Str2 = new Strin...原创 2019-01-23 11:02:09 · 487 阅读 · 0 评论