databaseconnection.java

一般性的内容,可以生成和修改还在有其他的好友添加等等

package zd.bbs ;
import java.sql.* ;
public class DataBaseConnection
{
	private final String DBDRIVER	= "com.microsoft.sqlserver.jdbc.SQLServerDriver" ;
	private final String DBURL		= "jdbc:sqlserver://localhost:1433;DatabaseName=db" ;
	private final String DBUSER		= "sa" ;
	private final String DBPASSWORD	= "tiantian" ;
	private Connection conn			= null ;
	public DataBaseConnection()
	{
		try
		{
			Class.forName(DBDRIVER) ; 
			conn = DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD) ;	
		}
		catch (Exception e)
		{
			e.printStackTrace();
		}
	}
	public Connection getConnection()
	{
		return this.conn ;
	}
	public void close()
	{
		try
		{
			this.conn.close() ;			
		}
		catch (Exception e)
		{
		}
	}
};