dbconnectionmanager.java

利用JSP来实现网站的各种功能

package bookshop;
import java.sql.*;

public class DBConnectionManager {
	private String driverName=
		"com.mysql.jdbc.Driver";
	private String url=
		"jdbc:mysql://localhost:3306/bookshop";//;databaseName=bookshop
	private String user="root";
	private String password="19870921";
	
	public void setDriverName(String newDriverName){
		this.driverName=newDriverName;
	}
	public String getDriverName(){
		return driverName;}
	
	public void setUrl(String newUrl){
		this.url=newUrl;}
		
    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;
		}
		
	}

}