刚试了,好像不是那个问题。我想配置有问题,我是将sql 2000 driver for jdbc的3个数据包的目录(D:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib)加到环境变量的classpath中去,对吗?请教!
http://www.csdn.net/develop/Read_Article.asp?Id=18012二、安装jdbc驱动程序 对于windows2000操作系统的sqlserver2000 双击setup安装jdbc驱动程序,将/program files/microsoft SQL Server 2000 driver for JDBC/lib目录下的.jar文件拷贝至公共库的/tomcat/common/lib目录下就可以了!
对于windows2000操作系统的sqlserver2000
双击setup安装jdbc驱动程序,将/program files/microsoft SQL Server 2000 driver for JDBC/lib目录下的.jar文件拷贝至公共库的/tomcat/common/lib目录下就可以了!
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Name";
//Name为你的数据库的
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from forums";
ResultSet rs=stmt.executeQuery(sql);