matlab连接sqlite，sqlite-jdbc jar包下载

sqlite-jdbc jar包下载

https://mvnrepository.com/artifact/org.xerial/sqlite-jdbc/3.34.0

matlab建立sqlite数据源

https://ww2.mathworks.cn/help/database/ug/sqlite-jdbc-windows.html

表格形式返回查询结果：

%% Automate Importing Data by Generating Code Using the Database Explorer App
% This code reproduces the data obtained using the Database Explorer app by
% connecting to a database, executing a SQL query, and importing data into the
% MATLAB(R) workspace. To use this code, add the password for connecting to the
% database in the database command.% Auto-generated by MATLAB Version 9.4 (R2018a) and Database Toolbox Version 8.1 on 27-Aug-2021 22:03:16%% Set preferences
prefs = setdbprefs('DataReturnFormat');
setdbprefs('DataReturnFormat','table')%% Make connection to database
conn = database('','','','org.sqlite.JDBC','jdbc:sqlite:F:\databases\sonar.db');%% Execute query and fetch results
curs = exec(conn,['SELECT count(time)' ...'FROM estimate_depths']);
curs = fetch(curs);
data = curs.Data;
close(curs)%% Close connection to database
close(conn)%% Restore preferences
setdbprefs('DataReturnFormat',prefs)%% Clear variables
clear prefs conn curs

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！