package DataLayer;


import java.sql.*;
public class SqlHelper {
	private String dbURL;
	private String user;
	private String password;
	private Statement stmt;
	public SqlHelper()
	{
		dbURL = "jdbc:odbc:ICQ";
		user = "";
		password = "";
	}
	SqlHelper(String Url,String User,String pwd)
	{
		this.dbURL = Url;
		this.user = User;
		this.password = pwd;
	}
	
	public Connection getConnection() {
		try {
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			return DriverManager.getConnection(dbURL, user, password);

		} catch (Exception e) {
			System.out.print(e.toString());
		}
		return null;
	}
	
	
	public void setStatement(Connection con) {
		try
		{
			stmt=con.createStatement();	
			}
		catch(Exception e)
		{
			System.out.print(e.toString());
		}
	}
	public ResultSet getQuery(String queryString) {
		try
		{
			return stmt.executeQuery(queryString);
		}catch (Exception e) {
			System.out.print(e.toString());
		}
		return null;
		
	}
	public void getUpdate(String updateString) {
		try
		{
			stmt.executeUpdate(updateString);
		}catch (Exception e) {
			System.out.print(e.toString());
		}
		
	}

	
	public void closeStatement() {
		try
		{
			stmt.close();
		}catch (Exception e) {
			System.out.print(e.toString());
		}
		
	}
}