java - How to insert correctly data on MySQL db through JPA when tables are linked with OneToOne relationship -

-

i have doubt , consequently don't know how proceed correctly. have 3 different tables in figure below. i'm using jpa. here code generated automatically netbeans shows entities. question should persist database? if put user, have automatically persisted phone numbers , client? i'm pretty confused

here code

usercredential user = new usercredential();         user.setusername(username);         user.setpassword(utilbean.hashpassword(password));         user.setemail(email);          client client = new client();         client.setusercredential(user);         client.setname(name);         client.setsurname(surname);         client.setaddress(address);         client.setcity(city);         client.setzipcode(zipcode);         client.setcountry(country);         client.setfidelitypoints(0);          clientphonenumbers phonenumber = new clientphonenumbers();          phonenumber.setusername(username);          if(homenumber != null || !(homenumber.equals("")))         {             phonenumber.setcountrycodehome(areacodehomenumber);             phonenumber.sethome(homenumber);         }          phonenumber.setcountrycodemobile(areacodemobilenumber);         phonenumber.setmobile(mobilenumber);          client.setclientphonenumbers(phonenumber);           em.persist(user);

enter image description here

user credential

@entity @table(name = "user_credential") @namedqueries( {     @namedquery(name = "usercredential.findall", query = "select u usercredential u") }) public class usercredential implements serializable {     private static final long serialversionuid = 1l;     @id     @basic(optional = false)     @notnull     @size(min = 1, max = 16)     @column(name = "username")     private string username;     // @pattern(regexp="[a-z0-9!#$%&'*+/=?^_`{|}~-]+(?:\\.[a-z0-9!#$%&'*+/=?^_`{|}~-]+)*@(?:[a-z0-9](?:[a-z0-9-]*[a-z0-9])?\\.)+[a-z0-9](?:[a-z0-9-]*[a-z0-9])?", message="invalid email")//if field contains email address consider using annotation enforce field validation     @basic(optional = false)     @notnull     @size(min = 1, max = 255)     @column(name = "email")     private string email;     @basic(optional = false)     @notnull     @size(min = 1, max = 255)     @column(name = "password")     private string password;     @basic(optional = false)     @notnull     @size(min = 1, max = 45)     @column(name = "groupname")     private string groupname;     @column(name = "create_time")     @temporal(temporaltype.timestamp)     private date createtime;     @onetoone(cascade = cascadetype.all, mappedby = "usercredential")     private client client;      public usercredential()     {     }      public usercredential(string username)     {         this.username = username;     }      public usercredential(string username, string email, string password, string groupname)     {         this.username = username;         this.email = email;         this.password = password;         this.groupname = groupname;     }      public string getusername()     {         return username;     }      public void setusername(string username)     {         this.username = username;     }      public string getemail()     {         return email;     }      public void setemail(string email)     {         this.email = email;     }      public string getpassword()     {         return password;     }      public void setpassword(string password)     {         this.password = password;     }      public string getgroupname()     {         return groupname;     }      public void setgroupname(string groupname)     {         this.groupname = groupname;     }      public date getcreatetime()     {         return createtime;     }      public void setcreatetime(date createtime)     {         this.createtime = createtime;     }      public client getclient()     {         return client;     }      public void setclient(client client)     {         this.client = client;     }      @override     public int hashcode()     {         int hash = 0;         hash += (username != null ? username.hashcode() : 0);         return hash;     }      @override     public boolean equals(object object)     {         // todo: warning - method won't work in case id fields not set         if (!(object instanceof usercredential))         {             return false;         }         usercredential other = (usercredential) object;         if ((this.username == null && other.username != null) || (this.username != null && !this.username.equals(other.username)))         {             return false;         }         return true;     }      @override     public string tostring()     {         return "it.volaconoi.entity.usercredential[ username=" + username + " ]";     }  }

client

@entity @table(name = "client") @namedqueries( {     @namedquery(name = "client.findall", query = "select c client c") }) public class client implements serializable {     private static final long serialversionuid = 1l;     @id     @basic(optional = false)     @notnull     @size(min = 1, max = 16)     @column(name = "username")     private string username;     @basic(optional = false)     @notnull     @size(min = 1, max = 45)     @column(name = "name")     private string name;     @basic(optional = false)     @notnull     @size(min = 1, max = 45)     @column(name = "surname")     private string surname;     @basic(optional = false)     @notnull     @size(min = 1, max = 45)     @column(name = "address")     private string address;     @basic(optional = false)     @notnull     @size(min = 1, max = 45)     @column(name = "city")     private string city;     @basic(optional = false)     @notnull     @size(min = 1, max = 10)     @column(name = "zip_code")     private string zipcode;     @basic(optional = false)     @notnull     @size(min = 1, max = 45)     @column(name = "country")     private string country;     @basic(optional = false)     @notnull     @column(name = "fidelity_points")     private int fidelitypoints;     @onetoone(cascade = cascadetype.all, mappedby = "client")     private clientphonenumbers clientphonenumbers;     @joincolumn(name = "username", referencedcolumnname = "username", insertable = false, updatable = false)     @onetoone(optional = false)     private usercredential usercredential;     @onetomany(cascade = cascadetype.all, mappedby = "username")     private collection<reservation> reservationcollection;      public client()     {     }      public client(string username)     {         this.username = username;     }      public client(string username, string name, string surname, string address, string city, string zipcode, string country, int fidelitypoints)     {         this.username = username;         this.name = name;         this.surname = surname;         this.address = address;         this.city = city;         this.zipcode = zipcode;         this.country = country;         this.fidelitypoints = fidelitypoints;     }      public string getusername()     {         return username;     }      public void setusername(string username)     {         this.username = username;     }      public string getname()     {         return name;     }      public void setname(string name)     {         this.name = name;     }      public string getsurname()     {         return surname;     }      public void setsurname(string surname)     {         this.surname = surname;     }      public string getaddress()     {         return address;     }      public void setaddress(string address)     {         this.address = address;     }      public string getcity()     {         return city;     }      public void setcity(string city)     {         this.city = city;     }      public string getzipcode()     {         return zipcode;     }      public void setzipcode(string zipcode)     {         this.zipcode = zipcode;     }      public string getcountry()     {         return country;     }      public void setcountry(string country)     {         this.country = country;     }      public int getfidelitypoints()     {         return fidelitypoints;     }      public void setfidelitypoints(int fidelitypoints)     {         this.fidelitypoints = fidelitypoints;     }      public clientphonenumbers getclientphonenumbers()     {         return clientphonenumbers;     }      public void setclientphonenumbers(clientphonenumbers clientphonenumbers)     {         this.clientphonenumbers = clientphonenumbers;     }      public usercredential getusercredential()     {         return usercredential;     }      public void setusercredential(usercredential usercredential)     {         this.usercredential = usercredential;     }      public collection<reservation> getreservationcollection()     {         return reservationcollection;     }      public void setreservationcollection(collection<reservation> reservationcollection)     {         this.reservationcollection = reservationcollection;     }      @override     public int hashcode()     {         int hash = 0;         hash += (username != null ? username.hashcode() : 0);         return hash;     }      @override     public boolean equals(object object)     {         // todo: warning - method won't work in case id fields not set         if (!(object instanceof client))         {             return false;         }         client other = (client) object;         if ((this.username == null && other.username != null) || (this.username != null && !this.username.equals(other.username)))         {             return false;         }         return true;     }      @override     public string tostring()     {         return "it.volaconoi.entity.client[ username=" + username + " ]";     }  }

** phone numbers **

@entity @table(name = "client_phone_numbers") @namedqueries( {     @namedquery(name = "clientphonenumbers.findall", query = "select c clientphonenumbers c") }) public class clientphonenumbers implements serializable {     private static final long serialversionuid = 1l;     @id     @basic(optional = false)     @notnull     @size(min = 1, max = 16)     @column(name = "username")     private string username;     @size(max = 8)     @column(name = "country_code_home")     private string countrycodehome;     @size(max = 45)     @column(name = "home")     private string home;     @basic(optional = false)     @notnull     @size(min = 1, max = 8)     @column(name = "country_code_mobile")     private string countrycodemobile;     @basic(optional = false)     @notnull     @size(min = 1, max = 45)     @column(name = "mobile")     private string mobile;     @joincolumn(name = "username", referencedcolumnname = "username", insertable = false, updatable = false)     @onetoone(optional = false)     private client client;      public clientphonenumbers()     {     }      public clientphonenumbers(string username)     {         this.username = username;     }      public clientphonenumbers(string username, string countrycodemobile, string mobile)     {         this.username = username;         this.countrycodemobile = countrycodemobile;         this.mobile = mobile;     }      public string getusername()     {         return username;     }      public void setusername(string username)     {         this.username = username;     }      public string getcountrycodehome()     {         return countrycodehome;     }      public void setcountrycodehome(string countrycodehome)     {         this.countrycodehome = countrycodehome;     }      public string gethome()     {         return home;     }      public void sethome(string home)     {         this.home = home;     }      public string getcountrycodemobile()     {         return countrycodemobile;     }      public void setcountrycodemobile(string countrycodemobile)     {         this.countrycodemobile = countrycodemobile;     }      public string getmobile()     {         return mobile;     }      public void setmobile(string mobile)     {         this.mobile = mobile;     }      public client getclient()     {         return client;     }      public void setclient(client client)     {         this.client = client;     }      @override     public int hashcode()     {         int hash = 0;         hash += (username != null ? username.hashcode() : 0);         return hash;     }      @override     public boolean equals(object object)     {         // todo: warning - method won't work in case id fields not set         if (!(object instanceof clientphonenumbers))         {             return false;         }         clientphonenumbers other = (clientphonenumbers) object;         if ((this.username == null && other.username != null) || (this.username != null && !this.username.equals(other.username)))         {             return false;         }         return true;     }      @override     public string tostring()     {         return "it.volaconoi.entity.clientphonenumbers[ username=" + username + " ]";     }  }

if want persist client well, have call user.setclient(client) before calling persist.


Comments

Post a Comment

Popular posts from this blog

C# random value from dictionary and tuple -

-
i have following code, , need random item contains string "region_1" dictionary. public static dictionary<int, tuple<string, int, currencytype>> itemarray = new dictionary<int, tuple<string, int, currencytype>>() { { 0xb3e, new tuple<string, int, currencytype>("region_1", 1500, currencytype.fame) } }; public static int generateitemid(string shopid) { var generateditem = itemarray.elementat(new random().next(0, itemarray.count)).key; } how select this? it's not possible efficiently... first create static random @ class level... prevent non-random behaviour if run query on short period of time... (it's seeded discrete clock) static random rnd = new random(); then: var item = itemarray.values .where(t => t.item1 == shopid) .orderby(_ => rnd.next()) .firstordefault()
Read more

.htaccess - htaccess convert request to clean url and add slash at the end of the url -

-
ok , searched more 4 days , more 20 posts here in stach or in websites without kind of success first here htaccess file rewriteengine on rewriterule ^([a-za-z0-9_]+)/?$ index.php?page=$1 [nc] rewriterule ^([a-za-z0-9_]+)\/([a-za-z0-9_]+)\/?$ index.php?page=$1&action=$2 [nc] i tried many codes 1 worked me can call request , works me www.example.com/pagename => www.example.com/index.php?page=pagename here questions , please provide me information "in detail" understand code well 1- how convert request automatically www.example.com/index.php?page=pagename www.example.com/pagename 2- if tried add slash @ end shows me page without images or styling mean www.example.com/pagename => works www.example.com/pagename/ => doesn't work that's :) for first part need 301 rule this: rewritecond %{the_request} /index\.php\?page=([^\s&]+) [nc] rewriterule ^ /%1? [r=301,l] for second part use absolute path in css, js, images files r...
Read more

cgi - How do I interpret URLs without extension as files rather than missing directories in nginx? -

-
so i'm trying install zoneminder , have run under nginx, has few compiled files need run using fast-cgi. these files lack extension. if file has extension, there no issue , nginx interprets file , return 404 if can't find it. if has no extension, assume it's directory , return 404 when can't find sort of index page. here have now: # security camera domain. server { listen 888; server_name mydomain.com; root /srv/http/zm; # enable php support. include php.conf; location / { index index.html index.htm index.php; } # enable cgi support. location ~ ^/cgi-bin/(.+)$ { alias /srv/cgi-bin/zm/; fastcgi_pass unix:/run/fcgiwrap.sock; fastcgi_param script_filename $document_root/$1; include fastcgi.conf; } } the idea is, under cgi-bin directory goes through fastcgi pipe. any idea on howi can fix this? upon closer inspection, realized zoneminder has 2 cgi sc...
Read more