JAVA连接Access数据库----(常用数据库连接一) 一时失言乱红尘 2022-09-17 12:14 195阅读 0赞 1.在E盘下建立一个Access文件,命名为zhaochao.accdb,打开文件,创建一张USER表插入内容如下: ![Center][] 2.打开控制面板-->管理工具-->数据源(ODBC) 如下图所示:然后点击系统DSN-->添加-->选择Microsoft Access Driver(\*.mbd,\*.accdb); ![Center 1][] 3.单击完成后会显示下图:然后单击选择,选择E:/zhaochao.accdb文件,数据源名中填写zhaochao然后单击确定,配置好数据源。 ![Center 2][] 4.eclipse或者myeclipse中新建java工程,工程中建立一个接口如下 package com.zhaochao.dba; import java.sql.Connection; public interface iConn { Connection getConn(); } 5.建立AccessConn类,实现iConn接口 package com.zhaochao.dba; import java.sql.Connection; import java.sql.DriverManager; public class AccessConn implements iConn { private static final String DBDRIVER = "sun.jdbc.odbc.JdbcOdbcDriver" ; private static final String DBURL = "jdbc:odbc:zhaochao" ; private static final String DBUSER = "" ; private static final String DBPASS = ""; private Connection conn=null; @Override public Connection getConn() { // TODO Auto-generated method stub try{ Class.forName(DBDRIVER); conn=DriverManager.getConnection(DBURL,DBUSER,DBPASS); }catch(Exception e){ e.printStackTrace(); } return conn; } } 6.测试数据库连接 package com.zhaochao.dba; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class Test { /** * @param args */ public static void main(String[] args) { // TODO Auto-generated method stub // TestMySQL(); // TestOracle(); // TestDB2(); // TestSQLServer(); TestAccess(); } private static void TestAccess() { Connection conn=null; PreparedStatement ps=null; ResultSet rs=null; iConn iconn=new AccessConn(); conn=iconn.getConn(); String sql="select * from USER"; try { ps=conn.prepareStatement(sql); rs=ps.executeQuery(); while(rs!=null &&rs.next()){ System.out.println(rs.getString(1)+"|"+rs.getString(2)+"|"+rs.getString(3)); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally{ if(conn!=null){ try { conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } if(ps!=null){ try { ps.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } if(rs!=null){ try { rs.close(); } catch (Exception e2) { // TODO: handle exception e2.printStackTrace(); } } } } } 7.运行结果如下: 1|zhaochao|zhaochao 2|admin|admin [Center]: /images/20220828/44108c158ba6425f9950f85d7190350b.png [Center 1]: /images/20220828/92ac62be0b5c402394e7337d81bc1a49.png [Center 2]: /images/20220828/bf9b0e2ceb1544a7a71ec27148f1b94e.png
还没有评论,来说两句吧...