Servlet增删改查案例经典实现.docx
- 文档编号:5600034
- 上传时间:2022-12-28
- 格式:DOCX
- 页数:13
- 大小:18.01KB
Servlet增删改查案例经典实现.docx
《Servlet增删改查案例经典实现.docx》由会员分享,可在线阅读,更多相关《Servlet增删改查案例经典实现.docx(13页珍藏版)》请在冰豆网上搜索。
Servlet增删改查案例经典实现
Add
publicclassAddextendsHttpServlet{
publicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException{
//编码问题
response.setContentType("text/html;charset=GBK");//浏览器显示的编码,默认的是iso
response.setCharacterEncoding("GBK");//浏览器到数据库取数据时候使用的编码
request.setCharacterEncoding("GBK");//浏览器到数据库存入数据时候所使用的编码方式
//必须为post方式才行的
//获取所提交表单的值
Stringid=request.getParameter("id");
//严谨的编码:
if("".equals(id)||id==null){
response.sendRedirect("./Main.html");
//System.out.println("zzz");
return;
}
Stringname=request.getParameter("user");
//Stringname=newString(name1.getBytes(("GBK")));//"ISO-8859-1",
intuserage=Integer.parseInt(request.getParameter("age"));
Stringaddr=request.getParameter("address");
intuserid=Integer.parseInt(id);
//调用dao层的方法进行添加到数据库的操作
Personp=newPerson();
p.setId(userid);
p.setName(name);
p.setAge(userage);
p.setAddress(addr);
IPersonDaoperson=newPersonDaoImpl();
person.addPerson(p);
//添加过后则重定向,跳向查询全部的页面
response.sendRedirect("/Jsp/selectAll");
}
//Post方法处理post的请求
publicvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException{
doGet(request,response);
}
}
Delete
publicclassDeleteextendsHttpServlet{
publicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException{
IPersonDaoperson=newPersonDaoImpl();
intid=Integer.parseInt(request.getParameter("id").trim());
person.delPersonById(id);
response.sendRedirect("/Jsp/selectAll");//重定向查询全部页面
//RequestDispatcherdp=request.getRequestDispatcher("/Add/selectAll");//转发方式
//dp.forward(request,response);
}
}
publicclassDelAllextendsHttpServlet{
publicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException{
//获取多个box的值的方法
String[]s=request.getParameterValues("like");//?
IPersonDaoperson=newPersonDaoImpl();
//使用for循环进行删除操作
for(inti=0;i //System.out.println(s[i]); intid=Integer.parseInt(s[i]); //循环删除操作 person.delPersonById(id); } response.sendRedirect("/Add/selectAll");//跳到查询全部页面 } //Post方法处理post的请求 publicvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse) throwsServletException,IOException{ doGet(request,response); } } Update publicclassUpdateHtmlextendsHttpServlet{ publicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse) throwsServletException,IOException{ //编码问题 response.setContentType("text/html;charset=GBK");//浏览器显示的编码,默认的是iso response.setCharacterEncoding("GBK");//浏览器到数据库取数据时候使用的编码 request.setCharacterEncoding("GBK");//浏览器到数据库存入数据时候所使用的编码方式 PrintWriterout=response.getWriter(); //out.print(""+response.getContentType()+"
");
//out.print("
"+response.getCharacterEncoding()+"
");//out.print("
"+request.getCharacterEncoding()+"
");//获取selectAll上的数据,使用超链接的方式获得的
intid=Integer.parseInt(request.getParameter("id").trim());
Stringusername=request.getParameter("username").trim();
username=newString(username.getBytes("iso-8859-1"),"GB2312");
//转码
//out.print("
"+username+"
");intuserage=Integer.parseInt(request.getParameter("age"));
Stringaddr=request.getParameter("address");
out.println("
DOCTYPEHTMLPUBLIC\"-//W3C//DTDHTML4.01Transitional//EN\">");
out.println("");
out.println("
out.println("
out.println("
out.print("
修改页面
");//定义表单
out.println("
out.println("
out.println("
"+"
+"
+"
out.println("
"+"
+"
+"
out.println("
"+"
+"
+"
//获取的addr
Stringselect="selected";
//自己的方法如下:
if(addr.equals("shanghai")){
out.println("
"+"
+"
+""
+"
+"
}elseif(addr.equals("huainan")){
out.println("
"+"
+"
+""
+"
+"
}elseif(addr.equals("beijing")){
out.println("
"+"
+"
+""
+"
+"
}elseif(addr.equals("hefei")){
out.println("
"+"
+"
+""
+"
+"
}
//老师的方法
/*out.println("
Strings1="
if(addr.equals("shanghai")){
s1+="selected='selected'";
}
s1+=">shanghai";
out.println(s1);
Strings2="
if(addr.equals("beijing")){
s2+="selected='selected'";
}
s2+=">beijing";
out.println(s2);
out.println("");
*/
out.println("
+"
+"
out.println("");
out.println("");
out.println("
out.println("");
out.println("