litesoft
@ 151
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 |
// This Source Code is in the Public Domain per: http://litesoft.org/License.txt package org.litesoft.sql; import java.sql.*; import org.litesoft.db.*; public class SQLProductSpecificHelperMySQL extends SQLProductSpecificAbstractHelper { /** * @param pProductVersion - Of The DataBase * @param pTableName - Of the Schema's Table Name * @param pSelectColumns - Of the Table (comma separated) * @param pSelectionWhereClause - null means all * @param pOrderBy - null means order immaterial * @param pOffset - Rows to Skip (>= 0 verified) * @param pLimit - Max Rows to return (>= 1 verified) @return !Null */ @Override public String buildQuery( String pProductVersion, String pTableName, // String pSelectColumns, String pSelectionWhereClause, String pOrderBy, // long pOffset, int pLimit ) { return "SELECT" + // " " + pSelectColumns + // " FROM " + pTableName + // " " + pSelectionWhereClause + // " " + pOrderBy + // " LIMIT " + pLimit + // " OFFSET " + pOffset; } @Override public boolean validateConnection( Connection pConnection, DBinfo pDBinfo ) throws SQLException { return LLvalidateConWith( pConnection, // "SELECT 1 AS Yup" ); } @Override public boolean tableExists( Connection pConnection, DBinfo pDBinfo, String pTableName ) throws SQLException, MultipleTablesException { return LLtableExists( pConnection, pDBinfo, pTableName, // "SELECT 1 AS Yup FROM " + pTableName + " LIMIT 1" ); } @Override public boolean columnExists( Connection pConnection, DBinfo pDBinfo, String pTableName, String pColumnName ) throws SQLException, MultipleTablesException { return LLcolumnExists( pConnection, pDBinfo, pTableName, pColumnName, // "SELECT " + pColumnName + " AS Yup FROM " + pTableName + " LIMIT 1" ); } } |