psserachbean.java

改代码是采用JSP实现的在线办公自动化管理系统

package com;

import com.bwm.string.Str;

public class Psserachbean{
		
	private String user1;
	private String user2;
	
	Str str=new Str();
	
	public String toSQL(String user1,String user2,String user3,String user4){
		
		this.user1=str.toChinese(user1);
		this.user2=str.toChinese(user2);
		this.user3=str.toChinese(user3);
		this.user4=str.toChinese(user4);
		
		if(user3.equals("")||user3==""){
			return new String("select * from jdwork where Name='"+user1+"'");
		}else{
			if(user4.equals("")||user4==""){
				return new String("select * from jdwork where Name='"+user1+"'and Works like '%"+user2+"%'");
			}
		}
	}
}