package register;import java.sql.*;
/**
 * @author BoogVo
 *
 */
public class Connect {
	Connection db = null;
	Statement query = null;
	ResultSet result = null;
	protected Connection getConnect()
	{
		if(this.db == null)
		{
			try
			{
				String url = "jdbc:mysql://127.0.0.1:3306/cinema";
				this.db = DriverManager.getConnection(url, "root", "root123");
			}
			catch(Exception e)
			{
				System.err.println("Could not connect to the data base");
			}
		}
		return this.db;
	}
	protected Statement getStatement() throws Exception
	{
		if(this.query == null?true:this.query.isClosed())
		{
			this.query = this.getConnect().createStatement();
		}
		return this.query;
	}
	public ResultSet executeQuery(String Query)
	{
		try
		{
			this.result = this.getStatement().executeQuery(Query);
		}
		catch(Exception e)
		{
			System.err.println("Couldn't execute that query");
		}
		return this.result;
	}
	public int updateQuery(String Query) throws Exception
	{
		int res = Integer.MIN_VALUE;
		try
		{
			res = this.getStatement().executeUpdate(Query);
		}
		catch (Exception e)
		{
			System.err.println("Could not update that query");
		}
		finally{
			this.clone();
		}
		return res;
	}
	public void closeConnect() throws Exception
	{
		if(this.result != null && !this.result.isClosed())
		{
			this.result.close();
			this.result = null;
		}
		if(this.query!= null && !this.query.isClosed())
		{
			this.query.close();
			this.query = null;
		}
		if(this.db != null && !this.query.isClosed())
		{
			this.db.close();
			this.db = null;
		}
	}
}

package register;import java.sql.*;
import register.Connect;
public class ShowRap {
	Connect con =new Connect();
	ResultSet res = null;
	public ResultSet showRap() throws Exception
	{
		String q = "SELECT tenrap FROM rap LIMIT 0,5";
		con.getStatement();
		this.res = con.executeQuery(q);
		return this.res;
	}
}