Access数据库中有username和password两个字段,下面用java实现对acess的访问,代码如下
/**
* Java 连接Access 数据库测试
*/
package Test;
import java.sql.*;
/**
* @author sxch
*
*/
public class AccessTest {
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
try{
String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=test.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
System.out.println("before connection");
Connection conn=DriverManager.getConnection(strurl);
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from usertable");
while(rs.next())
{
System.out.println(rs.getString("username")+"\t"+rs.getString("password"));
}
}catch(Exception e)
{
System.out.println(e);
}
}
}