我用switch,case语句,不知道错哪了,请求帮助
我用switch,case语句,
switch (searchType){
case '员工编号':
sql="select * from userType where userId='"+searchDemand+"'";
rs=sm.executeQuery(sql);
break;
case '员工姓名':
sql="select * from userType where name='"+searchDemand+"'";
rs=sm.executeQuery(sql);
break;
case '用户类型':
sql="select * from userType where type='"+searchDemand+"'";
rs=sm.executeQuery(sql);
break;
case '用户有效期':
sql="select * from userType where userDate<='"+searchDemand+"'";
rs=sm.executeQuery(sql);
break;
default:
break;
}
提示有错,可我不知道错哪了,请求帮助!谢谢!