try{

           Class.forName("com.mysql.jdbc.Driver");  // MySQL database connection
           java.sql.Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/lsdb?" + "user=root&password=");
           java.sql.PreparedStatement pst = conn.prepareStatement("Select * from history");
           ResultSet rs = pst.executeQuery();


           ResultSetMetaData rsmt = rs.getMetaData();
            int c = rsmt.getColumnCount();
            Vector column = new Vector(c);
            for(int i = 1; i <= c; i++)
            {
                column.add(rsmt.getColumnName(i));
            }
            Vector data = new Vector();
            Vector row = new Vector();

            DefaultTableModel model = (DefaultTableModel) tableHistory.getModel();

            model.setRowCount(0);

            while(rs.next())
            {
                String data1 = rs.getString(2);
                String data2 = rs.getString(3);
                String data3 = rs.getString(4);
                String data4 = rs.getString(5);

                Object[] rows = { data1, data2, data3, data4 };
                model.addRow(rows);
            }

            pst.close();
            rs.close();
            conn.close();
       }
       catch(Exception e){
       }