connectiondatebase.java

包含了学生管理系统的一些基本操作以及相关窗口页面实现。

package com.hb.studentmanager.connection;

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

public class ConnectionDateBase {
	private String driver;
	private String url;
	private String user;
	private String password;
	
	public ConnectionDateBase() {
		super();
		try {
			FileInputStream fis=new FileInputStream("com/hb/studentmanager/connection/Connection.properties");
			Properties pop=new Properties();
			pop.load(fis);
			driver=pop.getProperty("driver");
			url=pop.getProperty("url");
			user=pop.getProperty("user");
			password=pop.getProperty("password");
			//System.out.println(driver+url+user+password);
		} catch (FileNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IOException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public Connection getDateBaseConnection(){
		Connection con=null;
		try {
			Class.forName(driver);
			con=DriverManager.getConnection(url, user, password);
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return con;
		
	}
	
}