public void saveSentMessage(COutgoingMessage message) throws Exception {
Statement sqlCmd;
if (connection != null) {
sqlCmd =
connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
sqlCmd.executeUpdate(
"insert into sms_out (recipient, text, dispatch_date, flash_sms, status_report, src_port, dst_port, validity_period) values ('"
+ message.getRecipient()
+ "', '"
+ message.getText().replaceAll("'", "''")
+ "', "
+ escapeDate(message.getDate(), true)
+ ", "
+ (message.getFlashSms() ? 1 : 0)
+ ", "
+ (message.getStatusReport() ? 1 : 0)
+ ", "
+ message.getSourcePort()
+ ", "
+ message.getDestinationPort()
+ ", "
+ message.getValidityPeriod()
+ ")");
connection.commit();
sqlCmd.close();
}
}
