连接SQLServer数据库

/*
 * 用于连接SQL Server 2000数据库
 */
package lib;

import java.sql.*;

public class DBConnector
{

  String DriverName;
  String ip;
  int port;
  String DBName;
  String DBUrl;
  String userName;
  String password;
  Connection conn;
  ResultSet rs;
 
 
 public String getDBUrl()
 {
     return DBUrl;
 }
 public void setDBUrl(String url)
 {
     DBUrl = url;
 }
 public String getDriverName()
 {
     return DriverName;
 }
 public void setDriverName(String driverName)
 {
     DriverName = driverName;
 }
 
  public String getDBName() {
  return DBName;
 }
 public void setDBName(String name) {
  DBName = name;
 }
 public String getIp() {
  return ip;
 }
 public void setIp(String ip) {
  this.ip = ip;
 }
 public String getPassword() {
  return password;
 }
 public void setPassword(String password) {
  this.password = password;
 }
 public int getPort() {
  return port;
 }
 public void setPort(int port) {
  this.port = port;
 }
 public String getUserName() {
  return userName;
 }
 public void setUserName(String userName) {
  this.userName = userName;
 }
 public DBConnector()
  {
  port = 1433;      //SQl Server默认端口为1433
  DriverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
  conn = null;
  rs = null;
  }
 public void getConnection()
 {
  if(ip!=null&&DBName!=null)
  {
   DBUrl = "jdbc:microsoft:sqlserver://" + ip + ":" + port + ";";
   DBUrl += "DatabaseName=" + DBName;
  }
     try
     {
         Class.forName(DriverName);
         conn = DriverManager.getConnection(DBUrl,userName,password);
     }
     catch(Exception e){}
 }
  public void executeInsert(String s)
  {
      try
      {
          Statement statement = conn.createStatement();
          int i = statement.executeUpdate(s);
      }
      catch(SQLException sqlexception)
      {
          System.err.println("faq.executeUpdate:" + sqlexception.getMessage());
      }
  }
 
  public ResultSet executeQuery(String s)
  {
      rs = null;
      try
      {
          Statement statement = conn.createStatement();
          rs = statement.executeQuery(s);
      }
      catch(Exception e)
      {
       e.printStackTrace();
      }
      return rs;
  }
 
  public void executeDelete(String s)
  {
      try
      {
          Statement statement = conn.createStatement();
          statement.executeUpdate(s);
      }
      catch(SQLException sqlexception)
      {
          System.err.println("faq.executeDelete: " + sqlexception.getMessage());
      }
  }
 
  public int executeUpdate(String s)
  {
      int i = 0;
      try
      {
          Statement statement = conn.createStatement();
          i = statement.executeUpdate(s);
      }
      catch(SQLException sqlexception)
      {
          System.err.println("faq.executeDelete: " + sqlexception.getMessage());
      }
      return i;
  }
 
  public void close()
  {
      try
      {
          if(rs != null)
              rs.close();
          if(conn != null)
              conn.close();
      }
      catch(SQLException sqlexception)
      {
          System.err.println("faq.executeDelete: " + sqlexception.getMessage());
      }
  }
}

//

/*
 * 连接SQL Server2000数据库测试
 */
package test;

import java.net.URL;
import java.sql.*;
import lib.*;

public class CSQLTest
{
       public static void main(String[] args)
       {
        DBConnector dbc = new DBConnector();
        dbc.setIp("GDDL-BPF5IYUDUP");
        dbc.setDBName("GDDB");
        dbc.setUserName("Xing");
        dbc.setPassword("123456");
           String query="select * from BuJian";
              try
              {
               dbc.getConnection();
               ResultSet rs = dbc.executeQuery(query);
                 while(rs.next())
                  System.out.println(rs.getString(2));
                 dbc.close();
 
              }
              catch(SQLException ex)
              {
               ex.printStackTrace();
              }
              catch(java.lang.Exception ex)
              {
                 ex.printStackTrace();
              }
       }
}