java与sqlserver20052000数据库连接基类jdbc驱动资料

《java与sqlserver20052000数据库连接基类jdbc驱动资料》由会员上传分享，免费在线阅读，更多相关内容在应用文档-天天文库。

1、关于jdbc驱动可以去微软上下载importjava.sql.*;publicclassBaseDao{privateConnectiondbConn=null;privateStatementstmt=null;privateResultSetrs=null;publicvoidsetConnection(ConnectiondbConn){  this.dbConn=dbConn;}publicConnectiongetConnection(){  returnthis.dbConn;}publicStatementgetStateme

2、nt(){  returnthis.stmt;}publicvoidsetStatement(Statementstmt){  this.stmt=stmt;}publicResultSetgetResultSet(){  returnthis.rs;}publicvoidsetResultSet(ResultSetrs){  this.rs=rs;}publicvoidcreatConnect(){  StringdriverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";  //加

3、载JDBC驱动  StringdbURL="jdbc:sqlserver://localhost:1433;DatabaseName=rs";  //连接服务器和数据库rs    StringuserName="sa";  //默认用户名  StringuserPwd="123456";  //密码  try  {    Class.forName(driverName);    dbConn=DriverManager.getConnection(dbURL,userName,userPwd);    this.setConnection

4、(dbConn);    this.setStatement(dbConn.createStatement());    System.out.println("ConnectionSuccessful!");  }catch(SQLExceptione){  e.printStackTrace();  }}publicResultSetsearchResult(Stringstr){  try{  this.setResultSet(this.stmt.executeQuery(str));  }catch(SQLExceptione){

5、      e.printStackTrace();  }  returnthis.rs;}publicvoidupdateResult(Stringstr){  try{  this.stmt.executeUpdate(str);  }catch(SQLExceptione){      e.printStackTrace();  }}publicvoidcloseConnect(){  try{      if(this.rs!=null){      this.rs.close();      this.rs=null;      

6、}      if(this.stmt!=null){      this.stmt.close();      this.stmt=null;      }      if(this.dbConn!=null){      this.dbConn.close();      this.dbConn=null;      }  }catch(SQLExceptione){      e.printStackTrace();  }}}另外注:1.因为SQLexpress服务器默认是禁用的并且端口号没有配置,所以要进行重新设置2.如果你以前用j

7、ava连接sqlserver2000的话就要注意了:在sqlserver2000中加载驱动和URL路径的语句是StringdriverName="com.microsoft.jdbc.sqlserver.SQLServerDriver";StringdbURL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=rs";而sqlserver2005中加载驱动和url的语句则为StringdriverName="com.microsoft.sqlserver.jdbc.SQLServ

8、erDriver";StringdbURL="jdbc:sqlserver://localhost:1433;DatabaseName=rs";如果写法错误将会找不到驱动.sql