dbconnectionmanager.java

JSP+SQL应用开发网上书店系统,采用BMP模式开发

package hell;

import java.sql.*;

public class DBConnectionManager {

 private String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=J2EETest";
 private String user="sa";
 private String password="";
 private String driverName="com.microsoft.jdbc.sqlserver.SQLServerDriver";
public void setDrivaerName(String newDriverName){
   this.driverName =newDriverName;
 }
public String getDriverName(){
 return driverName;
 }
public void setUrl(String newUrl){
 this.url =newUrl;
 }
 public String getUrl(){
 return url;
 }
 public void setUser(String newUser){
  this.user =newUser;
 }
 public String getUser(){
 return user;
 }
public void setPassword(String newPassword){
 this.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;
  }
 }
}