dbconnection.java

封装了SQL、Socket、WAP、MIME等功能的通用组件

package org.lazybug.sql;

import java.sql.*;
import java.util.Map;
import org.lazybug.util.ConfigUtil;
/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2003</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class DBConnection
{
    private static int id = 0;
    public String dbconn_id;
    private long validPeriod = 0;
    private Connection conn;

    protected DBConnection(String url, String user, String password) throws SQLException
    {
        conn = DriverManager.getConnection(url, user, password);
        dbconn_id = "连接["+(id++)+"]";
    }
    protected DBConnection(String url) throws SQLException
    {
        conn = DriverManager.getConnection(url);
        dbconn_id = "连接["+(id++)+"]";
    }

    public Connection get()
    {
        validPeriod = System.currentTimeMillis()+ConfigUtil.getInteger("db_cvp");
        return conn;
    }

    protected long validPeriod()
    {
        return validPeriod;
    }

    protected boolean isClosed() throws SQLException
    {
        return conn.isClosed();
    }

    protected void close() throws SQLException
    {
        this.conn.close();
    }
}