net.sf.esfinge.querybuilder.utils.DataBaseChannel Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of querybuilder-jdbc Show documentation

The Esfinge QueryBuilder JDBC is the persistence framework for Esfinge QueryBuilder using JDBC.

The newest version!

package net.sf.esfinge.querybuilder.utils;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

public class DataBaseChannel {
	private Connection connection;

	public DataBaseChannel(Connection con) {
		setConnection(con);
	}

	public void setConnection(Connection con) {
		this.connection = con;
	}

	public boolean checkConnection() {
		try {
			return (connection == null || !connection.isClosed() || connection
					.isValid(0));
		} catch (Exception err) {
			return false;
		}
	}

	public int executeUpdate(String query) throws SQLException {

		int result = -1;
		Statement stm = null;

		stm = connection.createStatement();
		result = stm.executeUpdate(query);

		if (stm != null) {
			try {
				stm.close();
				stm = null;
			} catch (SQLException sqlerr) {
			}
		}

		if (connection != null) {

			try {
				connection.close();
			} catch (SQLException sqlerr) {
			}
		}

		return result;

	}

	public ArrayList executeQuery(String query) throws SQLException {
		ArrayList listLineResult = new ArrayList();
		ResultSet set = null;
		Statement stm = null;

		stm = connection.createStatement();

		set = stm.executeQuery(query);

		ResultSetMetaData rsmd = set.getMetaData();

		while (set.next()) {
			Line line = new Line();
			for (int i = 1; i <= rsmd.getColumnCount(); i++) {
				LineField lineField = new LineField();
				lineField.setFieldName(rsmd.getColumnName(i).toUpperCase());
				lineField.setFieldType(rsmd.getColumnTypeName(i).getClass());
				lineField.setFieldValue(set.getObject(i));
				line.AddLineField(lineField);
			}
			listLineResult.add(line);
		}

		if (stm != null) {
			try {
				stm.close();
				stm = null;
			} catch (SQLException sqlerr) {
			}
		}

		if (set != null) {
			try {
				set.close();
				set = null;
			} catch (SQLException sqlerr) {
			}
		}

		return listLineResult;
	}

}