我已经下载了jdbc driver: com.inet.tds.TdsDriver.

Question

我发给你的邮件上附有文档，如果还不清楚，我给个例子你：String url="jdbc:inetdae7:10.1.22.134:1433?charset=gb2312&database=MyDatabase";
String driver="com.inet.tds.TdsDriver";
try{
  Class.forName(driver).newInstance();
  Connection con=DriverManager.getConnection(url,usr,password);
  ……
}catch(Exception e){
  ……
}

Answer 1

报错
E:\Study\java\Test>java DbSql
java.lang.ClassNotFoundException: com.inet.tds.TdsDriverDbSql.java-------------
import java.sql.*;public class DbSql
{
  public static void main(String args[])
  {
  try
  {
     String url="jdbc:inetdae7:202.121.67.141:1433?charset=gb2312&database=Graduate";
     String driver="com.inet.tds.TdsDriver";  Class.forName(driver).newInstance();     String login = "administrator";
     String password = "tzy";
     Connection con=DriverManager.getConnection(url,login,password);     DatabaseMetaData conMD = con.getMetaData();
     Statement st = con.createStatement();
     ResultSet rs = st.executeQuery("SELECT size FROM sysfiles");
     while (rs.next())
     {
       System.out.println(String.valueOf(rs.getInt("size")));
     }
     System.out.println();
     st.close();
     con.close();
     }
      catch(java.sql.SQLException e){System.out.println(e.toString());}
      catch(java.lang.ClassNotFoundException e){System.out.println(e.toString());}
      catch(java.lang.InstantiationException e){System.out.println(e.toString());}
      catch(java.lang.IllegalAccessException e){System.out.println(e.toString());}
 }
}安装的是jdbc driver: com.inet.tds.TdsDriver将驱动程序 freetds_jdbc.jar 拷贝到d:\jbuilder5\jdk1.3\LIB下面autoexec.bat-------SET JAVA_HOME=d:\jbuilder5\jdk1.3
set classpath=./;d:\jbuilder5\jdk1.3\bin\tools.jar;d:\jbuilder5\jdk1.3\lib\dt.jar;d:\jbuilder5\jdk1.3\lib
path=%path%;d:\jbuilder5\jdk1.3\bin;d:\jbuilder5\jdk1.3;d:\tomcat\bin