br.ufscar.old.util

Class SQLUtils

java.lang.Object

br.ufscar.old.util.SQLUtils

public class SQLUtils
extends Object

Constructor Summary

Constructors

Constructor and Description
SQLUtils()

Method Summary

Methods

Modifier and Type	Method and Description
static PreparedStatement	buildPS(Connection conn, String sql, List<String> termosChave, int numAtrs, int numParams)
static void	close(Connection conn)
static String	getBetweenArticles(String chave, int numTermos, String[] atributos, Date dataDe, Date dataAte, Integer quantidade, Boolean release, String unidades, String produtos)
static String	getBetweenAssignments(String chave, int numTermos, String[] atributos, Date dataDe, Date dataAte, Integer quantidade, String unidades, String produtos)
static String	getBetweenDates(Date dataDe, Date dataAte, String column)
static String	getBetweenDates(String dataDe, String dataAte, String column)
static String	getBetweenEditions(Integer idProduto, String chave, int numTermos, String[] atributos, String dataDe, String dataAte, Integer quantidade)
static String	getBetweenTime(Date dataDe, Date dataAte, String column)
static ResultSet	getRSFromPS(Connection conn, String chave, String sql, List<String> termosChave, int numAtrs)
static List<String>	getTerms(String key)
static String	getWhere(int numTermos, String[] atributos)
static String	getWhereIn(List<Integer> values)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SQLUtils

public SQLUtils()

Method Detail

getWhere

public static String getWhere(int numTermos,
              String[] atributos)

getBetweenAssignments

public static String getBetweenAssignments(String chave,
                           int numTermos,
                           String[] atributos,
                           Date dataDe,
                           Date dataAte,
                           Integer quantidade,
                           String unidades,
                           String produtos)

getBetweenArticles

public static String getBetweenArticles(String chave,
                        int numTermos,
                        String[] atributos,
                        Date dataDe,
                        Date dataAte,
                        Integer quantidade,
                        Boolean release,
                        String unidades,
                        String produtos)

getBetweenEditions

public static String getBetweenEditions(Integer idProduto,
                        String chave,
                        int numTermos,
                        String[] atributos,
                        String dataDe,
                        String dataAte,
                        Integer quantidade)

getBetweenTime

public static String getBetweenTime(Date dataDe,
                    Date dataAte,
                    String column)

getBetweenDates

public static String getBetweenDates(Date dataDe,
                     Date dataAte,
                     String column)

getBetweenDates

public static String getBetweenDates(String dataDe,
                     String dataAte,
                     String column)

getWhereIn

public static String getWhereIn(List<Integer> values)

getTerms

public static List<String> getTerms(String key)

buildPS

public static PreparedStatement buildPS(Connection conn,
                        String sql,
                        List<String> termosChave,
                        int numAtrs,
                        int numParams)
                                 throws SQLException

Throws:

SQLException

getRSFromPS

public static ResultSet getRSFromPS(Connection conn,
                    String chave,
                    String sql,
                    List<String> termosChave,
                    int numAtrs)
                             throws SQLException

Throws:

SQLException

close

public static void close(Connection conn)