20151223--联系人项目
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ page import="java.util.*" %> <%@ page import="com.hanqi.*" %> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>联系人</title> <script type="text/javascript"> function disp_confirm() { var r = confirm("确定要删除该记录吗?") if (r == true) { response.sendRedirect("FindList"); } } </script> </head> <body> <a href="FindList">显示全部内容:</a> <table border="1"> <tr> <th></th> <th>姓名</th> <th>电话</th> <th>分组</th> </tr> <% Object obj = request.getAttribute("userlist"); if(obj != null) { ArrayList<Bao> array = (ArrayList<Bao>)obj; //遍历 for(Bao u : array) { out.print( "<tr><td>"+ "\t <a onclick='return disp_confirm()' href='Delete?id="+u.getId() + "'>删除</a>" +"</td><td>"+ u.getName()+"</td><td>" + u.getTel() + "</td><td>" + u.getGroupId()+"</td></tr>"); } //DeleteUser? ?是要删除的userid } else { out.append("用户列表为空"); } %> </table> <form method="post" action="Baoc" > <input name="id" type="hidden" value="0" /> <ul> <li>请输入联系人姓名:<input name="name" type="text" width=30 /></li> <li>请输入联系人电话号码:<input name="tel" type="text" width=30 /></li> <li><input type="submit" value="提交" /> <input type="reset" value="取消" /> </li> </ul> </form> </body> </html>
package com.hanqi; import java.io.IOException; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; /** * Servlet implementation class Baoc */ @WebServlet("/Baoc") public class Baoc extends HttpServlet { private static final long serialVersionUID = 1L; /** * @see HttpServlet#HttpServlet() */ public Baoc() { super(); // TODO Auto-generated constructor stub } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("UTF-8"); response.setContentType("text/html;charset=UTF-8"); response.setCharacterEncoding("UTF-8"); String id = request.getParameter("id"); String name = request.getParameter("name"); String tel = request.getParameter("tel"); if(name != null && name.trim().length() > 0) { //get方式时需要的转码 post方式不需要 // name = new String(name.getBytes("ISO-8859-1"),"UTF-8"); if(tel != null && tel.trim().length() > 0) { //调用数据访问层 //构建实体类 实例化 Bao m = new Bao(); m.setId(Integer.parseInt(id)); m.setName(name); m.setTel(tel); DAL md = new DAL(); try { if(md.insert(m) >0) { request.getRequestDispatcher("index.jsp").forward(request,response); } else { response.getWriter().append("保存数据失败"); } } catch (Exception e) { response.getWriter().append("发生错误" + e.getMessage()); e.printStackTrace(); } } else { response.getWriter().append("parentid不能为空"); } } else { response.getWriter().append("请正确填写地区名称"); } response.getWriter().append("Served at: ").append(request.getContextPath()); } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request, response); } }
package com.hanqi; import java.util.ArrayList; public class Bao { private int id; public int getId() { return id; } public void setId(int id) { this.id = id; } private String Name; public String getName() { return Name; } public void setName(String name) { Name = name; } private String Tel; public String getTel() { return Tel; } public void setTel(String tel) { Tel = tel; } private int GroupId; public int getGroupId() { return GroupId; } public void setGroupId(int groupId) { GroupId = groupId; } public ArrayList<Bao> getListAll() { // TODO 自动生成的方法存根 return null; } }
package com.hanqi; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import com.hanqi.*; public class DAL { //增 //创建一个实体类 m 并将它放置进去 public int insert(Bao m) throws Exception { int rtn = 0; Connection conn = DB.getConnection(); PreparedStatement pst = null; if (conn != null) { try { String sql = "insert into CONTACTS (id, Name, TEL,Groupid) values (SQ_C_ID.nextval,?,?,?) "; pst = conn.prepareStatement(sql); pst.setString(1, m.getName()); pst.setString(2, m.getTel()); pst.setInt(3, m.getGroupId()); //将执行结果赋给返回值 rtn = pst.executeUpdate(); } catch(Exception ex) { throw ex; } finally { try { pst.close(); } catch(Exception e) { conn.close(); } } } return rtn; } private String getName() { return null; } private int getParentid() { // TODO 自动生成的方法存根 return 0; } //删 public int delete(int id) throws Exception { int rtn = 0; Connection conn = DB.getConnection(); PreparedStatement pst = null; if (conn != null) { try { String sql = "delete CONTACTS where id = ?"; pst = conn.prepareStatement(sql); pst.setInt(1, id); rtn = pst.executeUpdate(); } catch(Exception ex) { throw ex; } finally { try { pst.close(); } catch(Exception e) { conn.close(); } } } return rtn; } //改 public int update(Bao user) throws Exception { int rtn = -1; Connection conn = DB.getConnection(); PreparedStatement pst = null; if (conn != null) { try { String sql = "update CONTACTS set name = ?,groupid = ? " + "where id = ? "; pst = conn.prepareStatement(sql); pst.setInt(3, user.getId()); pst.setString(1, user.getName()); pst.setInt(2, user.getGroupId()); rtn = pst.executeUpdate(); } catch(Exception ex) { throw ex; } finally { try { pst.close(); } catch(Exception e) { conn.close(); } } } return rtn; } //将全部数据全部查出 public ArrayList<Bao> getListAll() throws Exception { ArrayList<Bao> rtn = null; Connection conn = DB.getConnection(); PreparedStatement pst = null; if (conn != null) { try { String sql = "select * from CONTACTS"; pst = conn.prepareStatement(sql); ResultSet rs = pst.executeQuery(); rtn = new ArrayList<Bao>(); if(rs != null) { while(rs.next()) { Bao u = new Bao(); u.setId(rs.getInt("id")); u.setName(rs.getString("name")); u.setTel(rs.getString("tel")); u.setGroupId(rs.getInt("Groupid")); rtn.add(u); //取一个数就放一个数 } } } catch(Exception ex) { throw ex; } finally { try { pst.close(); } catch(Exception e) { conn.close(); } } } return rtn; } }
package com.hanqi; import java.io.IOException; 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 com.hanqi.*; /** * Servlet implementation class Delete */ @WebServlet("/Delete") public class Delete extends HttpServlet { private static final long serialVersionUID = 1L; /** * @see HttpServlet#HttpServlet() */ public Delete() { super(); // TODO Auto-generated constructor stub } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("UTF-8"); response.setContentType("text/html;charset=UTF-8"); response.setCharacterEncoding("UTF-8"); String id = request.getParameter("id"); DAL ud = new DAL(); if(id != null && id.trim().length() > 0) { //删除 try { ud.delete(Integer.parseInt(id)); //将 id 强制转换为 int 型 response.sendRedirect("FindList"); } catch (Exception e) { response.getWriter().append("删除数据失败"); e.printStackTrace(); } //删除 } } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request, response); } }
package com.hanqi; import java.io.IOException; import java.util.ArrayList; 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 com.hanqi.*; /** * Servlet implementation class FindList */ @WebServlet("/FindList") public class FindList extends HttpServlet { private static final long serialVersionUID = 1L; /** * @see HttpServlet#HttpServlet() */ public FindList() { super(); // TODO Auto-generated constructor stub } /** * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */ protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("UTF-8"); response.setContentType("text/html;charset=UTF-8"); response.setCharacterEncoding("UTF-8"); DAL ud = new DAL(); try { ArrayList<Bao> al = ud.getListAll(); request.setAttribute("userlist", al); } catch(Exception e) { response.getWriter().append("查找数据失败"); e.printStackTrace(); } //页面跳转 request.getRequestDispatcher("index.jsp").forward(request,response); } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doGet(request, response); } }