jdbc连接本地access数据库的demo。
POM文件
<project xmlns="/POM/4.0.0" xmlns:xsi="/2001/XMLSchema-instance" xsi:schemaLocation="/POM/4.0.0 /xsd/maven-4.0.0.xsd"><modelVersion>4.0.0</modelVersion><groupId>xyz.jangle</groupId><artifactId>jdbc</artifactId><version>0.0.1-SNAPSHOT</version><dependencies><dependency><groupId>net.sf.ucanaccess</groupId><artifactId>ucanaccess</artifactId><version>4.0.1</version></dependency></dependencies><build><sourceDirectory>src\main\java</sourceDirectory><plugins><plugin><artifactId>maven-compiler-plugin</artifactId><version>3.7.0</version><configuration><source>11</source><target>11</target></configuration></plugin></plugins></build></project>
JAVA代码
package jdbc;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;/*** jdk8之后,使用jdbc 连接 Access数据库的 DEMO* * @author jangle* @email jangle@jangle.xyz* @time 11月28日 下午7:51:22* * 需要引用pom依赖**<dependency><groupId>net.sf.ucanaccess</groupId><artifactId>ucanaccess</artifactId><version>4.0.1</version></dependency>*/public class AccessDemo {public static void main(String[] args) throws Exception {// 加载Access驱动Class.forName("net.ucanaccess.jdbc.UcanaccessDriver");// 前缀 加 数据库文件地址String url = "jdbc:ucanaccess://"+"C:\\Users\\jangl\\Documents\\Database1.accdb";Connection connection = DriverManager.getConnection(url);String sql ="select * from table1"; PreparedStatement statement = connection.prepareStatement(sql);ResultSet resultSet = statement.executeQuery();while (resultSet.next()) {System.out.println("id:"+resultSet.getLong("id")+",字段1 "+resultSet.getString(2));}}}
参考文献:/m0_37204491/article/details/81010758