String sql_sp="select lengthb(TRIM(fhmc)) as lfh,lengthb(TRIM(shmc)) as lsh,lengthb(TRIM(pzmc)) as lpm,TRIM(fhmc) AS FHMC ,TRIM(shmc) AS SHMC,TRIM(pzmc) AS PZMC from v_jjd where jjdh='"+rs.getString("jjdh")+"' and clsh='"+rs.getString("clsh")+"'";
ResultSet rs1=db.executeQuery(sql_sp);
rs1.next();
fh=rs1.getString("fhmc");
sh=rs1.getString("shmc");
pm=rs1.getString("pzmc");
lfh=80 - rs1.getInt("lfh");
lsh=50 - rs1.getInt("lsh");
lpm=30 - rs1.getInt("lpm");
for(int a=0;a<lpm;a++)
{
pm=pm+" ";
}
for(int b=0;b<lfh;b++)
{
fh=fh+" ";
}
for(int c=0;c<lsh;c++)
{
sh=sh+" ";
}
up_sql="insert into bgjl.TBDIPDO (TIMESTAMP, SERIALNO ,QUEUEID , HEADER , DATA , STATUS , PROCESSTIME ,DESCRIPTION) (select "+sjc+",000,rpad('mrc1',12,' '),rpad('384',12,' ')||rpad('10.10.1.2',50,' ')||rpad('mrc1',12,' ')||to_char(sysdate,'yyyymmddhhmiss')||' '||' 3'||'1'||' '||' '||' '||' ','mrc1'||rpad(pzbh,6,' ')||'"+pm+"'||rpad(cpbh,7,' ')||' '||to_char(jjsj,'yyyymmddhhmmss') ||rpad(shbh,6,' ')||rpad(fhbh,6,' ')||'"+fh+"'||'"+sh+"'||rpad(clsh,3,' ')||'"+lb+"'||rpad(to_char(wzqz),8,' ')||rpad(to_char(kczl),6,' ')||rpad(to_char(wzqz-kczl),6,' ')||rpad(' ',20,' '),'N',to_char(sysdate,'yyyymmddhhmiss'),'' from v_jjd where jlbh='"+rs.getString("jlbh")+"' and clsh='"+rs.getString("clsh")+"'and shbj=0) ";
sh_sql="update jl_cl_jjd set shbj=9,shrm='"+user_id+"',shsj=to_date('" + dtime+ "','yyyy-mm-dd hh24:mi:ss') where jlbh='"+rs.getString("jlbh")+"' and clsh='"+rs.getString("clsh")+"' and shbj=0";
ResultSet rs1=db.executeQuery(sql_sp);
rs1.next();
fh=rs1.getString("fhmc");
sh=rs1.getString("shmc");
pm=rs1.getString("pzmc");
lfh=80 - rs1.getInt("lfh");
lsh=50 - rs1.getInt("lsh");
lpm=30 - rs1.getInt("lpm");
for(int a=0;a<lpm;a++)
{
pm=pm+" ";
}
for(int b=0;b<lfh;b++)
{
fh=fh+" ";
}
for(int c=0;c<lsh;c++)
{
sh=sh+" ";
}
up_sql="insert into bgjl.TBDIPDO (TIMESTAMP, SERIALNO ,QUEUEID , HEADER , DATA , STATUS , PROCESSTIME ,DESCRIPTION) (select "+sjc+",000,rpad('mrc1',12,' '),rpad('384',12,' ')||rpad('10.10.1.2',50,' ')||rpad('mrc1',12,' ')||to_char(sysdate,'yyyymmddhhmiss')||' '||' 3'||'1'||' '||' '||' '||' ','mrc1'||rpad(pzbh,6,' ')||'"+pm+"'||rpad(cpbh,7,' ')||' '||to_char(jjsj,'yyyymmddhhmmss') ||rpad(shbh,6,' ')||rpad(fhbh,6,' ')||'"+fh+"'||'"+sh+"'||rpad(clsh,3,' ')||'"+lb+"'||rpad(to_char(wzqz),8,' ')||rpad(to_char(kczl),6,' ')||rpad(to_char(wzqz-kczl),6,' ')||rpad(' ',20,' '),'N',to_char(sysdate,'yyyymmddhhmiss'),'' from v_jjd where jlbh='"+rs.getString("jlbh")+"' and clsh='"+rs.getString("clsh")+"'and shbj=0) ";
sh_sql="update jl_cl_jjd set shbj=9,shrm='"+user_id+"',shsj=to_date('" + dtime+ "','yyyy-mm-dd hh24:mi:ss') where jlbh='"+rs.getString("jlbh")+"' and clsh='"+rs.getString("clsh")+"' and shbj=0";
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货