Package ai.libs.jaicore.db.sql

Class MySQLQueryBuilder

java.lang.Object

ai.libs.jaicore.db.sql.MySQLQueryBuilder

All Implemented Interfaces:

ISQLQueryBuilder

public class MySQLQueryBuilder
extends java.lang.Object
implements ISQLQueryBuilder

Constructor Summary

Constructors

Constructor	Description
MySQLQueryBuilder()

Method Summary

Modifier and Type	Method	Description
java.lang.String	buildInsertSQLCommand(java.lang.String table, java.util.Map<java.lang.String,? extends java.lang.Object> map)
Pair<java.lang.String,java.util.List<java.lang.Object>>	buildInsertStatement(java.lang.String table, java.util.Map<java.lang.String,? extends java.lang.Object> map)
java.lang.String	buildMultiInsertSQLCommand(java.lang.String table, java.util.List<java.lang.String> keys, java.util.List<java.util.List<?>> datarows)
java.lang.String	buildSelectSQLCommand(java.lang.String table, java.util.Map<java.lang.String,java.lang.String> conditions)
java.lang.String	parseSQLCommand(java.lang.String sql, java.util.List<?> values)

Methods inherited from class java.lang.Object

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

Constructor Detail

MySQLQueryBuilder

public MySQLQueryBuilder()

Method Detail

buildInsertStatement

public Pair<java.lang.String,java.util.List<java.lang.Object>> buildInsertStatement(java.lang.String table,
                                                                                          java.util.Map<java.lang.String,? extends java.lang.Object> map)

Specified by:

buildInsertStatement in interface ISQLQueryBuilder

buildInsertSQLCommand

public java.lang.String buildInsertSQLCommand(java.lang.String table,
                                              java.util.Map<java.lang.String,? extends java.lang.Object> map)

Specified by:

buildInsertSQLCommand in interface ISQLQueryBuilder

buildMultiInsertSQLCommand

public java.lang.String buildMultiInsertSQLCommand(java.lang.String table,
                                                   java.util.List<java.lang.String> keys,
                                                   java.util.List<java.util.List<?>> datarows)

Specified by:

buildMultiInsertSQLCommand in interface ISQLQueryBuilder

parseSQLCommand

public java.lang.String parseSQLCommand(java.lang.String sql,
                                        java.util.List<?> values)

Specified by:

parseSQLCommand in interface ISQLQueryBuilder

buildSelectSQLCommand

public java.lang.String buildSelectSQLCommand(java.lang.String table,
                                              java.util.Map<java.lang.String,java.lang.String> conditions)

Specified by:

buildSelectSQLCommand in interface ISQLQueryBuilder