读取jdbc.properties文件，信息入库

 ToSaveErrlog.java

package com.inspur.sms.util;

import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

public class ToSaveErrlog {
	public Connection conn = null;
	public Properties props;
	public String url;
	public String user;
	public String password;
	public String driver;

	public ToSaveErrlog() throws FileNotFoundException,
			IOException, ClassNotFoundException {
		/*
		 * 获取properties的相对路劲：ToSaveErrlog.class.getClassLoader().getResourceAsStream("save2logdb.properties")
		 * 加载properties文件
		 * */
		props = new Properties();
		props.load(ToSaveErrlog.class.getClassLoader().getResourceAsStream("save2logdb.properties"));
		url = props.getProperty("jdbc.url");
		user = props.getProperty("jdbc.username");
		password = props.getProperty("jdbc.password");
		driver = props.getProperty("jdbc.driverClassName");
		Class.forName(driver);
	}

	/*
	 * 将接受参数,存入数据库SMSLOG2DB表中
	 */
	public void toSaveLog(String sendNum, String sendCont, int sendLevel,
			int sendErrorNum) throws Exception {
		String sql = spellSql(sendNum, sendCont, sendLevel, sendErrorNum);
		sqlBusiness(sql);
	}

	/*
	 * 拼sql
	 */
	public String spellSql(String sendNum, String sendCont, int sendLevel,
			int sendErrorNum) {
		String sql = "INSERT INTO LOGDB.SMSLOG2DB(SENDTIME, SENDNUM, SENDCONT, SENDLEVEL, SENDERRORNUM) "
				+ "VALUES(SYSDATE, '"
				+ sendNum
				+ "', '"
				+ sendCont
				+ "',"
				+ sendLevel + "," + sendErrorNum + ")";
		return sql;
	}

	/*
	 * 存入数据库
	 */
	private void sqlBusiness(String sql) throws SQLException, Exception {
		String url = null;

		Class.forName(driver);
		conn = getConnection();
		Statement stmt = conn.createStatement();
		stmt.executeUpdate(sql);
		stmt.close();
		conn.close();
		System.out.println("OK");
	}

	/*
	 * 从jdbc.properties文件中读出参数
	 */
	public Connection getConnection() throws SQLException {
		return DriverManager.getConnection(url, user, password);
	}
	


}

Test.java

package test;

import java.util.ArrayList;
import java.util.List;

import com.inspur.sms.util.ToSaveErrlog;

public class Test {
	/**
	 * @param args
	 * @throws Exception
	 */
	public static void main(String[] args) throws Exception {
		/* 调用ToSaveErrlog类中得方法toSaveLog将日志存入数据库SMSLOG2DB表中 */
		new ToSaveErrlog().driver		
		ToSaveErrlog toSaveErrlog = new ToSaveErrlog();
		toSaveErrlog.toSaveLog("13581581581", "短信测试Test555", 3, 9);
	}
}

save2logdb.properties

jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@192.168.1.234:1521:orcl
jdbc.username=logdb
jdbc.password=logdb