Package com.hadoopz.MyDroidLib.orm.core.sql

Class SqliteSqlBuilder

java.lang.Object

com.hadoopz.MyDroidLib.orm.core.sql.SqliteSqlBuilder

All Implemented Interfaces:

SqlBuilder

public class SqliteSqlBuilder
extends Object
implements SqlBuilder

Author:

jw362j

Constructor Summary

Constructors

Constructor	Description
SqliteSqlBuilder()

Method Summary

Modifier and Type	Method	Description
String	doCreateTable(String tableName, com.mycomm.IProtocol.sql.annotation.MyTable myTable, Field[] fields)	CREATE TABLE `showable` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `author` varchar(255) DEFAULT NULL, `catagory` varchar(255) NOT NULL, `catagory_order` int(11) NOT NULL DEFAULT '0', `cnt` int(11) DEFAULT NULL, `content` longtext, `createTime` datetime DEFAULT NULL, `description` varchar(255) DEFAULT NULL, `imgname` varchar(255) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) )ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8
String	doInsertInToTable(String tableName, Field[] fields)
String	doUpdateTable(String tableName, Field[] fields, String IdFieldName)
static SqlBuilder	getSqlBuilderInstance()

Methods inherited from class java.lang.Object

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

Constructor Detail

SqliteSqlBuilder

public SqliteSqlBuilder()

Method Detail

getSqlBuilderInstance

public static SqlBuilder getSqlBuilderInstance()

doCreateTable

public String doCreateTable(String tableName,
                            com.mycomm.IProtocol.sql.annotation.MyTable myTable,
                            Field[] fields)

CREATE TABLE `showable` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `author` varchar(255) DEFAULT NULL, `catagory` varchar(255) NOT NULL, `catagory_order` int(11) NOT NULL DEFAULT '0', `cnt` int(11) DEFAULT NULL, `content` longtext, `createTime` datetime DEFAULT NULL, `description` varchar(255) DEFAULT NULL, `imgname` varchar(255) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) )ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8

Specified by:

doCreateTable in interface SqlBuilder

Parameters:

tableName -

myTable -

fields -

Returns:

doInsertInToTable

public String doInsertInToTable(String tableName,
                                Field[] fields)

Specified by:

doInsertInToTable in interface SqlBuilder

doUpdateTable

public String doUpdateTable(String tableName,
                            Field[] fields,
                            String IdFieldName)

Specified by:

doUpdateTable in interface SqlBuilder