springboot人事管理系统网站(人员工资绩效奖惩培训离职招聘)javaweb+ssm

/admin/a_user_list.jsp" method="post">

• 姓名查询


•  

<%
String names = request.getParameter("names");
String sql="";
int is=0;
sql="select * from user where 1=1 and type='user' ";
if(names !=null){
String name1=new String(names.getBytes("iso_8859_1"),"utf-8");
sql =sql + " and name like '%"+name1+"%' ";
}
sql=sql+" order by name desc";
ResultSet RS_result=connDbBean.executeQuery(sql);
while(RS_result.next()){
is=is+1;
String id=RS_result.getString("id");
String name=RS_result.getString("name");
String sex=RS_result.getString("sex");
String age=RS_result.getString("age");
String level=RS_result.getString("level");
String jixiao=RS_result.getString("jixiao");
String jl=RS_result.getString("jl");
String tel=RS_result.getString("tel");
String statu=RS_result.getString("statu");
int sum = Integer.parseInt(level)+Integer.parseInt(jixiao);
if("-".equals(jl.substring(0,1))){
sum =sum-Integer.parseInt(jl.subSequence(1,jl.length()).toString());
}else{
sum =sum+Integer.parseInt(jl);
}
%>






<%
}
%>

姓名	绩效工资	状态	操作
<%=name %>	<%=jixiao %>	<%=statu %>	修改 清空绩效