br.com.sankhya.jasperfuncs

Class Funcoes

java.lang.Object

br.com.sankhya.jasperfuncs.Funcoes

public class Funcoes
extends java.lang.Object

Classe com métodos utilitários para serem usados em relatórios. Todos os métodos devem ser testáveis pelo ambiente do iReport, portanto não podem conter chamadas a métodos ou recursos que só existem no ambiente do servidor de aplicações, como JAPE e outros.

Author:

gualberto

Constructor Summary

Constructors

Constructor and Description
Funcoes()

Method Summary

Modifier and Type	Method and Description
static java.sql.Connection	conectarOracle(java.lang.String ip, java.lang.String numeroPorta, java.lang.String servico, java.lang.String usuario, java.lang.String senha)
static java.sql.Connection	conectarSqlServer(java.lang.String ip, java.lang.String numeroPorta, java.lang.String nomeBanco, java.lang.String usuario, java.lang.String senha)
static java.sql.Connection	conectarSqlServer(java.lang.String ip, java.lang.String numeroPorta, java.lang.String instancia, java.lang.String nomeBanco, java.lang.String usuario, java.lang.String senha)
static java.lang.String	pdes(java.sql.Connection c, java.lang.String sCol, java.lang.String sTable, java.lang.String sWhere)
static java.lang.Object	stp(java.sql.Connection c, java.lang.String name)
static java.lang.Object	stp(java.sql.Connection c, java.lang.String name, java.lang.Object[] inParams)
static java.lang.Object	stp(java.sql.Connection c, java.lang.String name, java.lang.Object[] inParams, int outType)

Methods inherited from class java.lang.Object

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

Constructor Detail

Funcoes

public Funcoes()

Method Detail

pdes

public static java.lang.String pdes(java.sql.Connection c,
                                    java.lang.String sCol,
                                    java.lang.String sTable,
                                    java.lang.String sWhere)

conectarOracle

public static java.sql.Connection conectarOracle(java.lang.String ip,
                                                 java.lang.String numeroPorta,
                                                 java.lang.String servico,
                                                 java.lang.String usuario,
                                                 java.lang.String senha)

conectarSqlServer

public static java.sql.Connection conectarSqlServer(java.lang.String ip,
                                                    java.lang.String numeroPorta,
                                                    java.lang.String nomeBanco,
                                                    java.lang.String usuario,
                                                    java.lang.String senha)

conectarSqlServer

public static java.sql.Connection conectarSqlServer(java.lang.String ip,
                                                    java.lang.String numeroPorta,
                                                    java.lang.String instancia,
                                                    java.lang.String nomeBanco,
                                                    java.lang.String usuario,
                                                    java.lang.String senha)

stp

public static java.lang.Object stp(java.sql.Connection c,
                                   java.lang.String name,
                                   java.lang.Object[] inParams)
                            throws java.lang.Exception

Throws:

java.lang.Exception

stp

public static java.lang.Object stp(java.sql.Connection c,
                                   java.lang.String name)
                            throws java.lang.Exception

Throws:

java.lang.Exception

stp

public static java.lang.Object stp(java.sql.Connection c,
                                   java.lang.String name,
                                   java.lang.Object[] inParams,
                                   int outType)
                            throws java.lang.Exception

Throws:

java.lang.Exception