下面的代码要实现连接到本机上的Access数据库(与class文件同一文件夹中的HDB.mdb)上
import java.sql.*;
class Test
{
public static void main( String arg[] )
{
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url =" jdbc:odbc:HDB";
Connection con = DriverManager.getConnection(url,"","");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery( "SELECT * FROM \"User\" WHERE Name = \'1\'");
while (rs.next())
{
System.out.println(rs.getString(1));
}
} catch ( Exception ex ) {
System.out.println( ex.toString()
}
}
}
有异常java.sql.SQLException: No suitable driver found for jdbc:odbc:HDB 哪里出错了?要怎样才可以正常连接上Access 数据库?
能不能再详细一点点```我刚接触JDBC