insert.tag

某石油系统正在使用的实时报表平台系统

<%@ tag body-content="empty" dynamic-attributes="columnAttr" %>
<%@ attribute name="table" required="true" %>
<%@ include file="init.tagf" %>

<c:set var="v_columnNames" value=""/>
<c:set var="v_paramMarkers" value=""/>
<c:set var="v_separator" value=""/>
<c:catch var="errormsg">
<sql:update dataSource="${tags_tour_dataSource}">
<c:forEach var="v_entry" items="${columnAttr}">
<sql:param value="${v_entry.value}"/>
<c:set var="v_columnNames"
value="${v_columnNames}${v_separator}${v_entry.key}"/>
<c:set var="v_paramMarkers"
value="${v_paramMarkers}${v_separator}${'?'}"/>
<c:set var="v_separator" value=", "/>
</c:forEach>
INSERT INTO ${table} (${v_columnNames})
VALUES (${v_paramMarkers})
</sql:update>
</c:catch>

<c:if test="${!empty errormsg}">
<pre><c:out value="${errormsg}" /></pre>
</c:if>