com.github.panhongan.util.hive.HiveSession Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of java-utils Show documentation

java utils

There is a newer version: 0.1.8

package com.github.panhongan.util.hive;

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

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import com.github.panhongan.util.sql.SqlUtil;


public class HiveSession {
	
	private static final Logger logger = LoggerFactory.getLogger(HiveSession.class);
	
	private Connection conn = null;
	
	private Statement stmt = null;
	
	public HiveSession(Connection connection) throws SQLException {
		this.conn = connection;
		stmt = conn.createStatement();
	}
	
	public ResultSet executeQuery(String sql) {
		ResultSet rs = null;
		
		try {
			if (stmt != null) {
				rs = stmt.executeQuery(sql);
			}
		} catch (SQLException e) {
			logger.warn(e.getMessage(), e);
		}
		
		return rs;
	}
	
	public boolean executeUpdate(String sql) {
		boolean ret = false;
		
		try {
			if (stmt != null) {
				stmt.executeUpdate(sql);
				ret = true;
			}
		} catch (SQLException e) {
			logger.warn(e.getMessage(), e);
		}
		
		return ret;
	}
	
	public boolean execute(String sql) {
		boolean ret = false;
		
		try {
			if (stmt != null) {
				stmt.execute(sql);
				ret = true;
			}
		} catch (SQLException e) {
			logger.warn(e.getMessage(), e);
		}
		
		return ret;
	}
	
	public void close() {
		SqlUtil.closeStatement(stmt);
		SqlUtil.closeConnection(conn);
	}

}