各位好:本人XP系统下安装SQLSERVER2000个人版,并下载安装了升级包SP4,JDBC驱程安装了SP3同时已将BIN\目录下的三个文件设置好PATH环境变量,但找不出原因为什么会连接不上SQL,SQLSERVER已正常启动,JAVA程序代码如下:
package JDBCtest;
import java.sql.*;public class TestJdbc { /**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
String strDriver="com.microsoft.jdbc.sqlServer.SQLServerDriver";
String url="jdbc:microsoft:sqlserver:(local):1433"+","+"tocm"+","+"111111";
try {
Class.forName(strDriver);
try {
Connection con=DriverManager.getConnection(url);
Statement stm=con.createStatement();
ResultSet rs=stm.executeQuery("Select * form student");
while(rs.next())
{
System.out.println(rs.getRow());
System.out.println("id: "+rs.getInt(1));
System.out.println("name:"+rs.getString(2));
System.out.println("age;"+rs.getInt(3));
System.out.println("department;"+rs.getString(4));
}
rs.close();
stm.close();
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
System.out.println("loader Driver fail");
} }}
请高手指点原因所在,谢谢
(url, "username","password");
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
return DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=SCMS", "sa", "sa");
}
try {
Class.forName(strDriver); 这语句就出异常了,应该就执行不到下面的语句吧,不知道驱程还要设置些什么.