Java Swing JTree MySQL

package display;

import java.sql.*;
import java.util.ArrayList;
import javax.swing.tree.DefaultMutableTreeNode;
import javax.swing.tree.DefaultTreeModel;
import util.Database;

public class DisplayCategory extends javax.swing.JFrame {

	Connection con = null;
	Statement stm = null;

	public DisplayCategory() {
		initComponents();
		pop_tree();// call to populate the JTree
	}

	// System generated code
	@SuppressWarnings("unchecked")
	// <editor-fold defaultstate="collapsed" desc="Generated Code">
	private void initComponents() {

		jPanel1 = new javax.swing.JPanel();
		jScrollPane1 = new javax.swing.JScrollPane();
		cat_tree = new javax.swing.JTree();

		setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
		setTitle("Product List");

		jScrollPane1.setViewportView(cat_tree);

		javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
		jPanel1.setLayout(jPanel1Layout);
		jPanel1Layout.setHorizontalGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
				.addGroup(jPanel1Layout
						.createSequentialGroup().addGap(18, 18, 18).addComponent(jScrollPane1,
								javax.swing.GroupLayout.PREFERRED_SIZE, 199, javax.swing.GroupLayout.PREFERRED_SIZE)
						.addContainerGap(26, Short.MAX_VALUE)));
		jPanel1Layout.setVerticalGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
				.addGroup(jPanel1Layout
						.createSequentialGroup().addGap(23, 23, 23).addComponent(jScrollPane1,
								javax.swing.GroupLayout.PREFERRED_SIZE, 235, javax.swing.GroupLayout.PREFERRED_SIZE)
						.addContainerGap(30, Short.MAX_VALUE)));

		javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
		getContentPane().setLayout(layout);
		layout.setHorizontalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
				.addGroup(layout.createSequentialGroup().addContainerGap()
						.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE,
								javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
						.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)));
		layout.setVerticalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
				.addGroup(layout.createSequentialGroup().addContainerGap()
						.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE,
								javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
						.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)));

		pack();
	}// </editor-fold>

	@SuppressWarnings("CallToThreadDumpStack")
	public final void pop_tree() {
		try {

			try {
				con = Database.getConnection();
				stm = con.createStatement();
			} catch (Exception ex) {
				ex.printStackTrace();
			}
			ArrayList list = new ArrayList();
			list.add("Category List");
			String sql = "SELECT * from category";

			ResultSet rs = stm.executeQuery(sql);

			while (rs.next()) {
				Object value[] = { rs.getString(1), rs.getString(2) };
				list.add(value);
			}
			Object hierarchy[] = list.toArray();
			DefaultMutableTreeNode root = processHierarchy(hierarchy);

			DefaultTreeModel treeModel = new DefaultTreeModel(root);
			cat_tree.setModel(treeModel);
		} catch (Exception e) {
		}

	}

	@SuppressWarnings("CallToThreadDumpStack")
	public DefaultMutableTreeNode processHierarchy(Object[] hierarchy) {
		DefaultMutableTreeNode node = new DefaultMutableTreeNode(hierarchy[0]);
		try {
			int ctrow = 0;
			int i = 0;
			try {

				try {
					con = Database.getConnection();
					stm = con.createStatement();
				} catch (Exception ex) {
					ex.printStackTrace();
				}
				String sql = "SELECT catid, catname from category";
				ResultSet rs = stm.executeQuery(sql);

				while (rs.next()) {
					ctrow = rs.getRow();
				}
				String L1Nam[] = new String[ctrow];
				String L1Id[] = new String[ctrow];
				ResultSet rs1 = stm.executeQuery(sql);
				while (rs1.next()) {
					L1Nam[i] = rs1.getString("catname");
					L1Id[i] = rs1.getString("catid");
					i++;
				}
				DefaultMutableTreeNode child, grandchild;
				for (int childIndex = 0; childIndex < L1Nam.length; childIndex++) {
					child = new DefaultMutableTreeNode(L1Nam[childIndex]);
					node.add(child);// add each created child to root
					String sql2 = "SELECT scatname from subcategory where catid= '" + L1Id[childIndex] + "' ";
					ResultSet rs3 = stm.executeQuery(sql2);
					while (rs3.next()) {
						grandchild = new DefaultMutableTreeNode(rs3.getString("scatname"));
						child.add(grandchild);// add each grandchild to each child
					}
				}

			} catch (Exception ex) {
				ex.printStackTrace();
			}

		} catch (Exception e) {
		}

		return (node);
	}

	public static void main(String args[]) {
		java.awt.EventQueue.invokeLater(new Runnable() {

			public void run() {
				new DisplayCategory().setVisible(true);
			}
		});
	}

	// Variables declaration - do not modify
	private javax.swing.JTree cat_tree;
	private javax.swing.JPanel jPanel1;
	private javax.swing.JScrollPane jScrollPane1;
	// End of variables declaration
}

package util;

import java.sql.Connection;
import java.sql.DriverManager;

public class Database {
	public static Connection getConnection() {
		try {
			Class.forName("com.mysql.jdbc.Driver");
			Connection con = DriverManager.getConnection(
					"jdbc:mysql://localhost:3306/jtree_category?autoReconnect=true&useSSL=false&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai",
					"root", "root");
			return con;
		} catch (Exception ex) {
			System.out.println("Database.getConnection() Error -->" + ex.getMessage());
			return null;
		}
	}

	public static void close(Connection con) {
		try {
			con.close();
		} catch (Exception ex) {
		}
	}
}

CREATE DATABASE IF NOT EXISTS jtree_category;
USE jtree_category;

CREATE TABLE `category` (
  `catid` int(10) unsigned NOT NULL auto_increment,
  `catname` varchar(45) NOT NULL,
  PRIMARY KEY  (`catid`)
);

INSERT INTO `category` (`catid`,`catname`) VALUES 
 (1,'Monitor'),
 (2,'Mouse'),
 (3,'Keyboard');

CREATE TABLE `subcategory` (
  `scatid` int(10) unsigned NOT NULL auto_increment,
  `catid` int(10) unsigned NOT NULL,
  `scatname` varchar(45) NOT NULL,
  PRIMARY KEY  (`scatid`),
  KEY `FK_subcategory_1` (`catid`),
  CONSTRAINT `FK_subcategory_1` FOREIGN KEY (`catid`) REFERENCES `category` (`catid`)
);

INSERT INTO `subcategory` (`scatid`,`catid`,`scatname`) VALUES 
 (1,1,'Samsung'),
 (2,2,'A4Tech'),
 (3,1,'Philips'),
 (4,2,'Sonic'),
 (5,3,'Perfect');