Databases
StackOverflow2013
Postsdbo
POHow to persist such data in mysql
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to persist such data in mysql
    primarykey
    data
    text
    <p>I have the following 5 classes [other attributes and methods have been skipped]</p> <p><strong>CommonInterface.java</strong></p> <pre><code> import java.util.Vector; public class CommonInterface { public Vector myDescription; public Vector myPartyPlaceThing; public Vector myRole; public Vector myMomentInterval; } </code></pre> <p><strong>Description.java</strong></p> <pre><code> import java.util.Vector; public class Description { public Vector myPartyPlaceThing; public Vector myCommonInterface; } </code></pre> <p><strong>PartyPlaceThing.java</strong></p> <pre><code> import java.util.Vector; public class PartyPlaceThing { public Vector myRole; public Description myDescription; public Vector myCommonInterface; } </code></pre> <p><strong>Role.java</strong></p> <pre><code> import java.util.Vector; public class Role { public Vector myMomentInterval; public PartyPlaceThing myPartyPlaceThing; public Vector myCommonInterface; } </code></pre> <p><strong>MomentInterval.java</strong></p> <pre><code> import java.util.Vector; public class MomentInterval { public Role myRole; public Vector myMIDetail; public Vector myCommonInterface; } </code></pre> <p><strong>MIDetail.java</strong></p> <pre><code> public class MIDetail { public MomentInterval myMomentInterval; } </code></pre> <p>Now I want to persist the data in these classes in a database [mysql] where "<strong>tableName in DB == className in java</strong>"</p> <p>I know that such attributes will be included as foreign keys but the <strong>problem</strong> is how will the tables basically be created?</p> <p><strong>e.g</strong> the table description would contain partyplacething as foreign key. This means that table of partyplacething <strong>must</strong> exist before table of description can be created. similar is the case with other classes thus creating a deadlock cuz I need tables of "role and description" before I can create partyplacething and so on. the only table that I can successfully create is of MIDetail (right now cuz it is independent).</p> <p><strong>How should I change my model so that my original relationships are maintained and I can successfully persist data in a database???</strong></p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAriful Islam
    1. USArifah Azhar
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to persist such data in mysql
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POHow to persist such data in mysql
      1. This table or related slice is empty.
      1. VTDownMod
    1. CO:) no its not homework. i m working on tool development. just the database phase is left. and after evaluation of my classes i found out that i have this problem with the relationship in classes. i was lost on how to proceed. i looked on internet [2 days] and i just could not find a "spot on" for what i m looking for. that is y i thought about asking here.
      singulars
      1. POHow to persist such data in mysql
      1. USArifah Azhar
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload