我试过了,不行 to starDXJ(独行剑) :当然不是用odbc,否则直接用jdbc-odbc桥不就得了
CLASSPATH=.;F:\j2sdk1.4.1_01\lib;E:\Program Files\Microsoft SQL Server 2000 Driv er for JDBC\lib\msbase.jar;E:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar;E:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;F:\xml\ibm\xml4j_2_0_15\xml4j_2_0_15\xml4j.jar
install_dir/lib/msbase.jar
install_dir/lib/msutil.jar
install_dir/lib/mssqlserver.jar
(其中install_dir为安装目录)就是不行呀,程序如下:import java.util.*;
import javax.sql.*;
import java.sql.*;
//import com.microsoft.jdbc.sqlserver.SQLServerDriver;
//上面这句应该不用加吧,加上也没用public class DataTest{
public static void mian(String args[]){
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://192.168.0.94:1433","sa","111");
Statement stmt=conn.createStatement();
String SQL="select * from spt_values";
ResultSet rs=stmt.executeQuery(SQL);
while(rs.next()){
String name=rs.getString(1);
System.out.println(name);
}
}
}
你已经拷贝到install_dir/lib中了吗
to starDXJ(独行剑) :当然不是用odbc,否则直接用jdbc-odbc桥不就得了
er for JDBC\lib\msbase.jar;E:\Program Files\Microsoft SQL Server 2000 Driver for
JDBC\lib\mssqlserver.jar;E:\Program Files\Microsoft SQL Server 2000 Driver for
JDBC\lib\msutil.jar;F:\xml\ibm\xml4j_2_0_15\xml4j_2_0_15\xml4j.jar
jdbc:microsoft:sqlserver://192.168.0.94:1433;DatabaseName=?你可以去看看这个DRIVER的帮助
driver=com.microsoft.jdbc.sqlserver.SQLServerDriver
url=jdbc:microsoft:sqlserver://211.154.43.44:1433;databasename=sinopec
username=sa
password=
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");*……¥#??