sophyly
- 浏览: 11323 次
- 性别:
- 来自: 成都
-
最新评论
文章列表
import java.util.Date;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.commons.utils.DateUtil;
public class TestJson2 {
public static void main(String[] args) {
Date dateStart=new Date();
String dateStartFormat="";
dateStart ...
import java.io.StringReader;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.alibaba.fastjson.JSONReader;
publi ...
--0、导出数据 将数据导出为excel，再复制到UE中，保存为txt格式
select '"' ||ECIF_CUST_NO|| '",'||'"' ||replace (name,' ','') || '",'||'"' ||CERT_TYPE|| '",'||'"' ||CERT_NO || '"' as A
from t_usr_reg_info where USER_CERT_LEVEL = '05' and ECIF_CUST_NO is null ;
--1、创建临时表
crea ...
--将已导入ecc_base_order_his历史表中的ECC_CYCLE_TRANSFER_ACCOUNTS数据有效期未过期预约类数据copy到
--ecc_base_order中
insert into ecc_base_order ebo
select * from (select his.* from ecc_base_order_his his
where his.order_no in(select b.order_no from ecc_cycle_transfer_accounts b left join ecc_base_order a
on a.order ...
往eccOrderLog表中插入多条数据
public void saveEccOrderLogAAList(List<EccPayDetail> eccPayDetails , String flag, String userId , String newStatus ){
StringBuilder qlSB = new StringBuilder(" insert into ecc_order_log (seq_no , order_no , order_action , old_order_status ,"
+ &quo ...
工具类：SqlInConditionStringUtil
其中：getOracleSQLIn方法适合单一SQL语句
getOracleSQLIn方法适合嵌套SQL语句
public static String getOracleSQLIn(List<String> ids, int count, String field) {
count = Math.min(count, 1000);
int len = ids.size();
int size = len % count;
if ( ...
--企业基本业务信息，更新有效业务号字段，成链
PROCEDURE SJBL_GXYXYWH(v_PRIPID IN VARCHAR2) AS
TYPE T_DS IS TABLE OF VARCHAR2(24);
r_ZCDJYWSEQ_DS T_DS;
-- 动态seq
v_SQL VARCHAR2(200);
BEGIN
--v_SQL := 'SELECT ZCDJYWSEQ FROM T_REG_QYJGJBXXYW WHERE PRIPID = :v_PRIPID ORDER BY APPRDAT ...
/**
* <p>Method ：queryMzjInfo
* <p>Description : 民政局信息查询
*
* @param mzjInfo
* @param pageNum
* @param pageSize
* @return
*/
public QueryResult queryMzjInfo(MzjQueryConditionPoJo mzjInfo, int pageNum, int pageSize){
List<FrkMzjMbstjbxx> estInfoList = thi ...
SQL语句：
/**
* <p>Method ：queryMzjInfo
* <p>Description : 民政局信息查询
*
* @param mzjInfo
* @param pageNum
* @param pageSize
* @return
*/
@SuppressWarnings("unchecked")
public List<FrkMzjMbstjbxx> queryMzjInfo(final MzjQueryConditionPoJo mzjInfo, fin ...
HQL 语句
/**
* <p>Method ：queryEstInfoList
* <p>Description : 股权查询列表
*
* @param estQueryBean
* @param pageNum
* @param pageSize
* @return
*/
@SuppressWarnings("unchecked")
@Override
public List<FrkGsjQyjgdjxx> queryEstInfoList(final FrkGsjQyj ...
ACtion代码：
public class PedigreeAction extends BaseAction{
public PedigreeQueryBO pedigreeQueryBO;
public void setPedigreeQueryBO(PedigreeQueryBO pedigreeQueryBO) {
this.pedigreeQueryBO = pedigreeQueryBO;
}
@SuppressWarnings("unchecked")
public String getPedigreeDetail() ...
定期更新数据，以便统计；定期设置使用job
create or replace procedure CSHCYBQ(v_CSNF in varchar2) as
v_DQNY varchar2(6);--当前年月
v_TJNY varchar2(6);--统计年月
v_SCNY varchar2(6);--上一次统计年月
v_TJNJ varchar2(6);--统计年季
v_TJNF varchar2(4);--统计年份
v_TJYF number(2);--统计月份
v_T ...
获取组织机构代码，以'a','b'...形式返回
比如：若为211241003 返回： '211241003','211241','211200','210000'
211241 返回：'211241','211200','210000'
211200 返回：'211200','210000'
210000 返回：'210000'
CREATE OR REPLACE FUNCTION GET_PARENT_ORGCODE(in_code IN VARCHAR2)
RETURN VARCHAR2
...