?????6 update&delete
?Download as DOCX, PDF?
0 likes?417 views
This document provides code examples for performing CRUD (create, read, update, delete) operations in Java Server Pages (JSP) and MySQL. It includes code for JSP files to display and edit records, as well as Java servlet classes and DAO classes containing SQL statements to interact with the database and implement the CRUD functionality.
![UPDATE [Table-Name] SET
Column1='Value1',Column2='Value2',... WHERE clause
UPDATE SET
1=¡¯ 1¡ä, 2=¡¯ 2¡ä
WHERE ¡¯ ¡¯
UPDATE tb_department SET dep_name=¡¯testedit¡¯,
dep_sname=¡¯ ¡¯ WHEREdep_id =¡¯ 2¡ä
SQL UPDATE
Table)
Record
Record Where](https://image.slidesharecdn.com/6updatedelete-130811050554-phpapp02/85/6-update-delete-3-320.jpg)
![delete Database (MySQL)
Code
DELETE FROM [Table-Name] WHERE clause
DELETE
DELETE FROM TABLE_NAME =
WHERE =](https://image.slidesharecdn.com/6updatedelete-130811050554-phpapp02/85/6-update-delete-4-320.jpg)
More Related Content
What's hot (19)
Viewers also liked (8)
Similar to ?????6 update&delete (20)
![Ex[1].3 php db connectivity](https://cdn.slidesharecdn.com/ss_thumbnails/ex1-3phpdbconnectivity-130227182839-phpapp02-thumbnail.jpg?width=560&fit=bounds)
?????6 update&delete
- 2. 5404101390 5404101417 1 2556 SQL UPDATE Table) Record 1 Where Update Database (MySQL) Code
- 3. UPDATE [Table-Name] SET Column1='Value1',Column2='Value2',... WHERE clause UPDATE SET 1=¡¯ 1¡ä, 2=¡¯ 2¡ä WHERE ¡¯ ¡¯ UPDATE tb_department SET dep_name=¡¯testedit¡¯, dep_sname=¡¯ ¡¯ WHEREdep_id =¡¯ 2¡ä SQL UPDATE Table) Record Record Where
- 4. delete Database (MySQL) Code DELETE FROM [Table-Name] WHERE clause DELETE DELETE FROM TABLE_NAME = WHERE =
- 5. DELETE FROM membersbook WHEREmember_id=¡±+ID+¡± ¡±; JSP edit 1. WebContent--> New --> JSP file edit.jsp
- 6. 2. edit.jsp EditServlet.java 1. Package com.controller--> New -- > Servlet EditServlet
- 7. 2. EditServlet. java Method doPost Method doget
- 9. DeleteServet.java 1. DeleteServet. java Method doPost MemberDAO.java 1. MemberDAO.java Method Method
- 12. Code Class edit <body> <% MembersBean mem = (MembersBean)request.getAttribute("MemberData"); %> <form action="UpdateServlet" method="post"> <input type="hidden" value="<%=mem.getMember_id()%>"name ="memberID"/> <table> <tr>
- 13. <td align="right"> </td> <td align="center" bgcolor="green"><input type="text" name="name" value ="<%=mem.getMember_firstname()%>"></td> </tr> <tr> <td align="right"> </td> <td align="center" bgcolor="green"><input type="text" name="lastname" value ="<%=mem.getMember_lastname()%>"></td> </tr> <tr> <td align="right"> </td> <td align="center" bgcolor="green"><textarea rows="5" cols="10" name="address" ><%=mem.getMember_address()%></textarea></td > </tr> <tr> <td align="right"> </td>
- 14. <td align="center" bgcolor="green"><input type="text" name="phone" value ="<%=mem.getMember_number()%>"></td> </tr> <tr> <td colspan="2" align="center"><input value=" type="submit"><input value=" type="reset"></td> </tr> </table> </form> </body> Code Class EditServlet protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doPost(request, response);
- 15. } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub String memberID = request.getParameter("memberID"); MemberDAO md = new MemberDAO(); String page = "edit.jsp"; request.setAttribute("MemberData",md.getMem ber(memberID)); RequestDispatcher dispatcher = request.getRequestDispatcher(page);
- 16. if(dispatcher != null){ dispatcher.forward(request, response); //forward request, response System.out.println("send complete"); // send complete } // } } Code Class UpdateServlet protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub request.setCharacterEncoding("UTF-8"); String id = request.getParameter("memberID"); String fname = request.getParameter("name") ; String lname = request.getParameter("lastname") ; String addr = request.getParameter("address") ; String tel = request.getParameter("phone");
- 17. String page = "Search.jsp"; // Profile.jsp MemberDAO md = new MemberDAO(); MembersBean mem = new MembersBean(); mem.setMember_id(Integer.parseInt(id)); mem.setMember_firstname(fname); mem.setMember_lastname(lname); mem.setMember_address(addr); mem.setMember_number(tel); md.UpdateMembers(mem); RequestDispatcher dispatcher = request.getRequestDispatcher(page); if(dispatcher != null){ dispatcher.forward(request, response); //forward request, response System.out.println("send complete"); // send complete } //
- 18. } Code Class DeleteServet protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub doPost(request, response); } /** * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response) */ protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { // TODO Auto-generated method stub String id = request.getParameter("memberID"); String page = "Search.jsp"; // Search.jsp MemberDAO md = new MemberDAO();
- 19. MembersBean mem = new MembersBean(); mem.setMember_id(Integer.parseInt(id)); md.DeleteMembers(id); RequestDispatcher dispatcher = request.getRequestDispatcher(page); if(dispatcher != null){ dispatcher.forward(request, response); //forward request, response System.out.println("send complete"); // send complete } // } Code Class MemberDAO
- 20. public static MembersBean getMember(String ID){ MembersBean mem = new MembersBean(); String sql = "SELECT * FROM membersbook WHERE member_id="+ID+""; //SELECT FROM members try { dbc.createConnection(); // stmt = dbc.getStatement(); // getStatement() stmt rs = stmt.executeQuery(sql); // rs while (rs.next()) { mem = new MembersBean(); mem.setMember_id(rs.getInt("member_id")); mem.setMember_username(rs.getString("member_u sername"));
- 22. mem.setMember_email(rs.getString("member_email" )); mem.setMember_image(rs.getString("member_imag e")); } } catch (Exception e) { e.printStackTrace(); // error } return mem; } ------------------------------- Method Update---------- ---------------- public static boolean UpdateMembers(MembersBean mem){ String sql = "UPDATE membersbook SET member_firstname='" +mem.getMember_firstname()+"',member_lastname= '"
- 23. +mem.getMember_lastname()+"',member_address='" +mem.getMember_address()+"',member_number='" +mem.getMember_number()+"'WHERE member_id=" +mem.getMember_id(); try { dbc.createConnection(); // stmt = dbc.getStatement(); // getStatement() stmt stmt.executeUpdate(sql); // rs } catch (Exception e) { e.printStackTrace(); // error } return true; }
- 24. ------------------------------- Method Delete----------- --------------- public static boolean DeleteMembers(String ID){ String sql = "DELETE FROM membersbook WHERE member_id="+ID+""; try{ dbc.createConnection(); // stmt = dbc.getStatement(); // getStatement() stmt stmt.executeUpdate(sql); // rs } catch (Exception e) { e.printStackTrace(); // error } return true; }