数据库工具类（scala语言）

C3P0工具类

package com.air.antispider.stream.common.util.database;

import com.air.antispider.stream.common.util.jedis.PropertiesUtil;
import com.mchange.v2.c3p0.ComboPooledDataSource;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

/**
*/
public class c3p0Util {
public static ComboPooledDataSource cpds = null;

/**
 * 创建c3p0连接池
 */
private static void createConnectionPool(){
    Properties prop = PropertiesUtil.getProperties("c3p0.properties");
    cpds = new ComboPooledDataSource(true);
    try {
        cpds.setJdbcUrl(prop.getProperty("jdbcUrl"));
        cpds.setDriverClass(prop.getProperty("driverClass"));
        cpds.setUser(prop.getProperty("username"));
        cpds.setPassword(prop.getProperty("password"));
        cpds.setMinPoolSize(new Integer(prop.getProperty("minPoolSize")));
        cpds.setMaxPoolSize(new Integer(prop.getProperty("maxPoolSize")));
        cpds.setInitialPoolSize(new Integer(prop.getProperty("initialPoolSize")));
        cpds.setMaxIdleTime(new Integer(prop.getProperty("maxIdleTime")));
        cpds.setAcquireIncrement(new Integer(prop.getProperty("acquireIncrement")));

    } catch (Exception e) {
        e.printStackTrace();
    }
}

private static synchronized void connectionPoolInit(){
    if(cpds == null){
        createConnectionPool();
    }
}

/**
 * 获取连接池
 * @return 返回一个连接
 */
public static Connection getConnection(){
    try{
        if(cpds == null){
            connectionPoolInit();
        }
        Connection conn = cpds.getConnection();
        return conn;
    }catch (Exception e){
        e.printStackTrace();
    }
    return null;
}

/**
 * 关闭连接
 * @param conn Connection
 * @param pst PreparedStatement
 * @param rs ResultSet
 */
public static void close(Connection conn,PreparedStatement pst,ResultSet rs){
    if(rs!=null){
        try {
            rs.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    if(pst!=null){
        try {
            pst.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    if(conn!=null){
        try {
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

public static void close(Connection conn,PreparedStatement pst){
    if(pst!=null){
        try {
            pst.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    if(conn!=null){
        try {
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

public static void close(Connection conn){
    if(conn!=null){
        try {
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

查询工具类

package com.air.antispider.stream.common.util.database

import scala.collection.mutable.ArrayBuffer

/**

• 工具类的作用：通过sql和value读取数据库的某一个字段
• Created by wangsenfeng on 2019/1/4.
  */
  object QueryDB {
  def queryData(sql: String, field: String): ArrayBuffer[String] = {
  //创建ab，用来封装数据
  val arr = new ArrayBufferString
  //获取连接
  val conn = c3p0Util.getConnection
  //执行sql语句
  val ps = conn.prepareStatement(sql)
  val rs = ps.executeQuery()
  //封装数据
  while (rs.next()){
  arr.+=(rs.getString(field))
  }
  c3p0Util.close(conn,ps,rs)
  //返回结果
  arr
  }
  }