Advertisement
Guest User

Untitled

a guest
Jul 23rd, 2017
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.53 KB | None | 0 0
  1. <form method="post" action="updatedemo.jsp">
  2. <table width="50%" border="1" align="center">
  3. <tr>
  4. <td width="41%" height="32"><em><strong>name</strong></em></td>
  5. <td width="59%">
  6. <input type="text" name="name" value="<%= resultset.getString(1) %>">
  7. </td>
  8. </tr>
  9. <tr>
  10. <td height="34"><em><strong>lastname</strong></em></td>
  11. <td>
  12. <input type="text" name="lastname" value="<%= resultset.getString(2) %>">
  13. </td>
  14. <input type="submit" name="submit">
  15. </form>
  16. <%
  17. }
  18. %>
  19. </BODY>
  20. </HTML>
  21.  
  22. <%@page import="java.sql.*"%>
  23.  
  24. <%
  25.  
  26. String name=request.getParameter("name");
  27. //int no=Integer.parseInt(code);
  28. String lastname=request.getParameter("lastname");
  29. try{
  30. Connection conn = null;
  31. Class.forName("com.mysql.jdbc.Driver").newInstance();
  32. conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/demo","root", "jack");
  33. Statement st=null;
  34. st=conn.createStatement();
  35.  
  36.  
  37.  
  38.  
  39. String sqlEDIT="UPDATE INTO demoproject(name,lastname) VALUES(?,?)";
  40. java.sql.PreparedStatement ps=conn.prepareStatement(sqlEDIT);
  41. ps.setString(1,name);
  42. ps.setString(2,lastname);
  43.  
  44. ps.executeUpdate();
  45. int i=ps.executeUpdate();
  46. if(i>0)
  47. {
  48. out.print("project added into database");
  49. response.sendRedirect("demo1.jsp");
  50. }
  51. }
  52. catch(Exception e){
  53. System.out.println(e);
  54. }
  55. %>
  56.  
  57. UPDATE table_name
  58. SET column1=value1,column2=value2,...
  59. WHERE some_column=some_value;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement