dbconnectionmanager.java

来自「jsp学习 jsp编程白例源代码此部分是指文件夹名为第1～9章中的内容（如表1」· Java 代码 · 共 52 行

package bookshop;
import java.sql.*;

public class DBConnectionManager {
	private String driverName = 
"com.microsoft.jdbc.sqlserver.SQLServerDriver"; 
	private String url = 
				"jdbc:microsoft:sqlserver://localhost:1433;databaseName=bookshop";
	private String user = "sa";
	private String password = "123";

	public void setDriverName(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;
	        	}
	    	}
	
}