opendb.java

来自「一个银行数据中心网站」· Java 代码 · 共 36 行

package com.am;
import java.sql.*;

public class OpenDB
{

    String userName="sa";
    String userPassword="1";
    private String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
    private String url = "jdbc:microsoft:sqlserver://localhost:1433;dataBaseName=test";

    private Connection dbConn;
    public OpenDB()
    {

    }
    public Connection getConnection()
    {
        try
        {
            Class.forName(driverName).newInstance();
            dbConn=DriverManager.getConnection(url,userName,userPassword);


        }
        catch(Exception ex)
        {
            System.out.println(ex.toString());
            dbConn = null;
        }

        return dbConn;
    }

}