sql server 2000和sqlserver 2005 连接字符串的区别在哪里?下面是属于sql2000连接代码吗?
- HTML code
private static final String DRIVERCLASS = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; [code=C#]private static final String URL = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=db_DrinkeryManage"; private static final String USERNAME = "sa"; private static final String PASSWORD = "123";
另,sqlserver 2005驱动包括哪些文件?在哪里下载?谢谢!!
------解决方案--------------------
- Java code
private static final String DRIVER = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; private static final String URL = "jdbc:microsoft:sqlserver://127.0.0.1:1433;databaseName=petClinic"; private static final String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver"; private static final String URL = "jdbc:sqlserver://127.0.0.1:1433;databaseName=petClinic"; private static final String USER = "sa"; private static final String PASSWORD = "ok";