private static boolean deletePrice(int price) {
Connection connection = null;
PreparedStatement statement = null;
DBPool dbpool = new DBPool();
try {
connection = dbpool.getConnectionGateway();
if (connection == null) {
Util.logger.error("Impossible to connect to DB");
return false;
}
String sqlUpdate = "DELETE FROM giadau WHERE id=" + price;
Util.logger.info(" DELETE Gia dau: " + sqlUpdate);
statement = connection.prepareStatement(sqlUpdate);
if (statement.execute()) {
Util.logger.info("Loi xoa gia dau ");
return false;
}
return true;
} catch (SQLException e) {
Util.logger.error(": Error:" + e.toString());
return false;
} catch (Exception e) {
Util.logger.error(": Error:" + e.toString());
return false;
} finally {
dbpool.cleanup(statement);
dbpool.cleanup(connection);
}
}
private static boolean deleteWinner(int phien) {
Connection connection = null;
PreparedStatement statement = null;
DBPool dbpool = new DBPool();
try {
connection = dbpool.getConnectionGateway();
if (connection == null) {
Util.logger.error("Impossible to connect to DB");
return false;
}
String sqlUpdate = "DELETE FROM daugia_winner WHERE phien=" + phien;
Util.logger.info(" DELETE WINNER: " + sqlUpdate);
statement = connection.prepareStatement(sqlUpdate);
if (statement.execute()) {
Util.logger.info("Loi xoa nguoi duy nhat thap nhat ");
return false;
}
return true;
} catch (SQLException e) {
Util.logger.error(": Error:" + e.toString());
return false;
} catch (Exception e) {
Util.logger.error(": Error:" + e.toString());
return false;
} finally {
dbpool.cleanup(statement);
dbpool.cleanup(connection);
}
}
private static boolean saveChat(String fromnick, String tonick, String noidung) {
Connection connection = null;
PreparedStatement statement = null;
DBPool dbpool = new DBPool();
try {
connection = dbpool.getConnectionGateway();
if (connection == null) {
Util.logger.error("Impossible to connect to DB");
return false;
}
String sqlInsert = "INSERT INTO vtv6_chatketnoi (fromnick,tonick,content)" + "VALUES(?,?,?)";
statement = connection.prepareStatement(sqlInsert);
statement.setString(1, fromnick);
statement.setString(2, tonick);
statement.setString(3, noidung);
statement.executeUpdate();
Util.logger.info("sqlInsert : " + sqlInsert);
return true;
} catch (SQLException e) {
Util.logger.error(": Error:" + e.toString());
return false;
} catch (Exception e) {
Util.logger.error(": Error:" + e.toString());
return false;
} finally {
dbpool.cleanup(statement);
dbpool.cleanup(connection);
}
}
private static int getPhien() {
int result = -1;
Connection cnn = null;
PreparedStatement statement = null;
DBPool dbpool = new DBPool();
ResultSet rs = null;
String query = "SELECT phien FROM ketnoiphien where isprocess=1 ";
try {
cnn = dbpool.getConnectionGateway();
statement = cnn.prepareStatement(query);
if (statement.execute()) {
rs = statement.getResultSet();
while (rs.next()) {
result = rs.getInt(1);
return result;
}
}
return result;
} catch (SQLException ex2) {
Util.logger.error("GetSequence. Ex:" + ex2.toString());
return result;
} catch (Exception ex3) {
Util.logger.error("GetSequece. Ex3:" + ex3.toString());
return result;
} finally {
dbpool.cleanup(rs);
dbpool.cleanup(statement);
dbpool.cleanup(cnn);
}
}
private static boolean isexist(String userid, String mlist) {
Connection connection;
PreparedStatement statement;
DBPool dbpool;
connection = null;
statement = null;
dbpool = new DBPool();
try {
connection = dbpool.getConnectionGateway();
String query3 = "select * from " + mlist + " where user_id='" + userid + "' ";
Util.logger.info(query3);
Vector result3 = DBUtil.getVectorTable(connection, query3);
if (result3.size() > 0) {
Vector item = (Vector) result3.elementAt(0);
return true;
// tempMilisec = (String) item.elementAt(0);
}
return false;
} catch (SQLException e) {
Util.logger.error(": Error:" + e.toString());
Util.logger.printStackTrace(e);
return true;
} catch (Exception e) {
Util.logger.error(": Error:" + e.toString());
Util.logger.printStackTrace(e);
return true;
} finally {
dbpool.cleanup(statement);
dbpool.cleanup(connection);
}
}
public static String getMobileOperatorNew(String userid, int type) {
String tmpOperator = "-";
Connection connection = null;
DBPool dbpool = new DBPool();
try {
connection = dbpool.getConnection("gateway");
String query =
"SELECT operator FROM icom_isdnseries WHERE prefix= substr('"
+ userid
+ "',1, length(prefix)) ";
if (type == 1 || type == 0) {
query += " and type=" + type;
}
Vector result = DBUtil.getVectorTable(connection, query);
for (int i = 0; i < result.size(); i++) {
Vector item = (Vector) result.elementAt(i);
tmpOperator = (String) item.elementAt(0);
}
return tmpOperator;
} catch (Exception ex) {
Util.logger.sysLog(
LogValues.INFORMATIVE,
"Utils",
"getMobileOperator: Get MobileOpereator Failed" + ex.toString());
return tmpOperator;
} finally {
dbpool.cleanup(connection);
}
}
public static String getContent(String Code) {
// tach lastcode
String content;
Connection connection = null;
DBPool dbpool = new DBPool();
String query =
"select Content from [IComStore].[dbo].[SDPText] where Code = '"
+ Code
+ "' order by CreateDate desc";
try {
connection = dbpool.getConnection("store");
Vector result = DBUtil.getVectorTable(connection, query);
Util.logger.info("DBUtil.getCode: queryStatement:" + query);
if (result.size() > 0) {
Vector item = (Vector) result.elementAt(0);
content = item.elementAt(0).toString();
return content;
}
} catch (Exception ex) {
Util.logger.info("DBUtil.getCode: getContent: Failed" + ex.getMessage());
Util.logger.printStackTrace(ex);
return "";
} finally {
dbpool.cleanup(connection);
}
return "";
}
private static boolean deleteUser(String user, String table) {
Connection connection = null;
PreparedStatement statement = null;
DBPool dbpool = new DBPool();
try {
connection = dbpool.getConnectionGateway();
if (connection == null) {
Util.logger.error("Impossible to connect to DB");
return false;
}
String sqlUpdate = "DELETE FROM " + table + " WHERE user_id='" + user + "'";
Util.logger.info(" DELETE USER: "******"Loi xoa user " + user + "trong bang " + table);
return false;
}
return true;
} catch (SQLException e) {
Util.logger.error(": Error:" + e.toString());
return false;
} catch (Exception e) {
Util.logger.error(": Error:" + e.toString());
return false;
} finally {
dbpool.cleanup(statement);
dbpool.cleanup(connection);
}
}
private static boolean add2CanceledAds(String userID) {
boolean OK = false;
Util.logger.info(className + ".add2CanceledAds()");
String tablename = "vng_cancel_ads";
String sSQLInsert = "replace into " + tablename + "(userid)" + " values(?)";
Connection connection = null;
PreparedStatement ps = null;
DBPool dbpool = new DBPool();
try {
connection = dbpool.getConnectionGateway();
ps = connection.prepareStatement(sSQLInsert);
ps.setString(1, userID);
if (ps.executeUpdate() >= 1) {
OK = true;
}
ps.close();
} catch (SQLException e) {
OK = false;
Util.logger.info(className + ".add2CanceledAds() error:" + e.getMessage());
} catch (Exception e) {
OK = false;
Util.logger.info(className + ".add2CanceledAds() error:" + e.getMessage());
} finally {
dbpool.cleanup(connection);
}
return OK;
}
private static boolean saverequest(String userid, String dtbase, int subcode) {
Connection connection = null;
PreparedStatement statement = null;
DBPool dbpool = new DBPool();
try {
connection = dbpool.getConnectionGateway();
if (connection == null) {
Util.logger.error("Impossible to connect to DB");
return false;
}
String sqlInsert =
"INSERT INTO " + dtbase + "(userid, subcode) VALUES ('" + userid + "'," + subcode + ")";
Util.logger.info("Insert:" + sqlInsert);
statement = connection.prepareStatement(sqlInsert);
if (statement.execute()) {
Util.logger.error("Insert into dbcontent");
return false;
}
return true;
} catch (SQLException e) {
Util.logger.error(": Error:" + e.toString());
return false;
} catch (Exception e) {
Util.logger.error(": Error:" + e.toString());
return false;
} finally {
dbpool.cleanup(statement);
dbpool.cleanup(connection);
}
}
private int insertData2cancel(
String user_id,
String service_id,
String command_code,
String mlist,
MsgObject msgObject,
String mtfree,
int msgtype,
String Service_ss_id,
String mt_count) {
int ireturn = 1;
Connection connection = null;
DBPool dbpool = new DBPool();
// long lmilisec = System.currentTimeMillis();
String sqlInsert =
"Insert into "
+ mlist
+ "_cancel(user_id, service_id, date,command_code,request_id, message_type,mobile_operator,mt_free,mt_count) values ('"
+ user_id
+ "','"
+ service_id
+ "','"
+ new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date())
+ "','"
+ Service_ss_id
+ "','"
+ msgObject.getRequestid()
+ "','"
+ msgtype
+ "','"
+ msgObject.getMobileoperator()
+ "',"
+ mtfree
+ ","
+ mt_count
+ ")";
try {
connection = dbpool.getConnectionGateway();
if (DBUtil.executeSQL(connection, sqlInsert) < 0) {
Util.logger.error(
this.getClass().getName()
+ ""
+ ": uppdate Statement: Insert "
+ mlist
+ " Failed:"
+ sqlInsert);
ireturn = -1;
}
} catch (Exception ex) {
Util.logger.error(this.getClass().getName() + ":Insert " + mlist + " Failed");
ireturn = -1;
Util.logger.printStackTrace(ex);
} finally {
dbpool.cleanup(connection);
}
return ireturn;
}
/* Tim list bai hat */
private static String findListofMusic(
String dtbase, String userid, String infoid, String lastid, int subcode) {
String result = "";
// String musicid = "";
Connection connection = null;
PreparedStatement statement = null;
ResultSet rs = null;
DBPool dbpool = new DBPool();
try {
connection = dbpool.getConnection(dtbase);
if (connection == null) {
Util.logger.error("Impossible to connect to DB");
return result;
}
String sqlSelect =
"SELECT musicname_sms, musicid FROM icom_music WHERE ( upper(operator) = '"
+ infoid.toUpperCase()
+ "')";
if (!"".equalsIgnoreCase(lastid)) {
sqlSelect = sqlSelect + " AND musicid not in(" + lastid + ") ";
}
Util.logger.info("SEARCH SONG MUSIC : " + sqlSelect);
statement = connection.prepareStatement(sqlSelect);
if (statement.execute()) {
rs = statement.getResultSet();
while (rs.next()) {
result = result + rs.getString(1) + "-" + rs.getString(2) + ";";
if (result.length() > 160) {
// cap nhat cho khach hang list danh sach da gui
updateListMusic(userid, lastid, dbcontent, subcode);
return result;
} else {
if ("".equalsIgnoreCase(lastid)) {
lastid = lastid + rs.getString(2);
} else {
lastid = lastid + "," + rs.getString(2);
}
}
}
}
return result;
} catch (SQLException e) {
Util.logger.error(": Error:" + e.toString());
return result;
} catch (Exception e) {
Util.logger.error(": Error:" + e.toString());
return result;
} finally {
dbpool.cleanup(rs);
dbpool.cleanup(statement);
dbpool.cleanup(connection);
}
}
private static String[] findMusicIDlike(String find, String infoid) {
String[] result = new String[2];
Connection connection = null;
PreparedStatement statement = null;
ResultSet rs = null;
DBPool dbpool = new DBPool();
for (int i = 0; i < 2; i++) {
result[i] = "";
}
try {
connection = dbpool.getConnection("store");
if (connection == null) {
Util.logger.error("Impossible to connect to DB");
return result;
}
String ope = "";
if (infoid.equalsIgnoreCase("vinaphone")) ope = "VNPCode";
else if (infoid.equalsIgnoreCase("mobifone")) ope = "VMSCode";
else ope = "VTCode";
String sqlSelect =
"SELECT top 1 RingbackName_E,"
+ ope
+ " FROM [IComStore].[dbo].Ringback WHERE SearchRingbackName LIKE '%"
+ find
+ "%' and "
+ ope
+ " is not null and "
+ ope
+ " <>''";
Util.logger.info("SEARCH MA SO : " + sqlSelect);
statement = connection.prepareStatement(sqlSelect);
Util.logger.info("SEARCH MA SO");
if (statement.execute()) {
rs = statement.getResultSet();
while (rs.next()) {
result[0] = rs.getString(1);
result[1] = rs.getString(2);
}
}
return result;
} catch (SQLException e) {
Util.logger.error(": Error:" + e.toString());
return result;
} catch (Exception e) {
Util.logger.error(": Error:" + e.toString());
return result;
} finally {
dbpool.cleanup(rs);
dbpool.cleanup(statement);
dbpool.cleanup(connection);
}
}
// Lay noi dung trong icom_textbase_data
private String getContent(String gameid, String commandcode) {
// String content = "";
// String area = "";
Connection connection = null;
DBPool dbpool = new DBPool();
PreparedStatement statement = null;
ResultSet rs = null;
// String[] result = null;
String result = "";
try {
connection = dbpool.getConnectionGateway();
if (connection == null) {
Util.logger.error("Impossible to connect to DB");
return result;
}
// Lấy company_id của commandcode
// /int company_id = getCompanyId(commandcode);
// String company_name = "";
String query =
"SELECT content FROM icom_textbase_data WHERE ( upper(gameid) = '"
+ gameid.toUpperCase()
+ "') AND ( upper(subcode1) ='"
+ commandcode.toUpperCase()
+ "')";
statement = connection.prepareStatement(query);
Util.logger.info("LOST MESSAGE" + query);
if (statement.execute()) {
rs = statement.getResultSet();
while (rs.next()) {
result = rs.getString(1);
}
}
return result;
} catch (Exception ex) {
Util.logger.info(this.getClass().getName() + " SoiCauXoSo: Failed" + ex.getMessage());
ex.printStackTrace();
// content = "Ma tinh khong hop le. Soan tin: CAU<Matinh> gui 8551
// de soi cau chinh xac nhat";
return result;
} finally {
dbpool.cleanup(rs);
dbpool.cleanup(statement);
dbpool.cleanup(connection);
}
}
private static String findListofMusic(String date) {
String result = "";
// String musicid = "";
Connection connection = null;
PreparedStatement statement = null;
ResultSet rs = null;
DBPool dbpool = new DBPool();
String lastresult = "";
try {
connection = dbpool.getConnection("mediatech");
if (connection == null) {
Util.logger.error("Impossible to connect to DB");
return result;
}
String sqlSelect =
"select top 3 replace(NameVote,' ','') NameVote,Code from PlaysList where DatePlay='"
+ date
+ "' order by newid() ; ";
Util.logger.info("SEARCH List game : " + sqlSelect);
statement = connection.prepareStatement(sqlSelect);
if (statement.execute()) {
rs = statement.getResultSet();
int i = 0;
while (rs.next()) {
result =
result
+ rs.getString(2).trim()
+ "_"
+ rs.getString(1).substring(0, rs.getString(1).length() - 4)
+ ";";
}
return result;
}
return result;
} catch (SQLException e) {
Util.logger.error(": Error:" + e.toString());
return result;
} catch (Exception e) {
Util.logger.error(": Error:" + e.toString());
return result;
} finally {
dbpool.cleanup(rs);
dbpool.cleanup(statement);
dbpool.cleanup(connection);
}
}
/* ghi lai dsach khach hang */
private static boolean saveClient(
String userid,
String operator,
String keyword,
String serviceid,
Timestamp timesend,
BigDecimal requestid) {
Connection connection = null;
PreparedStatement statement = null;
DBPool dbpool = new DBPool();
try {
connection = dbpool.getConnectionGateway();
if (connection == null) {
Util.logger.error("Impossible to connect to DB");
return false;
}
String sqlInsert =
"INSERT INTO icom_list_customer( userid, operator, keyword, serviceid, timesend, requestid) VALUES ('"
+ userid
+ "','"
+ operator.toUpperCase()
+ "','"
+ keyword
+ "','"
+ serviceid.toUpperCase()
+ "','"
+ timesend
+ "','"
+ requestid
+ "')";
Util.logger.info("Insert:" + sqlInsert);
statement = connection.prepareStatement(sqlInsert);
if (statement.execute()) {
Util.logger.error("Insert into icom_list_customer");
return false;
}
return true;
} catch (SQLException e) {
Util.logger.error(": Error:" + e.toString());
return false;
} catch (Exception e) {
Util.logger.error(": Error:" + e.toString());
return false;
} finally {
dbpool.cleanup(statement);
dbpool.cleanup(connection);
}
}
private long getSequence(String gameid, String serviceid) {
long sequence = 1;
Connection cnn = null;
PreparedStatement statement = null;
DBPool dbpool = new DBPool();
ResultSet rs = null;
String query = "select sequence from icom_sequence where gameid='" + gameid.toUpperCase() + "'";
try {
cnn = dbpool.getConnectionGateway();
statement = cnn.prepareStatement(query);
String sequence_temp = "";
if (statement.execute()) {
rs = statement.getResultSet();
// rs = statement.getResultSet();
while (rs.next()) {
sequence_temp = rs.getString(1);
}
}
sequence = Long.parseLong(sequence_temp);
if (sequence > 0) {
String sqlUpdate =
"update icom_sequence set sequence = sequence + 1 where gameid='"
+ gameid.toUpperCase()
+ "'";
statement = cnn.prepareStatement(sqlUpdate);
if (statement.executeUpdate() != 1) {
Util.logger.error("GetSequence: Update icom_sequence Failed");
}
}
} catch (SQLException ex2) {
Util.logger.error("GetSequence. Ex:" + ex2.toString());
} catch (Exception ex3) {
Util.logger.error("GetSequece. Ex3:" + ex3.toString());
} finally {
dbpool.cleanup(rs, statement);
dbpool.cleanup(cnn);
}
return sequence;
}
private static String Getmobile(String stt) {
String result = "";
// String musicid = "";
Connection connection = null;
PreparedStatement statement = null;
ResultSet rs = null;
DBPool dbpool = new DBPool();
try {
connection = dbpool.getConnectionGateway();
if (connection == null) {
Util.logger.error("Impossible to connect to DB");
return result;
}
int tam = -1;
try {
tam = Integer.parseInt(stt);
} catch (Exception ex) {
}
String sqlSelect = "SELECT userid FROM ketnoi where stt=" + stt;
Util.logger.info("SEARCH CODE : " + sqlSelect);
statement = connection.prepareStatement(sqlSelect);
if (statement.execute()) {
rs = statement.getResultSet();
while (rs.next()) {
result = rs.getString(1);
Util.logger.info("Code: " + result);
return result;
}
}
return result;
} catch (SQLException e) {
Util.logger.error(": Error:" + e.toString());
return result;
} catch (Exception e) {
Util.logger.error(": Error:" + e.toString());
return result;
} finally {
dbpool.cleanup(rs);
dbpool.cleanup(statement);
dbpool.cleanup(connection);
}
}
private int saveWinner(String keyword, String serviceid, String userid, String mttext, int phien)
throws Exception {
Connection connection = null;
PreparedStatement statement = null;
String sqlString = null;
DBPool dbpool = new DBPool();
// Util.logger.info("sendMT:" + msgObject.getUserid()+ "@TO" +
// msgObject.getServiceid() + "@" + msgObject.getUsertext() );
try {
connection = dbpool.getConnectionGateway();
if (connection == null) {
Util.logger.error("Impossible to connect to DB");
return -1;
}
String sqlInsert =
"Insert into daugia_winner (command_code,user_id,service_id,info,phien) values ('"
+ keyword
+ "','"
+ userid
+ "','"
+ serviceid
+ "','"
+ mttext
+ "',"
+ phien
+ ")";
Util.logger.info("Insert:" + sqlInsert);
statement = connection.prepareStatement(sqlInsert);
if (statement.executeUpdate() != 1) {
Util.logger.info("SieuRe: Insert in to daugia_winner Failed");
return -1;
}
return 1;
} catch (SQLException e) {
Util.logger.error("SieuRe: Error:" + e.toString());
return -1;
} catch (Exception e) {
Util.logger.error("SieuRe: Error:" + e.toString());
return -1;
} finally {
dbpool.cleanup(statement);
dbpool.cleanup(connection);
}
}
private static String[] getListblacknick() {
int max = getmaxlist();
String[] result = new String[max];
// String musicid = "";
Connection connection = null;
PreparedStatement statement = null;
ResultSet rs = null;
DBPool dbpool = new DBPool();
String lastresult = "";
try {
connection = dbpool.getConnectionGateway();
if (connection == null) {
Util.logger.error("Impossible to connect to DB");
return result;
}
String sqlSelect = "select blacknick from vtv6_blacknick ";
Util.logger.info("SEARCH List game : " + sqlSelect);
statement = connection.prepareStatement(sqlSelect);
if (statement.execute()) {
rs = statement.getResultSet();
int i = 0;
while (rs.next()) {
result[i] = rs.getString(1);
i++;
}
return result;
}
return result;
} catch (SQLException e) {
Util.logger.error(": Error:" + e.toString());
return result;
} catch (Exception e) {
Util.logger.error(": Error:" + e.toString());
return result;
} finally {
dbpool.cleanup(rs);
dbpool.cleanup(statement);
dbpool.cleanup(connection);
}
}
// Tim sdt co trong danh sach da gui tin hay nhan tin hay khong.
private static String getMusicID(String userid, String dtbase, int subcode) {
Connection cnn = null;
PreparedStatement statement = null;
DBPool dbpool = new DBPool();
ResultSet rs = null;
String sequence_temp = "";
try {
cnn = dbpool.getConnectionGateway();
String query =
"SELECT musichotid FROM "
+ dtbase
+ " WHERE userid= '"
+ userid.toUpperCase()
+ "' AND subcode="
+ subcode;
if (cnn == null) {
Util.logger.error("Impossible to connect to DB");
return sequence_temp;
}
statement = cnn.prepareStatement(query);
if (statement.execute()) {
rs = statement.getResultSet();
while (rs.next()) {
sequence_temp = rs.getString(1);
}
}
return sequence_temp;
} catch (SQLException ex2) {
Util.logger.error("GetSequence. Ex:" + ex2.toString());
return sequence_temp;
} catch (Exception ex3) {
Util.logger.error("GetSequece. Ex3:" + ex3.toString());
return sequence_temp;
} finally {
dbpool.cleanup(rs);
dbpool.cleanup(statement);
dbpool.cleanup(cnn);
}
}
/* tim ma so cac bai hat */
private static List<String> findBirth(String birthday) {
List<String> lstresult = new ArrayList<String>();
int code = 0;
Connection connection = null;
PreparedStatement statement = null;
ResultSet rs = null;
DBPool dbpool = new DBPool();
try {
connection = dbpool.getConnection("VOVTV");
if (connection == null) {
Util.logger.error("Impossible to connect to DB");
return lstresult;
}
String sqlSelect =
"SELECT NickName FROM [dbo].NickName WHERE Brithday LIKE '" + birthday + "'";
Util.logger.info("SEARCH THEO BIRTHDAY AND ADDRESS : " + sqlSelect);
Vector result = DBUtil.getVectorTable(connection, sqlSelect);
Util.logger.info("DBUtil.getCode: queryStatement:" + sqlSelect);
for (int iIndex = 0; iIndex < result.size(); iIndex++) {
Vector vtRow = (Vector) result.elementAt(iIndex);
String nick = (String) vtRow.elementAt(0);
lstresult.add(nick);
}
} catch (SQLException e) {
Util.logger.error(": Error:" + e.toString());
return lstresult;
} catch (Exception e) {
Util.logger.error(": Error:" + e.toString());
return lstresult;
} finally {
dbpool.cleanup(rs);
dbpool.cleanup(statement);
dbpool.cleanup(connection);
}
return lstresult;
}
private static int findCode() {
int result = 0;
// String musicid = "";
Connection connection = null;
PreparedStatement statement = null;
ResultSet rs = null;
DBPool dbpool = new DBPool();
try {
connection = dbpool.getConnectionGateway();
if (connection == null) {
Util.logger.error("Impossible to connect to DB");
return result;
}
String sqlSelect = "SELECT stt FROM ketnoi order by stt desc limit 1";
Util.logger.info("SEARCH CODE : " + sqlSelect);
statement = connection.prepareStatement(sqlSelect);
if (statement.execute()) {
rs = statement.getResultSet();
while (rs.next()) {
result = rs.getInt(1);
Util.logger.info("Code: " + result);
return result;
}
}
return result;
} catch (SQLException e) {
Util.logger.error(": Error:" + e.toString());
return result;
} catch (Exception e) {
Util.logger.error(": Error:" + e.toString());
return result;
} finally {
dbpool.cleanup(rs);
dbpool.cleanup(statement);
dbpool.cleanup(connection);
}
}
// Update khach hang dua ra gia duy nhat va nho nhat
private static boolean updateWinner(
String keyword, String serviceid, String userid, String mttext, int phien) {
Connection connection = null;
PreparedStatement statement = null;
DBPool dbpool = new DBPool();
try {
connection = dbpool.getConnectionGateway();
if (connection == null) {
Util.logger.error("Impossible to connect to DB");
return false;
}
String sqlUpdate =
"UPDATE daugia_winner SET command_code ='"
+ keyword
+ " ',user_id= '"
+ userid
+ "',service_id='"
+ serviceid
+ "',info='"
+ mttext
+ "' WHERE phien="
+ phien;
Util.logger.info(" UPDATE DATE: " + sqlUpdate);
statement = connection.prepareStatement(sqlUpdate);
if (statement.execute()) {
Util.logger.info("Update nguoi trung thuong to send " + userid + " to dbcontent");
return false;
}
return true;
} catch (SQLException e) {
Util.logger.error(": Error:" + e.toString());
return false;
} catch (Exception e) {
Util.logger.error(": Error:" + e.toString());
return false;
} finally {
dbpool.cleanup(statement);
dbpool.cleanup(connection);
}
}
// cap nhat danh sach khach hang
private static boolean updateListMusic(String userid, String lastid, String dtbase, int subcode) {
Connection connection = null;
PreparedStatement statement = null;
DBPool dbpool = new DBPool();
try {
connection = dbpool.getConnectionGateway();
if (connection == null) {
Util.logger.error("Impossible to connect to DB");
return false;
}
// Update cac danh sach bai hat da gui cho khach hang
String sqlUpdate =
"UPDATE "
+ dtbase
+ " SET musichotid = '"
+ lastid
+ "' WHERE upper(userid)='"
+ userid.toUpperCase()
+ "' AND subcode="
+ subcode;
Util.logger.info(" UPDATE DATE: " + sqlUpdate);
statement = connection.prepareStatement(sqlUpdate);
if (statement.execute()) {
Util.logger.info("Update list music to send " + userid + " to dbcontent");
return false;
}
return true;
} catch (SQLException e) {
Util.logger.error(": Error:" + e.toString());
return false;
} catch (Exception e) {
Util.logger.error(": Error:" + e.toString());
return false;
} finally {
dbpool.cleanup(statement);
dbpool.cleanup(connection);
}
}
private static String[] getPhien() {
String[] result = new String[4];
result[0] = "";
result[1] = "";
result[2] = "";
result[3] = "";
Connection cnn = null;
PreparedStatement statement = null;
DBPool dbpool = new DBPool();
ResultSet rs = null;
String query = "SELECT phien,begintime,endtime,sanpham FROM daugia_phien where isprocess=1 ";
try {
cnn = dbpool.getConnectionGateway();
statement = cnn.prepareStatement(query);
if (statement.execute()) {
rs = statement.getResultSet();
while (rs.next()) {
result[0] = rs.getInt(1) + "";
result[1] = rs.getString(2);
result[2] = rs.getString(3);
result[3] = rs.getString(4);
return result;
}
}
return result;
} catch (SQLException ex2) {
Util.logger.error("GetSequence. Ex:" + ex2.toString());
return result;
} catch (Exception ex3) {
Util.logger.error("GetSequece. Ex3:" + ex3.toString());
return result;
} finally {
dbpool.cleanup(rs);
dbpool.cleanup(statement);
dbpool.cleanup(cnn);
}
}
private static String Getblacklist(String nick) {
String result = "";
// String musicid = "";
Connection connection = null;
PreparedStatement statement = null;
ResultSet rs = null;
DBPool dbpool = new DBPool();
try {
connection = dbpool.getConnectionGateway();
if (connection == null) {
Util.logger.error("Impossible to connect to DB");
return result;
}
String sqlSelect = "SELECT blacklist FROM vtv6_nick where nick='" + nick + "'";
Util.logger.info("SEARCH CODE : " + sqlSelect);
statement = connection.prepareStatement(sqlSelect);
if (statement.execute()) {
rs = statement.getResultSet();
while (rs.next()) {
result = rs.getString(1);
Util.logger.info("Code: " + result);
return result;
}
}
return result;
} catch (SQLException e) {
Util.logger.error(": Error:" + e.toString());
return result;
} catch (Exception e) {
Util.logger.error(": Error:" + e.toString());
return result;
} finally {
dbpool.cleanup(rs);
dbpool.cleanup(statement);
dbpool.cleanup(connection);
}
}
private int savenickqueue(String user_id, String nick, String request_id) throws Exception {
Connection connection = null;
PreparedStatement statement = null;
String sqlString = null;
DBPool dbpool = new DBPool();
// Util.logger.info("sendMT:" + msgObject.getUserid()+ "@TO" +
// msgObject.getServiceid() + "@" + msgObject.getUsertext() );
try {
connection = dbpool.getConnectionGateway();
if (connection == null) {
Util.logger.error("Impossible to connect to DB");
return -1;
}
String sqlInsert =
"Insert into vtv6_nick (user_id,nick,request_id) values ('"
+ user_id
+ "','"
+ nick
+ "','"
+ request_id
+ "')";
Util.logger.info("Insert:" + sqlInsert);
statement = connection.prepareStatement(sqlInsert);
if (statement.executeUpdate() != 1) {
Util.logger.info("SieuRe: Insert in to daugia_winner Failed");
return -1;
}
return 1;
} catch (SQLException e) {
Util.logger.error("SieuRe: Error:" + e.toString());
return -1;
} catch (Exception e) {
Util.logger.error("SieuRe: Error:" + e.toString());
return -1;
} finally {
dbpool.cleanup(statement);
dbpool.cleanup(connection);
}
}
public static int executeSQL(String sql) {
PreparedStatement statement = null;
DBPool dbpool = new DBPool();
Connection obj = dbpool.getConnectionGateway();
try {
statement = obj.prepareStatement(sql);
if (statement.executeUpdate() < 0) {
return -1;
}
return 1;
} catch (SQLException e) {
return -1;
} catch (Exception e) {
return -1;
} finally {
dbpool.cleanup(statement);
dbpool.cleanup(obj);
}
}
private static boolean updateBlacklist(String userid, String blacklist) {
Connection connection = null;
PreparedStatement statement = null;
DBPool dbpool = new DBPool();
try {
connection = dbpool.getConnectionGateway();
if (connection == null) {
Util.logger.error("Impossible to connect to DB");
return false;
}
// Update cac danh sach bai hat da gui cho khach hang
String sqlUpdate =
"UPDATE vtv6_nick SET blacklist = '"
+ blacklist
+ "' WHERE upper(user_id)='"
+ userid.toUpperCase()
+ "' and status=1";
Util.logger.info(" UPDATE: " + sqlUpdate);
statement = connection.prepareStatement(sqlUpdate);
if (statement.execute()) {
Util.logger.info("Update vtv6_nick " + userid + " to dbcontent");
return false;
}
return true;
} catch (SQLException e) {
Util.logger.error(": Error:" + e.toString());
return false;
} catch (Exception e) {
Util.logger.error(": Error:" + e.toString());
return false;
} finally {
dbpool.cleanup(statement);
dbpool.cleanup(connection);
}
}