Servlet增删改查案例经典实现

Add

public class Add extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

// 编码问题

response.setContentType("text/html;charset=GBK");// 浏览器显示的编码，默认的是iso

response.setCharacterEncoding("GBK");// 浏览器到数据库取数据时候使用的编码

request.setCharacterEncoding("GBK");// 浏览器到数据库存入数据时候所使用的编码方式

// 必须为post方式才行的

// 获取所提交表单的值

String id = request.getParameter("id");

// 严谨的编码：

if ("".equals(id) || id == null) {

response.sendRedirect("./Main.html");

// System.out.println("zzz");

return;

}

String name = request.getParameter("user");

// String name=new String(name1.getBytes(("GBK")));//"ISO-8859-1",

int userage = Integer.parseInt(request.getParameter("age"));

String addr = request.getParameter("address");

int userid = Integer.parseInt(id);

// 调用dao层的方法进行添加到数据库的操作

Person p = new Person();

p.setId(userid);

p.setName(name);

p.setAge(userage);

p.setAddress(addr);

IPersonDao person = new PersonDaoImpl();

person.addPerson(p);

// 添加过后则重定向，跳向查询全部的页面

response.sendRedirect("/Jsp/selectAll");

}

// Post方法处理post的请求

public void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

doGet(request, response);

}

}

Delete

public class Delete extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

IPersonDao person=new PersonDaoImpl();

int id=Integer.parseInt(request.getParameter("id").trim());

person.delPersonById(id);

response.sendRedirect("/Jsp/selectAll");//重定向查询全部页面

//RequestDispatcher dp=request.getRequestDispatcher("/Add/selectAll");//转发方式

//dp.forward(request, response);

}

}

public class DelAll extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

//获取多个box的值的方法

String[] s = request.getParameterValues("like");// ?

IPersonDao person = new PersonDaoImpl();

//使用for循环进行删除操作

for (int i = 0; i < s.length; i++) {

// System.out.println(s[i]);

int id = Integer.parseInt(s[i]);

//循环删除操作

person.delPersonById(id);

}

response.sendRedirect("/Add/selectAll");// 跳到查询全部页面

}

// Post方法处理post的请求

public void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

doGet(request, response);

}

}

Update

public class UpdateHtml extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

//编码问题

response.setContentType("text/html;charset=GBK");// 浏览器显示的编码，默认的是iso

response.setCharacterEncoding("GBK");// 浏览器到数据库取数据时候使用的编码

request.setCharacterEncoding("GBK");// 浏览器到数据库存入数据时候所使用的编码方式

PrintWriter out = response.getWriter();

//out.print("

"+response.getContentType()+"

");

//out.print("

"+response.getCharacterEncoding()+"

");

//out.print("

"+request.getCharacterEncoding()+"

");

//获取selectAll上的数据，使用超链接的方式获得的

int id = Integer.parseInt(request.getParameter("id").trim());

String username = request.getParameter("username").trim();

username = new String(username.getBytes("iso-8859-1"),"GB2312");

//转码

//out.print("

"+username+"

");

int userage = Integer.parseInt(request.getParameter("age"));

String addr = request.getParameter("address");

out.println("");

out.println("");

out.println(" ");

out.println(" ");

out.println("

");

out.print("

修改页面

");

// 定义表单

out.println("

");

out.println("

");

out.println("

" + "" + ""

+ "

");

out.println("

" + "" + "" + "");

out.println("

" + "" + "" + "");

//获取的addr

String select="selected";

//自己的方法如下：

if(addr.equals("shanghai")){

out.println("

" + "" + ""

+ "

");

}else if(addr.equals("huainan")){

out.println("

" + "" + ""

+ "

");

}else if(addr.equals("beijing")){

out.println("

" + "" + ""

+ "

");

}else if (addr.equals("hefei")){

out.println("

" + "" + ""

+ "

");

}

//老师的方法

/*out.println("");

String s1="

huainan

if(addr.equals("shanghai")){

s1+="selected='selected' ";

}

s1+=">shanghai";

out.println(s1);

String s2="

huainan

if(addr.equals("beijing")){

s2+="selected='selected' ";

}

s2+=">beijing";

out.println(s2);

out.println("

");

*/

out.println("

" + "" + "" + "");

out.println("

" + "ID号码：" + "	" + "" + "
" + "姓名：" + "	" + "" + "
" + "年龄：" + "	" + "" + "
" + "住址：" + "	" + ""+"huainanhefeibeijingshanghai" +" " + "
" + "住址：" + "	" + ""+"huainanhefeibeijingshanghai" +" " + "
" + "住址：" + "	" + ""+"huainanhefeibeijingshanghai" +" " + "
" + "住址：" + "	" + ""+"huainanhefeibeijingshanghai" +" " + "
" + "" + "	" + "" + "

");

out.println("

");

out.println("

");

out.println(" ");

out.println("");

out.flush();

out.close();

}

public void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

doGet(request, response);

}

}

public class Update extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

// 编码问题

response.setContentType("text/html;charset=GBK");// 浏览器显示的编码，默认的是iso

response.setCharacterEncoding("GBK");// 浏览器到数据库取数据时候使用的编码

request.setCharacterEncoding("GBK");// 浏览器到数据库存入数据时候所使用的编码方式

// 必须为post方式才行的

// 获取修改页上的值

int userId = Integer.parseInt(request.getParameter("id1"));

String name = request.getParameter("name1");

int age = Integer.parseInt(request.getParameter("age1"));

String address = request.getParameter("address");

// dao层

IPersonDao person = new PersonDaoImpl();

Person p = new Person();

p.setId(userId);

p.setName(name);

p.setAge(age);

p.setAddress(address);

// 修改的方法进行调用

person.updatePerson(p);

response.sendRedirect("/Jsp/selectAll");// 跳到查询全部页面

}

public void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

doGet(request, response);

}

}

Select

public class SelAll extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

// 编码问题

response.setContentType("text/html;charset=GBK");// 浏览器显示的编码，默认的是iso

response.setCharacterEncoding("GBK");// 浏览器到数据库取数据时候使用的编码

request.setCharacterEncoding("GBK");// 浏览器到数据库存入数据时候所使用的编码方式

PrintWriter out = response.getWriter();

// 1 不同的请求在同一個session对象中传值创建session对象（通过request）

HttpSession session = request.getSession();

// 2 获取另外一个servlet中的session的值

String sessionName = (String) session.getAttribute("name");

String sessionPwd = (String) session.getAttribute("pwd");

if (null == sessionName || "".equals(sessionName) || null == sessionPwd

|| "".equals(sessionPwd)) {

response.sendRedirect("./Login.jsp");// 跳到登陆页面

return;

}

// out.println("");

List list = new ArrayList();

IPersonDao person = new PersonDaoImpl();

list = person.selAllPerson();

request.setAttribute("list",list);

request.getRequestDispatcher("./SelAll.jsp").forward(request, response);

}

public void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

doGet(request, response);

}

}

selectAll.jsp

<%@page import="com.hnsfxy.entity.Person"%>

<%@page import="java.util.List"%>

<%@page language="java"contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>

JSP查询所有的记录

<%

List list=(List) request.getAttribute("list");

for(Object o:list){

Person p=(Person) o;

%>

<%

}

%>

用户ID	用户名	年龄	地址	操作
<%=p.getId()%>	<%=p.getName() %>	<%=p.getAge() %>	<%=p.getAddress() %>	删除 href="/Jsp/updateh?id=<%=p.getId() %>&&username=<%=p.getName() %> &&age=<%=p.getAge() %>&&address=<%=p.getAddress()%>">修改

添加联系人

Main.html

添加用户页面

ID号码：
姓名：
年龄：
住址：	huainan hefei beijing shanghai