|
楼主 |
发表于 2014-9-11 08:05:20
|
显示全部楼层
- public static String Update_CM_Data(String CBTZDID,String TTL_BZH,String HT_BZH,String QKSM){
- String sqlselect="select count(*) as count1 from TB_SHIPNAME_TJ_ABS a where a.CBTZDID='"+CBTZDID+"'";
- String username=ContextHelper.getPerson().getName();
- String userid=ContextHelper.getPerson().getID();
- String guids=com.justep.system.util.CommonUtils.createGUID();
-
- Map<String,String> maps=new HashMap<String,String>();
- maps.put(DatabaseProduct.ORACLE.name(), sqlselect);
- int count2=0;//返回是否成功
- int count=Integer.parseInt(SQL.select(maps, null, "/production/business/yulang/ttjhltj/data").iterator().next().getDecimal(0).toString());
- if(count==0){//没有数据就添加insert
- String sqlInsert="insert into TB_SHIPNAME_TJ_ABS( CBTZDID,TTL_BZH,HT_BZH,QKSM,INSERT_DATE,INSERT_USERNAME,INSERT_USERID) values ('"+CBTZDID+"','"+TTL_BZH+"','"+HT_BZH+"','"+QKSM+"',sysdate,'"+username+"','"+userid+"')";
- Map<String,String> maps1=new HashMap<String,String>();
- maps1.put(DatabaseProduct.ORACLE.name(), sqlInsert);
- count2= Integer.parseInt(SQL.select(maps1, null, "/production/business/yulang/ttjhltj/data").iterator().next().getDecimal(0).toString());
-
- }else{//有数据就更新
-
- String sqlUpdate="update TB_SHIPNAME_TJ_ABS set TTL_BZH='"+TTL_BZH+"',HT_BZH='"+HT_BZH+"',QKSM='"+QKSM+"',INSERT_DATE=sysdate,INSERT_USERNAME='"+username+"',INSERT_USERID='"+userid+"' where CBTZDID='"+CBTZDID+"'";
- Map<String,String> maps2=new HashMap<String,String>();
- maps2.put(DatabaseProduct.ORACLE.name(), sqlUpdate);
- count2=Integer.parseInt(SQL.select(maps2, null, "/production/business/yulang/ttjhltj/data").iterator().next().getDecimal(0).toString());
- }
- if(count2>0){
-
- return "'flag':true";
- }else{
-
- return "'flag':false";
- }
-
- }
复制代码 |
|