worknotebean.java

来自「企业办公自动化管理系统」· Java 代码 · 共 30 行

package com;

import com.bwm.string.Str;
public class Worknotebean{
		
	private String user1;
	private String user2;
	Str str=new Str();
	
	public String toNull(String a){
		if(a==null){
			a="";
		}
		return a;
	}
		
	public String toSQL(String user1,String user2){
		
		this.user1=user1;
		this.user2=toNull(user2);
		
		if(user2.equals("")||user2==""){
			return new String("select * from jdwork where Name='"+user1+"'");
		}
		else{
			return new String("select * from jdwork where Name='"+user1+"'and Works like '%"+user2+"%'");
		}
	}
}