com.busit.util

Interface Sql

public interface Sql

Method Summary

Methods

Modifier and Type	Method and Description
long	delete(String sql) Perform a DELETE statement on the database.
String	escape(String text) Escapes some text such that it can be used safely in sql statements.
long	insert(String sql) Perform an INSERT statement on the database.
Any	select(String sql) Perform a SELECT statement on the database.
Any	selectOne(String sql) Perform a SELECT statement on the database expecting a single row in return.
long	update(String sql) Perform an UPDATE statement on the database.

Method Detail

select

Any select(String sql)

Perform a SELECT statement on the database.

Parameters:

sql - the sql query

Returns:

the result of the query in the form of an array (rows) of key/value pairs (column/value), if no result, an empty array is returned

selectOne

Any selectOne(String sql)

Perform a SELECT statement on the database expecting a single row in return.

Parameters:

sql - the sql query

Returns:

the result of the query in the form key/value pairs (column/value), if no result, null is returned

insert

long insert(String sql)

Perform an INSERT statement on the database.

Parameters:

sql - the sql query

Returns:

the newly inserted primary key

update

long update(String sql)

Perform an UPDATE statement on the database.

Parameters:

sql - the sql query

Returns:

the number of rows affected

delete

long delete(String sql)

Perform a DELETE statement on the database.

Parameters:

sql - the sql query

Returns:

the number of rows affected

escape

String escape(String text)

Escapes some text such that it can be used safely in sql statements.

Parameters:

text - the text to be escaped

Returns:

properly escaped sql-safe text