jsp连数据库问题
<%@ 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" %>
<%--
See if the employee is already defined. If not, insert the
info, else update it.
--%>
<sql:setDataSource
url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=EmpDbInfo"
driver="sun.jdbc.odbc.JdbcOdbcDriver" user="sa"
password="123456" var="empDbInfo" />
<sql:query var="empDbInfo" dataSource="${Employee}">
SELECT * FROM Employee
WHERE UserName = ?
<sql:param value="${param.userName}" />
</sql:query>
.............
org.apache.jasper.JasperException: An exception occurred processing JSP page /store.jsp at line 14
11: driver="sun.jdbc.odbc.JdbcOdbcDriver" user="sa"
12: password="123456" var="empDbInfo" />
13:
14: <sql:query var="empDbInfo" dataSource="${Employee}">
15: SELECT * FROM Employee
16: WHERE UserName = ?
17: <sql:param value="${param.userName}" />
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:553)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:442)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:333)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
root cause
javax.servlet.ServletException: javax.servlet.jsp.JspException: 'dataSource' is null
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:911)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:840)
org.apache.jsp.store_jsp._jspService(store_jsp.java:140)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:419)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:333)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
root cause
javax.servlet.jsp.JspException: 'dataSource' is null
org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.getConnection(Unknown Source)
org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doStartTag(Unknown Source)
org.apache.jsp.store_jsp._jspx_meth_sql_005fquery_005f0(store_jsp.java:188)
org.apache.jsp.store_jsp._jspService(store_jsp.java:101)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:419)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:333)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
--------------------编程问答-------------------- javax.servlet.ServletException: javax.servlet.jsp.JspException: 'dataSource' is null
这是你报错中的语句。
'dataSource' is null --------------------编程问答-------------------- --------------------编程问答-------------------- <sql:setDataSource
url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=EmpDbInfo"
driver="com.microsoft.jdbc.sqlserver.SQLServerDriver" user="sa"
password="123456" var="empDbInfo" />
--------------------编程问答-------------------- ${empDbInfo} 小写 --------------------编程问答--------------------
+1 --------------------编程问答-------------------- org.apache.jasper.JasperException: An exception occurred processing JSP page /store.jsp at line 9
6: See if the employee is already defined. If not, insert the
7: info, else update it.
8: --%>
9: <sql:setDataSource
10: url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=EmpDbInfo"
11: driver="com.microsoft.jdbc.sqlserver.SQLServerDriver" user="sa"
12: password="123456" var="empDbInfo" />
用了三楼的就得到这个结果
--------------------编程问答-------------------- 改成小写后得题目的错误
补充:Java , Web 开发