com.nonesole.persistence.sql
Class SQLDML

java.lang.Object
  extended by com.nonesole.persistence.sql.SQLDML

public class SQLDML
extends java.lang.Object

Provide methods who can transform object to sql.

 Example��
 String sql = DML.getInstance().transferToDeleteSql(new JavaBean());
 DML.getInstance().execute(sql,DataSource.getConnection());
 
It spent 1.5s on transforming 50,000 rows data which have 5 field.

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

Method Summary
static SQLDML getInstance()
          Get SQLDML Object
 java.lang.String transferToDeleteSql(java.lang.Object obj)
          Transform object to delete sql
 java.lang.String transferToInsertSql(java.lang.Object obj)
          Transform object to insert sql
 java.lang.String transferToUpdateSql(java.lang.Object obj)
          /** Transform object to update sql
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Method Detail

getInstance

public static SQLDML getInstance()
Get SQLDML Object

Returns:
DML Object

transferToDeleteSql

public java.lang.String transferToDeleteSql(java.lang.Object obj)
                                     throws OperationsException
Transform object to delete sql

Parameters:
obj - Object needs transform
Returns:
String
Throws:
OperationsException

transferToUpdateSql

public java.lang.String transferToUpdateSql(java.lang.Object obj)
                                     throws OperationsException
/** Transform object to update sql

Parameters:
obj - Object needs transform
Returns:
String
Throws:
OperationsException

transferToInsertSql

public java.lang.String transferToInsertSql(java.lang.Object obj)
                                     throws OperationsException
Transform object to insert sql

Parameters:
obj - Object needs transform
Returns:
String
Throws:
OperationsException