{"id":50,"date":"2021-10-08T01:32:31","date_gmt":"2021-10-08T01:32:31","guid":{"rendered":"https:\/\/ouritsource.com\/blog\/?p=50"},"modified":"2021-10-08T02:28:57","modified_gmt":"2021-10-08T02:28:57","slug":"how-to-display-data-from-mysql-in-java-using-netbeans-12","status":"publish","type":"post","link":"https:\/\/ouritsource.com\/blog\/how-to-display-data-from-mysql-in-java-using-netbeans-12\/","title":{"rendered":"How To Display Data From MySQL in Java Using NetBeans 12"},"content":{"rendered":"\n

Cick File, New Project, Java Application, and give it a project name: JtableDB.<\/li><\/ol>\n\n\n\n
$\"\"$ <\/figure>\n\n\n\n
2. Click Jtabledb under Surce Packages, New, JFrame Form and change class name: JtableData. <\/p>\n\n\n\n
$\"\"$ <\/figure>\n\n\n\n
<\/p>\n\n\n\n
$\"\"$ <\/figure>\n\n\n\n
3. Click onJtableData.java (form) and click on Design.\u00a0 Add a Button and a Table.<\/p>\n\n\n\n
$\"\"$ <\/figure>\n\n\n\n
4\/ Click on table (jTable1), right-click to open pop-up menu, and click on Properties, then Click on model.<\/p>\n\n\n\n
$\"\"$ <\/figure>\n\n\n\n
5. Modify table so Column titles are id, username, and password.<\/p>\n\n\n\n
$\"\"$ <\/figure>\n\n\n\n
6.The database being used contains the following table and data.<\/p>\n\n\n\n
$\"\"$ <\/figure>\n\n\n\n
7. Right click on the button, events, action, action performed.<\/p>\n\n\n\n
$\"\"$ <\/figure>\n\n\n\n
8. In the JtableData.java, go to source code, and add \u201cimport java.sql.*\u201d.<\/p>\n\n\n\n
9. In the button\u2019s Action event, add the following:<\/p>\n\n\n\n
\/\/database connection<\/span>
try {<\/span>
\u00a0\u00a0\u00a0 \/\/open database connection<\/span>
\u00a0\u00a0\u00a0 Class.forName<\/em>(\u201ccom.mysql.jdbc.Driver\u201d);
\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0Connection con = DriverManager.getConnection(\u201cjdbc:mysql:\/\/localhost:3306\/mydb?useSSL=false\u201d,\u201droot\u201d,\u201dmysql@123\u201d);
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0Statement st = con.createStatement();<\/span>

\u00a0\u00a0\u00a0 \/\/mysql query\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>
\u00a0\u00a0\u00a0 String sql = \u201cselect * from login\u201d;
\u00a0\u00a0\u00a0 ResultSet rs = st.executeQuery(sql);<\/span>

\u00a0\u00a0\u00a0 while(rs.next()){<\/span>
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/each record from db table will be read and data stored in string variables<\/span>
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 String id = String.valueOf(rs.getint(\u201cid\u201d));
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 String username = rs.getString(\u201cusername\u201d);
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 String password = rs.getString(\u201cpassword\u201d);<\/span><\/p>\n\n\n\n
\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\/\/create string array to store data retrieved from db table<\/span>
\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0String tbData[] = {id,username,password};
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 DefaultTableModel tblModel = (DefaultTableModel<\/em>)jTable1.getModel();<\/span><\/p>\n\n\n\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\/\/add string array data into jtable<\/span>
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0tblModel.addRows(tbData);
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }
con.close();

\u00a0\u00a0 } catch(Exception e) {
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 System.out.println(e.getMessage()); }<\/span><\/p>\n<\/body>","protected":false},"excerpt":{"rendered":"
Cick File, New Project, Java Application, and give it a project name: JtableDB. 2. Click Jtabledb under Surce Packages, New, JFrame Form and change class name: JtableData. 3. Click onJtableData.java (form) and…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[9,10,8],"class_list":["post-50","post","type-post","status-publish","format-standard","hentry","category-java","tag-java","tag-mysql","tag-netbeans","no-thumbnail"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/ouritsource.com\/blog\/wp-json\/wp\/v2\/posts\/50","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ouritsource.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ouritsource.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ouritsource.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ouritsource.com\/blog\/wp-json\/wp\/v2\/comments?post=50"}],"version-history":[{"count":2,"href":"https:\/\/ouritsource.com\/blog\/wp-json\/wp\/v2\/posts\/50\/revisions"}],"predecessor-version":[{"id":70,"href":"https:\/\/ouritsource.com\/blog\/wp-json\/wp\/v2\/posts\/50\/revisions\/70"}],"wp:attachment":[{"href":"https:\/\/ouritsource.com\/blog\/wp-json\/wp\/v2\/media?parent=50"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ouritsource.com\/blog\/wp-json\/wp\/v2\/categories?post=50"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ouritsource.com\/blog\/wp-json\/wp\/v2\/tags?post=50"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}