sql2.jsp

来自「介绍了j2ee开发常用的学习知识,如servlet,javamail,EJB等知」· JSP 代码 · 共 19 行

<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<%@  taglib  prefix="c"  uri="http://java.sun.com/jsp/jstl/core"  %>
<%@  taglib  prefix="sql"  uri="http://java.sun.com/jsp/jstl/sql"  %>
<%@  taglib  prefix="x"  uri="http://java.sun.com/jsp/jstl/xml"  %>
<sql:setDataSource var="dataSrc"
    url="jdbc:mysql://localhost/sample" driver="org.gjt.mm.mysql.Driver"
    user="root" password="javaee"/>
<sql:transaction dataSource="${dataSrc}" >
    <sql:update sql="insert into book (title,author,price)values( ? ,?,?)">
        <sql:param value="What Is Struts"/>
        <sql:param value="hanks"/>
        <sql:param value="${27.00}"/>
    </sql:update>
    <sql:update sql="update book set last_modified = now() where title = ?">
        <sql:param value="What Is Struts"/>
    </sql:update>
</sql:transaction>