Java连接Access数据库
来源:互联网 发布:阿里云新logo矢量图 编辑:程序博客网 时间:2024/05/21 15:48
- import java.sql.*;
- public class T {
- public static void main(String args[]) {
- Connection con;
- Statement sql;
- ResultSet rs;
- try {
- Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
- } catch (ClassNotFoundException e) {
- System.out.println("" + e);
- }
- try {
- con = DriverManager.getConnection("jdbc:odbc:redsun", "", "");
- sql = con.createStatement();
- rs = sql.executeQuery("Select * FROM member");
- while (rs.next()) {
- String name = rs.getString(1);
- String sex = rs.getString(3);
- System.out.println("姓名:" + name);
- System.out.println("年龄:" + sex);
- }
- con.close();
- } catch (SQLException el) {
- }
- }
- }