复件 kylesqlmanager.java

创建中间企业对象层

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

package com.kyle.eobject;

//import java.io.*;

public class KyleSqlManager
{
	public KyleSqlManager()
	{
	}

	public void setTableName(String value)
	{
		if (value!=null) tableName=value.trim();
	}
	
	public String getTableName()
	{
		return tableName;
	}

	public void setFields(String value)
	{
		if (value!=null) fields=value.trim();
		if (fields.length()==0) fields="*";
	}
	
	public String getFields()
	{
		return fields;
	}

	public void setWhere(String value)
	{
		if (value!=null) where=value.trim();
	}
	
	public String getWhere()
	{
		return where;
	}

	public void setOrderBy(String value)
	{
		if (value!=null) orderBy=value.trim();
	}
	
	public String getOrderBy()
	{
		return orderBy;
	}

	public void setKey(String value)
	{
		if (value!=null) key=value.trim();
		if (key.length()==0) key="ID";
	}
	
	public String getKey()
	{
		return key;
	}

	public void clearSpilth()
	{
		where="";
		orderBy="";
	}
	
	public String getSimpleSql()
	{
		return "select " + fields + " from " + tableName;
	} 

	public String getSql()
	{
		String s = getSimpleSql();
		if (where.length()>0) s+= " where " + where;
		if (orderBy.length()>0) s+= " order by " + orderBy; 
		return s;
	}

	public String getCountSql(String name)
	{
		String s="";
		s = "select count(*) as " + name + " from " + tableName;
		if (where.length()>0) s+= " where " + where;
		return s;
	}
	
	public String getPageSql(int pageNo, int pageSize)
	{
		String s="";
		if (pageNo==1)
		{
	        s+= "select top " + pageSize + " " + fields + " from " + tableName;
	        if (where.length()>0) s+= " where " + where ;
		}
		else
		{
	        if (where.length()>0)
	        {
	        	s = "select top " + pageSize + " " + fields + " from " + tableName ;
	        	s+= " where " + key + " NOT IN (select top " + pageSize*(pageNo-1) ;
	        	s+= " " + key + " from " + tableName + " where " + where +")";
	        	s+= " and " + where ;
	     	}
	     	else
	     	{
	        	s = "select top " + pageSize + " " + fields + " from " + tableName ;
	        	s+= " where " + key + " NOT IN (select top " + pageSize*(pageNo-1) ;
	        	s+= " " + key + " from " + tableName + ")";
	     	}
		}
		return s;	
	}
	
	
	private String tableName="";
	private String fields="*";
	private String where="";
	private String orderBy="";
	private String key="ID";

	public static void main(String args[]) throws Exception
	{
		System.out.println("sss");	
		KyleSqlManager sql = new KyleSqlManager();
		sql.setTableName("user");
		sql.setWhere("id>2");
		System.out.println(sql.getPageSql(2,10));
		
		
		
	}
}