仅供学习研究使用,切勿用于商业 示例代码 d:/empty.mdb 为access的mdb文件路径 public static void main(String[] args) throws SQLException, ClassNotFoundException { String url ="jdbc:access:/d:/empty.mdb"; Class.forName("com.hxtt.sql.access.AccessDriver"); Connection con = DriverManager.getConnection(url); Statement statement = con.createStatement(); statement.execute("drop table if exists test;"); statement.execute("create table if not exists test(field1 varchar(25),field2 varchar(25),field3 varchar(25),field4 varchar(25),field5 varchar(25),field6 varchar(25))"); for(int i=0;i<10000;i++){ statement.execute("insert into test(field1,field2,field3,field4,field5,field6) values('field1_"+i+"','field2_"+i+"','field3_"+i+"','field4_"+i+"','field5_"+i+"','filed6_"+i+"')"); } ResultSet rs= statement.executeQuery("select * from test"); while(rs.next()){ System.out.println(rs.getString(1)+"\t"+rs.getString(2)+"\t"+rs.getString(3)+"\t"+rs.getString(4)+"\t"+rs.getString(5)+"\t"+rs.getString(6)); } con.close(); }
2022-03-18 19:00:45 2.66MB java jdbc acess
1
本系统是才用JAVA Swing JDBC来实现的,本人也在学习,大家一起进步!
2021-05-24 19:18:32 40KB Acess JAVA JDBC swing
1
ruan-almeida-c.github.io:RelógioAcessível
2021-03-09 14:06:36 117KB JavaScript
1
这是本人用java做的一个小小的登陆界面,连接的是Access数据库,数据源的名字是mysource,只要在本地机上配置一下就可以使用了。很简单的界面……
2019-12-21 19:29:27 10KB java+Acess java 登陆界面
1