logsql.java

实现统一的人员日志管理系统管理后台

package com.tb.log.util.tools;

public class LogSql {
	String getSql = "";
	String sql = "";
	
	String getEndDate = "";
	String getStartDate = "";
	String getProId = "";
	
	
	public String getPageSql(String start_date,String end_date,String pro_id,int user_id){
		
		if(start_date ==null || start_date.equals("")){
			getStartDate = "";
		}else{
			getStartDate = " log_date>='"+start_date+"' and";
		}
		if(end_date ==null || end_date.equals("")){
			getEndDate = "";
		}else{
			getEndDate = " log_date<='"+end_date+"' and";
		}
		
		if(pro_id ==null || pro_id.equals("")){
			getProId = "";
		}else{
			getProId = " pro_id="+pro_id;
		}
		sql = getStartDate+getEndDate+getProId;

		if(sql==null||sql.equals("")){
			getSql = "select * from (select row_.*, rownum rownum_ from (select * from t_worklog where user_id="+user_id+") row_ where rownum <=?) where rownum_ >?"; 
		}else{
			//如果sql最后一个字符是","号将它去掉
			if(sql.substring(sql.length()-4,sql.length()).equals(" and")){
				sql = sql.substring(0,sql.length()-4);
			}
			getSql = "select * from (select row_.*, rownum rownum_ from (select * from t_worklog where user_id="+user_id+" and "+sql+") row_ where rownum <=?) where rownum_ >?";
		}
		return getSql;
	}
	
	public String getCountSql(String start_date,String end_date,String pro_id,int user_id){
		
		if(start_date ==null || start_date.equals("")){
			getStartDate = "";
		}else{
			getStartDate = " log_date >='"+start_date+"' and";
		}
		if(end_date ==null || end_date.equals("")){
			getEndDate = "";
		}else{
			getEndDate = " log_date<='"+end_date+"' and";
		}
		
		if(pro_id ==null || pro_id.equals("")){
			getProId = "";
		}else{
			getProId = " pro_id="+pro_id;
		}
		sql = getStartDate+getEndDate+getProId;

		if(sql==null||sql.equals("")){
			sql = "select count(*) from (select row_.*, rownum rownum_ from " +
			"(select *  from t_worklog where user_id="+user_id+") row_ )"; 
		}else{
			sql = "select count(*) from (select * from t_worklog where user_id="+user_id+"and "+getStartDate+getEndDate+getProId;
			//如果sql最后一个字符是","号将它去掉
			if(sql.substring(sql.length()-4,sql.length()).equals(" and")){
				sql = sql.substring(0,sql.length()-4);
				
			}
			sql = sql +")";
		}
		return sql;
	}
		public static void main(String[] args) {
			
			LogSql getsql = new LogSql();
			//String  pro_category = "";
			String start_date = "";
			String end_date = "2009-09-01";
			String pro_state = "" ;
			String pro_id = "";
			//System.out.println(getsql.toSql(start_date, end_date, pro_id));
			//System.out.println(getsql.getPageSql(start_date, end_date, pro_id));
		}
}