源代码如下:
<%@ page contentType="text/html;charset=GBK"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core"%>
<%@ taglib prefix="sql" uri="http://java.sun.com/jstl/sql"%>
<%@ include file="banner.jsp"%>
<%@ page isErrorPage="false"%>
<html>
<body bgcolor="#ddaa12">
<h3>JSP 操作Mysql数据库</h3>
<%
session.setAttribute("MysqlDriver","com.mysql.jdbc.Driver");
session.setAttribute("User","root");
session.setAttribute("Password","19841229");
session.setAttribute("Url","jbdc:mysql://localhost:3306/lionest");
%><sql:setDataSource 
var="example"
driver="${sessionScope.MysqlDriver}"
url="${sessionScope.Url}"
user="${sessionScope.User}"
password="${sessionScope.Password}"
/><sql:transaction dataSource="${example}">
 <sql:query var="showDatas">SECLECT * FROM book;</sql:query>
</sql:transaction><table width="70%" border="0">
<c:forEach var="row" items="${showDatas.rowsByIndex}">
<tr>
<c:forEach var="col" items="${row}"/>
<td><c:out value="${col}"/></td>
</tr>
</c:forEach>
</table><table width="70%" border="0">
<c:forEach var="row" items="${showDatas.rows}">
<tr>
<td><c:out value="${row.id}"/></td>
<td><c:out value="${row.name}"/></td>
</tr>
</c:forEach>
</table>
</body>
</html>
Exception;
------------------------------------------------
org.apache.jasper.JasperException: Exception in JSP: /body.jsp:1613: session.setAttribute("Url","jbdc:mysql://localhost:3306/lionest");
14: %>
15: 
16: <sql:setDataSource 
17: var="example"
18: driver="${sessionScope.MysqlDriver}"
19: url="${sessionScope.Url}"
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:467)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:371)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause javax.servlet.ServletException: javax.servlet.jsp.JspTagException: In &lt;driver&gt;, invalid driver class name: "java.lang.ClassNotFoundException: ${sessionScope.MysqlDriver}"
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:842)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.body_jsp._jspService(body_jsp.java:122)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:328)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:315)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)