我的,测试通过package test;
import java.sql.*;public class faq {
String sDBDriver ="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String URL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=huadu";
Connection conn = null;
ResultSet rs = null;public faq() {
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("My Error is(faq): " + e.getMessage());
}
}public ResultSet executeQuery(String sql) {
rs = null;
try {
conn = DriverManager.getConnection(URL,"sa","");
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("My Error is(executeQuery): " + ex.getMessage());
}
return rs;
}}
import java.sql.*;public class faq {
String sDBDriver ="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String URL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=huadu";
Connection conn = null;
ResultSet rs = null;public faq() {
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("My Error is(faq): " + e.getMessage());
}
}public ResultSet executeQuery(String sql) {
rs = null;
try {
conn = DriverManager.getConnection(URL,"sa","");
Statement stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("My Error is(executeQuery): " + ex.getMessage());
}
return rs;
}}
我就是安装后将ClassPath指向了安装目录的LIB子目录了
String url = urlHeader + servername + ":1433;User=‘" + uid + "’;Password=‘" + pwd+“’”;
参考设置:
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
谢谢大家热心帮助,散分!