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