dbconnection.java

用jsp,java写的在线购物系统

// Decompiled by Jad v1.5.7g. Copyright 2000 Pavel Kouznetsov.
// Jad home page: http://www.geocities.com/SiliconValley/Bridge/8617/jad.html
// Decompiler options: packimports(3) fieldsfirst ansi 
// Source File Name:   DBConnection.java

package mediastore.common;

import java.io.PrintStream;
import java.sql.*;

// Referenced classes of package mediastore.common:
//            SystemConfig

public class DBConnection
{

    private static String DBDriver = null;
    private static String ConnStr = null;
    private int nDriverLoaded;

    public DBConnection()
        throws ClassNotFoundException
    {
        nDriverLoaded = -1;
        DBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
        ConnStr = SystemConfig.getDBConnection();
        System.out.println("ConnStr:" + ConnStr);
        try
        {
            Class.forName(DBDriver);
            nDriverLoaded = 0;
        }
        catch(ClassNotFoundException e)
        {
            throw e;
        }
    }

    public Connection getDBConnection()
        throws SQLException
    {
        Connection conn = null;
        if(nDriverLoaded == 0)
            try
            {
                conn = DriverManager.getConnection(ConnStr);
                System.out.println("conn is not null");
            }
            catch(SQLException e)
            {
                throw e;
            }
        return conn;
    }

    public void closeDBConnection(Connection conn)
        throws SQLException
    {
        try
        {
            conn.close();
        }
        catch(SQLException e)
        {
            throw e;
        }
    }

}