java与sqlserver连接问题

[wangtianabc]

我装上jdbc的驱动后classpath＝.;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar
我的程序如下
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(Exception e)
{
System.out.println("1:"+e);
}
try
{
Connection con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs","sa","004687bty");
Statement sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs=sql.executeQuery("select * from authors");
while(rs.next())
{
System.out.print(rs.getString(2));
System.out.print("");
}
}
catch(SQLException e)
{
System.out.println("2:"+e);
}
还是抛出异常如下：
1:java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
2:java.sql.SQLException: No suitable driver

[djpsunday]

你要把三个驱动包放到TOMCAT容器下lib相应目录下才会起作用的,配环境变量是为了在DOS模式下编译执行JAVA类的!

[wangtianabc]

在eclipse环境下编译不行吗

[jiankuang0802]

没发现驱动程序?用eclipse吧,项目-属性,在里面直接添加 jar包.

[wangtianabc]

搞定