Focus HMI panel uses SQLITE database. Automatically records and reports data. You can access database data with scripts. Sample code is shared below. After copying and pasting this code, correct the quotation marks.<\/p>\n\n\n\n
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
public class sql{
public sql(Class Accessing){
String url = \"jdbc:sqlite:\" + \"c:\\\\ABC\\\\FocusHmi\\\\LastValueDB.sqlite\";
try (Connection conn = DriverManager.getConnection(url)) {
if (conn != null) {
javax.swing.JOptionPane.showMessageDialog(null , \"Connected\");
String sql = \"SELECT Count(*) FROM MyTable\";
Statement stmt = conn.createStatement();
ResultSet rs=stmt.executeQuery(sql);
javax.swing.JOptionPane.showMessageDialog(null , rs.getInt(1));
if(!conn.isClosed())conn.close();
}else{
javax.swing.JOptionPane.showMessageDialog(null , \"Not Connected\");
}
} catch (SQLException exp) {
javax.swing.JOptionPane.showMessageDialog(null , exp.getMessage());
}
}
}<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"Focus HMI panel uses SQLITE database. Automatically records and reports data. You can access database data with scripts.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kadence_starter_templates_imported_post":false,"_swpsp_post_exclude":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[60],"tags":[206],"class_list":["post-1363","post","type-post","status-publish","format-standard","hentry","category-hmi","tag-data-management"],"yoast_head":"\n
Focus HMI SQLite Database: Access Data Using Scripts | Fultek<\/title>\n<meta name=\"description\" content=\"Focus HMI SQLite database usage. Access and manage your operator panel's internal data automatically using the provided Java script blocks.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.fultek.com.tr\/en\/focus-hmi-panel-database\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Scada\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/en\\\/focus-hmi-panel-database\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/en\\\/focus-hmi-panel-database\\\/\"},\"author\":{\"name\":\"Scada\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/en\\\/#\\\/schema\\\/person\\\/df45498fb898b0dd50c90cab08dfaedf\"},\"headline\":\"Focus HMI Panel Database\",\"datePublished\":\"2020-12-09T09:09:25+00:00\",\"dateModified\":\"2026-04-27T11:55:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/en\\\/focus-hmi-panel-database\\\/\"},\"wordCount\":37,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/en\\\/#organization\"},\"keywords\":[\"Data Management\"],\"articleSection\":[\"HMI\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.fultek.com.tr\\\/en\\\/focus-hmi-panel-database\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/en\\\/focus-hmi-panel-database\\\/\",\"url\":\"https:\\\/\\\/www.fultek.com.tr\\\/en\\\/focus-hmi-panel-database\\\/\",\"name\":\"Focus HMI SQLite Database: Access Data Using Scripts | Fultek\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/en\\\/#website\"},\"datePublished\":\"2020-12-09T09:09:25+00:00\",\"dateModified\":\"2026-04-27T11:55:15+00:00\",\"description\":\"Focus HMI SQLite database usage. Access and manage your operator panel's internal data automatically using the provided Java script blocks.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/en\\\/focus-hmi-panel-database\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fultek.com.tr\\\/en\\\/focus-hmi-panel-database\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/en\\\/focus-hmi-panel-database\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fultek.com.tr\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Focus HMI Panel Database\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.fultek.com.tr\\\/en\\\/\",\"name\":\"FULTEK | PLC | HMI | SCADA Software\",\"description\":\"PLC, HMI and SCADA Software \u2013 Industrial Automation Solutions\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.fultek.com.tr\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/en\\\/#organization\",\"name\":\"FULTEK | PLC | HMI | SCADA Software\",\"url\":\"https:\\\/\\\/www.fultek.com.tr\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.fultek.com.tr\\\/en\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/cropped-Fultek.png\",\"contentUrl\":\"https:\\\/\\\/www.fultek.com.tr\\\/en\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/cropped-Fultek.png\",\"width\":704,\"height\":151,\"caption\":\"FULTEK | PLC | HMI | SCADA Software\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.fultek.com.tr\\\/en\\\/#\\\/schema\\\/person\\\/df45498fb898b0dd50c90cab08dfaedf\",\"name\":\"Scada\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/74e267f7888087018e836ff4895a9b821489ce0a36abfbcd066f3b845c9c9522?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/74e267f7888087018e836ff4895a9b821489ce0a36abfbcd066f3b845c9c9522?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/74e267f7888087018e836ff4895a9b821489ce0a36abfbcd066f3b845c9c9522?s=96&d=mm&r=g\",\"caption\":\"Scada\"},\"sameAs\":[\"http:\\\/\\\/www.fultek.com.tr\\\/en\"],\"url\":\"https:\\\/\\\/www.fultek.com.tr\\\/en\\\/author\\\/salih\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Focus HMI SQLite Database: Access Data Using Scripts | Fultek","description":"Focus HMI SQLite database usage. Access and manage your operator panel's internal data automatically using the provided Java script blocks.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.fultek.com.tr\/en\/focus-hmi-panel-database\/","twitter_misc":{"Written by":"Scada","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fultek.com.tr\/en\/focus-hmi-panel-database\/#article","isPartOf":{"@id":"https:\/\/www.fultek.com.tr\/en\/focus-hmi-panel-database\/"},"author":{"name":"Scada","@id":"https:\/\/www.fultek.com.tr\/en\/#\/schema\/person\/df45498fb898b0dd50c90cab08dfaedf"},"headline":"Focus HMI Panel Database","datePublished":"2020-12-09T09:09:25+00:00","dateModified":"2026-04-27T11:55:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fultek.com.tr\/en\/focus-hmi-panel-database\/"},"wordCount":37,"commentCount":0,"publisher":{"@id":"https:\/\/www.fultek.com.tr\/en\/#organization"},"keywords":["Data Management"],"articleSection":["HMI"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fultek.com.tr\/en\/focus-hmi-panel-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fultek.com.tr\/en\/focus-hmi-panel-database\/","url":"https:\/\/www.fultek.com.tr\/en\/focus-hmi-panel-database\/","name":"Focus HMI SQLite Database: Access Data Using Scripts | Fultek","isPartOf":{"@id":"https:\/\/www.fultek.com.tr\/en\/#website"},"datePublished":"2020-12-09T09:09:25+00:00","dateModified":"2026-04-27T11:55:15+00:00","description":"Focus HMI SQLite database usage. Access and manage your operator panel's internal data automatically using the provided Java script blocks.","breadcrumb":{"@id":"https:\/\/www.fultek.com.tr\/en\/focus-hmi-panel-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fultek.com.tr\/en\/focus-hmi-panel-database\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.fultek.com.tr\/en\/focus-hmi-panel-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fultek.com.tr\/en\/"},{"@type":"ListItem","position":2,"name":"Focus HMI Panel Database"}]},{"@type":"WebSite","@id":"https:\/\/www.fultek.com.tr\/en\/#website","url":"https:\/\/www.fultek.com.tr\/en\/","name":"FULTEK | PLC | HMI | SCADA Software","description":"PLC, HMI and SCADA Software \u2013 Industrial Automation Solutions","publisher":{"@id":"https:\/\/www.fultek.com.tr\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fultek.com.tr\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.fultek.com.tr\/en\/#organization","name":"FULTEK | PLC | HMI | SCADA Software","url":"https:\/\/www.fultek.com.tr\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fultek.com.tr\/en\/#\/schema\/logo\/image\/","url":"https:\/\/www.fultek.com.tr\/en\/wp-content\/uploads\/2026\/03\/cropped-Fultek.png","contentUrl":"https:\/\/www.fultek.com.tr\/en\/wp-content\/uploads\/2026\/03\/cropped-Fultek.png","width":704,"height":151,"caption":"FULTEK | PLC | HMI | SCADA Software"},"image":{"@id":"https:\/\/www.fultek.com.tr\/en\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.fultek.com.tr\/en\/#\/schema\/person\/df45498fb898b0dd50c90cab08dfaedf","name":"Scada","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/74e267f7888087018e836ff4895a9b821489ce0a36abfbcd066f3b845c9c9522?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/74e267f7888087018e836ff4895a9b821489ce0a36abfbcd066f3b845c9c9522?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/74e267f7888087018e836ff4895a9b821489ce0a36abfbcd066f3b845c9c9522?s=96&d=mm&r=g","caption":"Scada"},"sameAs":["http:\/\/www.fultek.com.tr\/en"],"url":"https:\/\/www.fultek.com.tr\/en\/author\/salih\/"}]}},"taxonomy_info":{"category":[{"value":60,"label":"HMI"}],"post_tag":[{"value":206,"label":"Data Management"}]},"featured_image_src_large":false,"author_info":{"display_name":"Scada","author_link":"https:\/\/www.fultek.com.tr\/en\/author\/salih\/"},"comment_info":0,"category_info":[{"term_id":60,"name":"HMI","slug":"hmi","term_group":0,"term_taxonomy_id":60,"taxonomy":"category","description":"HMI and HMI Software Blog","parent":58,"count":19,"filter":"raw","cat_ID":60,"category_count":19,"category_description":"HMI and HMI Software Blog","cat_name":"HMI","category_nicename":"hmi","category_parent":58}],"tag_info":[{"term_id":206,"name":"Data Management","slug":"data-management","term_group":0,"term_taxonomy_id":206,"taxonomy":"post_tag","description":"Advanced data management features for Focus HMI panels, including database creation, USB report exporting, and FTP file transfers.","parent":0,"count":4,"filter":"raw"}],"_links":{"self":[{"href":"https:\/\/www.fultek.com.tr\/en\/wp-json\/wp\/v2\/posts\/1363","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fultek.com.tr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fultek.com.tr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fultek.com.tr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fultek.com.tr\/en\/wp-json\/wp\/v2\/comments?post=1363"}],"version-history":[{"count":3,"href":"https:\/\/www.fultek.com.tr\/en\/wp-json\/wp\/v2\/posts\/1363\/revisions"}],"predecessor-version":[{"id":2398,"href":"https:\/\/www.fultek.com.tr\/en\/wp-json\/wp\/v2\/posts\/1363\/revisions\/2398"}],"wp:attachment":[{"href":"https:\/\/www.fultek.com.tr\/en\/wp-json\/wp\/v2\/media?parent=1363"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fultek.com.tr\/en\/wp-json\/wp\/v2\/categories?post=1363"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fultek.com.tr\/en\/wp-json\/wp\/v2\/tags?post=1363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}