top.bayberry.core.db.helper.jpbc

类 DB_Query

java.lang.Object

top.bayberry.core.db.helper.jpbc.DB_Query

直接已知子类:

DJPA_Query, DMBP_Query

public class DB_Query
extends Object

jdbc Select

          ┌─┐       ┌─┐
       ┌──┘ ┴───────┘ ┴──┐
       │                 │
       │       ───       │
       │  ─┬┘       └┬─  │
       │                 │
       │       ─┴─       │
       │                 │
       └───┐         ┌───┘
           │         │
           │         │
           │         │
           │         └──────────────┐
           │                        │
           │                        ├─┐
           │      author:lelouch    ┌─┘
           │                        │
           └─┐  ┐  ┌───────┬──┐  ┌──┘
             │ ─┤ ─┤       │ ─┤ ─┤
             └──┴──┘       └──┴──┘
                 神兽保佑
                 代码无BUG!
 

作者:

lelouch

字段概要

字段

限定符和类型	字段和说明
protected Connection	conn
static boolean	debug 是否显示日志

构造器概要

构造器

构造器和说明
DB_Query(Connection conn) Instantiates a new Db query.

方法概要

限定符和类型	方法和说明
protected ResultSet	_executeQuery(String sql) executeQuery
protected ResultSet	_executeQuery(String sql, Object... param) executeQuery
protected ResultSet	_find(String tableName, String where, Object... param) find
protected ResultSet	_findById(String tableName, String id) _findById
protected static ResultSet	executeQuery_(Connection conn, String sql) executeQuery
static ResultSet	executeQuery_(Connection conn, String sql, Object[] param) executeQuery
protected static ResultSet	executeQuery(Connection conn, String sql, Object... param) executeQuery
DB_Result	executeQuery(SqlQuery sqlQuery) executeQuery
DB_Result	executeQuery(String sql) executeQuery
DB_Result	executeQuery(String sql, Object... param) executeQuery
protected static ResultSet	find_(Connection conn, String tableName, String where, Object[] param) find_
DB_Result	find(String tableName, String where, Object... param) find
protected static ResultSet	findAll_(Connection conn, String tableName) findAll_
DB_Result	findAll(String tableName) findById
protected static ResultSet	findById_(Connection conn, String tableName, String id) findById_
protected static ResultSet	findById_(Connection conn, String tableName, String id, String idName) findById_
DB_Result	findById(String tableName, String id) findById
DB_Result	findById(String tableName, String id, String idName) findById
protected static List<TableColumn>	getTabelColumns(Connection conn, String schema, String tableName) Gets tabel info.
List<TableColumn>	getTabelColumns(String schema, String tableName) Gets tabel info.
protected static String	getTabelComment(Connection conn, String schema, String tableName) Get tabel comment string .
String	getTabelComment(String schema, String tableName) Get tabel comment string .
protected static String[]	getTabels(Connection conn, String schema) Get tabels string [ ].
String[]	getTabels(String schema) Get tabels string [ ].

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

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

字段详细资料

conn

protected Connection conn

debug

public static boolean debug

是否显示日志

构造器详细资料

DB_Query

public DB_Query(Connection conn)

Instantiates a new Db query.

参数:

conn - the conn

方法详细资料

executeQuery

public DB_Result executeQuery(String sql)

executeQuery

参数:

sql - sql语句

返回:

the db result

executeQuery

public DB_Result executeQuery(SqlQuery sqlQuery)

executeQuery

参数:

sql - sql语句

返回:

the db result

executeQuery

public DB_Result executeQuery(String sql,
                              Object... param)

executeQuery

参数:

sql - sql语句

param - 参数对象

返回:

the db result

findById

public DB_Result findById(String tableName,
                          String id,
                          String idName)

findById

参数:

tableName - 表名

id - id

idName - id列名

返回:

db result

findById

public DB_Result findById(String tableName,
                          String id)

findById

参数:

tableName - 表名

id - id

返回:

db result

findAll

public DB_Result findAll(String tableName)

findById

参数:

tableName - 表名

id - id

idName - id列名

返回:

db result

find

public DB_Result find(String tableName,
                      String where,
                      Object... param)

find

参数:

tableName - 表名

where - where条件

param - 参数对象

返回:

the db result

getTabels

public String[] getTabels(String schema)

Get tabels string [ ]. 获取所有表名

参数:

schema - the schema

返回:

string [ ]

getTabelComment

public String getTabelComment(String schema,
                              String tableName)

Get tabel comment string . 获取表注释

参数:

schema - the schema

tableName - the table name

返回:

the string

getTabelColumns

public List<TableColumn> getTabelColumns(String schema,
                                         String tableName)

Gets tabel info. 获取表字段信息

参数:

conn - the conn

schema - the schema

tableName - the table name

返回:

the tabel info

_find

protected ResultSet _find(String tableName,
                          String where,
                          Object... param)

find

参数:

tableName - 表名

where - where条件

param - 参数对象

返回:

the result set

_executeQuery

protected ResultSet _executeQuery(String sql)

executeQuery

参数:

sql - sql语句

返回:

the result set

_executeQuery

protected ResultSet _executeQuery(String sql,
                                  Object... param)

executeQuery

参数:

sql - sql语句

param - the param

返回:

the result set

executeQuery_

protected static ResultSet executeQuery_(Connection conn,
                                         String sql)

executeQuery

参数:

conn - 连接对象

sql - sql语句

返回:

the result set

_findById

protected ResultSet _findById(String tableName,
                              String id)

_findById

参数:

tableName - 表名

id - id

返回:

result set

executeQuery_

public static ResultSet executeQuery_(Connection conn,
                                      String sql,
                                      Object[] param)

executeQuery

参数:

conn - 连接对象

sql - sql语句

param - 参数对象

返回:

the result set

find_

protected static ResultSet find_(Connection conn,
                                 String tableName,
                                 String where,
                                 Object[] param)

find_

参数:

conn - 连接对象

tableName - 表名

where - where条件

param - 参数对象

返回:

the result set

findAll_

protected static ResultSet findAll_(Connection conn,
                                    String tableName)

findAll_

参数:

conn - 连接对象

tableName - 表名

where - where条件

param - 参数对象

返回:

the result set

findById_

protected static ResultSet findById_(Connection conn,
                                     String tableName,
                                     String id,
                                     String idName)

findById_

参数:

conn - 连接对象

tableName - 表名

id - id

idName - id列名

返回:

result set

findById_

protected static ResultSet findById_(Connection conn,
                                     String tableName,
                                     String id)

findById_

参数:

conn - 连接对象

tableName - 表名

id - id

返回:

result set

executeQuery

protected static ResultSet executeQuery(Connection conn,
                                        String sql,
                                        Object... param)

executeQuery

参数:

conn - 连接对象

sql - sql语句

param - 参数对象

返回:

the result set

getTabels

protected static String[] getTabels(Connection conn,
                                    String schema)

Get tabels string [ ]. 获取所有表名

参数:

conn - the conn

schema - the schema

返回:

string [ ]

getTabelComment

protected static String getTabelComment(Connection conn,
                                        String schema,
                                        String tableName)

Get tabel comment string . 获取表注释

参数:

conn - the conn

schema - the schema

tableName - the table name

返回:

the string

getTabelColumns

protected static List<TableColumn> getTabelColumns(Connection conn,
                                                   String schema,
                                                   String tableName)

Gets tabel info. 获取表字段信息

参数:

conn - the conn

schema - the schema

tableName - the table name

返回:

the tabel info