com.nonesole.persistence.sql
Interface ISQLOperations

All Known Implementing Classes:
PreparedStatementOperations, SQLOperations

public interface ISQLOperations

SQL operation interface

Version:
1.0 - build in 2009-07-11
Author:
JACK LEE

Method Summary
 void batchDelete(java.util.List<java.lang.Object> obj, java.sql.Connection conn)
          Delete list of objects in database
 java.util.List<java.lang.Object> batchInsert(java.util.List<java.lang.Object> obj, java.sql.Connection conn)
          Insert list of objects to database
 java.util.List<java.lang.Object> batchUpdate(java.util.List<java.lang.Object> obj, java.sql.Connection conn)
          Update list of objects in database
 void delete(java.lang.Object obj, java.sql.Connection conn)
          Delete one object in database
 void execute(java.lang.String sql, java.sql.Connection conn)
          Execute sql (it would be insert,update,delete sql)
 java.lang.Object insert(java.lang.Object obj, java.sql.Connection conn)
          Insert one object to database
 java.util.List<java.lang.Object> query(java.lang.String sql, java.lang.Class<?> clazz, java.sql.Connection conn)
          Search objects in database
 java.lang.Object update(java.lang.Object obj, java.sql.Connection conn)
          Update one object in database
 

Method Detail

insert

java.lang.Object insert(java.lang.Object obj,
                        java.sql.Connection conn)
                        throws OperationsException
Insert one object to database

Parameters:
obj -
conn -
Returns:
object
Throws:
OperationsException

update

java.lang.Object update(java.lang.Object obj,
                        java.sql.Connection conn)
                        throws OperationsException
Update one object in database

Parameters:
obj -
conn -
Returns:
object
Throws:
OperationsException

delete

void delete(java.lang.Object obj,
            java.sql.Connection conn)
            throws OperationsException
Delete one object in database

Parameters:
obj -
conn -
Throws:
OperationsException

query

java.util.List<java.lang.Object> query(java.lang.String sql,
                                       java.lang.Class<?> clazz,
                                       java.sql.Connection conn)
                                       throws OperationsException
Search objects in database

Parameters:
sql -
clazz - - Class of object
conn -
Returns:
object
Throws:
OperationsException

execute

void execute(java.lang.String sql,
             java.sql.Connection conn)
             throws OperationsException
Execute sql (it would be insert,update,delete sql)

Parameters:
sql -
conn -
Throws:
OperationsException

batchInsert

java.util.List<java.lang.Object> batchInsert(java.util.List<java.lang.Object> obj,
                                             java.sql.Connection conn)
                                             throws OperationsException
Insert list of objects to database

Parameters:
list - of obj
conn -
Returns:
list of object
Throws:
OperationsException

batchUpdate

java.util.List<java.lang.Object> batchUpdate(java.util.List<java.lang.Object> obj,
                                             java.sql.Connection conn)
                                             throws OperationsException
Update list of objects in database

Parameters:
list - of obj
conn -
Returns:
list of object
Throws:
OperationsException

batchDelete

void batchDelete(java.util.List<java.lang.Object> obj,
                 java.sql.Connection conn)
                 throws OperationsException
Delete list of objects in database

Parameters:
list - of obj
conn -
Throws:
OperationsException