连接oracle数据库驱动

package com.visionsoft.logistics.service;

import com.visionsoft.logistics.utils.SysConstants;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.sql.*;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
/**
 * 和message相关的数据库操作
 */
@Service
public class OracleSqlService {

	@Autowired
	private SysConstants sysConstants;

	private PreparedStatement pstmt;
	private ResultSet resultSet ;
	private Connection connection;

	/**
	 * 根据查询条件查询消息列表
	 */
	public boolean insert(String sql){
		PreparedStatement statement = null;
		Connection conn = null;
		try {
			Class.forName("oracle.jdbc.driver.OracleDriver");// 加载Oracle驱动程序
			conn = DriverManager.getConnection(sysConstants.oracleUrl,sysConstants.oracleUser,sysConstants.oraclePassword);
			statement = conn.prepareStatement(sql);
			return statement.executeUpdate() > 0;
		}catch (Exception e) {
			e.printStackTrace();
		}finally {
			try {
				if(statement != null) {
					statement.close();
				}
				if(conn != null) {
					conn.close();
				}
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return false;
	}

	public  Connection getConnection() {
		Connection connection = null;
		try {
			// 加载Oracle驱动程序
			Class.forName("oracle.jdbc.driver.OracleDriver");
			// 获取连接
			connection = DriverManager.getConnection(sysConstants.oracleUrl,sysConstants.oracleUser,sysConstants.oraclePassword);
		} catch (Exception e) {
			throw new RuntimeException("get connection error!", e);
		}
		return connection;
	}



	public List<Map<String, Object>> findResult(String sql, List<?> params)
			throws SQLException {
		connection = this.getConnection();
		List<Map<String, Object>> list = new ArrayList<>();
		int index = 1;
		pstmt = connection.prepareStatement(sql);
		if (params != null && !params.isEmpty()) {
			for (int i = 0; i < params.size(); i++) {
				pstmt.setObject(index++, params.get(i));
			}
		}
		resultSet = pstmt.executeQuery();
		ResultSetMetaData metaData = resultSet.getMetaData();
		int cols_len = metaData.getColumnCount();
		while (resultSet.next()) {
			Map<String, Object> map = new HashMap<>();
			for (int i = 0; i < cols_len; i++) {
				String cols_name = metaData.getColumnName(i + 1);
				Object cols_value = resultSet.getObject(cols_name);
				if (cols_value == null) {
					cols_value = "";
				}
				map.put(cols_name, cols_value);
			}
			list.add(map);
		}
		return list;
	}


	/**
	 * 释放资源
	 */
	public void closeResource(){
		if(resultSet != null){
			try {
				resultSet.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		if(pstmt != null){
			try {
				pstmt.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		if(connection != null){
			try {
				connection.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}

}