com.ckjava.db.utils

类 DbUtils

java.lang.Object

org.apache.commons.lang3.StringUtils

com.ckjava.utils.StringUtils

com.ckjava.db.utils.DbUtils

所有已实现的接口:

Constants

public class DbUtils
extends StringUtils

数据库相关的帮助类

• 根据 dburl,username,password 获取数据源 DataSource
• 根据 数据源 可以获取到数据库的 所有表 的列表
• 根据 数据源 和 表名 获取到表的详细信息
• 根据 数据源 和 sql 获取到查询结果
• 根据 数据源 和 sql 获取到查询结果,并且带有列名

作者:

chen_k 2018年1月31日-下午7:22:54

嵌套类概要

从类继承的嵌套类/接口 com.ckjava.utils.StringUtils

StringUtils.StringDiff

从接口继承的嵌套类/接口 com.ckjava.utils.Constants

Constants.CHARSET, Constants.CONCAT, Constants.DBOPERATION, Constants.DBTYPE, Constants.HTTPMETHOD, Constants.OSTYPE, Constants.QUERYTYPE, Constants.REG, Constants.SPLITER, Constants.STATUS, Constants.TIMEFORMAT

字段概要

从类继承的字段 org.apache.commons.lang3.StringUtils

CR, EMPTY, INDEX_NOT_FOUND, LF, SPACE

构造器概要

构造器

构造器和说明
DbUtils()

方法概要

限定符和类型	方法和说明
static void	closeResource(java.sql.Connection conn, java.sql.PreparedStatement ps, java.sql.ResultSet rs) 关闭数据库相关资源
static javax.sql.DataSource	createDataSource(java.lang.String url, java.lang.String username, java.lang.String password) 根据 db url, 用户名, 密码创建数据源, 并将其存入到类缓存中, 自动根据 url 中的定义加载驱动类
static void	executeMutiSql(java.sql.Connection conn, java.lang.String sql) 执行多条sql

从类继承的方法 com.ckjava.utils.StringUtils

containsStr, extractVariable, getCleanStr, getCleanXmlString, getDecodeCleanXmlString, getProperStr, getStr, getStr, getStringByFilter, getUTF8Str, isNotNullAndNotBlank, levenshtein, main, objectHasStr, replaceVariable

从类继承的方法 org.apache.commons.lang3.StringUtils

abbreviate, abbreviate, abbreviateMiddle, appendIfMissing, appendIfMissingIgnoreCase, capitalize, center, center, center, chomp, chomp, chop, compare, compare, compareIgnoreCase, compareIgnoreCase, contains, contains, containsAny, containsAny, containsAny, containsIgnoreCase, containsNone, containsNone, containsOnly, containsOnly, containsWhitespace, countMatches, countMatches, defaultIfBlank, defaultIfEmpty, defaultString, defaultString, deleteWhitespace, difference, endsWith, endsWithAny, endsWithIgnoreCase, equals, equalsAny, equalsAnyIgnoreCase, equalsIgnoreCase, getCommonPrefix, getFuzzyDistance, getJaroWinklerDistance, getLevenshteinDistance, getLevenshteinDistance, indexOf, indexOf, indexOf, indexOf, indexOfAny, indexOfAny, indexOfAny, indexOfAnyBut, indexOfAnyBut, indexOfDifference, indexOfDifference, indexOfIgnoreCase, indexOfIgnoreCase, isAllLowerCase, isAllUpperCase, isAlpha, isAlphanumeric, isAlphanumericSpace, isAlphaSpace, isAnyBlank, isAnyEmpty, isAsciiPrintable, isBlank, isEmpty, isNoneBlank, isNoneEmpty, isNotBlank, isNotEmpty, isNumeric, isNumericSpace, isWhitespace, join, join, join, join, join, join, join, join, join, join, join, join, join, join, join, join, join, join, join, join, join, join, join, joinWith, lastIndexOf, lastIndexOf, lastIndexOf, lastIndexOf, lastIndexOfAny, lastIndexOfIgnoreCase, lastIndexOfIgnoreCase, lastOrdinalIndexOf, left, leftPad, leftPad, leftPad, length, lowerCase, lowerCase, mid, normalizeSpace, ordinalIndexOf, overlay, prependIfMissing, prependIfMissingIgnoreCase, remove, remove, removeAll, removeEnd, removeEndIgnoreCase, removeFirst, removeIgnoreCase, removePattern, removeStart, removeStartIgnoreCase, repeat, repeat, repeat, replace, replace, replaceAll, replaceChars, replaceChars, replaceEach, replaceEachRepeatedly, replaceFirst, replaceIgnoreCase, replaceIgnoreCase, replaceOnce, replaceOnceIgnoreCase, replacePattern, reverse, reverseDelimited, right, rightPad, rightPad, rightPad, rotate, split, split, split, split, splitByCharacterType, splitByCharacterTypeCamelCase, splitByWholeSeparator, splitByWholeSeparator, splitByWholeSeparatorPreserveAllTokens, splitByWholeSeparatorPreserveAllTokens, splitPreserveAllTokens, splitPreserveAllTokens, splitPreserveAllTokens, splitPreserveAllTokens, startsWith, startsWithAny, startsWithIgnoreCase, strip, strip, stripAccents, stripAll, stripAll, stripEnd, stripStart, stripToEmpty, stripToNull, substring, substring, substringAfter, substringAfterLast, substringBefore, substringBeforeLast, substringBetween, substringBetween, substringsBetween, swapCase, toEncodedString, toString, trim, trimToEmpty, trimToNull, truncate, truncate, uncapitalize, upperCase, upperCase, wrap, wrap, wrapIfMissing, wrapIfMissing

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

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

构造器详细资料

DbUtils

public DbUtils()

方法详细资料

createDataSource

public static javax.sql.DataSource createDataSource(java.lang.String url,
                                                    java.lang.String username,
                                                    java.lang.String password)
                                             throws java.lang.Exception

根据 db url, 用户名, 密码创建数据源, 并将其存入到类缓存中, 自动根据 url 中的定义加载驱动类

参数:

url - 数据库连接 url, 包含数据库主机名,端口号,数据库

username - 数据库用户名

password - 数据库密码

返回:

DataSource

抛出:

java.lang.Exception - 异常对象

executeMutiSql

public static void executeMutiSql(java.sql.Connection conn,
                                  java.lang.String sql)

执行多条sql

参数:

conn - Connection 对象

sql - 以 ; 分隔的 sql

closeResource

public static void closeResource(java.sql.Connection conn,
                                 java.sql.PreparedStatement ps,
                                 java.sql.ResultSet rs)

关闭数据库相关资源

参数:

conn - Connection 对象

ps - PreparedStatement 对象

rs - ResultSet 对象