java 连接 oracle

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