databaseutils.java

用xml+swing+jdbc(hsqldb)写的电视广告管理软件 客户定义好广告的具体信息

package util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Locale;
import java.util.ResourceBundle;

public class DataBaseUtils {

	private static Connection connection;

	static {
		ResourceBundle bundle = ResourceBundle.getBundle("config",Locale.ROOT,
				new XMLResourceBundleControl());
		String url = bundle.getString("url");
		String driver = bundle.getString("driver");
		String user = bundle.getString("user");
		String password = bundle.getString("password");
		try {
			Class.forName(driver);
			connection = DriverManager.getConnection(url, user, password);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}

	public static Connection getConnection() {
		return connection;
	}

	public static void setConnection(Connection connection) {
		DataBaseUtils.connection = connection;
	}

}