package eky.cc.sms;
import java.io.File;
import java.io.IOException;
import java.io.InputStream;
import java.io.UnsupportedEncodingException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Date;
import java.util.Properties;
import com.ibm.icu.text.SimpleDateFormat;
import java.io.BufferedInputStream;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.InputStream;
/**
* @author CY E-mail:
* @version 创建时间:2019-8-8
*/
public class smssend {
private static String dbUrl; // 数据库连接地址
private static String dbUserName; // 用户名
private static String dbPassword; // 密码
private static String jdbcName; // 驱动名称
static {
try {
InputStream in;
in = new BufferedInputStream (new FileInputStream("WebContent/WEB-INF/jdbc-interface.properties"));
Properties props = new Properties();
try {
props.load(in);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
jdbcName = props.getProperty("jdbcName");
dbUrl = props.getProperty("dbUrl");
dbUserName = props.getProperty("dbUserName");
dbPassword = props.getProperty("dbPassword");
} catch (FileNotFoundException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
}
/**
* 获取数据库连接
* @return
* @throws Exception
*/
public Connection getCon(){
try {
Class.forName(jdbcName);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
Connection con = null;
try {
con = DriverManager.getConnection(dbUrl, dbUserName, dbPassword);
} catch (SQLException e) {
e.printStackTrace();
}
return con;
}
/**
* 短信发送
* @param msg 短信内容
* @param phone 发送号码
* @return
*/
public Boolean sendmsg (String msg,String phone) {
boolean b=false;
int i=0;
try {
Date date=new Date();
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String sysdate=formatter.format(date);
Connection conn=getCon();
System.out.println("数据库连接成功!");
Statement s = conn.createStatement();
String insert_sql ="insert into sms_send.sms_public_send(rec_id,srv_type,srv_name,send_nbr,sms_message,state,create_date)" +
"values(sms_send.seq_sms_pubsend1.nextval,****,'***',"+ phone +","+ msg +",'RDY',"+ sysdate+")";
i=s.executeUpdate(insert_sql);
s.close();
conn.close();
System.out.println(i);
if (i>0) {
b=true;
}
} catch (Exception e) {
e.printStackTrace();
System.out.println("短信发送失败");
}
return b;
}
public static void main(String[] args) {
smssend dbUtil=new smssend();
dbUtil.sendmsg("短信测试","17338784160");
}
}
jdbc-interface.properties 文件内容
dbUrl=jdbc:orjdbc:@你的地址
dbUserName=你的用户
dbPassword=你的密码
jdbcName=oracle.jdbc.OracleDriver