{"id":3701,"date":"2020-12-09T11:05:27","date_gmt":"2020-12-09T09:05:27","guid":{"rendered":"https:\/\/www.fultek.com.tr\/?p=3701"},"modified":"2021-12-18T13:29:02","modified_gmt":"2021-12-18T11:29:02","slug":"focus-hmi-panel-database","status":"publish","type":"post","link":"https:\/\/www.fultek.com.tr\/Deneme\/focus-hmi-panel-database\/","title":{"rendered":"Focus HMI Panel Database"},"content":{"rendered":"\n

Focus HMI panel<\/a> SQLITE database’i kullan\u0131r. Verileri otomatik olarak kaydeder ve raporlar. Scriptler ile database verilerine ula\u015fabilirsiniz. A\u015fa\u011f\u0131da \u00f6rnek kod payla\u015f\u0131lm\u0131\u015ft\u0131r. Bu kodu kopyalay\u0131p yap\u0131\u015ft\u0131rd\u0131ktan sonra t\u0131rnak i\u015faretlerini d\u00fczeltiniz. Database dosyas\u0131 HMI Panel<\/a> projenizin bulundu\u011fu klas\u00f6rdedir.<\/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());
}
}
}<\/p>\n","protected":false},"excerpt":{"rendered":"

Focus HMI panel SQLITE database’i kullan\u0131r. Verileri otomatik olarak kaydeder ve raporlar. Scriptler ile database verilerine ula\u015fabilirsiniz. A\u015fa\u011f\u0131da \u00f6rnek kod payla\u015f\u0131lm\u0131\u015ft\u0131r.<\/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":"","_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":[269],"tags":[292,272,291],"class_list":["post-3701","post","type-post","status-publish","format-standard","hentry","category-hmi-destek","tag-database","tag-hmi","tag-hmi-panel"],"taxonomy_info":{"category":[{"value":269,"label":"HMI"}],"post_tag":[{"value":292,"label":"database"},{"value":272,"label":"hmi"},{"value":291,"label":"hmi panel"}]},"featured_image_src_large":false,"author_info":{"display_name":"Scada","author_link":"https:\/\/www.fultek.com.tr\/Deneme\/author\/salih\/"},"comment_info":0,"category_info":[{"term_id":269,"name":"HMI","slug":"hmi-destek","term_group":0,"term_taxonomy_id":272,"taxonomy":"category","description":"Focus HMI destek blo\u011fu.","parent":1,"count":20,"filter":"raw","cat_ID":269,"category_count":20,"category_description":"Focus HMI destek blo\u011fu.","cat_name":"HMI","category_nicename":"hmi-destek","category_parent":1}],"tag_info":[{"term_id":292,"name":"database","slug":"database","term_group":0,"term_taxonomy_id":295,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":272,"name":"hmi","slug":"hmi","term_group":0,"term_taxonomy_id":275,"taxonomy":"post_tag","description":"","parent":0,"count":18,"filter":"raw"},{"term_id":291,"name":"hmi panel","slug":"hmi-panel","term_group":0,"term_taxonomy_id":294,"taxonomy":"post_tag","description":"","parent":0,"count":2,"filter":"raw"}],"_links":{"self":[{"href":"https:\/\/www.fultek.com.tr\/Deneme\/wp-json\/wp\/v2\/posts\/3701","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fultek.com.tr\/Deneme\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fultek.com.tr\/Deneme\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fultek.com.tr\/Deneme\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fultek.com.tr\/Deneme\/wp-json\/wp\/v2\/comments?post=3701"}],"version-history":[{"count":3,"href":"https:\/\/www.fultek.com.tr\/Deneme\/wp-json\/wp\/v2\/posts\/3701\/revisions"}],"predecessor-version":[{"id":3708,"href":"https:\/\/www.fultek.com.tr\/Deneme\/wp-json\/wp\/v2\/posts\/3701\/revisions\/3708"}],"wp:attachment":[{"href":"https:\/\/www.fultek.com.tr\/Deneme\/wp-json\/wp\/v2\/media?parent=3701"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fultek.com.tr\/Deneme\/wp-json\/wp\/v2\/categories?post=3701"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fultek.com.tr\/Deneme\/wp-json\/wp\/v2\/tags?post=3701"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}