import java.sql.*;public class Access {
public static void main(String args[]) {
Connection con;
Statement stmt; // 声明Statement对象
ResultSet rs;
String strurl = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=user.mdb"; try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("注册成功");
} catch (ClassNotFoundException e) {
System.out.println("" + e);
}
try {
con = DriverManager.getConnection(strurl, "", "");
System.out.println("连接数据库");
stmt = con.createStatement();
System.out.println("将SQL语句发送到数据库");
rs = stmt.executeQuery("select * from user");
System.out.println("读取数据库");
while (rs.next()) {
String name = rs.getString(2); // 获得数据库第一列
String sex = rs.getString(3);
System.out.println("姓名:" + name); // 输出信息
System.out.println("性别:" + sex);
}
con.close();
} catch (SQLException el) {
}
}
}
public static void main(String args[]) {
Connection con;
Statement stmt; // 声明Statement对象
ResultSet rs;
String strurl = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=user.mdb"; try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("注册成功");
} catch (ClassNotFoundException e) {
System.out.println("" + e);
}
try {
con = DriverManager.getConnection(strurl, "", "");
System.out.println("连接数据库");
stmt = con.createStatement();
System.out.println("将SQL语句发送到数据库");
rs = stmt.executeQuery("select * from user");
System.out.println("读取数据库");
while (rs.next()) {
String name = rs.getString(2); // 获得数据库第一列
String sex = rs.getString(3);
System.out.println("姓名:" + name); // 输出信息
System.out.println("性别:" + sex);
}
con.close();
} catch (SQLException el) {
}
}
}
DBQ=E:\\XXX\user.mdb
public static void main(String args[]) {
Connection con;
Statement stmt; // 声明Statement对象
ResultSet rs;
String strurl = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=D:/JAVA/TestAccess/user.mdb"; try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("注册成功");
} catch (ClassNotFoundException e) {
System.out.println("" + e);
}
try {
con = DriverManager.getConnection(strurl, "", "");
System.out.println("连接数据库");
stmt = con.createStatement();
System.out.println("将SQL语句发送到数据库"); //程序只运行到此!!
rs = stmt.executeQuery("select * from user");
System.out.println("读取数据库");
while (rs.next()) {
String name = rs.getString(2); // 获得数据库第一列
String sex = rs.getString(3);
System.out.println("姓名:" + name); // 输出信息
System.out.println("性别:" + sex);
}
con.close();
} catch (SQLException el) {
}
}
}
还是不行啊,再麻烦下~~谢谢