public static void checkUpdateCounts(int[] updateCounts) {
for (int i = 0; i < updateCounts.length; i++) {
if (updateCounts[i] >= 0) {
logger.info("checkUpdateCounts: Successfully executed; updateCount=" + updateCounts[i]);
} else if (updateCounts[i] == Statement.SUCCESS_NO_INFO) {
logger.info(
"checkUpdateCounts: Successfully executed; updateCount=Statement.SUCCESS_NO_INFO");
} else if (updateCounts[i] == Statement.EXECUTE_FAILED) {
logger.info("checkUpdateCounts: Failed to execute; updateCount=Statement.EXECUTE_FAILED");
}
}
}
public static void freeCon(Connection con) {
try {
if (con != null) {
con.close();
con = null;
}
} catch (SQLException sqle) {
logger.error("freeCon:", sqle);
}
}
public static void freeUp(ResultSet rsCntSize, PreparedStatement ps0) {
try {
if (rsCntSize != null) {
rsCntSize.close();
rsCntSize = null;
}
if (ps0 != null) {
ps0.close();
ps0 = null;
}
} catch (SQLException sqle) {
logger.warn("freeUp: Error: ", sqle);
}
}
/** @author ravikishores */
public class VMSDAOUtils {
static Logger logger = Logger.getLogger(VMSDAOUtils.class.getName());
public static String getUrl(String dbname, String dbserver, String domain) throws Exception {
// jdbc:jtds:<server_type>://<server>[:<port>][/<database>]
String url = null;
// String url = "jdbc:jtds:sqlserver://"+ dbserver +":1433/"+dbname+ ";domain=LDS";
if (domain.equalsIgnoreCase(VMSStaticParams.BEALIAS)) {
url =
VMSStaticParams.DB_URL_PREFIX
+ dbserver
+ ":"
+ VMSStaticParams.MSSQL_PORT
+ "/"
+ dbname;
} else if (domain.equalsIgnoreCase(VMSStaticParams.FEALAIS)) {
url =
VMSStaticParams.DB_URL_PREFIX
+ dbserver
+ VMSStaticParams.FESUFFIX
+ ":"
+ VMSStaticParams.MSSQL_PORT
+ "/"
+ dbname;
} else if (domain.equalsIgnoreCase(VMSStaticParams.APACBEALIAS)) {
url =
VMSStaticParams.DB_URL_PREFIX
+ dbserver
+ VMSStaticParams.BESUFFIX_APAC
+ ":"
+ VMSStaticParams.MSSQL_PORT
+ "/"
+ dbname;
} else if (domain.equalsIgnoreCase(VMSStaticParams.APACFEALAIS)) {
url =
VMSStaticParams.DB_URL_PREFIX
+ dbserver
+ VMSStaticParams.FESUFFIX_APAC
+ ":"
+ VMSStaticParams.MSSQL_PORT
+ "/"
+ dbname;
}
return url;
}
// public static String getMyUrl(String dbname, String dbserver, int i) throws Exception {
// String url = null;
// if(i == 0) {
// url = VMSStaticParams.MYSQL_DB_URL_PREFIX + VMSStaticParams.MYSQL_DB_SERVER + ":" +
// VMSStaticParams.MYSQL_PORT + "/"
// + VMSStaticParams.MYSQL_DATABASE;
// } else if(i == 1){
// url = VMSStaticParams.DEST_MYSQL_DB_URL_PREFIX + VMSStaticParams.DEST_MYSQL_DB_SERVER
// + ":" + VMSStaticParams.DEST_MYSQL_PORT + "/"
// + VMSStaticParams.DEST_MYSQL_DATABASE;
// }
// System.out.println("URL returned: " + url);
// logger.info("URL returned: " + url);
//
// return url;
// }
/** Creates a new instance of VMSDAOUtils */
public VMSDAOUtils() {}
public static void freeCon(Connection con) {
try {
if (con != null) {
con.close();
con = null;
}
} catch (SQLException sqle) {
logger.error("freeCon:", sqle);
}
}
public static void freeUp(ResultSet rsCntSize, PreparedStatement ps0) {
try {
if (rsCntSize != null) {
rsCntSize.close();
rsCntSize = null;
}
if (ps0 != null) {
ps0.close();
ps0 = null;
}
} catch (SQLException sqle) {
logger.warn("freeUp: Error: ", sqle);
}
}
public static void checkUpdateCounts(int[] updateCounts) {
for (int i = 0; i < updateCounts.length; i++) {
if (updateCounts[i] >= 0) {
logger.info("checkUpdateCounts: Successfully executed; updateCount=" + updateCounts[i]);
} else if (updateCounts[i] == Statement.SUCCESS_NO_INFO) {
logger.info(
"checkUpdateCounts: Successfully executed; updateCount=Statement.SUCCESS_NO_INFO");
} else if (updateCounts[i] == Statement.EXECUTE_FAILED) {
logger.info("checkUpdateCounts: Failed to execute; updateCount=Statement.EXECUTE_FAILED");
}
}
}
/**
* @param rs1
* @param st1
* @throws SQLException
*/
public static void cleanUp(ResultSet rs1, Statement st1) throws SQLException {
if (rs1 != null) {
rs1.close();
rs1 = null;
}
if (st1 != null) {
st1.close();
st1 = null;
}
}
/**
* @param con
* @param useDB
* @return
* @throws SQLException
*/
public static int runQueryCom(Connection con, String useDB) throws SQLException {
PreparedStatement st0 = con.prepareStatement(useDB);
int num = st0.executeUpdate();
st0.close();
st0 = null;
return num;
}
/**
* @param con
* @param qry
* @return
* @throws SQLException
*/
public static Vector runQuery(Connection con, String qry) throws SQLException {
Vector res = new Vector();
PreparedStatement st1 = con.prepareStatement(qry);
ResultSet rs1 = st1.executeQuery();
while (rs1.next()) {
res.add(new Integer(rs1.getInt(1)));
}
// free resources
freeUp(rs1, st1);
return res;
}
}