dbconnection.java

理发店网上发型设计预约系统

package barbershop.database;

import java.sql.*;

public class DBConnection
{
	private String driverName="com.microsoft.jdbc.sqlserver.SQLServerDriver";
	
	private String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=barbershop";
	
	private String sqlPassword="123";
	 		
	public void setDriverName(String driverName)
	{
		this.driverName = driverName;
	}
	
	public String getDriverName()
	{
		return driverName;
	}
	
	public void setUrl(String url)
	{
		this.url = url;
	}
	
	public String getUrl()
	{
		return url;
	}
	
	public void setSqlPassword(String password)
	{
		this.sqlPassword = password;
	}
	
	public String getSqlPassword()
	{
		return sqlPassword;
	}
	
	public Connection getConnection()
	{
		try
		{
			Class.forName(driverName);
			return DriverManager.getConnection(url,"sa",sqlPassword);
		}
		catch(Exception e)
		{
			e.printStackTrace();
			return null;
		}
	}
}