importjava.sql.DriverManager;importjava.sql.Connection;importjava.sql.Statement;importjava.sql.ResultSet;publicclassTest{publicstaticvoidmain(String[]args){Connectionconn...
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
public class Test {
public static void main(String[] args) {
Connection conn= null;
Statement stmt = null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:Driver={Microsoft Access Driver(*.mdb)};DBQ=E:\\db1.mdb";
conn=DriverManager.getConnection(url,"","");
stmt = conn.createStatement();
String query="select * from employee";
ResultSet rs = stmt.executeQuery(query);
while(rs.next()){
System.out.println("用户名: "+rs.getString("usernaeme")+" 密码: "+rs.getString("password")+" 用户类型: "+rs.getString("type"));
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception e){
e.printStackTrace();
}
}
}
在线等!!!
1楼道帅哥 , 可以百度hi聊不 不是说JDBC不用这么配置了吗??
谁教我一下 百度hi聊 可以加分
展开