java 找不到适合 jdbc 的驱动程序：ucanaccess://C:\Users\Asim Iqbal\Documents\PersonInfo.accdb
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/31741879/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
No suitable driver found for jdbc:ucanaccess://C:\Users\Asim Iqbal\Documents\PersonInfo.accdb
提问by Faisal_mthe
I have to face this error:
我必须面对这个错误：
No suitable driver found for jdbc:ucanaccess://C:\Users\Asim Iqbal\Documents\PersonInfo.accdb org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:555)
找不到适合 jdbc 的驱动程序：ucanaccess://C:\Users\Asim Iqbal\Documents\PersonInfo.accdb org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:555)
in my JSP project. But when I run PersonDAO.javaseparately, it works properly. But, by using Bean I have to face this type of error. These files are as followed.
在我的 JSP 项目中。但是当我PersonDAO.java单独运行时，它可以正常工作。但是，通过使用 Bean，我不得不面对这种类型的错误。这些文件如下。
PersonDAO.java
PersonDAO.java
import java.util.*;
import java.sql.*;
import java.io.*;
public class PersonDAO implements Serializable {
private PreparedStatement stmt;
public ArrayList pList;
String url="jdbc:ucanaccess://C:\Users\Asim Iqbal\Documents\PersonInfo.accdb";
Connection conn = DriverManager.getConnection(url);
public PersonDAO() throws SQLException{
establishConnection();
}
private void establishConnection() throws SQLException
{
String url1="jdbc:ucanaccess://C:\Users\Asim Iqbal\Documents\PersonInfo.accdb";
conn = DriverManager.getConnection(url1);
}
public ArrayList getPerson(String name) throws SQLException {
PersonInfo pInfo=new PersonInfo();
pList=new ArrayList();
String sql="SELECT * FROM Person WHERE name=?";
stmt=conn.prepareStatement(sql);
stmt.setString(1,name);
ResultSet rs=stmt.executeQuery();
String add,n;
String p;
while(rs.next()){
n=rs.getString("Name");
add=rs.getString("Address");
p=rs.getString("PhoneNumber");
pInfo.setName(n);
pInfo.setAddress(add);
pInfo.setpNumber(p);
pList.add(pInfo);
}
return pList;
}
}
saveperson.jsp
保存人.jsp
</head>
<jsp:useBean id="pDAO" class="Person.PersonDAO" scope = "request" />
<jsp:useBean id="personBean" class="Person.PersonInfo" scope="request"/>
<jsp:setProperty name="personBean" property="name" param="name"/>
<jsp:setProperty name="personBean" property="address" param="address"/>
<jsp:setProperty name="personBean" property="pNumber" param="pNumber"/>
<%
pDAO.setPerson(personBean);
%>
<center>
<h1>You have successfully add the record!</h1>
<h4>
<a href="index.html" > Add another Person Record </a> <br>
<br><br>
<a href="searchperson.jsp" > Search Person </a>
</h4>
</center>
Please tell me where I am doing wrong..
请告诉我我哪里做错了..
回答by Florian Schaetz
You must add the ucanaccess jar to the classpath and call Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");before you try to open the connection (once is enough) for the DriverManager to find the driver with that url, see here.
您必须将 ucanaccess jar 添加到类路径并Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");在尝试打开连接（一次就足够了）之前调用，以便 DriverManager 找到具有该 url 的驱动程序，请参见此处。
