databaseconnection.java

自己做的一个火车票售票网站是课程设计 用的是servlet+jsp 数据库是ms

package com.jdbc;

import java.sql.*;

public class DataBaseConnection {
	private final String DBDRIVER="com.microsoft.jdbc.sqlserver.SQLServerDriver";
	private final String DBURL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=kese";
	private final String DBUSER="sa";
	private final String DBPASSWORD="";
	private Connection cnn =null;
	public DataBaseConnection(){
		try{
			Class.forName(DBDRIVER);
			cnn=DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);
		}
		catch(Exception e){
			
		}
	}
	public Connection getConnection(){
		return this.cnn;
	}
	public void close(){
		try{
			this.cnn.close();
		}
		catch(Exception e){
			
		}
		
	}

}