kylesql.java

创建中间企业对象层

/**
 * @author duke
 * @version 1.2
 * @date 2004-8-10 14:37
 */

package com.kyle.eobject;

//import java.io.*;

public class KyleQuerySQL
{
	public KyleQuerySQL(){}

	//SELECT * FROM table WHERE somewhere ORDERBY order
	public String field="";
	public String table="*";
	public String where="";
	public String orderby="";

	public String toString()
	{
		if (field.trim().length()==0) field="*";
		String s="SELECT " + field + " FROM " + table;
		if (where.length()>0) s+= " WHERE " + where;
		if (orderby.length()>0) s+= " ORDER BY " + orderby;
		return s;
	}

	public void addField(String value)
	{
		if (value==null) return;
		if (value.trim().length()==0) return;
		if (field.length()==0)
			field=value;
		else
			field += "," + value;
	}

	public static void main(String args[]) throws Exception
	{
		System.out.println("sss");	
		KyleQuerySQL sql = new KyleQuerySQL();
		sql.addField("id");
		sql.addField("a");
		sql.table="user";
		sql.where="id>2";
		System.out.println(sql);	
	}
}