SQL2000 关于 Java JDBC 驱动的安装和设定

    }
   
    private Connection getConnection() {
       
        try {
           
            System.out.println (getConnectionUrl());
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
            //Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDrive");
            conn =
                DriverManager.getConnection(getConnectionUrl(),userName,password);
               
            if(conn != null) {
               
                System.out.println ("数据库连接成功!");
            }
           
        }catch(Exception ce) {
           
            ce.printStackTrace();
            System.out.println ("getConnection() 内部错误跟踪:" +
                                ce.getMessage());
        }
       
        return conn;
    }
   
    public void display() {
       
        try {
           
            conn = getConnection();
            PreparedStatement pstmt =
                conn.prepareStatement("update friends set "+
                "salary = ? where name like ?");
            pstmt.setInt(1,10000);
            pstmt.setString(2,"李四");
            pstmt.executeUpdate();