teacherbean2.java

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

package bean;
import bean.TeacherBean;
public class TeacherBean2
{   TeacherBean th;
    public TeacherBean2()
    {
    	
    }
    public void add(TeacherBean th1)
    {
    	th=th1;
    }
	
   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[6];
     String sql2=" and ",sql3=sql2;
     int i;
     if(th.getUser_id()!=null)	
	     {sql1[0]="stu_info.user_id='"+th.getUser_id()+"'" ; }
	     else sql1[0]="stu_info.user_id like '%'";
	    if(th.getName()!=null)
	   { sql1[1]=" stu_info.name like '%"+th.getName().trim()+"%'" ; }
	     else sql1[1]="stu_info.name like '%'";
	     if(th.getSex()!=null&&!th.getSex().equals("option0"))
	     sql1[2]=" stu_info.sex='"+th.getSex()+"'";
	     else sql1[2]="stu_info.sex like '%'";
	     
	     if(th.getMin_age()!=null&&th.getMax_age()!=null)
	     sql1[3]="stu_info.age between "+th.getMin_age()+" and  "+th.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(th.getT_address()!=null)
     sql1[4]=" teacher.t_address like '%"+th.getT_address().trim()+"%'";
     else sql1[4]="teacher.t_address like '%'";
     if(th.getStudy_direction()!=null)
     sql1[5]="teacher.study_direction like '%"+th.getStudy_direction().trim()+"%'";
     else sql1[5]="teacher.study_direction like '%'";
     for(i=0;i<sql1.length-1;i++)
     {
     	sql2=sql2+sql1[i]+" and ";
     }
     sql2=sql2+sql1[i];
   return sql2;
   }
	
}