sv.com.sipop.dbfacade
Class DbFacade

java.lang.Object
  sv.com.sipop.dbfacade.DbFacade

public class DbFacade
extends java.lang.Object

Clase principal que oculta la conexion

Method Summary

void	close()
void	connect()
void	DoCommit()
void	DoRollback()
int	execute()
int	execute(java.lang.String sql)
java.sql.ResultSet	executeQuery()
java.sql.ResultSet	executeQuery(java.lang.String sql)
static DbFacade	getInstance()
void	reset()
void	setBinaryStream(int index, java.io.BufferedInputStream value, int length)
void	setBinaryStream(int index, java.io.InputStream value, int length)
void	setBlob(int index, java.sql.Blob value)
void	setBoolean(int index, boolean value)
void	setDate(int index, java.sql.Date value)
void	setDouble(int index, double value)
void	setFloat(int index, float value)
void	setInt(int index, int value)
void	setSql(java.lang.String sql)
void	setString(int index, java.lang.String value)

Methods inherited from class java.lang.Object

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

Method Detail

getInstance

public static DbFacade getInstance()
                            throws java.lang.Exception

Throws:

java.lang.Exception

connect

public void connect()
             throws java.lang.Exception

Throws:

java.lang.Exception

executeQuery

public java.sql.ResultSet executeQuery(java.lang.String sql)
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

executeQuery

public java.sql.ResultSet executeQuery()
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

execute

public int execute()
            throws java.sql.SQLException

Throws:

java.sql.SQLException

execute

public int execute(java.lang.String sql)
            throws java.sql.SQLException

Throws:

java.sql.SQLException

setSql

public void setSql(java.lang.String sql)
            throws java.sql.SQLException

Throws:

java.sql.SQLException

reset

public void reset()
           throws java.lang.Exception

Throws:

java.lang.Exception

DoCommit

public void DoCommit()
              throws java.lang.Exception

Throws:

java.lang.Exception

DoRollback

public void DoRollback()
                throws java.lang.Exception

Throws:

java.lang.Exception

close

public void close()
           throws java.sql.SQLException

Throws:

java.sql.SQLException

setString

public void setString(int index,
                      java.lang.String value)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

setInt

public void setInt(int index,
                   int value)
            throws java.sql.SQLException

Throws:

java.sql.SQLException

setDouble

public void setDouble(int index,
                      double value)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

setDate

public void setDate(int index,
                    java.sql.Date value)
             throws java.sql.SQLException

Throws:

java.sql.SQLException

setBinaryStream

public void setBinaryStream(int index,
                            java.io.BufferedInputStream value,
                            int length)
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

setBinaryStream

public void setBinaryStream(int index,
                            java.io.InputStream value,
                            int length)
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

setFloat

public void setFloat(int index,
                     float value)
              throws java.sql.SQLException

Throws:

java.sql.SQLException

setBoolean

public void setBoolean(int index,
                       boolean value)
                throws java.sql.SQLException

Throws:

java.sql.SQLException

setBlob

public void setBlob(int index,
                    java.sql.Blob value)
             throws java.sql.SQLException

Throws:

java.sql.SQLException