package com.vci.server.bof.utils;
|
|
import java.io.BufferedReader;
|
import java.io.IOException;
|
import java.io.Reader;
|
import java.math.BigDecimal;
|
import java.sql.Clob;
|
import java.sql.ResultSet;
|
import java.sql.SQLException;
|
import java.util.ArrayList;
|
import java.util.HashMap;
|
import java.util.Map;
|
|
import com.vci.corba.omd.atm.AttribItem;
|
import com.vci.corba.omd.data.AttributeValue;
|
import com.vci.corba.omd.data.BusinessObject;
|
|
public class ServerObjectUtil {
|
|
private static ServerObjectUtil instance = null;
|
|
private ServerObjectUtil() {
|
|
}
|
|
public static synchronized ServerObjectUtil getInstance() {
|
if (instance == null) {
|
instance = new ServerObjectUtil();
|
}
|
|
return instance;
|
}
|
|
|
public static BusinessObject createBOByRS(AttribItem[] attrItems, ResultSet rs) throws SQLException {
|
BusinessObject bo = new BusinessObject();
|
|
int index = 1;
|
|
bo.oid = rs.getString(index++);
|
bo.revisionid = rs.getString(index++);
|
bo.nameoid = rs.getString(index++);
|
bo.btName = rs.getString(index++);
|
bo.isLastR = rs.getInt(index++) != 0;
|
bo.isFirstR = rs.getInt(index++) != 0;
|
bo.isLastV = rs.getInt(index++) != 0;
|
bo.isFirstV = rs.getInt(index++) != 0;
|
bo.creator = rs.getString(index++);
|
bo.createTime = rs.getTimestamp(index++).getTime();
|
bo.modifier = rs.getString(index++);
|
bo.modifyTime = rs.getTimestamp(index++).getTime();
|
bo.revisionRule = rs.getString(index++);
|
bo.versionRule = rs.getString(index++);
|
bo.revisionSeq = rs.getShort(index++);
|
bo.revisionValue = rs.getString(index++);
|
bo.versionSeq = rs.getShort(index++);
|
bo.versionValue = rs.getString(index++);
|
bo.lctId = rs.getString(index++);
|
bo.lcStatus = rs.getString(index++);
|
bo.ts = rs.getTimestamp(index++).getTime();
|
bo.id = rs.getString(index++);
|
bo.name = rs.getString(index++);
|
bo.description = rs.getString(index++);
|
bo.owner = rs.getString(index++);
|
bo.fromVersion = rs.getString(index++);
|
|
ArrayList<AttributeValue> list = new ArrayList<AttributeValue>();
|
for (int i = 0; i < attrItems.length; i++) {
|
AttributeValue attrVal = new AttributeValue();
|
attrVal.attrName = attrItems[i].name;
|
attrVal.attrVal = rs.getString(index++);
|
list.add(attrVal);
|
}
|
bo.newAttrValList = new AttributeValue[0];
|
bo.hisAttrValList = list.toArray(new AttributeValue[list.size()]);
|
|
return bo;
|
}
|
|
|
|
public String tansferSystemDBDateToString(Map<String, String> attrType, String attributeName, Object value) {
|
if (value == null) {
|
return "";
|
}
|
String rsValue = "";
|
String dType = attrType.get(attributeName);
|
try {
|
if (dType.equals("VTString")){
|
rsValue = value.toString();
|
} else if (dType.equals("VTInteger")){
|
rsValue = ((BigDecimal)value).toString();
|
} else if (dType.equals("VTLong")){
|
rsValue = ((BigDecimal)value).toString();
|
} else if (dType.equals("VTDouble")){
|
rsValue = ((BigDecimal)value).toString();
|
} else if (dType.equals("VTBoolean")){
|
rsValue = (String)value;
|
} else if (dType.equals("VTImage")){
|
rsValue = (String)value;
|
} else if (dType.equals("VTDate")){
|
// rsValue = String.valueOf(((java.sql.Timestamp)value).getTime());
|
if (value instanceof java.sql.Date) {
|
long time = ((java.sql.Date)value).getTime();
|
rsValue = ((Long)time).toString();
|
} else if (value instanceof java.sql.Timestamp){
|
long time = ((java.sql.Timestamp)value).getTime();
|
rsValue = ((Long)time).toString();
|
}
|
} else if (dType.equals("VTTime")){
|
// rsValue = String.valueOf(((java.sql.Timestamp)value).getTime());
|
rsValue = ((java.sql.Timestamp)value).toString();
|
} else if (dType.equals("VTDateTime")) {
|
// rsValue = String.valueOf(((java.sql.Timestamp)value).getTime());
|
if (value instanceof java.sql.Date) {
|
long time = ((java.sql.Date)value).getTime();
|
rsValue = ((Long)time).toString();
|
} else if (value instanceof java.sql.Timestamp){
|
long time = ((java.sql.Timestamp)value).getTime();
|
rsValue = ((Long)time).toString();
|
}
|
} else if (dType.equals("VTNote")){
|
rsValue = (String)value;
|
} else if (dType.equals("VTFilePath")) {
|
rsValue = (String)value;
|
} else if (dType.equals("VTClob")) {
|
rsValue = clobToString((java.sql.Clob)value);
|
} else {
|
rsValue = (String)value;
|
}
|
} catch (Exception e) {
|
rsValue = "";
|
e.printStackTrace();
|
}
|
|
return rsValue;
|
}
|
|
public String tansferTypeDBDateToString(String attrType, Object value) {
|
if (value == null) {
|
return "";
|
} else if (value.equals("")) {
|
return "";
|
}
|
String rsValue = "";
|
|
if (attrType.equals("VTString")){
|
rsValue = String.valueOf(value);
|
} else if (attrType.equals("VTInteger")){
|
rsValue = ((BigDecimal)value).toString();
|
} else if (attrType.equals("VTLong")){
|
rsValue = ((BigDecimal)value).toString();
|
} else if (attrType.equals("VTDouble")){
|
rsValue = ((BigDecimal)value).toString();
|
} else if (attrType.equals("VTBoolean")){
|
rsValue = (String)value;
|
} else if (attrType.equals("VTImage")){
|
rsValue = (String)value;
|
} else if (attrType.equals("VTDate")){
|
if (value instanceof java.sql.Date) {
|
rsValue = ((java.sql.Date)value).toString();
|
} else if (value instanceof java.sql.Timestamp){
|
rsValue = ((java.sql.Timestamp)value).toString();
|
}
|
} else if (attrType.equals("VTTime")){
|
rsValue = ((java.sql.Timestamp)value).toString();
|
} else if (attrType.equals("VTDateTime")) {
|
if (value instanceof java.sql.Date) {
|
rsValue = ((java.sql.Date)value).toString();
|
} else if (value instanceof java.sql.Timestamp){
|
rsValue = ((java.sql.Timestamp)value).toString();
|
}
|
} else if (attrType.equals("VTNote")){
|
rsValue = (String)value;
|
} else if (attrType.equals("VTFilePath")) {
|
rsValue = (String)value;
|
} else if (attrType.equals("VTClob")) {
|
rsValue = clobToString((java.sql.Clob)value);
|
} else {
|
rsValue = (String)value;
|
}
|
return rsValue;
|
}
|
|
/**
|
* clob转String
|
* @param value
|
* @return
|
*/
|
private String clobToString(Clob value) {
|
// TODO Auto-generated method stub
|
String clobValue = "";
|
try {
|
Reader is = value.getCharacterStream();
|
BufferedReader br = new BufferedReader(is);
|
String s = br.readLine();
|
StringBuffer sb = new StringBuffer();
|
while(s!=null){
|
sb.append(s);
|
s=br.readLine();
|
}
|
clobValue = sb.toString();
|
} catch (SQLException e) {
|
e.printStackTrace();
|
} catch (IOException e) {
|
// TODO Auto-generated catch block
|
e.printStackTrace();
|
}
|
|
return clobValue;
|
}
|
|
public String tansferTypeDBDateToString(
|
HashMap<String, String> bO_CONSTANTS, String attrType,
|
Object attributeValue) {
|
// TODO Auto-generated method stub
|
return null;
|
}
|
}
|
