com.seeyon.ctp.event.sqllit

类 SQLLitUtils

java.lang.Object

com.seeyon.ctp.event.sqllit.SQLLitUtils

public class SQLLitUtils
extends java.lang.Object

Title: SQLLit工具类

Description: 复制于 CAPSQLiteUtil

Copyright: Copyright (c) 2012

Company: seeyon.com

构造器概要

构造器

构造器和说明
SQLLitUtils()

方法概要

限定符和类型	方法和说明
static void	closeConnection(java.sql.Connection connection)
static void	createTable(java.sql.Connection connection, java.lang.String createTableSql)
static void	deleteDbFile(java.lang.String dbName) 删除sqllite文件
static void	deleteTable(java.sql.Connection connection, java.lang.String tableName)
static void	execute(java.sql.Connection connection, java.lang.String updateBatchSql, java.util.List<java.lang.Object> param)
static void	executeBatch(java.sql.Connection connection, java.lang.String sql, java.util.List<java.util.List<java.lang.Object>> params)
static java.sql.Connection	getConnection(java.lang.String dbName)
static java.lang.String	getCreateTableSql(java.lang.String tableName, java.util.List<java.lang.String> tableFields) 获取创建表的sql
static java.lang.String	getInsertDataSql(java.lang.String tableName, java.util.List<java.lang.String> tableFields) 获取insertSql
static boolean	isExistTable(java.sql.Connection connection, java.lang.String tableName)
static java.util.List<java.util.Map<java.lang.String,java.lang.Object>>	select(java.sql.Connection connection, java.lang.String selectSql, java.util.List<java.lang.Object> param)
static void	updateBatch(java.sql.Connection connection, java.lang.String updateBatchSql, java.util.List<java.util.List<java.lang.Object>> params)

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

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

构造器详细资料

SQLLitUtils

public SQLLitUtils()

方法详细资料

getConnection

public static java.sql.Connection getConnection(java.lang.String dbName)
                                         throws java.sql.SQLException

抛出:

java.sql.SQLException

closeConnection

public static void closeConnection(java.sql.Connection connection)

createTable

public static void createTable(java.sql.Connection connection,
                               java.lang.String createTableSql)
                        throws java.sql.SQLException

抛出:

java.sql.SQLException

deleteTable

public static void deleteTable(java.sql.Connection connection,
                               java.lang.String tableName)
                        throws java.sql.SQLException

抛出:

java.sql.SQLException

execute

public static void execute(java.sql.Connection connection,
                           java.lang.String updateBatchSql,
                           java.util.List<java.lang.Object> param)
                    throws java.sql.SQLException

抛出:

java.sql.SQLException

executeBatch

public static void executeBatch(java.sql.Connection connection,
                                java.lang.String sql,
                                java.util.List<java.util.List<java.lang.Object>> params)
                         throws java.sql.SQLException

抛出:

java.sql.SQLException

updateBatch

public static void updateBatch(java.sql.Connection connection,
                               java.lang.String updateBatchSql,
                               java.util.List<java.util.List<java.lang.Object>> params)
                        throws java.sql.SQLException

抛出:

java.sql.SQLException

isExistTable

public static boolean isExistTable(java.sql.Connection connection,
                                   java.lang.String tableName)
                            throws java.sql.SQLException

抛出:

java.sql.SQLException

select

public static java.util.List<java.util.Map<java.lang.String,java.lang.Object>> select(java.sql.Connection connection,
                                                                                      java.lang.String selectSql,
                                                                                      java.util.List<java.lang.Object> param)
                                                                               throws java.sql.SQLException

抛出:

java.sql.SQLException

getCreateTableSql

public static java.lang.String getCreateTableSql(java.lang.String tableName,
                                                 java.util.List<java.lang.String> tableFields)

获取创建表的sql

参数:

tableName -

tableFields -

返回:

getInsertDataSql

public static java.lang.String getInsertDataSql(java.lang.String tableName,
                                                java.util.List<java.lang.String> tableFields)

获取insertSql

参数:

tableName -

tableFields -

返回:

deleteDbFile

public static void deleteDbFile(java.lang.String dbName)

删除sqllite文件

参数:

dbName -