Hibernate Gossip: 複合主鍵(一)
基於業務需求,您會需要使用兩個欄位來作複合主鍵,例如在User資料表中,您也許會使用"name"與"phone"兩個欄位來定義複合主鍵。 假設您這麼建立User表格:
CREATE TABLE user ( name VARCHAR(100) NOT NULL, phone VARCHAR(50) NOT NULL, age INT, PRIMARY KEY(name, phone) ); 在表格中,"name"與"age"被定義為複合主鍵,在映射時,您可以讓User類別直接帶有"name"與"age"這兩個屬性,而 Hibernate要求複合主鍵類別要實作Serializable介面,並定義equals()與hashCode()方法:
package onlyfun.caterpillar; equals()與hashCode()方法被用作兩筆不同資料的識別依據;接著您可以使用<composite-id>在映射文件中定義複合主鍵與物件的屬性對應:
<?xml version="1.0" encoding="utf-8"?> 在儲存資料方面,複合主鍵的儲存沒什麼區別,現在的問題在於如何依據複合主鍵來查詢資料,例如使用load()方法,您可以創建一個User實例,並設定複合主鍵對應的屬性,接著再透過load()查詢對應的資料,例如:
User user = new User(); user.setName("bush"); user.setPhone("0970123456"); Session session = sessionFactory.openSession(); // 以實例設定複合主鍵並載入對應的資料 user = (User) session.load(User.class, user); System.out.println(user.getAge() + "/t" + user.getName() + "/t" + user.getPhone()); session.close(); |
<script type="text/javascript">
</script> <script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript"> </script> name="google_ads_frame" marginwidth="0" marginheight="0" src="http://pagead2.googlesyndication.com/pagead/ads?client=ca-pub-9750319131714390&dt=1188792936546&lmt=1175337897&format=160x600_as&output=html&correlator=1188792936546&url=http%3A%2F%2Fcaterpillar.onlyfun.net%2FGossip%2FHibernateGossip%2FCompactPK1.html&ad_type=text_image&ref=http%3A%2F%2Fcaterpillar.onlyfun.net%2FGossip%2FHibernateGossip%2FHibernateGossip.html&cc=25&ga_vid=1129055167.1188554514&ga_sid=1188792105&ga_hid=514416939&ga_fc=true&flash=9&u_h=768&u_w=1024&u_ah=740&u_aw=1024&u_cd=32&u_tz=480&u_his=3&u_java=true&u_nplug=17&u_nmime=57" frameborder="0" width="160" scrolling="no" height="600" allowtransparency="allowtransparency"> <script type="text/javascript"> </script> <script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript"> </script> name="google_ads_frame" marginwidth="0" marginheight="0" src="http://pagead2.googlesyndication.com/pagead/ads?client=ca-pub-9750319131714390&dt=1188792936750&lmt=1175337897&prev_fmts=160x600_as&format=160x600_as&output=html&correlator=1188792936546&url=http%3A%2F%2Fcaterpillar.onlyfun.net%2FGossip%2FHibernateGossip%2FCompactPK1.html&ad_type=text_image&ref=http%3A%2F%2Fcaterpillar.onlyfun.net%2FGossip%2FHibernateGossip%2FHibernateGossip.html&cc=25&ga_vid=1129055167.1188554514&ga_sid=1188792105&ga_hid=514416939&ga_fc=true&flash=9&u_h=768&u_w=1024&u_ah=740&u_aw=1024&u_cd=32&u_tz=480&u_his=3&u_java=true&u_nplug=17&u_nmime=57" frameborder="0" width="160" scrolling="no" height="600" allowtransparency="allowtransparency"> |