kylesqlmanager.java

创建中间企业对象层

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

package com.kyle.eobject;

//import java.io.*;

public class KyleSqlUtils
{
	public KyleSqlManager()
	{
	}
	
	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;	
	}
	
	


	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));
		
		
		
	}
}