java 与sql server 2005(2000)数据库连接 基类（jdbc驱动）（转）

import java.sql.*; public class BaseDao { private Connection dbConn=null; private Statement stmt=null; private ResultSet rs=null; public void setConnection(Connection dbConn) { this.dbConn=dbConn; } public Connection getConnection() { return this.dbConn; } public Statement getStatement() { return this.stmt; } public void setStatement(Statement stmt) { this.stmt=stmt; } public ResultSet getResultSet(){ return this.rs; } public void setResultSet(ResultSet rs) { this.rs=rs; } public void creatConnect() { String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //加载JDBC驱动 String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=rs"; //连接服务器和数据库rs String userName = "sa"; //默认用户名 String userPwd = "123456"; //密码 try { Class.forName(driverName); dbConn = DriverManager.getConnection(dbURL, userName, userPwd); this.setConnection(dbConn); this.setStatement(dbConn.createStatement()); System.out.println("Connection Successful!"); }catch (SQLException e) { e.printStackTrace(); } } public ResultSet searchResult(String str){ try{ this.setResultSet(this.stmt.executeQuery(str)); }catch (SQLException e) { e.printStackTrace(); } return this.rs; } public void updateResult(String str) { try{ this.stmt.executeUpdate(str); }catch (SQLException e) { e.printStackTrace(); } } public void closeConnect(){ try { if(this.rs != null) { this.rs.close(); this.rs = null; } if(this.stmt != null) { this.stmt.close(); this.stmt = null; } if(this.dbConn != null) { this.dbConn.close(); this.dbConn = null; } } catch (SQLException e) { e.printStackTrace(); } } }

另外 
注:1.因为SQLexpress服务器默认是禁用的并且端口号没有配置,所以要进行重新设置 
2.如果你以前用java连接sql server 2000的话就要注意了: 
在sql server 2000 中加载驱动和URL路径的语句是 
String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; 
String dbURL = "jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=rs"; 
而sql server 2005 中加载驱动和url的语句则为 
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; 
String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=rs"; 
如果写法错误将会找不到驱动.

sqlserver数据库：java连接sqlserver2005数据库心得体会

首先得下载驱动程序到微软网站下载Microsoft SQL Server 2005 JDBC Driver 1.2　　解压Microsoft SQL Server 2005 jdbc driver1.2.exe 

得到sqljdbc.jar，用得时候直接加到classpath中去.