程序包 com.alibaba.druid.util

类 MySqlUtils

java.lang.Object

com.alibaba.druid.util.MySqlUtils

public class MySqlUtils
extends Object

字段概要

字段

修饰符和类型	字段	说明
static final Charset	ASCII
static final Charset	BIG5
static final Charset	GBK
static final Charset	UTF16
static final Charset	UTF32
static final Charset	UTF8

构造器概要

构造器

构造器	说明
MySqlUtils()

方法概要

修饰符和类型	方法	说明
static String	big5(String hex)
static String	buildKillQuerySql(Connection connection, SQLException error)
static XAConnection	createXAConnection(Driver driver, Connection physicalConn)
static BigDecimal	decimal(BigDecimal value, int precision, int scale)
static String	gbk(String hex)
static Class	getCommunicationsExceptionClass()
static String	getCreateTableScript(Connection conn)
static String	getCreateTableScript(Connection conn, boolean sorted, boolean simplify)
static Long	getId(Object conn)
static long	getLastPacketReceivedTimeMs(Connection conn)	已过时。
static List<String>	getTableDDL(Connection conn, List<String> tables)
static boolean	isBuiltinDataType(String dataType)
static boolean	isKeyword(String name)
static boolean	isNumber(String str)
static boolean	isSupportParseDateformat(String str)
static void	loadDataTypes(Set<String> dataTypes)
static Date	parseDate(String str, TimeZone timeZone)
static ZonedDateTime	parseDateTime(byte[] str, int off, int len, ZoneId zoneId)
static long	parseMillis(byte[] str, int off, int len, TimeZone timeZone)
static long	parseMillis(byte[] str, TimeZone timeZone)
static TimeZone	parseTimeZone(String str)
static List<String>	showTables(Connection conn)
static DateFormat	toJavaFormat(String fmt)
static DateFormat	toJavaFormat(String fmt, TimeZone timeZone)
static String	utf16(String hex)
static String	utf32(String hex)
static String	utf8(String hex)

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

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

字段详细资料

GBK

public static final Charset GBK

BIG5

public static final Charset BIG5

UTF8

public static final Charset UTF8

UTF16

public static final Charset UTF16

UTF32

public static final Charset UTF32

ASCII

public static final Charset ASCII

构造器详细资料

MySqlUtils

public MySqlUtils()

方法详细资料

createXAConnection

public static XAConnection createXAConnection(Driver driver,
 Connection physicalConn)
                                       throws SQLException

抛出:

SQLException

buildKillQuerySql

public static String buildKillQuerySql(Connection connection,
 SQLException error)
                                throws SQLException

抛出:

SQLException

isKeyword

public static boolean isKeyword(String name)

isBuiltinDataType

public static boolean isBuiltinDataType(String dataType)

showTables

public static List<String> showTables(Connection conn)
                               throws SQLException

抛出:

SQLException

getTableDDL

public static List<String> getTableDDL(Connection conn,
 List<String> tables)
                                throws SQLException

抛出:

SQLException

getCreateTableScript

public static String getCreateTableScript(Connection conn)
                                   throws SQLException

抛出:

SQLException

getCreateTableScript

public static String getCreateTableScript(Connection conn,
 boolean sorted,
 boolean simplify)
                                   throws SQLException

抛出:

SQLException

getId

public static Long getId(Object conn)

getLastPacketReceivedTimeMs

@Deprecated
public static long getLastPacketReceivedTimeMs(Connection conn)
                                        throws SQLException

已过时。

The lastQueryFinishedTime, returned from mysql8 com.mysql.cj.jdbc.JdbcConnection#getIdleFor, does not be updated by method pingInternal running for connection validation if option usePingMethod is true.
More troublesome is that lastQueryFinishedTime will not be set if option maintainTimeStats is false, so does mysql5 lastPacketReceivedTimeMs.

抛出:

SQLException

getCommunicationsExceptionClass

public static Class getCommunicationsExceptionClass()

loadDataTypes

public static void loadDataTypes(Set<String> dataTypes)

decimal

public static BigDecimal decimal(BigDecimal value,
 int precision,
 int scale)

isNumber

public static boolean isNumber(String str)

toJavaFormat

public static DateFormat toJavaFormat(String fmt,
 TimeZone timeZone)

toJavaFormat

public static DateFormat toJavaFormat(String fmt)

parseDate

public static Date parseDate(String str,
 TimeZone timeZone)

parseMillis

public static long parseMillis(byte[] str,
 TimeZone timeZone)

parseMillis

public static long parseMillis(byte[] str,
 int off,
 int len,
 TimeZone timeZone)

parseDateTime

public static ZonedDateTime parseDateTime(byte[] str,
 int off,
 int len,
 ZoneId zoneId)

isSupportParseDateformat

public static boolean isSupportParseDateformat(String str)

parseTimeZone

public static TimeZone parseTimeZone(String str)

utf32

public static String utf32(String hex)

utf16

public static String utf16(String hex)

utf8

public static String utf8(String hex)

gbk

public static String gbk(String hex)

big5

public static String big5(String hex)