dbbean.java~1~

基于J2EE的在线股票系统,其界面漂亮,对与初学者来说是一个很好的案例

package util;

import java.sql.*;

public class DBBean {
    private static String driver =
            "com.microsoft.jdbc.sqlserver.SQLServerDriver";
    private static String url =
            "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=auction";
    //private static String driver = "sun.jdbc.odbc.JdbcOdbcDriver";
    //private static String url = "jdbc:odbc:auction";

    private DBBean() {
    }

    /**
     * 建立一个可用连接，没有建立成功时，返回null
     * @return conn Connection
     */
    public static Connection getConnection() throws ClassNotFoundException,
            SQLException {
        Connection conn = null;

        Class.forName(driver);
        conn = DriverManager.getConnection(url, "sa", "sa");
        return conn;
    }
}