delete.jsp

来自「对入学者很实用用JAVA的基本语言写的」· JSP 代码 · 共 17 行

<%@ page contentType="text/html; charset=UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions"%>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%>
<sql:setDataSource var="ds"
	driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
	url="jdbc:sqlserver://localhost:1433;databaseName=training" user="sa"
	password="sa" />
<c:forEach var="usid" items="${paramValues.usid}">
  <sql:update dataSource="${ds}" var="rowNum">
      DELETE FROM USER_INFO WHERE USERID=?
      <sql:param value="${usid}"></sql:param>
  </sql:update>
</c:forEach>

<c:redirect url="db.jsp"></c:redirect>