對(duì)one-to-many,對(duì)school set的改動(dòng),會(huì)改變表SCHOOL中的數(shù)據(jù): #SCHOOL_ID是school表的主鍵,SCHOOL_ADDRESS是school表中的地址欄位 #表School的外鍵為SCHOOL_ADDRESS,它對(duì)應(yīng)表Address的主鍵ADDRESS_ID (11)insert oneSchool———— sqlInsertRowString: update SCHOOL set SCHOOL_ADDRESS=? where SCHOOL_ID=? (僅僅update foreign-key的值。) (22)delete oneSchool———— sqlDeleteRowString: update SCHOOL set SCHOOL_ADDRESS=null where SCHOOL_ID=? (很奇怪,把foreign-key設(shè)置為null不知道有什么實(shí)際意義?) (33)delete 屬于某一address的所有school ————sqlDeleteString: update SCHOOL set SCHOOL_ADDRESS=null where SCHOOL_ADDRESS=? (44)update ————sqlUpdateRowString:"", no need
對(duì)many-to-many,對(duì)school set的改動(dòng),會(huì)改變關(guān)系表ADDRESS_SCHOOL中的數(shù)據(jù): #“地區(qū)————學(xué)校”的關(guān)系為多對(duì)多的關(guān)系有點(diǎn)牽強(qiáng),只是為了方便與上面的one-to-many作比較 #假設(shè)有一個(gè)關(guān)系表ADDRESS_SCHOOL,有兩個(gè)字段ADDRESS_ID, SCHOOL_ID, #這兩個(gè)字段分別對(duì)應(yīng)ADDRESS和SCHOOL兩表的key (11)insert的SQL語句為: insert into ADDRESS_SCHOOL(ADDRESS_ID, SCHOOL_ID) values(?,?) (22)delete的SQL語句為: delete from ADDRESS_SCHOOL where ADDRESS_ID=? AND SCHOOL_ID=? (33)delete all的SQL語句為: delete from ADDRESS_SCHOOL where ADDRESS_ID=? (44)update的sql語句為 ————sqlUpdateRowString: update ADDRESS_SCHOOL set ADDRESS_ID=? where ADDRESS_ID=? AND SCHOOL_ID=?