Updating a database using the sql:update tag : Database « JSTL « Java

Updating a database using the sql:update tag


<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"

<%@ taglib prefix="sql" uri="http://java.sun.com/jstl/sql" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core" %>
<title>Updating a database using the sql:update tag</title>
<h1>Modify Address List</h1>
<sql:update dataSource="${conn}" var="addresses">
    INSERT INTO AddressList (name, street, city, country, telephone) VALUES (?, ?, ?, ?, ?)
    <sql:param value='${param["name"]}'/>
    <sql:param value='${param["street"]}'/>
    <sql:param value='${param["city"]}'/>
    <sql:param value='${param["country"]}'/>
    <sql:param value='${param["tel"]}'/>


Related examples in the same category

1.JSTL SQL Query
2.JSTL SQL Update
3.Presenting database content using tags
4.JSTL: Transaction with a JSP
5.SQL Tag Out Examples