studentbean2.java

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

package bean;
import bean.StudentBean;
public class StudentBean2
{  
 StudentBean stu_bean;
 public StudentBean2()
 {
 	
 }

 public void add(StudentBean sb)
 {stu_bean=sb;
 }
 public String changeinto()
 { String sql1[]=new String[9];
   String sql3, sql2=" from stu_info,student where ";
   sql3=sql2;
   int i;
  if(stu_bean.getUser_id()!=null)	
	     {sql1[0]="stu_info.user_id='"+stu_bean.getUser_id()+"'" ; }
	     else sql1[0]="stu_info.user_id like '%'";
	    if(stu_bean.getName()!=null)
	   { sql1[1]=" stu_info.name like '%"+stu_bean.getName().trim()+"%'" ; }
	     else sql1[1]="stu_info.name like '%'";
	     if(stu_bean.getSex()!=null&&!stu_bean.getSex().equals("option0"))
	     sql1[2]=" stu_info.sex='"+stu_bean.getSex()+"'";
	     else sql1[2]="stu_info.sex like '%'";
	     
	     if(stu_bean.getMin_age()!=null&&stu_bean.getMax_age()!=null)
	     sql1[3]="stu_info.age between "+stu_bean.getMin_age()+" and  "+stu_bean.getMax_age();
	     else sql1[3]="stu_info.age between 0 and 3000";
   if(stu_bean.getCollege()!=null)
   { sql1[4]=" student.college like '%"+stu_bean.getCollege().trim()+"%'";
   }
   else sql1[4]=" student.college like '%'";
   if(stu_bean.getDorm()!=null)
   {sql1[5]=" student.dorm like '%"+stu_bean.getDorm().trim()+"%'";
   }
   else sql1[5]=" student.dorm like '%'";
   if(!stu_bean.getisGraduation().equals("option5"))
   {
   	sql1[6]="student.isGraduation='"+stu_bean.getisGraduation()+"'";
   }
   else sql1[6]="student.isGraduation like '%'";
   if(stu_bean.getMajor()!=null)
   sql1[7]="student.major like '%"+stu_bean.getMajor().trim()+"%'";
   else sql1[7]="student.major like '%'";
   if(!stu_bean.getStudent_sort().equals("option6"))
   sql1[8]="student.student_sort='"+stu_bean.getStudent_sort()+"'";
   
   else sql1[8]="student.student_sort like '%'";
   
    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 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;
	}
   }
 

}