com.spun.util.database.SQLStatementUtils Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of approvaltests-util Show documentation

There is a newer version: 24.9.0

package com.spun.util.database;

import com.spun.util.DatabaseUtils;

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

public class SQLStatementUtils
{
  public static ResultSet executeQuery(SQLQuery query, Statement stmt)
  {
    return executeQuery(query.toString(DatabaseUtils.getDatabaseType(stmt)), stmt);
  }
  public static ResultSet executeQuery(String query, Statement stmt)
  {
    try
    {
      //My_System.query(query);
      return stmt.executeQuery(query);
    }
    catch (SQLException e)
    {
      throw new SQLInformationException(query, e);
    }
  }
  public static int executeUpdate(String query, Statement stmt)
  {
    try
    {
      return stmt.executeUpdate(query);
    }
    catch (SQLException e)
    {
      throw new SQLInformationException(query, e);
    }
  }
  public static boolean execute(String query, Statement stmt)
  {
    try
    {
      return stmt.execute(query);
    }
    catch (SQLException e)
    {
      throw new SQLInformationException(query, e);
    }
  }
}