package servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import db.MyDB;
import entity.BumenEntity;
import entity.SelectEntity;
import entity.YuangongEntity;
import entity.YuangongEntity;
import net.sf.json.JSONArray;
@WebServlet("/EmpServlet")
public class EmpServlet extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
PrintWriter out = response.getWriter();
/*YuangongEntity yGong=new YuangongEntity();
BumenEntity bumen=new BumenEntity();*/
/*System.out.println(bumen.getId());
System.out.println(yGong.getName());*/
String type=request.getParameter("type");
System.out.println("type="+type);
if(type.equals("select")){
String bmjson = JSONArray.fromObject(findEmp(request)).toString();
System.out.println(bmjson);
out.print(bmjson);
}else if (type.equals("add")) {
addEmp(request);
out.print("{\"name\":\"add\"}");
}else if (type.equals("update")) {
updateEmp(request);
out.print("{\"name\":\"update\"}");
}else if (type.equals("delete")) {
deleteEmp(request); //部门id是员工的外键,无法删除
out.print("{\"name\":\"delete\"}");
}else if (type.equals("delall")) {
delall(request); //部门id是员工的外键,无法删除
out.print("{\"name\":\"delete\"}");
}
}
public void delall(HttpServletRequest request){
String[] id=(request.getParameter("ids")).split(",");
System.out.println(id);
int[] nums=new int[id.length];
MyDB db=new MyDB();
for(int i=0;i<id.length;i++){
nums[i]=Integer.parseInt(id[i]);
System.out.println("delete:= "+nums[i]);
db.deleteBumen("delete from yuangong where id="+nums[i]);
}
//int id=Integer.parseInt(request.getParameter("id"));
}
public List<SelectEntity> findEmp(HttpServletRequest request) {
MyDB db=new MyDB();
ResultSet rs = null;
String id=request.getParameter("id").trim();
int idd;
String bumenName=request.getParameter("bumenname").trim();
String name=request.getParameter("name").trim();
String sex=request.getParameter("sex").trim();
List<SelectEntity> yList=new ArrayList<SelectEntity>();
/*YuangongEntity yGong=new YuangongEntity();
idd=Integer.parseInt(id);
BumenEntity bumen=new BumenEntity();
bumen.setId(idd);
System.out.println(bumen.getId());
yGong.setName(name);
System.out.println(yGong.getName());*/
String k="select bumen.id,bumen.bumenname,bumen.bumenzhize,yuangong.id,yuangong.name,yuangong.sex,yuangong.telephone,yuangong.zhiwei from bumen,yuangong ";
//111111111111111111111111111111111111111111111111111111111111111
if(id.equals("")&&bumenName.equals("")&&name.equals("")&&sex.equals("")){
k+="where bumen.id=yuangong.bumenid order by yuangong.id DESC";
//rs=db.selectSql("select * from bumen order by id DESC");
}
if(id.equals("")&&!bumenName.equals("")&&name.equals("")&&sex.equals("")){
k+="where bumen.bumenname=N'"+bumenName+"' and bumen.id=yuangong.bumenid order by yuangong.id DESC";
//rs=db.selectSql("select * from bumen where bumenname=N'"+bumenName+"'");
}
if(!id.equals("")&&bumenName.equals("")&&name.equals("")&&sex.equals("")){
idd=Integer.parseInt(request.getParameter("id"));
k+="where bumen.id='"+idd+"' and bumen.id=yuangong.bumenid order by yuangong.id DESC";
//rs=db.selectSql("select * from bumen where id="+idd);
}
if(!id.equals("")&&!bumenName.equals("")&&name.equals("")&&sex.equals("")){
int iddd=Integer.parseInt(request.getParameter("id"));
k+="where bumen.id='"+iddd+"' and bumen.bumenname=N'"+bumenName+"' and bumen.id=yuangong.bumenid order by yuangong.id DESC";
//rs=db.selectSql("select * from bumen where id="+iddd+",bumenname=N'"+bumenName+"'");
}
//22222222222222222222222222222222222222222222222222222222
if(id.equals("")&&bumenName.equals("")&&!name.equals("")&&sex.equals("")){
k+="where yuangong.name=N'"+name+"' and bumen.id=yuangong.bumenid order by yuangong.id DESC";
//rs=db.selectSql("select * from bumen order by id DESC");
}
if(id.equals("")&&!bumenName.equals("")&&!name.equals("")&&sex.equals("")){
k+="where bumen.bumenname=N'"+bumenName+"' and yuangong.name=N'"+name+"' and bumen.id=yuangong.bumenid order by yuangong.id DESC";
//rs=db.selectSql("select * from bumen where bumenname=N'"+bumenName+"'");
}
if(!id.equals("")&&bumenName.equals("")&&!name.equals("")&&sex.equals("")){
idd=Integer.parseInt(request.getParameter("id"));
k+="where yuangong.name=N'"+name+"' and bumen.id='"+idd+"' and bumen.id=yuangong.bumenid order by yuangong.id DESC";
//rs=db.selectSql("select * from bumen where id="+idd);
}
if(!id.equals("")&&!bumenName.equals("")&&!name.equals("")&&sex.equals("")){
int iddd=Integer.parseInt(request.getParameter("id"));
k+="where bumen.id='"+iddd+"' and bumen.bumenname=N'"+bumenName+"' and yuangong.name=N'"+name+"' and bumen.id=yuangong.bumenid order by yuangong.id DESC";
//rs=db.selectSql("select * from bumen where id="+iddd+",bumenname=N'"+bumenName+"'");
}
//3333333333333333333333333333333333333333333333333333333
if(id.equals("")&&bumenName.equals("")&&name.equals("")&&!sex.equals("")){
k+="where yuangong.sex=N'"+sex+"' and bumen.id=yuangong.bumenid order by yuangong.id DESC";
//rs=db.selectSql("select * from bumen order by id DESC");
}
if(id.equals("")&&!bumenName.equals("")&&name.equals("")&&!sex.equals("")){
k+="where bumen.bumenname=N'"+bumenName+"' and yuangong.sex=N'"+sex+"' and bumen.id=yuangong.bumenid order by yuangong.id DESC";
//rs=db.selectSql("select * from bumen where bumenname=N'"+bumenName+"'");
}
if(!id.equals("")&&bumenName.equals("")&&name.equals("")&&!sex.equals("")){
idd=Integer.parseInt(request.getParameter("id"));
k+="where yuangong.sex=N'"+sex+"' and bumen.id='"+idd+"' and bumen.id=yuangong.bumenid order by yuangong.id DESC";
//rs=db.selectSql("select * from bumen where id="+idd);
}
if(!id.equals("")&&!bumenName.equals("")&&name.equals("")&&!sex.equals("")){
int iddd=Integer.parseInt(request.getParameter("id"));
k+="where bumen.id='"+iddd+"' and bumen.bumenname=N'"+bumenName+"' and yuangong.sex=N'"+sex+"' and bumen.id=yuangong.bumenid order by yuangong.id DESC";
//rs=db.selectSql("select * from bumen where id="+iddd+",bumenname=N'"+bumenName+"'");
}
//4444444444444444444444444444444444444444444444444444444444
if(id.equals("")&&bumenName.equals("")&&!name.equals("")&&!sex.equals("")){
k+="where yuangong.sex=N'"+sex+"' and yuangong.name=N'"+name+"' and bumen.id=yuangong.bumenid order by yuangong.id DESC";
//rs=db.selectSql("select * from bumen order by id DESC");
}
if(id.equals("")&&!bumenName.equals("")&&!name.equals("")&&!sex.equals("")){
int idddd=Integer.parseInt(request.getParameter("id"));
k+="where bumen.bumenname=N'"+bumenName+"' and bumen.id='"+idddd+"' and yuangong.sex=N'"+sex+"' and yuangong.name=N'"+name+"' and bumen.id=yuangong.bumenid order by yuangong.id DESC";
//rs=db.selectSql("select * from bumen where bumenname=N'"+bumenName+"'");
}
if(!id.equals("")&&bumenName.equals("")&&!name.equals("")&&!sex.equals("")){
idd=Integer.parseInt
没有合适的资源?快使用搜索试试~ 我知道了~
资源详情
资源评论
资源推荐
收起资源包目录
![package](https://csdnimg.cn/release/downloadcmsfe/public/img/package.f3fc750b.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/HTML.png)
共 402 条
- 1
- 2
- 3
- 4
- 5
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![jar](https://img-home.csdnimg.cn/images/20210720083455.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![avatar](https://profile-avatar.csdnimg.cn/c8915676bf3b49798e43e0a48305123a_qq_43572319.jpg!1)
音图
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
我的内容管理 展开
我的资源 快来上传第一个资源
我的收益
登录查看自己的收益我的积分 登录查看自己的积分
我的C币 登录后查看C币余额
我的收藏
我的下载
下载帮助
![voice](https://csdnimg.cn/release/downloadcmsfe/public/img/voice.245cc511.png)
![center-task](https://csdnimg.cn/release/downloadcmsfe/public/img/center-task.c2eda91a.png)
安全验证
文档复制为VIP权益,开通VIP直接复制
![dialog-icon](https://csdnimg.cn/release/downloadcmsfe/public/img/green-success.6a4acb44.png)
评论0