import java.sql.*;/**
* @author meigui
*
* 更改所生成类型注释的模板为
* 窗口 > 首选项 > Java > 代码生成 > 代码和注释
*/
public class Access
{
public static void main(String[] args){
String str="jdbc:odbc:driver={Microsoft Access Driver(*.mdb)};BQA=E:/WorkSpace/OAkaoqin/kaoqin/demo.mdb";
Connection con=null;
Statement stmt;
ResultSet rs=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection(str);
stmt=con.createStatement();
rs=stmt.executeQuery("select * from Test");
while(rs.next())
System.out.println(rs.getString("name"));
con.close();
stmt.close();
rs.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
出现的错误:
java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6057)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6214)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:2473)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:336)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:178)
at java.sql.DriverManager.getConnection(DriverManager.java:543)
at java.sql.DriverManager.getConnection(DriverManager.java:216)
at kaoqin.Access.main(Access.java:25)
怎么解决?
驱动程序我也下载了。
* @author meigui
*
* 更改所生成类型注释的模板为
* 窗口 > 首选项 > Java > 代码生成 > 代码和注释
*/
public class Access
{
public static void main(String[] args){
String str="jdbc:odbc:driver={Microsoft Access Driver(*.mdb)};BQA=E:/WorkSpace/OAkaoqin/kaoqin/demo.mdb";
Connection con=null;
Statement stmt;
ResultSet rs=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection(str);
stmt=con.createStatement();
rs=stmt.executeQuery("select * from Test");
while(rs.next())
System.out.println(rs.getString("name"));
con.close();
stmt.close();
rs.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
出现的错误:
java.sql.SQLException: [Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6057)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6214)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:2473)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:336)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:178)
at java.sql.DriverManager.getConnection(DriverManager.java:543)
at java.sql.DriverManager.getConnection(DriverManager.java:216)
at kaoqin.Access.main(Access.java:25)
怎么解决?
驱动程序我也下载了。
//-----------------------------------------------------------------------------
Connection conn;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc:odbc:demo");
//取得Connection,数据库类型是access