dbconnectionmanager.java~4~

图书管理系统,B/S,C/S都有,附有源代码

package database;
import java.sql.*;
/**
 * <p>Title: library</p>
 * <p>Description: library</p>
 * <p>Copyright: Copyright (c) 2007</p>
 * <p>Company: </p>
 * @author nino
 * @version 0.1
 */

public class DBConnectionManager {

  //SQLServer
  private String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
  private String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Library_Data";
  private String user = "sa";
  private String password = "";

  public void setDriverName(String newDriverName) {
      driverName = newDriverName;
  }
  public String getDriverName() {
      return driverName;
  }

  public void setUrl(String newUrl) {
      url = newUrl;
  }
  public String getUrl() {
      return url;
  }
  public void setUser(String newUser) {
      user = newUser;
  }
  public String getUser() {
      return user;
  }
  public void setPassword(String newPassword) {
      password = newPassword;
  }
  public String getPassword() {
      return password;
  }

  public Connection getConnection() {
      try {
          Class.forName(driverName);
          return DriverManager.getConnection(url, user, password);
      }
      catch (Exception e) {
          e.printStackTrace();
          return null;
      }
  }

}