/**
* Convenience method for selecting records. Ideally this should not be use, instead a custom
* query for this table should be used.
*
* @param where sql where statement.
* @param orderBy sql order by statement
*/
public ResultSet select(String where, String orderBy) {
ResultSet rs = null;
java.sql.Statement stmnt = null;
try {
stmnt = GenOrmDataSource.createStatement();
StringBuilder sb = new StringBuilder();
sb.append(SELECT);
sb.append(FROM);
if (where != null) {
sb.append(WHERE);
sb.append(where);
}
if (orderBy != null) {
sb.append(" ");
sb.append(orderBy);
}
String query = sb.toString();
rs = new SQLResultSet(stmnt.executeQuery(query), query, stmnt);
} catch (java.sql.SQLException sqle) {
try {
if (stmnt != null) stmnt.close();
} catch (java.sql.SQLException sqle2) {
}
throw new GenOrmException(sqle);
}
return (rs);
}
public String execute() throws Exception {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
/*Establish a connection with a data source*/
Connection con1 =
DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "yash", "yash");
String str = "SELECT * FROM employee";
java.sql.Statement stmt = con1.createStatement();
ResultSet rs = stmt.executeQuery(str);
while (rs.next()) {
if (id.equals(rs.getString(1))) {
name = rs.getString(2);
gen = rs.getString(9);
address = rs.getString(4);
phone = rs.getString(5);
email = rs.getString(6);
salary = rs.getString(7);
dob = rs.getDate(8);
doj = rs.getDate(10);
}
}
con1.close();
} catch (Exception e) {
}
return MANAGEEDIT;
}
/**
* Closes any underlying java.sql.Result set and java.sql.Statement that was used to create this
* results set.
*/
public void close() {
try {
m_resultSet.close();
m_statement.close();
} catch (java.sql.SQLException sqle) {
throw new GenOrmException(sqle);
}
}
/** Gets version number out of a database table. */
public Version(java.sql.Statement st, String sqlTable) throws SQLException {
ResultSet rs = st.executeQuery("select major,minor,rev from " + sqlTable);
rs.next();
major = rs.getInt("major");
minor = rs.getInt("minor");
rev = rs.getInt("rev");
rs.close();
}
/**
* This resets the key generator from the values in the database Usefull if the generated key
* has been modified via some other means Connection must be open before calling this
*/
public synchronized void reset() {
m_nextKey = 0;
java.sql.Statement stmnt = null;
java.sql.ResultSet rs = null;
try {
stmnt = GenOrmDataSource.createStatement();
rs = stmnt.executeQuery(MAX_QUERY);
if (rs.next()) m_nextKey = rs.getInt(1);
} catch (java.sql.SQLException sqle) {
// The exception may occur if the table does not yet exist
if (WARNINGS) System.out.println(sqle);
} finally {
try {
if (rs != null) rs.close();
if (stmnt != null) stmnt.close();
} catch (java.sql.SQLException sqle2) {
throw new GenOrmException(sqle2);
}
}
}
public DataPointKeyGenerator(javax.sql.DataSource ds) {
m_nextKey = 0;
java.sql.Connection con = null;
java.sql.Statement stmnt = null;
try {
con = ds.getConnection();
con.setAutoCommit(true);
stmnt = con.createStatement();
java.sql.ResultSet rs = stmnt.executeQuery(MAX_QUERY);
if (rs.next()) m_nextKey = rs.getInt(1);
rs.close();
} catch (java.sql.SQLException sqle) {
// The exception may occur if the table does not yet exist
if (WARNINGS) System.out.println(sqle);
} finally {
try {
if (stmnt != null) stmnt.close();
if (con != null) con.close();
} catch (java.sql.SQLException sqle) {
}
}
}
public void write_in_db(
int try_id,
int catch_id,
String try_con,
String catch_con,
String method_try_between_con,
String catch_exception,
String previous_catch_con,
String file_path,
String package_name,
String class_name,
String method_name,
int try_loc,
int is_try_logged,
int try_log_count,
String try_log_levels,
int is_catch_logged,
int catch_log_count,
String catch_log_levels,
int have_previous_catches,
int previous_catches_logged,
int is_return_in_try,
int is_return_in_catch,
int is_catch_object_ignore,
int is_interrupted_exception,
int is_thread_sleep_try,
int throw_throws_try,
int throw_throws_catch,
int if_in_try,
int if_count_in_try,
int is_assert_try,
int is_assert_catch,
int previous_catches_log_count,
int catch_depth,
int is_method_have_param,
String method_param_as_string_original,
String method_param_as_string,
String method_param_type,
String method_param_name,
int method_param_count,
String method_call_names_try,
int method_call_count_try,
String operators_in_try,
int operators_count_try,
String variables_in_try,
int variables_count_try,
String method_call_names_till_try,
int method_call_count_till_try,
String operators_till_try,
int operators_count_till_try,
String variables_till_try,
int varaibles_count_till_try,
int loc_till_try,
int is_till_try_logged,
int till_try_log_count,
String till_try_log_levels,
int is_return_till_try,
int throw_throws_till_try,
int if_in_till_try,
int if_count_in_till_try,
int is_assert_till_try) {
util3_met utm = new util3_met();
// method_content = utm.replace_quotes_string(method_content);
method_try_between_con = utm.replace_quotes_string(method_try_between_con);
try_con = utm.replace_quotes_string(try_con);
catch_con = utm.replace_quotes_string(catch_con);
String insert_str =
"insert into "
+ table
+ " values("
+ try_id
+ ","
+ catch_id
+ ",\""
+ try_con
+ "\",\""
+ catch_con
+ "\",\""
+ method_try_between_con
+ "\",\""
+ catch_exception
+ "\",\""
+ previous_catch_con
+ "\",\""
+ file_path
+ "\",\""
+ package_name
+ "\",\""
+ class_name
+ "\",\""
+ method_name
+ "\","
+ try_loc
+ ","
+ is_try_logged
+ ","
+ try_log_count
+ ",\""
+ try_log_levels
+ "\","
+ is_catch_logged
+ ","
+ catch_log_count
+ ",\""
+ catch_log_levels
+ "\","
+ have_previous_catches
+ ","
+ previous_catches_logged
+ ","
+ is_return_in_try
+ ","
+ is_return_in_catch
+ ","
+ is_catch_object_ignore
+ ","
+ is_interrupted_exception
+ ","
+ is_thread_sleep_try
+ ","
+ throw_throws_try
+ ","
+ throw_throws_catch
+ ","
+ if_in_try
+ ","
+ if_count_in_try
+ ","
+ is_assert_try
+ ","
+ is_assert_catch
+ ","
+ previous_catches_log_count
+ ","
+ catch_depth
+ ","
+ is_method_have_param
+ ",\""
+ method_param_as_string_original
+ "\",\""
+ method_param_as_string
+ "\",\""
+ method_param_type
+ "\",\""
+ method_param_name
+ "\","
+ method_param_count
+ ",\""
+ method_call_names_try
+ "\","
+ method_call_count_try
+ ",'"
+ operators_in_try
+ "',"
+ operators_count_try
+ ",'"
+ variables_in_try
+ "',"
+ variables_count_try
+ ",'"
+ method_call_names_till_try
+ "',"
+ method_call_count_till_try
+ ",'"
+ operators_till_try
+ "',"
+ operators_count_till_try
+ ",'"
+ variables_till_try
+ "',"
+ varaibles_count_till_try
+ ","
+ loc_till_try
+ ","
+ is_till_try_logged
+ ","
+ till_try_log_count
+ ",\""
+ till_try_log_levels
+ "\","
+ is_return_till_try
+ ","
+ throw_throws_till_try
+ ","
+ if_in_till_try
+ ","
+ if_count_in_till_try
+ ","
+ is_assert_till_try
+ ")";
System.out.println("Insert str=" + insert_str);
System.out.println("Try id=" + try_id);
/*if("ajp".equalsIgnoreCase(package_name))
{
System.out.println("Hi for ajp:"+ package_name);
//interupt();
}*/
try {
System.out.println("I am writing");
stmt = conn.createStatement();
stmt.executeUpdate(insert_str);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void insert(
String if_block,
String if_expr,
String method_if_between_con,
int loc_till_if,
int is_till_if_logged,
int till_if_log_count,
String till_if_log_levels,
String operators_till_if,
int operators_count_till_if,
String variables_till_if,
int variables_count_till_if,
String method_call_names_till_if,
int method_call_count_till_if,
int is_return_till_if,
int throw_throws_till_if,
int if_in_till_if,
int if_count_in_till_if,
int is_assert_till_if,
int is_method_have_param,
String method_param_as_string_original,
String method_param_as_string,
String method_param_type,
String method_param_name,
int method_param_count,
int is_return_in_if,
int throw_throws_if,
int is_assert_if,
int is_null_condition_if,
int is_instance_of_condition_if,
String package_name,
String class_name,
String method_name,
String file_path,
int is_if_logged,
int if_log_count,
String if_log_levels) {
id++;
// int logged= 0;
/*if(log_count!=0)
{
logged =1;
}*/
util_met utm = new util_met();
method_if_between_con = utm.replace_quotes_string(method_if_between_con);
if_block = utm.replace_quotes_string(if_block);
method_if_between_con = "I am not inserting too large for if";
if_block = "too large not inserting if block";
if_expr = utm.replace_quotes_string(if_expr);
file_path = file_path.replace("\\", "\\\\");
String insert_str =
" insert into "
+ table
+ " values("
+ id
+ ",'"
+ if_block
+ "','"
+ if_expr
+ "','"
+ method_if_between_con
+ "',"
+ loc_till_if
+ ","
+ is_till_if_logged
+ ","
+ till_if_log_count
+ ",'"
+ till_if_log_levels
+ "','"
+ operators_till_if
+ "',"
+ operators_count_till_if
+ ",'"
+ variables_till_if
+ "',"
+ variables_count_till_if
+ ",'"
+ method_call_names_till_if
+ "',"
+ method_call_count_till_if
+ ","
+ is_return_till_if
+ ","
+ throw_throws_till_if
+ ","
+ if_in_till_if
+ ","
+ if_count_in_till_if
+ ","
+ is_assert_till_if
+ ","
+ is_method_have_param
+ ",'"
+ method_param_as_string_original
+ "','"
+ method_param_as_string
+ "','"
+ method_param_type
+ "','"
+ method_param_name
+ "',"
+ method_param_count
+ ","
+ is_return_in_if
+ ","
+ throw_throws_if
+ ","
+ is_assert_if
+ ","
+ is_null_condition_if
+ ","
+ is_instance_of_condition_if
+ ",'"
+ package_name
+ "','"
+ class_name
+ "','"
+ method_name
+ "', '"
+ file_path
+ "',"
+ is_if_logged
+ ","
+ if_log_count
+ ",'"
+ if_log_levels
+ "'"
+ " )";
System.out.println("Insert str" + insert_str);
try {
if (conn == null) {
// System.out.println("I am null");
}
stmt = conn.createStatement();
stmt.executeUpdate(insert_str);
} catch (SQLException e) { // TODO Auto-generated catch block
e.printStackTrace();
}
}
private List<Object[]> getCustomStgUsers(boolean usedb2) {
List<Object[]> listData = new ArrayList<Object[]>();
String ServerName = "";
int PortNumber;
String DatabaseName = "";
java.util.Properties properties;
String url = "";
java.sql.Connection con = null;
if (usedb2) {
ServerName = synDB.getConfigProperties("SERVER_NAME");
PortNumber = Integer.parseInt(synDB.getConfigProperties("PORT_NUMBER"));
DatabaseName = synDB.getConfigProperties("DATABASE");
properties = new java.util.Properties();
properties.put("user", synDB.getConfigProperties("USER"));
properties.put("password", synDB.getConfigProperties("PASSWORD"));
properties.put("sslConnection", "true");
System.setProperty("javax.net.ssl.trustStore", synDB.getConfigProperties("CACERTS_PATH"));
System.setProperty("javax.net.ssl.trustStorePassword", "changeit");
System.setProperty("db2.jcc.charsetDecoderEncoder", "3");
url = "jdbc:db2://" + ServerName + ":" + PortNumber + "/" + DatabaseName;
try {
new DB2Driver();
} catch (Exception e) {
System.out.println("Error: failed to load Db2 jcc driver.");
}
} else {
ServerName = synDB.getConfigProperties("SERVER_NAME");
PortNumber = Integer.parseInt(synDB.getConfigProperties("PORT_NUMBER"));
DatabaseName = synDB.getConfigProperties("DATABASE");
properties = new java.util.Properties();
properties.put("user", synDB.getConfigProperties("USER"));
properties.put("password", synDB.getConfigProperties("PASSWORD"));
url = "jdbc:postgresql://" + ServerName + ":" + PortNumber + "/" + DatabaseName;
}
try {
System.out.println("url: " + url);
con = java.sql.DriverManager.getConnection(url, properties);
try {
String sql =
"SELECT a.ID_NRIC, FIRST_NAME, LAST_NAME, MOBILE, EMAIL, ACCOUNT_STATUS, AGENT_CODE, AGENCY, NEED2FA, NEEDTNC, USER_TYPE, USER__SUB_TYPE, a.CREATED_DATE, b.ROLE_NAME "
+ "FROM CUSTOM_STG_USER a INNER JOIN CUSTOM_STG_USER_ROLE b ON (b.ID_NRIC=a.ID_NRIC) ";
StringBuilder sbSQLSTGUser = new StringBuilder();
sbSQLSTGUser.append(sql);
System.out.println("Select from PSE.CUSTOM_STG_USER DB2: " + sbSQLSTGUser.toString());
java.sql.Statement ps = con.createStatement();
java.sql.ResultSet rs = ps.executeQuery(sbSQLSTGUser.toString());
System.out.println("get data....");
Object[] objArrays = new Object[14];
while (rs.next()) {
objArrays = new Object[14];
objArrays[0] = rs.getString(1);
objArrays[1] = rs.getString(2);
objArrays[2] = rs.getString(3);
objArrays[3] = rs.getString(4);
objArrays[4] = rs.getString(5);
objArrays[5] = rs.getString(6);
objArrays[6] = rs.getString(7);
objArrays[7] = rs.getString(8);
objArrays[8] = rs.getString(9);
objArrays[9] = rs.getString(10);
objArrays[10] = rs.getString(11);
objArrays[11] = rs.getString(12);
objArrays[12] = rs.getString(13);
objArrays[13] = rs.getString(14);
listData.add(objArrays);
System.out.println(
"GET FROM DB2 | ID_NRIC:"
+ objArrays[0]
+ ", FIRST_NAME:"
+ objArrays[1]
+ ", LAST_NAME:"
+ objArrays[2]
+ ", MOBILE:"
+ objArrays[3]
+ ", EMAIL:"
+ objArrays[4]
+ ", ACCOUNT_STATUS:"
+ objArrays[5]
+ ", AGENT_CODE:"
+ objArrays[6]
+ ", AGENCY:"
+ objArrays[7]
+ ", NEED2FA:"
+ objArrays[8]
+ ", NEEDTNC:"
+ objArrays[9]
+ ", USER_TYPE:"
+ objArrays[10]
+ ", USER_SUB_TYPE:"
+ objArrays[11]
+ ", CREATED_DATE :"
+ objArrays[12]
+ ", ROLE_NAME :"
+ objArrays[13]);
}
} catch (Exception e) {
e.printStackTrace();
System.out.println("select is failing1");
}
if (con != null) {
try {
con.close();
con = null;
} catch (Exception e) {
}
}
} catch (Exception e) {
e.printStackTrace();
}
return listData;
}
