Overview  Package   Class  Use  Deprecated  Index
Home >> All >> [ safejdbc overview ]	PREV CLASS  NEXT CLASS
SUMMARY:  JAVADOC |  SOURCE |  DOWNLOAD | NESTED | FIELD | CONSTR | METHOD	DETAIL: FIELD | CONSTR | METHOD

---

safejdbc
Class TXSQL  

java.lang.Object
  safejdbc.TXSQL

All Implemented Interfaces:

SQL

---

class TXSQL

extends java.lang.Object

implements SQL

This class is only for internal use, to provide a SQL interface, that can be used in a transactional context.

---

Field Summary
private  java.sql.Connection	_connection

 

Constructor Summary
(package private)	TXSQL(java.sql.Connection connection)

 

Method Summary
void	query(java.lang.String prepSql, FillingCommand cmd, ResultSetProcessor rsProcessor)           Use this method to execute SQL-Query-Statements such as select from.
void	query(java.lang.String sqlStr, ResultSetProcessor rsProcessor)           Use this method to execute SQL-Query-Statements such as select from. Example:
int	singleIntQuery(java.lang.String sqlStmt)           This method is a convenience method for executing a SQL query which has a single row with a single column containing a number as a result.
int	singleIntQuery(java.lang.String prepSqlStmt, FillingCommand cmd)           This method is a convenience method for executing a SQL query which has a single row with a single column containing a number as a result.
int	update(java.lang.String sqlStr)           Use this method to execute modifying SQL-statements such as insert into or update. Example:
int	update(java.lang.String prepSql, FillingCommand cmd)           Use this method to execute modifying SQL-statements such as insert into or update, with a PreparedStatement.

 

Methods inherited from class java.lang.Object

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

 

Field Detail

_connection

private java.sql.Connection _connection

Constructor Detail

TXSQL

TXSQL(java.sql.Connection connection)

Method Detail

update

public int update(java.lang.String sqlStr)
           throws java.sql.SQLException

Description copied from interface: SQL

Use this method to execute modifying SQL-statements such as insert into or update.
Example:

 sql.update("INSERT INTO customer (id, name) VALUES (1, 'John Smith')");
 

Specified by:

update in interface SQL

---

query

public void query(java.lang.String sqlStr,
                  ResultSetProcessor rsProcessor)
           throws java.sql.SQLException

Description copied from interface: SQL

Use this method to execute SQL-Query-Statements such as select from.
Example:

 sql.query("SELECT id, name FROM customer WHERE id > 0",
           new ResultSetIterator() {
               public void forEachRow(ResultSet rs) throws SQLException {
                   System.out.println(rs.getString("name"));
               }});
 

Specified by:

query in interface SQL

---

update

public int update(java.lang.String prepSql,
                  FillingCommand cmd)
           throws java.sql.SQLException

Description copied from interface: SQL

Use this method to execute modifying SQL-statements such as insert into or update, with a PreparedStatement. The statement is executed in a separate transaction, the change is committed immediately.
Example:

 final int id = 1;
 final String name = "John Smith";
  
 sql.update("INSERT INTO customer (id, name) VALUES (?, ?)",
            new FillingCommand() {
                public void fill(PreparedStatement s) throws SQLException {
                    s.setInt(1, id);
                    s.setString(2, name);
                }});
 

Specified by:

update in interface SQL

---

query

public void query(java.lang.String prepSql,
                  FillingCommand cmd,
                  ResultSetProcessor rsProcessor)
           throws java.sql.SQLException

Description copied from interface: SQL

Use this method to execute SQL-Query-Statements such as select from.
Example:

 final int id_threshold = 3;
      
 sql.query("SELECT id, name FROM customer WHERE id > ?",
           new FillingCommand() {
               public void fill(PreparedStatement s) throws SQLException {
                   s.setInt(1, id_threshold);
               }},
           new ResultSetIterator() {
               public void forEachRow(ResultSet rs) throws SQLException {
                   System.out.println(rs.getString("name"));
               }});
 

Specified by:

query in interface SQL

---

singleIntQuery

public int singleIntQuery(java.lang.String sqlStmt)
                   throws java.sql.SQLException

This method is a convenience method for executing a SQL query which has a single row with a single column containing a number as a result. This method is useful for queries such as "SELECT COUNT(*) FROM ... WHERE ...".

Specified by:

singleIntQuery in interface SQL

---

singleIntQuery

public int singleIntQuery(java.lang.String prepSqlStmt,
                          FillingCommand cmd)
                   throws java.sql.SQLException

This method is a convenience method for executing a SQL query which has a single row with a single column containing a number as a result. This method is useful for queries such as "SELECT COUNT(*) FROM ... WHERE ...".

Specified by:

singleIntQuery in interface SQL

---

Overview  Package   Class  Use  Deprecated  Index
Home >> All >> [ safejdbc overview ]	PREV CLASS  NEXT CLASS
SUMMARY:  JAVADOC |  SOURCE |  DOWNLOAD | NESTED | FIELD | CONSTR | METHOD	DETAIL: FIELD | CONSTR | METHOD

---