/**
* @author ivan
*此对象用于读取配置文件的信息
*/
public class ReadProperties {
/*
* 加载指定路径下的配置文件信息,并获得Properties对象
* (non-Javadoc)
* @see com.voole.interf.IProperties#getProperties()
* @return Properties对象
*/
public static Properties getProperties() {
return getProperties("/config.properties");
}
public static Properties getProperties(String path) {
InputStream inStream = ReadProperties.class.getResourceAsStream(path);
Properties prop = new Properties();
try {
if(inStream != null){
prop.load(inStream);
inStream.close();
}
} catch (IOException e) {
System.out.println("加载指定路径下的配置文件出错！"+e.getMessage());
}
return prop;
}
//使用
public static void main(String[] args) {
Properties pr = ReadProperties.getProperties();
System.out.println("mysql connection -- " + pr.getProperty("SQL_DRIVER"));
}
}
public final class ConnectionManager {
private ComboPooledDataSource ds;
private ConnectionManager(String propertiesPath) throws Exception {
ds = new ComboPooledDataSource();
Properties properties = ReadProperties.getProperties(propertiesPath);
// ds.setDriverClass("oracle.jdbc.driver.OracleDriver");
// ds.setJdbcUrl("jdbc:oracle:thin:@127.0.0.1:1521:orcl");
// ds.setUser("test");
// ds.setPassword("testtest");
ds.setDriverClass(properties.getProperty("SQL_DRIVER"));
ds.setJdbcUrl(properties.getProperty("CONTEST_CONN_URL"));
//初始化时获取三个连接，取值应在minPoolSize与maxPoolSize之间。Default: 3 initialPoolSize
ds.setInitialPoolSize(3);
//连接池中保留的最大连接数。Default: 15 maxPoolSize
ds.setMaxPoolSize(50);
连接池中保留的最小连接数。
//ds.setMinPoolSize(1);
//当连接池中的连接耗尽的时候c3p0一次同时获取的连接数。Default: 3 acquireIncrement
ds.setAcquireIncrement(1);
//每60秒检查所有连接池中的空闲连接。Default: 0 idleConnectionTestPeriod
ds.setIdleConnectionTestPeriod(60);
//最大空闲时间,25000秒内未使用则连接被丢弃。若为0则永不丢弃。Default: 0 maxIdleTime
ds.setMaxIdleTime(25000);
//连接关闭时默认将所有未提交的操作回滚。Default: false autoCommitOnClose
ds.setAutoCommitOnClose(true);
//定义所有连接测试都执行的测试语句。在使用连接测试的情况下这个一显著提高测试速度。注意：
//测试的表必须在初始数据源的时候就存在。Default: null preferredTestQuery
ds.setPreferredTestQuery("select now()");
// 因性能消耗大请只在需要的时候使用它。如果设为true那么在每个connection提交的
// 时候都将校验其有效性。建议使用idleConnectionTestPeriod或automaticTestTable
// 等方法来提升连接测试的性能。Default: false testConnectionOnCheckout
ds.setTestConnectionOnCheckout(false);
//如果设为true那么在取得连接的同时将校验连接的有效性。Default: false testConnectionOnCheckin
ds.setTestConnectionOnCheckin(true);
//定义在从数据库获取新连接失败后重复尝试的次数。Default: 30 acquireRetryAttempts
ds.setAcquireRetryAttempts(30);
//两次连接中间隔时间，单位毫秒。Default: 1000 acquireRetryDelay
ds.setAcquireRetryDelay(1000);
//获取连接失败将会引起所有等待连接池来获取连接的线程抛出异常。但是数据源仍有效
//保留，并在下次调用getConnection()的时候继续尝试获取连接。如果设为true，那么在尝试
//获取连接失败后该数据源将申明已断开并永久关闭。Default: false breakAfterAcquireFailure
ds.setBreakAfterAcquireFailure(true);
// <!--当连接池用完时客户端调用getConnection()后等待获取新连接的时间，超时后将抛出
// SQLException,如设为0则无限期等待。单位毫秒。Default: 0 -->
// <property name="checkoutTimeout">100</property>
// <!--c3p0将建一张名为Test的空表，并使用其自带的查询语句进行测试。如果定义了这个参数那么
// 属性preferredTestQuery将被忽略。你不能在这张Test表上进行任何操作，它将只供c3p0测试
// 使用。Default: null-->
// <property name="automaticTestTable">Test</property>
// <!--JDBC的标准参数，用以控制数据源内加载的PreparedStatements数量。但由于预缓存的statements
// 属于单个connection而不是整个连接池。所以设置这个参数需要考虑到多方面的因素。
// 如果maxStatements与maxStatementsPerConnection均为0，则缓存被关闭。Default: 0-->
// <property name="maxStatements">100</property>
// <!--maxStatementsPerConnection定义了连接池内单个连接所拥有的最大缓存statements数。Default: 0 -->
// <property name="maxStatementsPerConnection"></property>
// <!--c3p0是异步操作的，缓慢的JDBC操作通过帮助进程完成。扩展这些操作可以有效的提升性能
// 通过多线程实现多个操作同时被执行。Default: 3-->
// <property name="numHelperThreads">3</property>
// <!--用户修改系统配置参数执行前最多等待300秒。Default: 300 -->
// <property name="propertyCycle">300</property>
}
private static Map<String , ConnectionManager> managers = new HashMap<String, ConnectionManager>();
public static synchronized ConnectionManager getConnectionManager(String propertiesPath){
ConnectionManager manager = managers.get(propertiesPath);
if(manager == null){
try {
manager = new ConnectionManager(propertiesPath);
managers.put(propertiesPath, manager);
} catch (Exception e) {
throw new RuntimeException(e);
}
}
return manager;
}
public Connection getConnection() throws SQLException {
return ds.getConnection();
}
protected void finalize() throws Throwable {
DataSources.destroy(ds); //关闭datasource
super.finalize();
}
public static void closeConnection(Connection c){
try {
if(c != null)
c.close();
} catch (SQLException e) {
}
}
public static void closeStatement(Statement c){
try {
if(c != null)
c.close();
} catch (SQLException e) {
}
}
public static void closeResultSet(ResultSet c){
try {
if(c != null)
c.close();
} catch (SQLException e) {
}
}
}
public class DB {
public static Connection getConnection(String sqlDriver, String url) {
Connection conn = null;
try {
Class.forName(sqlDriver);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
try {
conn = DriverManager.getConnection(url);
} catch (SQLException e) {
try {
Thread.sleep(5000);
getConnection(sqlDriver, url);
} catch (InterruptedException e1) {
e1.printStackTrace();
}
e.printStackTrace();
}
return conn;
}
//通过数据库连接池c3p0获取connection
public static Connection getConnection(String propertyName){
Connection conn = null;
ConnectionManager manager = ConnectionManager.getConnectionManager(propertyName);
try {
conn = manager.getConnection();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
public static Statement getStatement(Connection conn) {
Statement stmt = null;
try {
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
} catch (SQLException e) {
e.printStackTrace();
}
return stmt;
}
public static PreparedStatement getPrepaStatement (Connection conn,String sql) {
PreparedStatement ps = null;
try {
ps = conn.prepareStatement(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return ps;
}
public static ResultSet getResultSet(Statement stmt,String sql){
ResultSet rs = null;
try {
rs = stmt.executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
}
return rs;
}
public static void update(Statement stmt,String sql){
try {
stmt.executeUpdate(sql);
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void closeConnection(Connection conn){
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public static void closeStatement(Statement stmt){
if (stmt != null) {
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public static void closeResultSet(ResultSet rs){
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
public void updateIndex() {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
conn = manager.getConnection();
stmt = DB.getStatement(conn);
String sqlSum = "select count(*) from IndexServiceCompany where ExecStatus=1";
rs = DB.getResultSet(stmt, sqlSum);
int recordSum = 0;
while (rs.next()) {
recordSum = rs.getInt(1);
}
int createTotal = 0;
if (recordSum > 0) {
createTotal = recordSum / indexSize + 1; // 要创建总次数
for (int j = 0; j < createTotal; j++) {
String sql = "select TOP ("
+ indexSize
+ ")* from IndexServiceCompany where ExecStatus=1 order by IID ";
String update = "";
rs = DB.getResultSet(stmt, sql);
int status = 0;
while (rs.next()) {
iid = rs.getInt("IID");
status = rs.getInt("EditStatus");
switch (status) {
case 1:
update(conn, rs.getString("TableName"), rs
.getString("ObjectCode"));// 也是新增的代码
System.out.println("新增...");
break;
case 2:
update(conn, rs.getString("TableName"), rs
.getString("ObjectCode"));
System.out.println("更新...");
break;
case 3:
delete(rs.getString("ObjectCode"));
default:
break;
}
update += iid + ",";
}
//批量提交docs给solr
if (addDocs.size() > 0) {
solrServer.add(addDocs);
solrServer.commit();
System.out.println("此次更新记录数 ：" + addDocs.size() + "条");
addDocs.clear();
}
// 更新数据库，标示此条记录已跟新到solr索引中
update = update.substring(0, update.length() - 1);
String upSql = "update IndexServiceCompany set ExecStatus=2, ExecTime=getdate() where IID in ("
+ update + ")";
DB.update(stmt, upSql);
System.out
.println(new Date() + " -- 第 " + (j + 1) + " 更新OK");
}// for over
} else {
System.out.println(new Date() + " -- no data ...");
}
} catch (SQLException e) {
e.printStackTrace();
} catch (SolrServerException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} finally {
ConnectionManager.closeResultSet(rs);
ConnectionManager.closeStatement(stmt);
ConnectionManager.closeConnection(conn);
}
}
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
