public class MysqlAdapter extends AbstractAdapter
"jdbc:mysql://" + DB_HOST + "/" + DB_NAME + "?user=" + DB_USER + "&password=" + DB_PASS;
ADAPTER_KEY, AUTODETECT_ADAPTER, DRIVER_KEY| Modifier | Constructor and Description | 
|---|---|
| protected  | MysqlAdapter()Empty protected constructor. | 
| Modifier and Type | Method and Description | 
|---|---|
| void | generateLimits(Query query,
              long offset,
              int limit)Generate a LIMIT offset, limit clause if offset > 0
 or an LIMIT limit clause if limit is > 0 and offset
 is 0. | 
| String | getIDMethodSQL(Object obj)Returns the SQL to get the database key of the last row
 inserted, which in this case is  SELECT
 LAST_INSERT_ID(). | 
| IDMethod | getIDMethodType()Returns the constant from the  IDMethodinterface denoting which
 type of primary key generation method this type of RDBMS uses. | 
| String | ignoreCase(String in)This method is used to ignore case. | 
| void | lockTable(Connection con,
         String table)Locks the specified table. | 
| String | toUpperCase(String in)This method is used to ignore case. | 
| void | unlockTable(Connection con,
           String table)Unlocks the specified table. | 
escapeText, getStringDelimiter, getUpdateLockClause, ignoreCaseInOrderBy, setCapabilities, supportsNativeLimit, supportsNativeOffset, useEscapeClauseForLike, useGetGeneratedKeys, useIlike, useMinusForExceptpublic String toUpperCase(String in)
toUpperCase in interface AdaptertoUpperCase in class AbstractAdapterin - The string to transform to upper case.public String ignoreCase(String in)
ignoreCase in interface AdapterignoreCase in class AbstractAdapterin - The string whose case to ignore.public IDMethod getIDMethodType()
AbstractAdapterIDMethod interface denoting which
 type of primary key generation method this type of RDBMS uses.getIDMethodType in interface AdaptergetIDMethodType in class AbstractAdapterAdapter.getIDMethodType()public String getIDMethodSQL(Object obj)
SELECT
 LAST_INSERT_ID().getIDMethodSQL in interface AdaptergetIDMethodSQL in class AbstractAdapterobj - Information used for key generation.Adapter.getIDMethodSQL(Object obj)public void lockTable(Connection con, String table) throws SQLException
lockTable in interface AdapterlockTable in class AbstractAdaptercon - The JDBC connection to use.table - The name of the table to lock.SQLException - No Statement could be created or
 executed.public void unlockTable(Connection con, String table) throws SQLException
unlockTable in interface AdapterunlockTable in class AbstractAdaptercon - The JDBC connection to use.table - The name of the table to unlock.SQLException - No Statement could be created or
 executed.public void generateLimits(Query query, long offset, int limit)
generateLimits in interface AdaptergenerateLimits in class AbstractAdapterquery - The query to modifyoffset - the offset Valuelimit - the limit ValueCopyright © 2000–2020 The Apache Software Foundation. All rights reserved.