<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<jsp:useBean id="now" class="java.util.Date"/>
<sql:setDataSource var="example" scope="application"
driver="sun.jdbc.odbc.JdbcOdbcDriver"
url="jdbc:odbc:example"
user="scott"
password=""
/>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head><body>
<%-- 查询数据库里面是否已经存在这个员工信息 --%>
<sql:query var="empDbInfo" dataSource="${example}" >
SELECT * FROM Employee
WHERE UserName = ?
<sql:param value="${param.userName}" />
</sql:query>
<fmt:parseDate value="${param.empDate}" var="parsedEmpDate" pattern="yyyy-MM-dd" />
<c:choose>
<c:when test="{empDbInfo.rowCount == 0}">
<sql:update>
INSERT INTO Employee
(UserName, Password, FirstName, LastName, Dept, EmpDate, EmailAddr, ModDate)
VALUES ( ?,?,?,?,?,?,?,?)
<sql:param value="${param.userName}" />
<sql:param value="${param.password}" />
<sql:param value="${param.firstName}" />
<sql:param value="${param.lastName}" />
<sql:param value="${param.dept}" />
<%-- 把提交的日期转化成数据库格式日期--%>
<sql:dateParam value="${parsedEmpDate}" type="date" />
<sql:param value="${param.emailAddr}" />
<%-- 标记时间戳 --%>
<sql:dateParam value="${now}" />
</sql:update>
</c:when>
<c:otherwise>
<sql:update>
UPDATE Employee
SET Password=?,
<sql:param value="${param.password}" />
SET FirstName=?,
<sql:param value="${param.firstName}" />
SET LastName=?,
<sql:param value="${param.lastName}" />
SET Dept=?,
<sql:param value="${param.dept}" />
SET EmpDate=?,
<%-- 把提交的日期转化成数据库格式日期--%>
<sql:dateParam value="${parsedEmpDate}" type="date" />
SET EmailAddr=?,
<sql:param value="${param.emailAddr}" />
SET ModDate=?
<%-- 标记时间戳 --%>
<sql:dateParam value="${now}" />
WHERE UserName=?
<sql:param value="${param.userName}" />
</sql:update>
</c:otherwise>
</c:choose>
</body>
</html>
现在出错成javax.servlet.ServletException:
SELECT * FROM Employee
WHERE UserName = ?: [Microsoft][ODBC Microsoft Access Driver]??? SQL ????
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<jsp:useBean id="now" class="java.util.Date"/>
<sql:setDataSource var="example" scope="application"
driver="sun.jdbc.odbc.JdbcOdbcDriver"
url="jdbc:odbc:example"
user="scott"
password=""
/>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head><body>
<%-- 查询数据库里面是否已经存在这个员工信息 --%>
<sql:query var="empDbInfo" dataSource="${example}" >
SELECT * FROM Employee
WHERE UserName = ?
<sql:param value="${param.userName}" />
</sql:query>
<fmt:parseDate value="${param.empDate}" var="parsedEmpDate" pattern="yyyy-MM-dd" />
<c:choose>
<c:when test="{empDbInfo.rowCount == 0}">
<sql:update>
INSERT INTO Employee
(UserName, Password, FirstName, LastName, Dept, EmpDate, EmailAddr, ModDate)
VALUES ( ?,?,?,?,?,?,?,?)
<sql:param value="${param.userName}" />
<sql:param value="${param.password}" />
<sql:param value="${param.firstName}" />
<sql:param value="${param.lastName}" />
<sql:param value="${param.dept}" />
<%-- 把提交的日期转化成数据库格式日期--%>
<sql:dateParam value="${parsedEmpDate}" type="date" />
<sql:param value="${param.emailAddr}" />
<%-- 标记时间戳 --%>
<sql:dateParam value="${now}" />
</sql:update>
</c:when>
<c:otherwise>
<sql:update>
UPDATE Employee
SET Password=?,
<sql:param value="${param.password}" />
SET FirstName=?,
<sql:param value="${param.firstName}" />
SET LastName=?,
<sql:param value="${param.lastName}" />
SET Dept=?,
<sql:param value="${param.dept}" />
SET EmpDate=?,
<%-- 把提交的日期转化成数据库格式日期--%>
<sql:dateParam value="${parsedEmpDate}" type="date" />
SET EmailAddr=?,
<sql:param value="${param.emailAddr}" />
SET ModDate=?
<%-- 标记时间戳 --%>
<sql:dateParam value="${now}" />
WHERE UserName=?
<sql:param value="${param.userName}" />
</sql:update>
</c:otherwise>
</c:choose>
</body>
</html>
现在出错成javax.servlet.ServletException:
SELECT * FROM Employee
WHERE UserName = ?: [Microsoft][ODBC Microsoft Access Driver]??? SQL ????
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货