jtds1.1连接sqlserver2000测试示例

public class testsqlserverjtds {
 public static void main(string[] args) {
  connection con=null;

        try
        {
            string driver="net.sourceforge.jtds.jdbc.driver";
            string url="jdbc:jtds:sqlserver://192.168.0.15:1433;databasename=test";
            class.forname(driver).newinstance();
            system.out.println(" 连接开始。。。。。。");
            long starttime = system.currenttimemillis();
            con =drivermanager.getconnection(url,"sa","123");
            long endtime = system.currenttimemillis();
            system.out.println(" 连接成功 !lost time:" + (endtime - starttime) / 1000 + "秒");

            con.close();
        } catch(exception e) {
            e.printstacktrace();
        } finally{
         try {

          if(null != con){
           con.close();
          }
         } catch (sqlexception e) {
    e.printstacktrace();
   }
        }
 }
}