jdbc连接access数据库一问!请指教
shiyq 2003-08-30 01:36:11 现在运行提示:“未发现数据源名,并且未指定默认驱动程序”,不知如何处理。
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
DBName = "test";
String dbUrl = "jdbc:odbc:Driver={MicroSoft Access Driver(*.mdb)};DBQ=" + DBName;
Connection con = DriverManager.getConnection(dbUrl,"Admin","");
Statement stmt = con.createStatement();
String query = "SELECT * FROM " + selectedItem;
ResultSet rs = stmt.executeQuery(query);
while(rs.next())
{
Integer time = new Integer(rs.getInt(1));
timeList = new LinkedList();
timeList.add(time);
Double data = new Double(rs.getDouble(2));
dataList = new LinkedList();
dataList.add(data);
}
}catch(ClassNotFoundException e)
{
JOptionPane.showMessageDialog(this,"Class Not Found.");
}
catch(SQLException e)
{
String sqlState = e.getSQLState();
String message = e.getMessage();
JOptionPane.showMessageDialog(this,sqlState + "\n" + message);
}
catch(Exception e){}
}