statsql.java

JSP简单的OA系统_非常不错的一个系统

package com;

public class Statsql{
		
	private String user1;
	private String user2;
	private String user3;
	private String user4;
	
	public String toSQL(String user1,String user2,String user3,String user4){
		
		this.user1=user1;
		this.user2=user2;
		this.user3=user3;
		this.user4=user4;
		
		if(user3.equals("个人")&&user4.equals("部门")){
			return new String("select * from jobwork where DateTime betweeen '"+user3+"' and '"+user4+"'");
		}
		else if((!user3.equals("")&&user4.equals(""))){
	    	return new String("select * from jdwork where Name='"+user1+"'and  DateTime betweeen '"+user3+"' and '"+user4+"'");
		}
		else if((user3.equals("")&&!user4.equals(""))){
	    	return new String("select * from jobwork where Branch='"+user2+"' and DateTime betweeen '"+user3+"' and '"+user4+"'");
		}
		return new String("select * from jobwork where Name='administrator'");
	}
}