public class DefaultBaseAction
extends java.lang.Object
限定符和类型 | 字段和说明 |
---|---|
protected boolean |
isPreparedStatement |
private Logger |
logger |
构造器和说明 |
---|
DefaultBaseAction(boolean isPreparedStatement) |
限定符和类型 | 方法和说明 |
---|---|
static java.util.Vector<java.lang.String> |
arrayToVector(java.lang.String[] input)
Array to vector
|
static void |
commitConnection(java.sql.Connection conn,
boolean commit)
Commit connection
|
static void |
connRelease(java.sql.Connection conn,
java.sql.ResultSet rs,
java.sql.Statement stmt)
Release.
|
static void |
connRollback(java.sql.Connection conn,
java.lang.Exception e)
Rollback.
|
protected void |
deleteWithoutCommit(java.lang.Object obj,
java.sql.Connection conn,
boolean isPrepared)
Delete data but not commit.
|
protected void |
execute(java.lang.String sql,
java.sql.Connection conn)
Execute SQL.
|
static void |
executeNotCommit(java.lang.String sql,
java.sql.Connection conn)
Execute SQL but not commit.
|
protected void |
executeSave(java.lang.String sql,
java.sql.Connection conn,
java.lang.Object obj)
Execute SQL.
|
static java.lang.reflect.Field[] |
getFields(java.lang.Object obj)
Get fields of Object
|
static void |
getGeneratedKeys(java.lang.Object obj,
java.sql.Statement st)
Get generate keys after insert.
|
static void |
handleCharacter(java.lang.Class<?> fieldType,
java.lang.StringBuilder sb,
java.lang.Object value)
Check field whether or not needs '' around it's value
|
protected java.lang.Object |
insertWithoutCommit(java.lang.Object obj,
java.sql.Connection conn,
boolean isPrepared)
Insert data but not commit.
|
static java.lang.Object |
invoke(java.lang.reflect.Field field,
java.lang.Object obj)
Get value frome get method
|
static boolean |
isDouble(java.lang.Object obj)
Determines whether the incoming object is a double number.
|
static boolean |
isInteger(java.lang.Object obj)
Determines whether the incoming object is a int number.
|
static java.lang.Object |
parseResultSetToObject(java.sql.ResultSet rs,
java.lang.Class<?> clazz,
java.util.List<OutputMapping> mapping)
Transform ResultSet to Object.
|
static void |
preventInjectionAttacks(java.lang.String sql)
Deal with injection attacks
|
protected java.util.List<java.lang.Object> |
query(java.lang.String sql,
java.lang.Class<?> clazz,
java.sql.Connection conn)
Query
|
static java.sql.ResultSet |
query(java.lang.String sql,
java.sql.Connection conn)
Execute sql
|
static java.util.List<java.util.List<java.lang.Object>> |
queryReturnDyadicList(java.lang.String sql,
java.lang.Class<?> clazz,
java.sql.Connection conn,
java.util.List<OutputMapping> mapping)
Query and return dyadic list.
|
static java.lang.Object |
rs2Obj(java.lang.Class<?> clazz,
java.sql.ResultSet rs,
int point)
Transform ResultSet to Object.
|
static java.lang.Object |
rs2Obj(java.lang.Class<?> clazz,
java.sql.ResultSet rs,
java.lang.String rsKey)
Transform ResultSet to Object.
|
static void |
setFieldValue(java.lang.String fieldName,
java.lang.Class<?> fieldType,
java.lang.Object obj,
java.lang.Object parameter)
Set field value by set method of object
|
protected void |
setValueToWhere(java.sql.PreparedStatement st,
java.util.Vector<java.lang.Object> values,
java.util.Vector<java.lang.Class<?>> fTypes,
int startPosition)
Set values to '?'
|
static java.lang.Class<?> |
str2Type(java.lang.String str)
Transform String to object type
|
protected java.lang.String |
transferToDeleteSql(java.lang.Object obj)
Transform object to delete sql
|
protected java.lang.String |
transferToInsertSql(java.lang.Object obj)
Transform object to insert sql
|
protected java.lang.String |
transferToUpdateSql(java.lang.Object obj)
Transform object to update sql
|
protected java.lang.Object |
updateWithoutCommit(java.lang.Object obj,
java.sql.Connection conn,
boolean isPrepared)
Update data but not commit.
|
private Logger logger
protected boolean isPreparedStatement
public static java.lang.Object invoke(java.lang.reflect.Field field, java.lang.Object obj) throws ExecuteSQLException, java.lang.NoSuchMethodException, java.lang.SecurityException, java.lang.IllegalAccessException, java.lang.IllegalArgumentException, java.lang.reflect.InvocationTargetException
field
- Field Objectobj
- Object needs do withExecuteSQLException
java.lang.SecurityException
java.lang.NoSuchMethodException
java.lang.reflect.InvocationTargetException
java.lang.IllegalArgumentException
java.lang.IllegalAccessException
public static void handleCharacter(java.lang.Class<?> fieldType, java.lang.StringBuilder sb, java.lang.Object value) throws ExecuteSQLException
fieldType
- field typesb
- string which needs joinvalue
- value which will join the stringExecuteSQLException
public static java.util.Vector<java.lang.String> arrayToVector(java.lang.String[] input)
input
- protected void setValueToWhere(java.sql.PreparedStatement st, java.util.Vector<java.lang.Object> values, java.util.Vector<java.lang.Class<?>> fTypes, int startPosition) throws ExecuteSQLException
st
- PreparedStatement objectvalues
- to '?'type
- of valuesstartPosition
- start position of valuesExecuteSQLException
protected java.lang.Object insertWithoutCommit(java.lang.Object obj, java.sql.Connection conn, boolean isPrepared) throws ExecuteSQLException, java.lang.NoSuchMethodException, java.lang.SecurityException, java.lang.IllegalAccessException, java.lang.IllegalArgumentException, java.lang.reflect.InvocationTargetException
obj
- conn
- java.lang.reflect.InvocationTargetException
java.lang.IllegalArgumentException
java.lang.IllegalAccessException
java.lang.SecurityException
java.lang.NoSuchMethodException
ExecuteSQLException
protected java.lang.Object updateWithoutCommit(java.lang.Object obj, java.sql.Connection conn, boolean isPrepared) throws ExecuteSQLException, java.lang.NoSuchMethodException, java.lang.SecurityException, java.lang.IllegalAccessException, java.lang.IllegalArgumentException, java.lang.reflect.InvocationTargetException
obj
- conn
- java.lang.reflect.InvocationTargetException
java.lang.IllegalArgumentException
java.lang.IllegalAccessException
java.lang.SecurityException
java.lang.NoSuchMethodException
ExecuteSQLException
protected void deleteWithoutCommit(java.lang.Object obj, java.sql.Connection conn, boolean isPrepared) throws ExecuteSQLException, java.lang.NoSuchMethodException, java.lang.SecurityException, java.lang.IllegalAccessException, java.lang.IllegalArgumentException, java.lang.reflect.InvocationTargetException
obj
- conn
- ExecuteSQLException
java.lang.reflect.InvocationTargetException
java.lang.IllegalArgumentException
java.lang.IllegalAccessException
java.lang.SecurityException
java.lang.NoSuchMethodException
protected java.lang.String transferToDeleteSql(java.lang.Object obj) throws ExecuteSQLException, java.lang.NoSuchMethodException, java.lang.SecurityException, java.lang.IllegalAccessException, java.lang.IllegalArgumentException, java.lang.reflect.InvocationTargetException
obj
- Object needs transformjava.lang.reflect.InvocationTargetException
java.lang.IllegalArgumentException
java.lang.IllegalAccessException
java.lang.SecurityException
java.lang.NoSuchMethodException
ExecuteSQLException
protected java.lang.String transferToUpdateSql(java.lang.Object obj) throws ExecuteSQLException, java.lang.NoSuchMethodException, java.lang.SecurityException, java.lang.IllegalAccessException, java.lang.IllegalArgumentException, java.lang.reflect.InvocationTargetException
obj
- Object needs transformjava.lang.reflect.InvocationTargetException
java.lang.IllegalArgumentException
java.lang.IllegalAccessException
java.lang.SecurityException
java.lang.NoSuchMethodException
ExecuteSQLException
protected java.lang.String transferToInsertSql(java.lang.Object obj) throws ExecuteSQLException, java.lang.NoSuchMethodException, java.lang.SecurityException, java.lang.IllegalAccessException, java.lang.IllegalArgumentException, java.lang.reflect.InvocationTargetException
obj
- Object needs transformjava.lang.reflect.InvocationTargetException
java.lang.IllegalArgumentException
java.lang.IllegalAccessException
java.lang.SecurityException
java.lang.NoSuchMethodException
ExecuteSQLException
public static void commitConnection(java.sql.Connection conn, boolean commit) throws ExecuteSQLException
conn
- commit
- ExecuteSQLException
public static void preventInjectionAttacks(java.lang.String sql) throws ExecuteSQLException
sql
- ExecuteSQLException
protected java.util.List<java.lang.Object> query(java.lang.String sql, java.lang.Class<?> clazz, java.sql.Connection conn) throws ExecuteSQLException
sql
- clazz
- conn
- ExecuteSQLException
protected void execute(java.lang.String sql, java.sql.Connection conn) throws ExecuteSQLException
sql
- conn
- ExecuteSQLException
protected void executeSave(java.lang.String sql, java.sql.Connection conn, java.lang.Object obj) throws ExecuteSQLException
sql
- conn
- ExecuteSQLException
public static void executeNotCommit(java.lang.String sql, java.sql.Connection conn) throws ExecuteSQLException
sql
- conn
- ExecuteSQLException
public static java.util.List<java.util.List<java.lang.Object>> queryReturnDyadicList(java.lang.String sql, java.lang.Class<?> clazz, java.sql.Connection conn, java.util.List<OutputMapping> mapping) throws ExecuteSQLException
sql
- clazz
- conn
- ExecuteSQLException
public static java.lang.Object rs2Obj(java.lang.Class<?> clazz, java.sql.ResultSet rs, java.lang.String rsKey) throws ExecuteSQLException
clazz
- rs
- rsKey
- java.sql.SQLException
ExecuteSQLException
public static java.lang.Object rs2Obj(java.lang.Class<?> clazz, java.sql.ResultSet rs, int point) throws ExecuteSQLException
clazz
- rs
- rsKey
- java.sql.SQLException
ExecuteSQLException
public static java.lang.Class<?> str2Type(java.lang.String str) throws ExecuteSQLException
str
- ExecuteSQLException
java.lang.ClassNotFoundException
public static void connRollback(java.sql.Connection conn, java.lang.Exception e) throws ExecuteSQLException
conn
- e
- ExecuteSQLException
public static void connRelease(java.sql.Connection conn, java.sql.ResultSet rs, java.sql.Statement stmt) throws ExecuteSQLException
conn
- rs
- stmt
- ExecuteSQLException
public static java.lang.reflect.Field[] getFields(java.lang.Object obj) throws ExecuteSQLException
obj
- ObjectExecuteSQLException
public static java.sql.ResultSet query(java.lang.String sql, java.sql.Connection conn) throws ExecuteSQLException
st
- PreparedStatement ObjectExecuteSQLException
public static java.lang.Object parseResultSetToObject(java.sql.ResultSet rs, java.lang.Class<?> clazz, java.util.List<OutputMapping> mapping) throws java.lang.Exception
rs
- ResultSet objectc
- Class of JavaBeanjava.lang.Exception
public static void setFieldValue(java.lang.String fieldName, java.lang.Class<?> fieldType, java.lang.Object obj, java.lang.Object parameter) throws java.lang.Exception
fieldName
- field namefieldType
- field typeobj
- owner of fieldparameter
- value of filedOperationsException
java.lang.Exception
public static final boolean isInteger(java.lang.Object obj)
obj
- public static final boolean isDouble(java.lang.Object obj)
obj
- public static void getGeneratedKeys(java.lang.Object obj, java.sql.Statement st) throws ExecuteSQLException
obj
- st
- ExecuteSQLException