菜鸟发问:JDBC与SQLserver连接的问题,提示“sa”登陆失败
彷徨的龙 2004-10-09 02:30:53 jdbc的驱动按照大侠们的都下载安装了,也设置了classpath
就是不能通过,错误提示:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]用户 ''sa'' 登录失败。原因: 未与信任 SQL Server 连接相关联。
源码:
import java.sql.*;
public class Test{
public Test(){}
public static void main(String args[]){
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); }
catch(ClassNotFoundException e){System.out.println("驱动加载不成功 ");}
try{
Connection conn =DriverManager.getConnection("jdbc:microsoft:sqlserver://Localhost:1433;User='sa';Password='';DatabaseName=pubs");
Statement stmt=conn.createStatement();
String sql="select * from employee";
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()) {
System.out.println("TestName:"+rs.getString("name"));
}
rs.close();
stmt.close();
conn.close();
} catch(Exception ex) { System.err.println(ex.getMessage()); }
}
}
多谢啊!!!!!