package?base;

import?io.DBConfig;

import?java.io.InputStream;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;

/**
?*?Basic?Database?IO.
?*?@author?Roman?Quiring
?*/
public?class?Dblink?
{
	private?static?String?dbms?=?DBConfig.get_config（“dbms“）;;
	private?static?String?sqlDriver?=?DBConfig.get_config（“sqlDriver“）;;
	private?static?String?dbServer?=?DBConfig.get_config（“dbServer“）;
	private?static?String?dbPort?=?DBConfig.get_config（“dbPort“）;
	private?static?String?dbName?=?DBConfig.get_config（“dbName“）;;
	private?static?String?dbUser?=?DBConfig.get_config（“dbUser“）;;
	private?static?String?dbPassword?=?DBConfig.get_config（“dbPassword“）;;
	
	/**
	?*?Static?constructor.
	?*/
	static
	{
		initDB（）;
	}
	
	/**
	?*?Initialises?the?connection?to?the?Database.
	?*/
	private?static?void?initDB（）?{
		try?
		{
			Class.forName（sqlDriver）;
		}?
		catch?（ClassNotFoundException?e）?
		{
			System.err.println（“JDBC?driver?could?not?be?found!“）;
			e.printStackTrace（）;
			return;
		}
		Connection?connection?=?getDBConnection（）;
		try?
		{
			connection.close（）;
		}?
		catch?（SQLException?e）?
		{
			System.err.println（“An?error?occurred?while?establishing?a?connection?to?the?database!“）;
			e.printStackTrace（）;
		}
	}
	
	/**
	?*?Returns?a?Connection?object.
	?*?@return?Connection?the?connection?object.
	?*/
	private?static?Connection?getDBConnection（）?{	
		Connection?connection?=?null;
		try?
		{
			connection?=?DriverManager.getConnection（“jdbc:“+dbms+“://“+dbServer+“:“+dbPort+“/“+dbName?dbUser?dbPassword）;
		}?
		catch?（SQLException?e）?
		{
			System.err.println（“Connection?to?database?failed!?Make?sure?the?specifications?in?the?config?file?are?correct.“）;
			e.printStackTrace（）;
		}
		return?connection;
	}
	
	/**
	?*?Executes?a?SQL?Statement?on?the?database.
	?*?@param?sql?the?SQL?statement.
	?*?@return?a?ResultSet?containing?the?results.
	?*/
	public?static?ResultSet?executeQuery（String?sql）
	{
		ResultSet?results?=?null;
		Connection?connection?=?getDBConnection（）;
		try?
		{
			Statement?statement?=?connection.createStatement（）;
			results?=?statement.executeQuery（sql）;
			connection.close（）;
		}?
		catch?（SQLException?e）?
		{
			e.printStackTrace（）;
		}
		
		return?results;
	}
	
	/**
	?*?Executes?a?SQL?Update?on?the?database.
	?*?@param?sql?the?SQL?statement.
	?*/
	public?static?void?updateQuery（String?sql）
	{
		Connection?connection?=?getDBConnection（）;
		try?
		{
			Statement?statement?=?connection.createStatement（）;
			statement.executeUpdate（sql）;
			connection.close（）;
		}?
		catch?（SQLException?e）?
		{
			e.printStackTrace（）;
		}
	}
	
	/**
	?*?Executes?a?SQL?Statement?on?the?database?and?accepts?additional?parameters-
	?*?@param?sql?the?SQL?statement.
	?*?@param?type?FORWARD_ONLY?SCROLL_SENSITIV

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2017-03-30?13:23??open-lims-master\
?????文件??????????31??2017-03-30?13:23??open-lims-master\.gitignore
?????文件???????32069??2017-03-30?13:23??open-lims-master\LICENSE
?????文件?????????160??2017-03-30?13:23??open-lims-master\README
?????目錄???????????0??2017-03-30?13:23??open-lims-master\filesystem\
?????目錄???????????0??2017-03-30?13:23??open-lims-master\filesystem\groups\
?????目錄???????????0??2017-03-30?13:23??open-lims-master\filesystem\groups\1\
?????文件??????????34??2017-03-30?13:23??open-lims-master\filesystem\groups\1\placeholder.txt
?????目錄???????????0??2017-03-30?13:23??open-lims-master\filesystem\groups\10\
?????文件??????????34??2017-03-30?13:23??open-lims-master\filesystem\groups\10\placeholder.txt
?????目錄???????????0??2017-03-30?13:23??open-lims-master\filesystem\groups\11\
?????文件??????????34??2017-03-30?13:23??open-lims-master\filesystem\groups\11\placeholder.txt
?????目錄???????????0??2017-03-30?13:23??open-lims-master\filesystem\groups\2\
?????文件??????????34??2017-03-30?13:23??open-lims-master\filesystem\groups\2\placeholder.txt
?????目錄???????????0??2017-03-30?13:23??open-lims-master\filesystem\groups\9\
?????文件??????????34??2017-03-30?13:23??open-lims-master\filesystem\groups\9\placeholder.txt
?????目錄???????????0??2017-03-30?13:23??open-lims-master\filesystem\organisation_units\
?????文件??????????34??2017-03-30?13:23??open-lims-master\filesystem\organisation_units\placeholder.txt
?????目錄???????????0??2017-03-30?13:23??open-lims-master\filesystem\projects\
?????文件??????????34??2017-03-30?13:23??open-lims-master\filesystem\projects\placeholder.txt
?????目錄???????????0??2017-03-30?13:23??open-lims-master\filesystem\samples\
?????文件??????????34??2017-03-30?13:23??open-lims-master\filesystem\samples\placeholder.txt
?????目錄???????????0??2017-03-30?13:23??open-lims-master\filesystem\temp\
?????文件??????????34??2017-03-30?13:23??open-lims-master\filesystem\temp\placeholder.txt
?????目錄???????????0??2017-03-30?13:23??open-lims-master\filesystem\templates\
?????目錄???????????0??2017-03-30?13:23??open-lims-master\filesystem\templates\OLDL\
?????文件??????????34??2017-03-30?13:23??open-lims-master\filesystem\templates\OLDL\placeholder.txt
?????目錄???????????0??2017-03-30?13:23??open-lims-master\filesystem\templates\OLVDL\
?????文件??????????34??2017-03-30?13:23??open-lims-master\filesystem\templates\OLVDL\placeholder.txt
?????目錄???????????0??2017-03-30?13:23??open-lims-master\filesystem\users\
?????目錄???????????0??2017-03-30?13:23??open-lims-master\filesystem\users\1\
............此處省略2860個文件信息