public interface SqlStringHelper
| 限定符和类型 | 方法和说明 |
|---|---|
StringBuilder |
appendPageString(StringBuilder str,
int pCode,
int pSize)
提供追加分页字符串的方法
|
StringBuilder |
appendSqlString(String[] strTable,
String[] strColumn,
String[] strConditionColumn)
提供根据条件进行SQL语句的拼接方法
返回样例A SELECT TableA.C1,TableA.C2 FROM TableA,TableB
返回样例B SELECT TableA.C1,TableA.C2 FROM TableA,TableB WHERE TableA.C1=?
|
Object[] |
strSplicingForInsertRemoveNull(String table,
String[] fieldName,
Object[] params)
提供对SQL语句的拼接,拼接过程将会移除字段为 NULL 的项目
|
StringBuilder |
strSplicingPart(StringBuilder stringBuilder,
int count,
String cutStr)
提供依据传入的模版进行字符串拼接
返回样例 SELECT ?
|
StringBuilder |
strSplicingSelect(StringBuilder stringBuilder,
String[] args)
提供对数据表查询的字符串拼接
返回样例 SELECT TableA.C1,TableA.C2
|
StringBuilder |
strSplicingUp(StringBuilder stringBuilder,
int count)
提供对数据表插入、更新、删除的字符串拼接
返回样例 SELECT ?
|
StringBuilder |
strSplicingUp(StringBuilder stringBuilder,
Object[] args)
提供对数据表插入、更新、删除的字符串拼接
返回样例 SELECT ?
|
StringBuilder appendSqlString(String[] strTable, String[] strColumn, String[] strConditionColumn)
strTable - 传入需要查询数据表名strColumn - 传入需要查询数据列名,如是多表查询需提供包含表名完整的完成列名 参数格式:TABLE_A.COLUMN_A,TABLE_B.COLUMN_BstrConditionColumn - 传入需要检索条件的列名,若不进行条件检索请赋空StringBuilder strSplicingSelect(StringBuilder stringBuilder, String[] args)
stringBuilder - 传入原有StringBuilder对象args - 传入待拼接的字符串数组StringBuilder strSplicingUp(StringBuilder stringBuilder, int count)
stringBuilder - 传入原有StringBuilder对象count - 传入数据长度StringBuilder strSplicingUp(StringBuilder stringBuilder, Object[] args)
stringBuilder - 传入原有StringBuilder对象args - 传入参数组StringBuilder strSplicingPart(StringBuilder stringBuilder, int count, String cutStr)
stringBuilder - 传入原有StringBuilder对象count - 传入数据长度cutStr - 传入拼接模版StringBuilder appendPageString(StringBuilder str, int pCode, int pSize)
str - 传入原有SQL语句 SELECT TABLE_A.COLUMN_A FROM TABLE_A WHERE CONDITION_A = ?pCode - 传入请求页面号pSize - 传入请求页面长度SELECT TABLE_A.COLUMN_A FROM TABLE_A WHERE CONDITION_A = ? LIMIT PAGE_CODE, PAGE_SIZE提供追加分页字符串的方法
返回代码样例 SELECT TABLE_A.COLUMN_A FROM TABLE_A WHERE CONDITION_A = ? LIMIT PAGE_CODE, PAGE_SIZE
Object[] strSplicingForInsertRemoveNull(String table, String[] fieldName, Object[] params)
table - 传入执行插入的数据表名fieldName - 传入执行插入的字段名params - 传入执行插入的参数名此方法将会移除值为NULL和""的项目
数据字段名个数需与待提交参数需个数相等,同时排列位置相同
返回字段中下标0为拼接完成的SQL语句,下标0为去除空项得到的待提交参数
This documentation was released into the public domain.