81,092
社区成员
发帖
与我相关
我的任务
分享
StringBuffer sql = new StringBuffer();
sql.append("select * from employee_w where 1=1");
//select * from employee_w where 1=1 是一定执行的
//String ename1 = ename.trim();
//如果名字不等于空,就在select * from employee_w where 加上and ename like '%" + ename +"%'
if(ename.trim()!=""){
sql.append(" and ename like '%" + ename +"%'");
}
//如果性别为男(我这里的1是select里男的value值)就在select * from employee_w where and ename like '%" + ename +"%'后面再加上and gender='男'
if(gender.equals("0")){
sql.append("");
}else if(gender.equals("1")){
sql.append(" and gender='男'");
}else if(gender.equals("2")){
sql.append(" and gender='女'");
}
//。。。。。。依次类推
if(age!=""){
sql.append(" and age= " + age);
}
if(salary.equals("0")){
sql.append(" " );
}else if(salary.equals("1")){
sql.append(" and salary<3000" );
}else if(salary.equals("2")){
sql.append(" and salary between 3000 and 5000" );
}else if(salary.equals("3")){
sql.append(" and salary between 5000 and 7000" );
}else if(salary.equals("4")){
sql.append(" and salary between 7000 and 9000" );
}else if(salary.equals("5")){
sql.append(" and salary>9000" );
}
if(deptno.equals("0")){
sql.append(" ");
}else if(deptno.equals("1")){
sql.append(" and deptno='1001'");
}else if(deptno.equals("2")){
sql.append(" and deptno='1002'");
}else if(deptno.equals("3")){
sql.append(" and deptno='1003'");
}else if(deptno.equals("4")){
sql.append(" and deptno='1004'");
}
//这里是类型转换
String sql1 = sql.toString();
PreparedStatement ps = conn.prepareStatement(sql1);
//这里是传到数据库的sql语句,你打印出来可以看一下就明白了....
System.out.println(sql1);
Map<String,String> map = new HashMap<String,String>
map.put("name",request.getParamter("name"));
map.put("address",request.getParamter("address"));
StrinBuffer sb = "select * from note where 1=1"
if(map.get("name")!=null){
sb.append(" and name='"+map.get(name)+"'");
}
if(map.get("address")!=null){
sb.append(" and address ='"+map.get("address")+"'");
}