jsp 连接access 的问题，来大佬帮我看下

braveboyny 2019-03-09 11:31:58



import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;



public class Hello {



	public static void main(String[] args) {

		// TODO Auto-generated method stub

		String url = "jdbc:Access:///E:/DBS/MyDB.accdb";

		try {

			Class.forName(

					"com.hxtt.sql.access.AccessDriver");/* 加载 链接access的驱动 */

			Connection conn = DriverManager.getConnection(url); // Connection

																// ，Statement,ResultSet为内置对象

			Statement stat = conn.createStatement();

			String sql = "select * from Worker";

			ResultSet rs = stat.executeQuery(sql);

			while (rs.next()) {

				System.out.println(rs.getString(2) + rs.getString(3) + "\n");

			}



		} catch (Exception e) {

			e.printStackTrace();

		}

	}



}

上面是用java 测试的运行正常
下面是jsp实现：



<%@ page language="java" contentType="text/html; charset=ISO-8859-1"

	pageEncoding="ISO-8859-1"%>

<%@ page import="java.sql.*"%>



<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">

<title>My first Java Page</title>

</head>

<body>

	<%

		String url = "jdbc:Access:///E:/DBS/MyDB.accdb";

		Class.forName("com.hxtt.sql.access.AccessDriver");

		Connection con = DriverManager.getConnection("url");

		Statement stat = con.createStatement();

		ResultSet rs = stat.executeQuery("select * from Worker");

	%>



	<%

		while (rs.next()) {

			out.print(rs.getString(2) + rs.getString(3) + "<br>");

		}

	%>

</body>

</html>

在jsp中用相同的实现却出现错误
异常信息如下：
org.apache.jasper.JasperException: javax.servlet.ServletException: java.lang.ClassNotFoundException: com.hxtt.sql.access.AccessDriver
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:560)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:461)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
Root Cause

javax.servlet.ServletException: java.lang.ClassNotFoundException: com.hxtt.sql.access.AccessDriver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:909)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:838)
org.apache.jsp.hello_jsp._jspService(hello_jsp.java:151)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:438)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

项目里面都加载了Access_JDBC3.0.jar,不知道是怎么回事！

...全文