cn.schoolwow.quickdao.helper

类 SQLHelper

java.lang.Object

cn.schoolwow.quickdao.helper.SQLHelper

所有已实现的接口:

Serializable

public class SQLHelper
extends Object
implements Serializable

另请参阅:

序列化表格

构造器概要

构造器

构造器和说明
SQLHelper(SyntaxHandler syntaxHandler)

方法概要

限定符和类型	方法和说明
String	columns(String className, String tableAlias) 返回列名的SQL语句
void	count(Query query) count语句
String	delete(Class _class) 返回根据属性删除的语句
String	delete(Class _class, String property) 返回根据属性删除的语句
void	delete(Query query) delete语句
String	dropTable(Class _class) 删除表
String	fetch(Class _class, String property) 返回fetch语句
String	fetchNull(Class _class, String property) 返回fetch语句
void	getAggerateList(Query query) getAggerateList语句
void	getArray(Query query) getArray语句
void	getPartList(Query query) getPartList语句
void	getValueList(Query query, String column) getValueList语句
String	insertIgnore(Class _class, String insertIgnoreSQL) 返回insertIgnore语句
String	union(Query query) union语句
void	update(Query query) update语句
String	updateById(Class _class) 返回根据id更新的语句
String	updateByUniqueKey(Class _class) 返回根据UniqueKey更新的SQL语句

从类继承的方法 java.lang.Object

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

构造器详细资料

SQLHelper

public SQLHelper(SyntaxHandler syntaxHandler)

方法详细资料

fetch

public String fetch(Class _class,
                    String property)

返回fetch语句

fetchNull

public String fetchNull(Class _class,
                        String property)

返回fetch语句

delete

public String delete(Class _class,
                     String property)

返回根据属性删除的语句

delete

public String delete(Class _class)

返回根据属性删除的语句

insertIgnore

public String insertIgnore(Class _class,
                           String insertIgnoreSQL)

返回insertIgnore语句

updateByUniqueKey

public String updateByUniqueKey(Class _class)

返回根据UniqueKey更新的SQL语句

updateById

public String updateById(Class _class)

返回根据id更新的语句

dropTable

public String dropTable(Class _class)

删除表

columns

public String columns(String className,
                      String tableAlias)

返回列名的SQL语句

count

public void count(Query query)

count语句

update

public void update(Query query)

update语句

delete

public void delete(Query query)

delete语句

getArray

public void getArray(Query query)

getArray语句

getValueList

public void getValueList(Query query,
                         String column)

getValueList语句

getAggerateList

public void getAggerateList(Query query)

getAggerateList语句

getPartList

public void getPartList(Query query)

getPartList语句

union

public String union(Query query)

union语句