sothis wrote:
>是不是在连接SQL Server 2000时,如果没有安装SQL Server 的SP4补丁包,Tomcat就打不开1433端口啊.
是的

longchuan wrote:
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]用户 'sa' 登录失败。原因: 未与信任 SQL Server 连接相关联。
......
我在这里搜过,但没有找到.

import java.sql.*;

public class Dbtest {

    Connection con;
    Statement sta;
    ResultSet rs;

    String driver;
    String url;
    String user;
    String pwd;

    public Dbtest() {
        driver = "net.sourceforge.jtds.jdbc.Driver";
        url = "jdbc:jtds:sqlserver://127.0.0.1:1433/Northwind";
        user = "sa";
        pwd = "你的密码";
        init();
    }

    public void init() {
        try {
            Class.forName(driver);
            System.out.println("driver is ok");
            con = DriverManager.getConnection(url, user, pwd);
            System.out.println("conection is ok");
            sta = con.createStatement();
            rs = sta.executeQuery("select * from Categories");
            while (rs.next())
                System.out.println(rs.getString("CategoryName"));
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public static void main(String args [])
    {
        new Dbtest();
    }
}