jstl数据库连接的问题
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%><%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<sql:setDataSource driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://localhost:1433;Database=?"
user="sa" password="?"
var="dataSource"/>
<sql:query var="result" sql="select * from jn_maoshuan"></sql:query>
为何这一行会出错?
<sql:setDataSource driver="com.microsoft.sqlserver.jdbc.SQLServerDriver" --------------------编程问答-------------------- 贴一下错误信息吧,不然都不知道是什么错误啊 --------------------编程问答--------------------
type Exception report
message An exception occurred processing JSP page /table.jsp at line 7
description The server encountered an internal error that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: An exception occurred processing JSP page /table.jsp at line 7
4: String path = request.getContextPath();
5: String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
6: %>
7: <sql:setDataSource driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
8: url="jdbc:sqlserver://localhost:1433;Database=astm"
9: user="sa" password="?"
10: var="dataSource"/>
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:521)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:412)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause
javax.servlet.ServletException: javax.servlet.jsp.JspTagException: In <driver>, invalid driver class name: "java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver"
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:861)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:794)
org.apache.jsp.table_jsp._jspService(table_jsp.java:92)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause
java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1680)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1526)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Class.java:247)
org.apache.taglibs.standard.tag.common.sql.DataSourceWrapper.setDriverClassName(Unknown Source)
org.apache.taglibs.standard.tag.common.sql.SetDataSourceTagSupport.doStartTag(Unknown Source)
org.apache.jsp.table_jsp._jspx_meth_sql_005fsetDataSource_005f0(table_jsp.java:118)
org.apache.jsp.table_jsp._jspService(table_jsp.java:69)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:388)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.36 logs. --------------------编程问答-------------------- 不太懂SQLServer,不过从错误信息可以看出,是DerverName,不对,应该版本之间有区别,05,08之间,建议楼主查询一下 --------------------编程问答-------------------- 弄了半天还是没有弄出来。 --------------------编程问答-------------------- 沉了?顶起... --------------------编程问答-------------------- jar没加啊。。。 --------------------编程问答-------------------- javax.servlet.ServletException: javax.servlet.jsp.JspTagException: In <driver>, invalid driver class name: "java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver"
看看异常就是没有追加jar包,看看环境jar追加了没有 --------------------编程问答-------------------- 根据错误信息提示应该是没加连接数据库的驱动包吧 --------------------编程问答-------------------- 为什么大家喜欢在页面端搞连接数据库这种东西
我觉得页面端主要还是负责传递数据、接收数据并显示
--------------------编程问答-------------------- 驱动jar包没有加貌似,
补充:Java , Web 开发