Question

java怎么连接sql server 2000

Answer 1

一、下载SQLSERVER2000的jdbc驱动程序并安装。在微软站点就有这个驱动程序： http://msdn.microsoft.com/downloads/default.asp?URL=/downloads/sample.asp?url=/msdn-files/027/001/779/msdncompositedoc.xml&FinishURL=%2Fdownloads%2Frelease%2Easp%3FReleaseID%3D38312%26area%3Dsearch%26ordinal%3D1%26redirect%3Dno
二。将其拷贝到tomcat中的common/lib中，然后重起tomcat.
三。测试，
try(
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;User=sa;Password=;DatabaseName=maxwell");
)
catch(ClassNotFoundException e){out.print("open database error!");}

加入此句话测试天津众 维原画设计提供