worknotebean.java

来自「改代码是采用JSP实现的在线办公自动化管理系统」· Java 代码 · 共 25 行

package com;

import com.bwm.string.Str;

public class Worknotebean{
		
	private String user1;
	private String user2;
	
	Str str=new Str();
	
	public String toSQL(String user1,String user2){
		
		this.user1=str.toChinese(user1);
		this.user2=str.toChinese(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+"%'");
		}
	}
}