查询条件写得不对吗？
该代码段能正常显示所有记录，但按姓名查或按职称（下拉式列表）或按部门（下拉式列表）时均查不到记录，请问代码该如何修改呢？另外”修改“两个字怎么不是超链接的样式？
String sqlString=" "; String teacherName=request.getParameter("teacherName"); String technicalPosition=request.getParameter("technicalPositionSelect"); String department=request.getParameter("departmentSelect"); if(request.getParameter("teacherName")!=null && request.getParameter("teacherName")!="") { sqlString=sqlString+ "and T_name='teacherName'"; } if(request.getParameter("technicalPositionSelect")!=null&&request.getParameter("technicalPositionSelect")!="") { sqlString=sqlString + " and T_technicalposition='technicalPosition'"; } if(request.getParameter("departmentSelect")!=null&&request.getParameter("departmentSelect")!="") { sqlString=sqlString + " and T_department='department'"; } ResultSet rs=db.executeQuery("select * from teacher " +" where 1=1 " +sqlString+" order by T_name desc " String teacherId=""; while(rs.next()) { teacherId=rs.getString("Id"); out.println("<tr height=22>"); out.println("<td align=center>"+rs.getString("T_name")+"</td>"); out.println("<td align=center>"+rs.getString("T_technicalposition")+"</td>"); out.println("<td align=center>"+rs.getString("T_department")+"</td>"); %> <td align="center"<a href="teacherModify.jsp?teacherId=<%=teacherId%>">修改</a> <a href="javascript:del('teacherManage.jsp',<%=teacherId%>)">删除</a></td></tr> }