try{
       Object header[]={"No Barang","Jumlah Barang","Kode Pembeli","Tanggal Pembelian","Harga Barang"};
       DefaultTableModel data = new DefaultTableModel(null,header);
       table.setModel(data);

       try{
       Class.forName("com.mysql.jdbc.Driver").newInstance();
       java.sql.Connection conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/PBO?zeroDateTimeBehavior=convertToNull","root","");
       java.sql.Statement state= conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
       String sql="SELECT * FROM pembelian ";
       ResultSet rs = state.executeQuery(sql);
       while(rs.next()){
       String test1 = rs.getString(1);
       int test2 = rs.getInt(2);
       String test3 = rs.getString(3);
       String test4 = rs.getString(4);
       int test5 = rs.getInt(5);



       String test[]={test1,String.valueOf(test2),test3,test4,String.valueOf(test5)};
       data.addRow(test);

       }
       }
       catch (Exception e)
       {
           JOptionPane.showMessageDialog(null,"Error:"+e.getMessage());
       }
       }
       catch (Exception e)
       {
           JOptionPane.showMessageDialog(null,"Error:"+e.getMessage());
       }