DBContorller1

package com.huawei.common;

import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.IOException;
import java.io.Reader;
import java.io.StringReader;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import org.apache.log4j.Logger;

import com.huawei.bo.EsbRequest;
import com.huawei.bo.MsgBO;
import com.huawei.db.Configuration;
import com.huawei.db.ConnectionPoolFactory;
import com.huawei.db.DBTools;

public class DBController {
protected Connection conn;

protected static Logger log = Logger.getLogger(DBController.class); // 日志

public boolean initConnect() {
try {
this.conn = ConnectionPoolFactory.getConnection();
} catch (SQLException e) {
// TODO Auto-generated catch block
// e.printStackTrace();
log.error("InitConnect Err:(SQL)" + e);
return false;
} catch (IOException e) {
// TODO Auto-generated catch block
// e.printStackTrace();
log.error("InitConnect Err:(IO)" + e);
}

return true;
}

/**
* 获取Sequences
*
* @param seqName
* @return
*/
public String getNextSeqId(String seqName) {
StringBuffer buf = new StringBuffer(32);

buf.append("select ").append(seqName).append(".nextval")
.append(" from dual");

// 初始化连接
initConnect();

return getResultString(buf.toString());
}

public String getCuurentSeqId(String seqName) {
StringBuffer buf = new StringBuffer(32);

buf.append("select ").append(seqName).append(".currval")
.append(" from dual");

// 初始化连接
initConnect();

return getResultString(buf.toString());
}

/**
* 简单SQL，单值查询结果
*
* @param sql
* @return
*/
public String getResultString(String sql) {
java.sql.PreparedStatement stmt = null;
java.sql.ResultSet rs = null;
String result = null;

try {
stmt = this.conn.prepareStatement(sql);

rs = stmt.executeQuery();

while (rs.next()) {
result = rs.getObject(1).toString();

return result;
}

} catch (SQLException e) {
// TODO Auto-generated catch block
// e.printStackTrace();
log.error("SQL Err(getResultString):" + e);
throw new BaseException(e);
} finally {
DBTools.close(rs);
DBTools.close(stmt);
ConnectionPoolFactory.freeConn(conn);
}

throw new BaseException("Canot found any data by sql [" + sql + "]");

}