im-pa-la工-具类

import org.slf4j.LoggerFactory;

import java.io.Serializable;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

/**
 * impala连接工具类
 *
 * @date:
 * @Description:
 */

public class ConnectionUtils implements Serializable {

    private static org.slf4j.Logger logger = LoggerFactory.getLogger(ConnectionUtils.class);

    private static Connection con;

    /**
     * 初始化连接
     *
     * @return
     */
    public static Connection initConnection() {
        try {
            Class.forName("com.cloudera.impala.jdbc41.Drive");
        } catch (Exception e) {
            logger.error("ConnectionUtils创建失败...." + con, e);
        }
        try {
            con = DriverManager.getConnection("jdbc:impala://ip:21050/ods_nc;AuthMech=3;UID=cloudera;PWD=cloudera", "hive", "hive");
            logger.info("数据库连接成功");
        } catch (Exception e) {
            logger.error("ConnectionUtils创建失败...." + con, e);
        }
        return con;
    }

    /**
     * 获取连接
     *
     * @return
     */
    public static Connection getConnection() {
        if (con == null) {
            synchronized (ConnectionUtils.class) {
                if (con == null) {
                    con = initConnection();
                }
            }
        }
        return con;
    }

    /**
     * 关闭连接
     */
    public static void closeConnection() {
        if (con != null) {
            synchronized (ConnectionUtils.class) {
                try {
                    con.close();
                    logger.info("ConnectionUtils 关闭成功...");
                } catch (SQLException e) {
                    logger.info("ConnectionUtils 关闭成功...", e);
                }
            }
        }


    }


    public static void main(String[] args) {
        Connection connection = ConnectionUtils.getConnection();
        System.out.println(connection);
    }

}

 java连接impala整合ldap