Access_JDBC30-无限制.zip

package com.jdbc.test1; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class hxtt50thselectlimit { public static Connection getConnection() { Connection conn = null; try { Class.forName("com.hxtt.sql.access.AccessDriver"); conn = (Connection) DriverManager.getConnection("jdbc:Access:///D:/Database1.mdb", "", ""); // 连接数据库 } catch (ClassNotFoundException | SQLException e) { e.printStackTrace(); } return conn; } public static void select() { Connection conn = getConnection(); String sql = "select *from usertable"; try { Statement st = conn.createStatement(); ResultSet rs = st.executeQuery(sql); // 执行SQL语句 while (rs.next()) { System.out.print(rs.getString("id") + " "); System.out.print(rs.getString("username") + " "); System.out.println(rs.getInt("age") + " "); } rs.close(); st.close(); conn.close(); } catch (SQLException e) { e.printStackTrace(); } } public static void main(String[] args) { for(int i=0;i<=60;i++) { System.out.println("第"+i+"次查询"); select(); } } /* 上限1：50次查询上限 若有限制，报错如下 第51次查询 java.sql.SQLException: HXTT Access Version 6.0 For Evaluation Purpose allows executing not more than 50 queries once. You can order commercial version from http://www.hxtt.com . at com.hxtt.b.am.a(Unknown Source) at com.hxtt.b.am.if(Unknown Source) at com.hxtt.sql.b0.a(Unknown Source) at com.hxtt.sql.b0.if(Unknown Source) at com.hxtt.sql.b0.a(Unknown Source) at com.hxtt.sql.an.a(Unknown Source) at com.hxtt.sql.an.a(Unknown Source) at com.hxtt.sql.an.if(Unknown Source) at com.hxtt.sql.an.executeQuery(Unknown Source) at com.jdbc.test.hxtt50limit.select(hxtt50limit.java:26) at com.jdbc.test.hxtt50limit.main(hxtt50limit.java:43)*/ } --------------------- 作者：gsls200808 来源：CSDN 原文：https://blog.csdn.net/gsls200808/article/details/79874527 版权声明：本文为博主原创文章，转载请附上博文链接！