storebean2.java

JSP同学录JSP+SQL基于B/S结构

package bean;
import bean.StoreBean;
import java.lang.*;
public class StoreBean2
{
	StoreBean store;
	public StoreBean2(){
	}
	public void add(StoreBean sb)
	{ store=sb;
	} 

    	public String changeinto()
	{ String sql1[]=new String[4],sql2=" where " ,sql3;
	     sql3=sql2;
	    int i; 
	 if(store.getUser_id()!=null)	
	     {sql1[0]="stu_info.user_id='"+store.getUser_id()+"'" ; }
	     else sql1[0]="stu_info.user_id like '%'";
	    if(store.getName()!=null)
	   { sql1[1]=" stu_info.name like '%"+store.getName().trim()+"%'" ; }
	     else sql1[1]="stu_info.name like '%'";
	     if(store.getSex()!=null&&!store.getSex().equals("option0"))
	     sql1[2]=" stu_info.sex='"+store.getSex()+"'";
	     else sql1[2]="stu_info.sex like '%'";
	     
	     if(store.getMin_age()!=null&&store.getMax_age()!=null)
	     sql1[3]="stu_info.age between "+store.getMin_age()+" and  "+store.getMax_age();
	     else sql1[3]="stu_info.age between 0 and 3000";
	     for( i=0;i<sql1.length-1;i++)
	     {
	       sql2=sql2+sql1[i]+" and ";
	     }
	     sql2=sql2+sql1[i];
	    //if(sql1.equals(sql3))
	    //{sql1=sql1+"user_id like '%'";}
	    //sql2=sql2+sql1; 
	    return sql2;  	
	}
    
    	public  String toChinese(String strvalue)
	{try{
		if(strvalue==null)
		{return null;
		}
		else{
			strvalue=new String(strvalue.getBytes("ISO8859_1"),"GBK");
			return strvalue;
		}
	}catch(Exception e)
	{return null;
	}
   }
}