package com.dengyu.mysql;
public enum SQLCommand {
CREATE_TABLE1(
"CREATE TABLE IF NOT EXISTS `TABLE1` (" +
"`int` INT UNSIGNED AUTO_INCREMENT," +
"`string` VARCHAR(100) NULL DEFAULT NULL," +
"PRIMARY KEY (`int`))"
),
//这句话就算如果不存在TABLE1的表,创建之
//有以下列数
//int列,存储数据
//string列,存储字符串
//主键为int
ADD_DATA(
"INSERT INTO `TABLE1` " +
"(`int`, `string`)" +
"VALUES (?, \'?\')"
),
//添加一行数据,包含2个值
DELETE_DATA(
"DELETE FROM `TABLE1` WHERE `int` = ?"
),
//删除主键为[int]的一行数据
SELECT_DATA(
"SELECT * FROM `TABLE1` WHERE `int` = ?"
);
//查找主键为[int]的一行数据
/*
* 这里可以添加更多的MySQL命令,格式如下
* COMMAND_NAME(
* "YOUR_COMMAND_HERE" +
* "YOUR_COMMAND_HERE"
* );
*/
private String command;
SQLCommand(String command)
{
this.command = command;
}
public String commandToString()
{
return command;
}
}