net.ymate.platform.persistence.jdbc.query

Class SQL

java.lang.Object

net.ymate.platform.persistence.jdbc.query.SQL

public final class SQL
extends Object

SQL语句及参数对象

Author:

刘镇 (suninformation@163.com) on 15/5/7 上午8:25

Constructor Summary

Constructors

Constructor and Description
SQL(IDatabase owner, String sql)

Method Summary

Modifier and Type	Method and Description
long	count()
long	count(String dataSourceName)
static SQL	create(Delete delete)
static SQL	create(IDatabase owner, String sql)
static SQL	create(IDatabase owner, String expressionSqlStr, Map<String,Object> params)
static SQL	create(Insert insert)
static SQL	create(Select select)
static SQL	create(String sql)
static SQL	create(String expressionSqlStr, Map<String,Object> params)
static SQL	create(Update update)
int	execute()
int	execute(String dataSourceName)
<T> IResultSet<T>	find(IResultSetHandler<T> handler)
<T> IResultSet<T>	find(IResultSetHandler<T> handler, Page page)
<T> IResultSet<T>	find(String dataSourceName, IResultSetHandler<T> handler)
<T> IResultSet<T>	find(String dataSourceName, IResultSetHandler<T> handler, Page page)
<T> T	findFirst(IResultSetHandler<T> handler)
<T> T	findFirst(String dataSourceName, IResultSetHandler<T> handler)
IDatabase	owner()
SQL	param(Object param)
SQL	param(Params params)
Params	params()
String	toString()

Methods inherited from class java.lang.Object

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

Constructor Detail

SQL

public SQL(IDatabase owner,
           String sql)

Method Detail

create

public static SQL create(String sql)

create

public static SQL create(IDatabase owner,
                         String sql)

create

public static SQL create(Select select)

create

public static SQL create(Insert insert)

create

public static SQL create(Update update)

create

public static SQL create(Delete delete)

create

public static SQL create(String expressionSqlStr,
                         Map<String,Object> params)

create

public static SQL create(IDatabase owner,
                         String expressionSqlStr,
                         Map<String,Object> params)

owner

public IDatabase owner()

param

public SQL param(Object param)

param

public SQL param(Params params)

params

public Params params()

toString

public String toString()

Overrides:

toString in class Object

execute

public int execute()
            throws Exception

Throws:

Exception

execute

public int execute(String dataSourceName)
            throws Exception

Throws:

Exception

findFirst

public <T> T findFirst(IResultSetHandler<T> handler)
                throws Exception

Throws:

Exception

findFirst

public <T> T findFirst(String dataSourceName,
                       IResultSetHandler<T> handler)
                throws Exception

Throws:

Exception

find

public <T> IResultSet<T> find(IResultSetHandler<T> handler)
                       throws Exception

Throws:

Exception

find

public <T> IResultSet<T> find(IResultSetHandler<T> handler,
                              Page page)
                       throws Exception

Throws:

Exception

find

public <T> IResultSet<T> find(String dataSourceName,
                              IResultSetHandler<T> handler)
                       throws Exception

Throws:

Exception

find

public <T> IResultSet<T> find(String dataSourceName,
                              IResultSetHandler<T> handler,
                              Page page)
                       throws Exception

Throws:

Exception

count

public long count()
           throws Exception

Throws:

Exception

count

public long count(String dataSourceName)
           throws Exception

Throws:

Exception