sf.database.jdbc.sql

Class CommonSql

java.lang.Object

sf.database.jdbc.sql.CommonSql

public class CommonSql
extends Object

通用common

Constructor Summary

Constructors

Constructor and Description
CommonSql()

Method Summary

Modifier and Type	Method and Description
static void	fillArrayStatement(PreparedStatement pst, Object... paras) 设置值
static void	fillListStatement(PreparedStatement pst, List<Object> paras) 设置值
static void	fillOrmStatement(PreparedStatement pst, List<SQLParameter> paras) 设置值
static void	fillSQLStatement(PreparedStatement pst, List<SQLParameter> paras) 设置值
static void	fillStatement(PreparedStatement pst, Object paras)
static SQLContext	forModelDelete(DBContext context, TableMapping table, DBDialect dialect, DBObject obj)
static SQLContext	forModelDeleteByIds(DBContext context, TableMapping table, DBDialect dialect, Object... keyParams)
static SQLContext	forModelExistsByIds(DBContext context, TableMapping table, DBDialect dialect, Object... keyParams)
static SQLContext	forModelSelectByIds(DBContext context, TableMapping table, DBDialect dialect, Object... keyParams)
static SQLContext	forModelUpdate(DBContext context, TableMapping table, DBDialect dialect, DBObject obj, boolean useOptimisticLock, boolean useNvl) 更新对象,如果有乐观锁,会根据乐观锁条件更新,并会更新数据库中的乐观锁条件.但不会更新对象的乐观锁字段的值.
static SQLContext	model2Save(DBContext context, TableMapping table, DBDialect dialect, DBObject obj, boolean useOptimisticLock) 生成插入语句

Methods inherited from class java.lang.Object

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

Constructor Detail

CommonSql

public CommonSql()

Method Detail

fillStatement

public static void fillStatement(PreparedStatement pst,
                                 Object paras)
                          throws SQLException

Throws:

SQLException

fillListStatement

public static void fillListStatement(PreparedStatement pst,
                                     List<Object> paras)
                              throws SQLException

设置值

Parameters:

pst -

paras -

Throws:

SQLException

fillArrayStatement

public static void fillArrayStatement(PreparedStatement pst,
                                      Object... paras)
                               throws SQLException

设置值

Parameters:

pst -

paras -

Throws:

SQLException

fillOrmStatement

public static void fillOrmStatement(PreparedStatement pst,
                                    List<SQLParameter> paras)
                             throws SQLException

设置值

Parameters:

pst -

paras -

Throws:

SQLException

fillSQLStatement

public static void fillSQLStatement(PreparedStatement pst,
                                    List<SQLParameter> paras)
                             throws SQLException

设置值

Parameters:

pst -

paras -

Throws:

SQLException

model2Save

public static SQLContext model2Save(DBContext context,
                                    TableMapping table,
                                    DBDialect dialect,
                                    DBObject obj,
                                    boolean useOptimisticLock)

生成插入语句

Parameters:

context - 上下文

table - 映射信息

dialect - 方言

obj - 对象

useOptimisticLock - 是否使用乐观锁

Returns:

forModelUpdate

public static SQLContext forModelUpdate(DBContext context,
                                        TableMapping table,
                                        DBDialect dialect,
                                        DBObject obj,
                                        boolean useOptimisticLock,
                                        boolean useNvl)

更新对象,如果有乐观锁,会根据乐观锁条件更新,并会更新数据库中的乐观锁条件.但不会更新对象的乐观锁字段的值.

Parameters:

table -

dialect -

obj -

useOptimisticLock - 是否使用乐观锁

useNvl - 是否使用mysql ifnull,oralce nvl,sqlserver isnull,postgresql coalesce

Returns:

forModelDeleteByIds

public static SQLContext forModelDeleteByIds(DBContext context,
                                             TableMapping table,
                                             DBDialect dialect,
                                             Object... keyParams)

forModelDelete

public static SQLContext forModelDelete(DBContext context,
                                        TableMapping table,
                                        DBDialect dialect,
                                        DBObject obj)

forModelSelectByIds

public static SQLContext forModelSelectByIds(DBContext context,
                                             TableMapping table,
                                             DBDialect dialect,
                                             Object... keyParams)

forModelExistsByIds

public static SQLContext forModelExistsByIds(DBContext context,
                                             TableMapping table,
                                             DBDialect dialect,
                                             Object... keyParams)