private void cariDetailPesanan(int noPesanan){
        try {
            Class.forName ("com.mysql.jdbc.Driver");
            String urldb="jdbc:mysql://localhost:3306/restaurant";
            String user=main.dbUser;
            String password=main.dbPassword;
            Connection koneksi=java.sql.DriverManager.getConnection(urldb,user,password);
            String strSQL = "SELECT * "
                            + "FROM `detail_pesanan` "
                            + "WHERE `no_pesanan` = '"+noPesanan+"' ";

            Statement st = koneksi.createStatement();
            ResultSet rs = st.executeQuery(strSQL);
            
            while (tblModel.getRowCount() > 0){
                tblModel.removeRow(0);
            }
            
            while (rs.next()){
                tblModel.addRow(new String[]{rs.getString(2), rs.getString(3)});
            }
            
            rs.close();
            st.close();
            koneksi.close();
        }catch(ClassNotFoundException cnfe){
            System.out.println("kesalahan saat"+"me-load driver jdbc \n"+cnfe.getMessage());
        }catch(SQLException sqle){
            System.out.println("keslahan saat koneksi atau "+"kesalahan query sql \n"+sqle.getMessage());
        }
    }