out_link_manbean2.java

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

package bean;
import bean.Out_link_manBean;
public class Out_link_manBean2
{
	Out_link_manBean out;
	public Out_link_manBean2()
	{
		
	}
	public void add(Out_link_manBean out1)
	{
		out=out1;
	}
	 public static 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;
	}
   }
   public String changeinto()
   { String sql1[]=new String[7];
     String sql2=" and ",sql3=sql2;
     int i;
     if(out.getUser_id()!=null)	
	     {sql1[0]="stu_info.user_id='"+out.getUser_id()+"'" ; }
	     else sql1[0]="stu_info.user_id like '%'";
	    if(out.getName()!=null)
	   { sql1[1]=" stu_info.name like '%"+out.getName().trim()+"%'" ; }
	     else sql1[1]="stu_info.name like '%'";
	     if(out.getSex()!=null&&!out.getSex().equals("option0"))
	     sql1[2]=" stu_info.sex='"+out.getSex()+"'";
	     else sql1[2]="stu_info.sex like '%'";
	     
	     if(out.getMin_age()!=null&&out.getMax_age()!=null)
	     sql1[3]="stu_info.age between "+out.getMin_age()+" and  "+out.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(out.getBelong_org()!=null)
     {sql1[4]=" Outer_linkman.belong_org like '%"+out.getBelong_org().trim()+"%'";
     }
     else sql1[4]="Outer_linkman.belong_org like '%'";
     
     if(out.getLink_kind()!=null&&!out.getLink_kind().trim().equals("option9"))
     sql1[5]=" Outer_linkman.link_kind='"+out.getLink_kind()+"'";
     else sql1[5]="Outer_linkman.link_kind like '%'";
     if(out.getMain_things()!=null&&!out.getMain_things().trim().equals(""))
     sql1[6]="Outer_linkman.main_things like '%"+out.getMain_things().trim()+"%'";
     else sql1[6]="Outer_linkman.main_things like '%'";
   	for(i=0;i<sql1.length-1;i++)
     {
     	sql2=sql2+sql1[i]+" and ";
     }
     sql2=sql2+sql1[i];
   return sql2;
   }
	
}