package de.verkehrszeichen.lobbysystem.sql;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;

public class SQL {

	private Connection con;

	public SQL(String hostname, int port, String username, String password, String database) {
		try {
			con = DriverManager.getConnection("jdbc:mysql://" + hostname + ":" + port + "/" + database + "?autoReconnect=true", username,
					password);
		} catch (SQLException ex) {
			ex.printStackTrace();
		}
	}

	public void update(String sql) {
		try {
			con.prepareStatement(sql).executeUpdate();
		} catch (SQLException ex) {
			ex.printStackTrace();
		}
	}

	public ResultSet query(String sql) {
		try {
			return con.prepareStatement(sql).executeQuery();
		} catch (SQLException ex) {
			ex.printStackTrace();
			return null;
		}
	}

}