SqlServer2000和SqlServer2005连接字符串

    --------------2000连接字符串------------

    private static final String driverName="com.microsoft.jdbc.sqlserver.SQLServerDriver";
    private static final String conStr="jdbc:microsoft:sqlserver://localhost:1433;databaseName=Demo";
    private static final String user="sa";
    private static final String pwd="ok";
   
    /**
     * 获得连接，JDBC方式
     * */
    public static Connection getConn(){
        Connection con=null;
        try {
            Class.forName(driverName);
            con=DriverManager.getConnection(conStr,user,pwd);
            System.out.println("success");
        } catch (Exception e) {
            System.out.println(e.getMessage());
            System.out.println("fault");
        }
        return con;
    }

    --------------2005连接字符串---------------------

    private static final String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";
    private static final String conStr="jdbc:sqlserver://localhost:1433;databaseName=T6GS_2008_001";
    private static final String user="sa";
    private static final String pwd="ok";
   
    /**
     * 获得连接，JDBC方式
     * */
    public static Connection getConn(){
        Connection con=null;
        try {
            Class.forName(driverName);
            con=DriverManager.getConnection(conStr,user,pwd);
            System.out.println("success");
        } catch (Exception e) {
            System.out.println(e.getMessage());
            System.out.println("fault");
        }
        return con;
    }