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
没有合适的资源?快使用搜索试试~ 我知道了~
资源详情
资源评论
资源推荐
收起资源包目录
MyProject01.zip (402个子文件)
EmpServlet.class 8KB
Myservlet.class 6KB
MyDB.class 3KB
YuangongEntity.class 3KB
YuangongDaoImpl.class 3KB
DBconn.class 3KB
SelectEntity.class 2KB
BumenDaoImpl.class 2KB
BumenEntity.class 1KB
YuangongRepository.class 375B
BumenRepository.class 354B
YuangongDao.class 354B
BumenDao.class 295B
.classpath 1KB
org.eclipse.wst.common.component 485B
org.eclipse.wst.jsdt.ui.superType.container 49B
app.08ac9351.css 239KB
style.css 90KB
layui.css 73KB
bootstrap_customized.min.css 53KB
chunk-vendors.1f0a25b2.css 37KB
stylesheet.css 20KB
jquery-ui.css 19KB
detail-page.css 18KB
home.css 17KB
jquery-ui.min.css 16KB
layer.css 14KB
listing.css 12KB
layui.mobile.css 10KB
blog.css 8KB
laydate.css 7KB
review.css 4KB
submit.css 3KB
help.css 2KB
jquery-ui.structure.css 2KB
login.css 2KB
booking-sign_up.css 2KB
jquery-ui.structure.min.css 2KB
error.css 1KB
code.css 1KB
contacts.css 808B
iconfont.eot 46KB
loading-0.gif 6KB
loading-2.gif 2KB
loading-1.gif 701B
index-all.html 332KB
Element.html 154KB
Elements.html 89KB
HttpConnection.html 88KB
Element.html 76KB
Node.html 73KB
Connection.html 64KB
Document.html 51KB
Elements.html 50KB
HttpConnection.Request.html 49KB
TextNode.html 49KB
Connection.html 49KB
Node.html 49KB
ChangeNotifyingArrayList.html 47KB
Jsoup.html 46KB
DocumentType.html 46KB
TokenQueue.html 44KB
DataNode.html 43KB
Whitelist.html 43KB
Attribute.html 42KB
XmlDeclaration.html 41KB
Parser.html 40KB
Comment.html 40KB
Attributes.html 39KB
Document.html 37KB
Connection.Base.html 35KB
Connection.Request.html 35KB
StringUtil.html 35KB
Evaluator.html 31KB
FormElement.html 31KB
overview-tree.html 30KB
HttpConnection.KeyVal.html 30KB
Document.OutputSettings.html 30KB
Selector.html 29KB
HttpConnection.Response.html 29KB
Tag.html 27KB
Evaluator.html 27KB
Evaluator.CssNthEvaluator.html 25KB
ParseErrorList.html 25KB
PseudoTextElement.html 24KB
Whitelist.html 24KB
Entities.html 23KB
HtmlTreeBuilder.html 23KB
ConstrainableInputStream.html 23KB
XmlTreeBuilder.html 23KB
Validate.html 23KB
Evaluator.IsNthLastChild.html 22KB
Connection.KeyVal.html 22KB
Evaluator.IsNthLastOfType.html 22KB
Evaluator.IsNthChild.html 22KB
Evaluator.IsNthOfType.html 22KB
Evaluator.AttributeWithValueContaining.html 22KB
Evaluator.AttributeWithValueEnding.html 22KB
Evaluator.AttributeWithValueStarting.html 22KB
Evaluator.AttributeWithValueNot.html 22KB
共 402 条
- 1
- 2
- 3
- 4
- 5
音图
- 粉丝: 0
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0