在微软网站下载jdbc的驱动,安装驱动,
将这三个包:
msbase.jar,mssqlserver.jar,msutil.jar
的路径放到环境变量classpath中,测试代码如下:
import java.sql.*;public class Test{
public void executeQuery(String sql){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;User=sa;Password=manager2000;DatabaseName=northwind");
// "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
Statement stmt=conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()){
System.out.println("TestName:"+rs.getString("lastname"));
}
}
catch(Exception ex) {
ex.printStackTrace();
}
}
public static void main(String args[]){ Test t=new Test();
t.executeQuery("select * from employees");
}
}
如还有问题请帖代码及异常
将这三个包:
msbase.jar,mssqlserver.jar,msutil.jar
的路径放到环境变量classpath中,测试代码如下:
import java.sql.*;public class Test{
public void executeQuery(String sql){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;User=sa;Password=manager2000;DatabaseName=northwind");
// "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
Statement stmt=conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()){
System.out.println("TestName:"+rs.getString("lastname"));
}
}
catch(Exception ex) {
ex.printStackTrace();
}
}
public static void main(String args[]){ Test t=new Test();
t.executeQuery("select * from employees");
}
}
如还有问题请帖代码及异常
我用Norton Internet Security的时候,开了防火墙就报这个错,你把NIS关了就没事了:)