Advertisement
GameNCode

SQL Update Table

Feb 8th, 2017
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.97 KB | None | 0 0
  1. <%@ page language="java" contentType="text/html; charset=windows-1255"
  2. pageEncoding="windows-1255"%>
  3. <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
  4. <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
  5. <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
  6. <html>
  7. <head>
  8. <meta http-equiv="Content-Type" content="text/html; charset=windows-1255">
  9. <title>Update SQL</title>
  10. </head>
  11. <body>
  12. <sql:setDataSource var="snapshot" driver="com.mysql.jdbc.Driver"
  13. url="jdbc:mysql://localhost/members"
  14. user="root" password="1234"/>
  15. <sql:query dataSource="${snapshot}" var="result">
  16. SELECT * FROM members;
  17. </sql:query>
  18. <sql:update dataSource="${snapshot}" var="insert">
  19. INSERT INTO members (user, pass) VALUES ('<%= request.getParameter("uname") %>', '<%= request.getParameter("pass") %>');
  20. </sql:update>
  21. <%
  22. response.sendRedirect("Login.jsp");
  23. %>
  24. </body>
  25. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement