sf.database.template.enjoy.ext

Class SqlKit

java.lang.Object

sf.database.template.enjoy.ext.SqlKit

public class SqlKit
extends Object

SqlKit

Field Summary

Fields

Modifier and Type	Field and Description
static String	SQL_COUNT_KEY

Constructor Summary

Constructors

Constructor and Description
SqlKit(String configName)
SqlKit(String configName, boolean devMode)

Method Summary

Modifier and Type	Method and Description
void	addSqlTemplate(com.jfinal.template.source.ISource sqlTemplate)
void	addSqlTemplate(String sqlTemplate)
com.jfinal.template.Engine	getEngine()
String	getSql(String key)
Set<Map.Entry<String,com.jfinal.template.Template>>	getSqlMapEntrySet()
SqlPara	getSqlPara(String key, Map data) 示例： 1：sql 定义 #sql("key") select * from xxx where id = #para(id) and age > #para(age) #end
SqlPara	getSqlPara(String key, Object... paras) 示例： 1：sql 定义 #sql("key") select * from xxx where a = #para(0) and b = #para(1) #end
SqlPara	getSqlParaBySource(String source, Map data) 根据sql模板语句获取sqlPara
SqlPara	getSqlParaPage(String key, Map data) 获取分页的sql 示例： 1：sql 定义 #sql("key") select * from xxx where id = #para(id) and age > #para(age) #end
SqlPara	getSqlParaPageSource(String source, Map data)
protected SqlPara	getSqlParaPageTemplate(com.jfinal.template.Template template, Map data)
void	parseSqlTemplate()
void	setBaseSqlTemplatePath(String baseSqlTemplatePath)
void	setDevMode(boolean devMode)
String	toString()

Methods inherited from class java.lang.Object

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

Field Detail

SQL_COUNT_KEY

public static final String SQL_COUNT_KEY

See Also:

Constant Field Values

Constructor Detail

SqlKit

public SqlKit(String configName,
              boolean devMode)

SqlKit

public SqlKit(String configName)

Method Detail

getEngine

public com.jfinal.template.Engine getEngine()

setDevMode

public void setDevMode(boolean devMode)

setBaseSqlTemplatePath

public void setBaseSqlTemplatePath(String baseSqlTemplatePath)

addSqlTemplate

public void addSqlTemplate(String sqlTemplate)

addSqlTemplate

public void addSqlTemplate(com.jfinal.template.source.ISource sqlTemplate)

parseSqlTemplate

public void parseSqlTemplate()

getSql

public String getSql(String key)

getSqlPara

public SqlPara getSqlPara(String key,
                          Map data)

示例： 1：sql 定义 #sql("key") select * from xxx where id = #para(id) and age > #para(age) #end

2：java 代码 Kv cond = Kv.by("id", 123).set("age", 18); getSqlPara("key", cond);

Parameters:

key -

data -

Returns:

getSqlParaPage

public SqlPara getSqlParaPage(String key,
                              Map data)

获取分页的sql 示例： 1：sql 定义 #sql("key") select * from xxx where id = #para(id) and age > #para(age) #end

2：java 代码 Kv cond = Kv.by("id", 123).set("age", 18); getSqlParaPage("key", cond);

Parameters:

key -

data -

Returns:

getSqlParaPageSource

public SqlPara getSqlParaPageSource(String source,
                                    Map data)

getSqlParaPageTemplate

protected SqlPara getSqlParaPageTemplate(com.jfinal.template.Template template,
                                         Map data)

getSqlPara

public SqlPara getSqlPara(String key,
                          Object... paras)

示例： 1：sql 定义 #sql("key") select * from xxx where a = #para(0) and b = #para(1) #end

2：java 代码 getSqlPara("key", 123, 456);

getSqlParaBySource

public SqlPara getSqlParaBySource(String source,
                                  Map data)

根据sql模板语句获取sqlPara

Parameters:

source - sql模板语句

data -

Returns:

getSqlMapEntrySet

public Set<Map.Entry<String,com.jfinal.template.Template>> getSqlMapEntrySet()

toString

public String toString()

Overrides:

toString in class Object