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();

本新闻共4页,当前在第2页 1 2 3 4

上一篇：Oracle与Access表之间的导入和导出实现

下一篇：解决方法摘自 studyhardlr 『http://www.javathinker.org/bbs/topic.jsp?db=7&topic=3749』

.elmc"