PHPopen-lims-master.zip

PHPopen-lims-master.zip

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个文件信息