java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序

Question

package bean;

import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;

public class ConBean
{
User user = null;
Connection conn ;
Statement stmt ;
ResultSet rs ;
public void Con(String uri) throws Exception
{
String url = "jdbc:odbc:driver={Microsoft Acess Driver( *.mdb)};DBQ= "+uri+"upload.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(url);
stmt = conn.createStatement();
}
public ResultSet query(String sql) throws Exception
{
rs = stmt.executeQuery(sql);
return rs;
}
public void save(User user) throws Exception
{
String sql = "update user sex =" + "'" + user.getSex() + "',age=" +"'" + user.getAge()+"',hun="+user.getHun() + "',address=" + "'" +user.getAddress() + "'" + "where name ='"+user.getName()+"'";
stmt.executeUpdate(sql);
}
public void insert(String sql) throws SQLException
{
stmt.executeUpdate(sql);
}
public void close() throws SQLException
{
if(null != rs)
{
rs.close();
}
if(null !=stmt)
{
stmt.close();
}
if(null !=conn)
{
conn.close();
}
}
}
package servlet;

import java.io.File;
import java.io.IOException;
import java.sql.ResultSet;

import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import bean.ConBean;

public class Login extends HttpServlet
{
/**
*
*/
private static final long serialVersionUID = 1L;
HttpSession session;
ConBean con;
File file;
ServletContext application;
ResultSet rs;
@Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException
{
resp.setContentType("text/html;charset=gbk");
application = this.getServletContext();
con = new ConBean();
String name =req.getParameter("name");
name = new String(name.getBytes("iso8859-1"));
String password = req.getParameter("password");
String sql = "select * from user where name='"+name+"'and password = '" + password + "'";
file = new File(application.getRealPath("/")+"WEB-INF/");
String uri = file.getPath();
try
{
con.Con(uri);
rs = con.query(sql);
if(rs.next())
{
session = req.getSession();
session.setAttribute("name", name);
session.setAttribute("password", password);
resp.sendRedirect("../main.jsp");
}
else
{
resp.sendRedirect("../index.jsp");
}
}
catch(Exception e)
{
e.printStackTrace();
}
}
@Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException
{
// TODO Auto-generated method stub
doGet(req, resp);
}
}

Answer 1

ConBean类Con方法中
String url = "jdbc:odbc:driver={Microsoft Acess Driver( *.mdb)};DBQ= "+uri+"upload.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Acess 这里应该是Access吧

追问

先谢谢哈 改了也不行

追答

你驱动jar包路径正确吗

追问

upload.mdb 在WEB-INF 目录下

Answer 2

ConBean类Con方法中
String url = "jdbc:odbc:driver={Microsoft Acess Driver( *.mdb)};DBQ= "+uri+"upload.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
是正确的，问题可能在于你的驱动JAR包有问题，以前用成功过你的驱动没，还是从官网上下载一个最新的驱动包吧，网上还有教程。还是有问题的话就再留言吧。

Answer 3

你自己下一个包啊

Answer 4

驱动包倒的可能有问题