dbconnection.java

可以完成会议室预定功能

import java.sql.*;

public class DBConnection {
	private String url = null;
	private String user = null;
	private String pwd = null;
	
	public DBConnection(String dbUrl,String dbUser,String dbPwd){
		url = "jdbc:odbc:"+dbUrl;
		user = dbUser;
		pwd = dbPwd;
	}
/*
 * 获取数据库连接
 * 返回连接对象
 */
	public Connection getConn(){
		
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection conn = DriverManager.getConnection(url,user,pwd);
			System.out.println("数据库连接成功！");
			return conn;
		}catch(ClassNotFoundException e){
			System.out.println("Driver no Found!");
			System.out.println(e);
			return null;
		}catch(SQLException e){
			System.out.println(e);
			return null;
		}				
	}
}