锘??xml version="1.0" encoding="utf-8" standalone="yes"?>亚洲另类无码专区丝袜,精品亚洲永久免费精品,精品国产亚洲男女在线线电影 http://www.tkk7.com/Kira-2006/-浠呬粎鏄竴闃甸涔熺艦浜?鍋忓亸鏄繖鏍鋒案鎭? 浠呬粎鏄竴鍦烘ⅵ涔熺艦浜?鍋忓亸鏄姝ょ殑鐪熷疄,zh-cnMon, 12 May 2025 14:42:19 GMTMon, 12 May 2025 14:42:19 GMT60娣卞叆嫻呭嚭Hibernate璇諱功絎旇--Hibernate甯歌浼樺寲絳栫暐http://www.tkk7.com/Kira-2006/articles/203632.htmlKira-2006Kira-2006Wed, 28 May 2008 12:37:00 GMThttp://www.tkk7.com/Kira-2006/articles/203632.htmlhttp://www.tkk7.com/Kira-2006/comments/203632.htmlhttp://www.tkk7.com/Kira-2006/articles/203632.html#Feedback0http://www.tkk7.com/Kira-2006/comments/commentRss/203632.htmlhttp://www.tkk7.com/Kira-2006/services/trackbacks/203632.html 1. 鍦ㄥ厑璁哥殑鎯呭喌涓嬶紝閫夌敤鏈鏂扮増鏈殑Hibernate鐨勫彂琛岀増銆?br /> 2. 鍒跺畾鍚堢悊鐨勭紦瀛樼瓥鐣ャ?br /> 3. 閲囩敤鍚堢悊鐨凷ession綆$悊鏈哄埗銆?br /> 4. 灝介噺浣跨敤寤惰繜鍔犺澆鐗規(guī)с?br /> 5. 璁懼畾鍚堢悊鐨勬壒澶勭悊鍙傛暟(batch_size)銆?br /> 6. 濡傛灉鍙兘錛岄夌敤UUID浣滀負涓婚敭鐢熸垚鍣ㄣ?br /> 7. 濡傛灉鍙兘錛岄夌敤鍩轟簬version鐨勪箰瑙傞攣絳栫暐鏇夸唬鎮(zhèn)茶閿併?br /> 8. 寮鍙戣繃紼嬩腑錛屾墦寮Hibernate鐨凷QL鏃ュ織杈撳嚭錛岄氳繃瑙傚療Hibernate鐢熸垚鐨剆ql璇彞榪涗竴姝ヤ簡瑙e疄鐜板師鐞嗭紝浠庤屾寚瀹氭洿濂界殑瀹炵幇絳栫暐銆?

Kira-2006 2008-05-28 20:37 鍙戣〃璇勮
]]>
娣卞叆嫻呭嚭Hibernate瀛︿範(fàn)絎旇--Criteria Queryhttp://www.tkk7.com/Kira-2006/articles/199774.htmlKira-2006Kira-2006Sat, 10 May 2008 14:59:00 GMThttp://www.tkk7.com/Kira-2006/articles/199774.htmlhttp://www.tkk7.com/Kira-2006/comments/199774.htmlhttp://www.tkk7.com/Kira-2006/articles/199774.html#Feedback0http://www.tkk7.com/Kira-2006/comments/commentRss/199774.htmlhttp://www.tkk7.com/Kira-2006/services/trackbacks/199774.html
Criteria criteria=session.createCriteria(TUser.class);
criteria.add(Expression.eq(
"name","Erica"));
criteria.add(Expression.eq(
"sex",new Integer(1));
榪欓噷鐨刢riteria瀹炰緥鏈川涓婃槸瀵筍QL“select * from t_user where name='Erica' and sex=1”鐨勫皝瑁呫?br /> Hibernate鍦ㄨ繍琛屾湡浼氭牴鎹瓹riteria涓寚瀹氱殑鏌ヨ鏉′歡鐢熸垚鐩稿簲鐨凷QL璇彞銆?br />
Criteria鏌ヨ琛ㄨ揪寮?br />     Criteria鏈韓鍙槸涓涓鍣紝鍏蜂綋鐨勬煡璇㈡潯浠惰閫氳繃Criteria.add鏂規(guī)硶娣誨姞鍒癈riteria瀹炰緥涓?br />
鏂規(guī)硶 鎻忚堪
Expression.eq

瀵瑰簲SQL “field=value”琛ㄨ揪寮?/p>

濡傦細Expression.eq("name","Erica")

Expression.allEq 鍙傛暟涓轟竴涓狹ap瀵硅薄錛屽叾涓寘鍚簡澶氫釜灞炴?鍊煎搴斿叧緋匯傜浉褰撲簬澶氫釜Expression.eq鍏崇郴鐨勫彔鍔?/td>
Expression.gt 瀵瑰簲SQL“field>value”琛ㄨ揪寮?/td>
Expression.ge 瀵瑰簲SQL“field>=value”琛ㄨ揪寮?/td>
Expression.lt 瀵瑰簲SQL“field<value”琛ㄨ揪寮?/td>
Expression.le 瀵瑰簲SQL“field<=value”琛ㄨ揪寮?/td>
Expression.between

瀵瑰簲SQL“between”琛ㄨ揪寮?/p>

濡傦細Expression.between("age",new Integer(13),new Integer(50));

Expression.like 瀵瑰簲SQL"field like valule"琛ㄨ揪寮?/td>
Expression.in 瀵瑰簲SQL“field in...”琛ㄨ揪寮?/td>
Expression.eqproperty 鐢ㄤ簬姣旇緝涓や釜灞炴т箣闂寸殑鍊鹼紝瀵瑰簲SQL“field>field”
Expression.gtProperty 鐢ㄤ簬姣旇緝涓や釜灞炴т箣闂寸殑鍊鹼紝瀵瑰簲SQL“field>=field”
Expression.ltProperty 鐢ㄤ簬姣旇緝涓や釜灞炴т箣闂寸殑鍊鹼紝瀵瑰簲SQL"field<field"
Expression.leProperty 鐢ㄤ簬姣旇緝涓や釜灞炴т箣闂寸殑鍊鹼紝瀵瑰簲SQL"field<=field"
Expression.and

and鍏崇郴緇勫悎錛屽錛?/p>

Expression.add(Expression.eq("name","Erica"),Expression.add("sex",new Integer(1)))

Expression.or

or鍏崇郴緇勫悎錛屽錛?/p>

Expression.or(Expression.eq("name","Erica"),Expression.add("sex",new Integer(1)))

Expression.sql

浣滀負琛ュ厖錛屾湰鏂規(guī)硶鎻愪緵浜嗗師鐢烻QL璇硶鐨勬敮鎸侊紝鎴戜滑鍙互閫氳繃榪欎釜鏂規(guī)硶鐩存帴閫氳繃SQL璇彞闄愬畾鏌ヨ鏉′歡

涓嬮潰鐨勪唬鐮佽繑鍥炴墍鏈夊悕縐頒互"Erica"鍏跺疄鐨勮褰曪細
Expression.sql("lower({alias}.name) like lower(?)","Erica%",Hibernate.STRING);
鍏朵腑鐨?{alias}"灝咹ibernate鍦ㄨ繍琛屾湡浣跨敤褰撳墠鍏寵仈鐨凱OJO鍒悕鏇挎崲


鍦℉ibernate3涓紝寮曞叆浜哛estrictions綾諱綔涓篍xpression鐨勬浛浠c?br />
紺轟緥鏌ヨ
    Example綾誨疄鐜頒簡Criteria鎺ュ彛錛屽悓鏍鳳紝瀹冧篃鍙互鐢ㄤ綔Criteria鐨勬煡璇㈡潯浠躲侲xample鐨勪綔鐢ㄦ槸錛氭牴鎹凡鏈夊璞★紝鏌ユ壘灞炴т笌涔嬬浉絎︾殑鍏朵粬瀵硅薄銆?br />
Criteria criteria=session.CreateCriteria(TUser.class);
TUser exampleUser
=new TUser();
exapleUser.getName(
"Erica");
criteria.add(Example.create(exampleUser));

List
<TUser> list=criteria.list();

for(TUser user:list){
System.out.println(user.getName());
}
鏂板緩涓涓猅User瀵硅薄exampleUser錛屽茍浣滀負鑼冩湰錛屾煡璇㈡墍鏈塶ame灞炴т笌涔嬬浉鍚岀殑璁板綍銆?br />
澶嶅悎鏌ヨ
Criteria criteria=session.createCriteria(TUser.class);
Criteria addrCriteria=criteria.createCriteria("addresses");
addrCriteria.add(Expression.like("addresses","%shanghai%"));


List
<TUser> list = criteria.list();
for(TUser user:list){
    System.out.println(user.getName());
    Set
<TAddress> addrSet=user.getAddresses();
    
for(TAddress addr:addrSet){
        System.out.println(addr.getAddress());
    }

}
綰㈣壊閮ㄥ垎灝辨槸鎴戜滑鏂板鐨勫鍚堟煡璇㈡潯浠訛紝鍙互鐪嬪埌錛屾垜浠彲浠ラ氳繃Criteria.createCriteria鏂規(guī)硶鍦ㄥ師鏈塁riteria瀵硅薄鐨勫熀紜涓婃瀯寤哄鍚堟煡璇€?br />
DetachedCriteria
   Hibernate2涓紝Criteria鐢熷懡鍛ㄦ湡浣嶄簬鍏跺涓籗ession鐢熷懡鍛ㄦ湡涓紝涔熷氨鏄錛岀敱鏌愪釜session鍒涘緩鐨凜riteria瀹炰緥錛屼竴鏃ession閿姣侊紝閭d箞姝riteria瀹炰緥涔熼殢涔嬪け鏁堛?br />     Hibernate3涓紩鍏ヤ簡DetachedCriteria錛孌etachedCriteria鍙互鑴辯session瀹炰緥鐙珛瀛樺湪錛岃繖鏍鳳紝鎴戜滑灝卞彲浠ュ皢鏌愪簺閫氱敤鐨凜riteria鏌ヨ鏉′歡榪涜鎶界錛屾瘡嬈′嬌鐢ㄦ椂鍐嶄笌褰撳墠session瀹炰緥緇戝畾浠ヨ幏寰楁洿濂界殑浠g爜閲嶇敤鏁堟灉銆?br />
DetachedCriteria deCriteria=DetachedCriteria.forClass(TUser.class);
deCriteria.add(Expression.eq(
"name","Erica"));
deCriteria.add(Expression.eq(
"sex",new Integer(1)));

Criteria criteria=deCriteria.getExecutableCriteria(session);
List<TUser> list=criteria.list();
for(TUser user:list){
    System.out.println(user.getName());
}
DetachedCriteria鐨勭敓瀛樺懆鏈熶笌session瀹炰緥鏃犲叧錛屾垜浠彲浠ョ嫭绔嬪垱寤篋etachedCriteria瀹炰緥錛屽茍鍦ㄩ渶瑕佷嬌鐢ㄦ椂涓巗ession鐩哥粦瀹氾紝浠庤岃幏寰楄繍琛屾湡Criteria瀹炰緥銆傝繖鏍鳳紝鎴戜滑灝卞彲浠ュ皢鏌ヨ閫昏緫鍜孋riteria瀹炰緥鍒嗙錛屼互鑾峰緱鏈澶у寲浠g爜鐨勯噸鐢ㄦ晥鏋溿?br />     DetachedCriteria涔熷彲浠ョ敤浜庡瓙鏌ヨ琛ㄨ揪錛?br />
DetachedCriteria aveAge=DetachedCriteria.forClass(TUser.class);
avgAge.setProjection(Projections.avg(
"age"));

Criteria criteria
=session.createCriteria(TUser.class);
criteria.add(Subqueries.propertyGT("age",avgAge));

閫氳繃Subqueries鎴戜滑鍙互灝咲etachedCriteria綰沖叆鏌ヨ琛ㄨ揪寮忥紝鍙嶆槧鍦⊿QL涓婂垯鏄竴涓吀鍨嬬殑瀛愭煡璇㈣鍙ャ備笂渚嬬敓鎴愮殑SQL璇彞澶ц嚧濡傦細select ... from T_User where age > (select avg(age) from T_User)

Criteria楂樼駭鐗規(guī)?br />     闄愬畾榪斿洖鐨勮褰曡寖鍥?/strong>
        閫氳繃criteria.setFirstResult/setMaxResults鏂規(guī)硶鍙互闄愬埗涓嬈℃煡璇㈣繑鍥炵殑璁板綍鑼冨洿錛?br />
Criteria criteria=session.createCriteria(TUser.class);
//闄愬畾鏌ヨ榪斿洖媯绱㈢粨鏋滀腑錛屼粠100鏉$粨鏋滃紑濮嬬殑20鏉¤褰?/span>
criteria.setFirstResult(100);
criteria.setMaxResults(
20);
        璁板綍鎺掑簭錛?br />
//
//
Criteria criteria=session.createCriteria(TUser.class);
criteria.add(Expression.eq(
"groupId",new Integer(2)));

criteria.addOrder(Order.asc(
"name"));
criteria.addOrder(Order.desc(
"groupId"));

    鍒嗙粍涓庣粺璁?br />         鍦℉ibernate3涓紝鎴戜滑榪樺彲浠ラ氳繃Criteria瀹屾垚鍒嗙粍鍜岀粺璁°傚垎緇勩佺粺璁¤〃杈懼紡鐢盚ibernate3鏂板紩鍏ョ殑Projections Class榪涜灝佽銆?br />
Criteria criteria=session.createCriteria(TUser.class);
criteria.setProjection(Projections.groupProperty("age"));


List
<TUser> list=criteria.list();
for(TUser user:list){
    System.out.println(user);
}

涓婁緥瀵瑰綋鍓嶇殑TUser璁板綍鎸夌収騫撮緞榪涜鍒嗙粍銆傞氳繃Projections.groupProperty鏂規(guī)硶錛屾垜浠寚瀹氫簡鐢ㄤ簬鍒嗙粍鐨勭洰鏍囧睘鎬?#8220;age”銆傜敓鎴愮殑SQL璇彞錛歴elect this.age as y0_ from T_User this_group by this_.age銆?br />     鍙﹀錛屽浜庡鏉′歡緇勫悎鐨勭粺璁°佸垎緇勫姛鑳斤紝鎴戜滑鍙互鍊熷姪ProjectionList瀹屾垚錛屼笅闈㈢殑渚嬪瓙涓紝鎴戜滑緇熻浜嗗悇涓勾榫勫眰嬈′腑鐨勭敤鎴鋒暟閲忥細

ProjectionList projectionlist=Projections.ProjectionList();
projectionList.add(Projections.groupProperty(
"age"));
projectionList.add9Projections.rowCount());

Criteria criteria
=session.createCriteria(TUser.class);
criteria.setProjection(projectionList);

 

 



Kira-2006 2008-05-10 22:59 鍙戣〃璇勮
]]>
娣卞叆嫻呭嚭Hibernate瀛︿範(fàn)絎旇--鏁版嵁鍏寵仈http://www.tkk7.com/Kira-2006/articles/199736.htmlKira-2006Kira-2006Sat, 10 May 2008 12:08:00 GMThttp://www.tkk7.com/Kira-2006/articles/199736.htmlhttp://www.tkk7.com/Kira-2006/comments/199736.htmlhttp://www.tkk7.com/Kira-2006/articles/199736.html#Feedback0http://www.tkk7.com/Kira-2006/comments/commentRss/199736.htmlhttp://www.tkk7.com/Kira-2006/services/trackbacks/199736.html涓瀵逛竴鍏寵仈
    涓婚敭鍏寵仈錛?/strong>鍗充袱寮犺〃閫氳繃涓婚敭褰㈡垚涓瀵逛竴鏄犲皠鍏崇郴銆?/p>     鐢ㄦ埛TUser涓庢姢鐓Passport鍏寵仈
    TUer.hbm.xml
    
<hibernate-mapping>
<class
    
name="TUser"
    table
="T_User">
    
    
<one-to-one 
        
name="passport"
        class
="TPassport"
        cascade
="all"
        outer-join
="true"/>
    
</class>
</hibernate-mapping>
cascade="all"琛ㄧず綰ц仈鍏崇郴璁劇疆涓?#8220;all”錛屽嵆鏃犺涓葷┖鎴挎墽琛屼換浣曟搷浣滐紝閮戒細鍏寵仈綾繪墽琛岀浉鍚岀殑鎿嶄綔銆?br />
    TPassport.hbm.xml
<hibernate-mapping>
<class
    
name="TPassport"
    table
="T_Passport">
    
<one-to-one
        
name="user"
        class
="TUser"
        constrain
="true">
    .
</class>
</hibernate-mapping>

    
constrain蹇呴』璁懼畾涓?#8220;true”錛屼互鍛婄煡Hibernate褰撳墠涓婚敭涓婂瓨鍦ㄤ竴涓害鏉熴?br />    
    嫻嬭瘯浠g爜錛?br />
TUser user = new TUser();
user.setAge(
new Integer(20));
user.setName(
"Carin");

TPassport passport 
= new TPassport();
passport.setSerial(
"PCN759386");
passport.setExpiry(
new Integer(20080101));

//鐩鎬簰璁劇疆鍏寵仈
passport.setUser(user);
user.setPassport(passport);

Transaction tx 
= sessioin.beginTransaction();
//鐢變簬TUser綾葷殑one-to-one鑺傜偣琚緗垚
//cascade=“all”鍏跺叧鑱旂殑passport瀵硅薄灝嗚綰ц仈淇濆瓨
session.save(user);

tx.commit();
    浠ヤ笅浠g爜瀹屾垚鍏寵仈瀵硅薄鐨勮鍙栵細
TUser user=(TUser)Hibernate.load(TUser.class,new Integer(15));
System.out.println(
"User name=>"+user.getName());
System.out.println(
"Passport Serial=>"+user.getPassport().getSerial());
    鎺у埗鍙拌緭鍑猴細
Hibernate:select tuser0_.id as id1_,
from T_USER tuser0_
left outer join
T_PASSPORT tpassport1_ on tuser0_.id
=tpassport1_.id
where tuser0_.id
=?
User name
=>Carin
Passport Serial
=>PCN759386
Hibernate閫氳繃left outer join灝員_User琛ㄥ強鍏跺叧鑱旂殑T_Passport琛ㄥ悓鏃惰鍏ワ紝鍥犱負姝ゆ椂灝唎ut-join=“true”銆傝嫢璁劇疆涓篺alse錛屽垯浼氬垎寮璇誨彇涓や釜琛ㄣ?br />
涓瀵瑰鍏寵仈
    鐢ㄦ埛TUser鍜屽湴鍧TAddress鐨勪竴瀵瑰鍏寵仈銆?br />     鍗曞悜涓瀵瑰鍏寵仈
        涓繪帶鏂筎User鐨勬槧灝勯厤緗細
<hibernate-mapping>
<class
    
name="TUser"
    table
="t_user"
    dynamic-update
="true"
    dynamic-insert
="true">
.
    
<set
        
name="address"
        table
="t_address"
        cascade
="all"
        order-by
="zipcode asc">
        
<key column="user_id"/>
        
<one-to-many class="TAddress">
    
</set>

</class>
</hibernate>
琚姩鏂筎Address鐨勮褰曠敱Hibernate璐熻矗璇誨彇錛屼箣鍚庡瓨鏀懼湪涓繪帶鏂筎User鎸囧畾鐨凜ollection綾誨瀷灞炴т腑銆?br /> 鍗曞悜涓瀵瑰鐨勫疄鐜版瘮杈冪畝鍗曪紝浣嗘槸瀛樺湪涓涓棶棰橈紝鐢變簬鏄崟鍚戝叧鑱旓紝涓轟簡淇濇寔鍏寵仈鍏崇郴錛屾垜浠彧鑳介氳繃涓繪帶鏂瑰琚姩鏂硅繘琛岀駭鑱旀洿鏂般傚鏋滆鍏寵仈鏂圭殑鍏寵仈瀛楁涓?#8220;NOT NULL”錛屽綋Hibernate鍒涘緩鎴栬呮洿鏂版椂錛屽彲鑳藉嚭鐜扮害鏉熻繚渚嬨?br />
鍙屽悜澶氬涓鍏寵仈
    瀹為檯涓婃槸“涓瀵瑰”涓?#8220;澶氬涓”鍏寵仈鐨勭粍鍚堛備篃灝辨槸璇存垜浠繀欏誨湪涓繪帶鏂歸厤緗竴瀵瑰鍏崇郴鐨勫熀紜涓婏紝鍦ㄨ鎺ф柟閰嶇疆涓庡叾瀵瑰簲鐨勫瀵逛竴鍏寵仈銆?br />     TUser.hbm.xml
<hibernate-mapping>
<class
    
name="TUser"
    table
="t_user"
    dynamic-update
="true"
    dynamic-insert
="true">
.
    
<set
        
name="address"
        table
="t_address"
        lazy
="false"
        inverse
="true"
        cascade
="all"
        sort
="unsorted"
        order-by
="zipcode asc">
        
<key column="user_id"/>
        
<one-to-many class="TAddress"/>
    
</set>
.
</class>
</hibernate>
inverse="true"錛孴User涓嶅湪浣滀負涓繪帶鏂癸紝鑰屾槸灝嗗叧鑱斿叧緋葷殑緇存姢宸ヤ綔浜ょ粰鍏寵仈瀵硅薄TAddress鏉ュ仛銆?br /> 鍦╫ne-to-many鍏崇郴涓紝灝唌any涓鏂硅緗負涓繪帶鏂癸紙inverse=“true”錛夊皢鏈夊姪浜庢ц兘鐨勬敼鍠勩?br />     TAddress.hbm.xml
<hibernat-mapping>
<class
    
name="TAddress"
    table
="t_address"
    dynamic-update
="false"
    dynamic-insert
="false">
.
    
<many-to-one
        
name="user"
        class
="TUser"
        cascade
="none"
        outer-join
="auto"
        update
="true"
        insert
="true"
        access
="property"
        column
="user_id"
        not-null
="true"/>
.
</class>
</hibernate-mapping>

澶氬澶氬叧鑱?br /> 闇瑕佸熷姪涓棿琛ㄦ潵瀹屾垚澶氬澶氭槧灝勪俊鎭殑淇濆瓨銆?br />     鐢變簬澶氬澶氬叧鑱旂殑鎬ц兘涓嶄匠錛堢敱浜庡紩鍏ヤ簡涓棿琛紝涓嬈¤鍙栨搷浣滈渶瑕佸弽澶嶅嬈℃煡璇級錛屽洜姝ゅ湪璁捐涓簲璇ラ伩鍏嶅ぇ閲忎嬌鐢ㄣ傚悓鏃訛紝鍦ㄥ瀵瑰鍏崇郴涓紝搴旀牴鎹儏鍐碉紝閲囧彇寤惰繜鍔犺澆鏈哄埗鏉ラ伩鍏嶆棤璋撶殑鎬ц兘寮閿銆?br />     TGroup涓嶵Role鐨勫瀵瑰鍏寵仈錛?br />     TGroup.hbm.xml錛?br />
<hibernate-mapping>
<class
    
name="TGroup"
    table
="t_group"
    dynamic-update
="false"
    dynamic-insert
="false">
.
    
<set
        
name="roles"
        table
="t_group_role"
        lazy
="false"
        inverse
="false"
        cascade
="save-update">
        
<key column="group_id"/>
        
<many-to-many
            
class="TRole"
            column
="role_id"/>
    
</set>
.
</class>
</hibernate>
t_group_role涓簍_group涓巘_role涔嬮棿鐨勬槧灝勮〃錛屽畠淇濆瓨浜唃roup鍜宺ole涔嬮棿鐨勬槧灝勫叧緋匯?br /> cascade=“save-update”錛屽浜庡瀵瑰閫昏緫鑰岃█錛屽緢灝戝嚭鐜板垹闄や竴鏂歸渶瑕佺駭鑱斿垹闄ゆ墍鏈夊叧鑱旀暟鎹殑鎯呭喌錛屽鍒犻櫎涓涓猤roup錛屼竴鑸笉浼氬垹闄ゅ叾涓寘鍚殑Role銆?br /> column=“group_id”鏄犲皠琛ㄤ腑瀵逛簬t_group琛ㄨ褰曠殑鏍囪瘑瀛楁銆?br />  
    TRole.hbm.xml錛?br />
<hibernate-mapping>
<class
    
name="TRole"
    table
="t_role"
    dynamic-update
="false"
    dynamic-insert
="false">
.
    
<set
        
name="groups"
        table
="t_group_role"
        lazy
="false"
        inverse
="true"
        cascade
="save-update"
        sort
="unsorted">
        
<key column="role_id"/>
        
<many-to-many 
            
class="TGroup"
            column
="group_id"
            outer-join
="auto"/>
    
</set>
.
</class>
</hibernate>
澶氬澶氬叧緋諱腑錛岀敱浜庡叧鑱斿叧緋繪槸涓ゅ紶琛ㄧ浉浜掑紩鐢紝鍥犳鍦ㄤ繚瀛樺叧鑱旂姸鎬佹椂蹇呴』瀵瑰弻鏂瑰悓鏃朵繚瀛樸?br />

Kira-2006 2008-05-10 20:08 鍙戣〃璇勮
]]>
娣卞叆嫻呭嚭Hibernate絎旇--1.2.1鎸佷箙鍖栬璁′笌瑙h?/title><link>http://www.tkk7.com/Kira-2006/articles/197776.html</link><dc:creator>Kira-2006</dc:creator><author>Kira-2006</author><pubDate>Fri, 02 May 2008 11:33:00 GMT</pubDate><guid>http://www.tkk7.com/Kira-2006/articles/197776.html</guid><wfw:comment>http://www.tkk7.com/Kira-2006/comments/197776.html</wfw:comment><comments>http://www.tkk7.com/Kira-2006/articles/197776.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.tkk7.com/Kira-2006/comments/commentRss/197776.html</wfw:commentRss><trackback:ping>http://www.tkk7.com/Kira-2006/services/trackbacks/197776.html</trackback:ping><description><![CDATA[     鎽樿: 瑙h﹀悎鐨勮璁$洰鏍囷細     1. 搴旂敤灞傝В鑰﹀悎--搴旂敤閫昏緫涓庢暟鎹昏緫鐩稿垎紱匯?    2. 璧勬簮灞傝В鑰﹀悎--閫昏緫緇撴瀯涓庣墿鐞嗙粨鏋勭浉鍒嗙銆? DAO妯″紡錛氬嵆Data Accessor妯″紡鍜孉ctive Domain Object妯″紡銆?    Data Accessor妯″紡...  <a href='http://www.tkk7.com/Kira-2006/articles/197776.html'>闃呰鍏ㄦ枃</a><img src ="http://www.tkk7.com/Kira-2006/aggbug/197776.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.tkk7.com/Kira-2006/" target="_blank">Kira-2006</a> 2008-05-02 19:33 <a href="http://www.tkk7.com/Kira-2006/articles/197776.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>Hibernate---SQL涓璬atetime鐨勬槧灝?/title><link>http://www.tkk7.com/Kira-2006/archive/2008/04/27/196459.html</link><dc:creator>Kira-2006</dc:creator><author>Kira-2006</author><pubDate>Sun, 27 Apr 2008 05:56:00 GMT</pubDate><guid>http://www.tkk7.com/Kira-2006/archive/2008/04/27/196459.html</guid><wfw:comment>http://www.tkk7.com/Kira-2006/comments/196459.html</wfw:comment><comments>http://www.tkk7.com/Kira-2006/archive/2008/04/27/196459.html#Feedback</comments><slash:comments>2</slash:comments><wfw:commentRss>http://www.tkk7.com/Kira-2006/comments/commentRss/196459.html</wfw:commentRss><trackback:ping>http://www.tkk7.com/Kira-2006/services/trackbacks/196459.html</trackback:ping><description><![CDATA[<p>鍦?nbsp;Hibernate瀛︿範(fàn)涓?閫氱敤鐨勮緗椂闂寸殑鏄犲皠濡備笅:</p> <p><property name="addtime" column="add_time"  type="date" not-null="true"></p> <p>濡傛灉鎸夌収涓婇潰鐨勬彁紺?鍒欏彂鐜?鐢熸垚鐨勬椂闂?鍙兘綺劇‘鍒版棩,濡?2007-08-08,鑰屾垜浠渶瑕佺殑鏄?2007-08-08 21:21:34</p> <p>鏈変漢鎻愮ず鍙互鏀規(guī)垚java.sql.Date綾誨瀷,鎴戞病璇曡繃,鍥犱負鍦ㄧ▼搴忎腑鐢ㄧ殑澶氱殑鏄?java.util.Date</p> <p>鍏跺疄,閫氳繃綆鍗曠殑淇敼XML鏂囦歡灝卞彲浠ュ緱鍒?007-08-08 21:21:34</p> <p><property name="addTime"><br />             <column name="add_time"<br />                     sql-type="datetime" not-null="true"/><br />         </property></p> <p>榪欐牱淇敼,搴旇鏇村彲浠ヨ澶у鎵鎺ュ彈</p> <img src ="http://www.tkk7.com/Kira-2006/aggbug/196459.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.tkk7.com/Kira-2006/" target="_blank">Kira-2006</a> 2008-04-27 13:56 <a href="http://www.tkk7.com/Kira-2006/archive/2008/04/27/196459.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>myeclipse鑷甫Struts緙哄皯jar鏂囦歡錛宒atasource閰嶇疆http://www.tkk7.com/Kira-2006/archive/2008/04/26/196313.htmlKira-2006Kira-2006Sat, 26 Apr 2008 10:44:00 GMThttp://www.tkk7.com/Kira-2006/archive/2008/04/26/196313.htmlhttp://www.tkk7.com/Kira-2006/comments/196313.htmlhttp://www.tkk7.com/Kira-2006/archive/2008/04/26/196313.html#Feedback2http://www.tkk7.com/Kira-2006/comments/commentRss/196313.htmlhttp://www.tkk7.com/Kira-2006/services/trackbacks/196313.html 鍦ㄥ簲鐢ㄨ繃紼嬩腑鎯充嬌鐢―BCP鏁版嵁婧愶紝閬囧埌浜嗕竴浜涢棶棰?閰嶇疆鐜:Eclipse3.1,Myeclipse4.02

   鍦╯truts-config.xml鐨勮璁¤鍥句腑鍙互閫夋嫨"鏂板鏁版嵁婧?錛孧yeclipse浼氬脊鍑哄悜瀵肩獥鍙o紝榪欓噷浣跨敤鐨勭己鐪丏ataSource鐨凾ype鏄?org.apache.struts.util.GenericDataSource"錛岃岀敤DBCP鏁版嵁婧愮殑璇濋渶瑕佹敼涓?org.apache.commons.dbcp.BasicDataSource"錛屽綋鐒朵簡閫氳繃Myeclipse鎻掑叆鐨凷truts妗嗘灦涓槸緙哄皯DBCP鐨勫寘鐨勶紝濂藉湪Tomcat鐢ㄧ殑灝辨槸榪欎釜錛屽洜姝よ兘澶熷湪Tomcat\common\lib鐩綍涓壘鍒伴渶瑕佺殑鍖咃細
   1.commons-dbcp-1.2.1.jar
   2.commons-pool-1.2.jar
   鍦ㄥ伐紼嬬殑閰嶇疆璺緞涓姞鍏ュ嵆鍙?涔熷彲浠ヤ粠apache鐨勭綉绔欎笂 涓嬭澆

   Myeclipse鐨勫悜瀵肩獥鍙d腑鍏鋒湁涓浜涘睘鎬ф爮錛屽湪榪欓噷鍙互杈撳叆鏁版嵁婧愪嬌鐢ㄧ殑Driver綾誨悕浠ュ強URL錛屽綋鐒惰繕鏈夌敤鎴峰悕/瀵嗙爜銆?br />    灞炴ф爮鍏ㄩ儴閮介厤緗畬姣曞悗錛屼細鍦╯truts-config.xml鏂囦歡涓姞鍏?lt;data-sources>鏍囩錛岃繖閲岄潰鐨?lt;data-source>鍗蟲槸鍒氬垰鏂板緩鐨勬暟鎹簮閰嶇疆鍙傛暟錛岃繖閲岄渶瑕佹墜宸ユ洿鏀癸細

      1.澧炲姞<data-source>鏍囩鐨則ype灞炴э紝榪欐牱 <data-source type="org.apache.commons.dbcp.BasicDataSource">錛?br />       2.灞炴у悕 driverClass 鏀逛負 dirverClassName錛?br />       3.灞炴у悕 user 鏀逛負username錛屾敞鎰弉鏄皬鍐欑殑錛?br />       4.鍘繪帀灞炴ф爣絳?loginTimeout銆?/p>

   鏀瑰畬浠ュ悗灝卞彲浠ュ惎鍔═omcat鐪嬫晥鏋滀簡



Kira-2006 2008-04-26 18:44 鍙戣〃璇勮
]]>
銆愯漿甯栥?1鏉¢潰鍚戝璞¤璁$殑緇忛獙鍘熷垯-銆奜OD鍚ず褰曘婣rthurJ.Rielhttp://www.tkk7.com/Kira-2006/articles/196308.htmlKira-2006Kira-2006Sat, 26 Apr 2008 10:40:00 GMThttp://www.tkk7.com/Kira-2006/articles/196308.htmlhttp://www.tkk7.com/Kira-2006/comments/196308.htmlhttp://www.tkk7.com/Kira-2006/articles/196308.html#Feedback0http://www.tkk7.com/Kira-2006/comments/commentRss/196308.htmlhttp://www.tkk7.com/Kira-2006/services/trackbacks/196308.html 61鏉¢潰鍚戝璞¤璁$殑緇忛獙鍘熷垯


(1)鎵鏈夋暟鎹兘搴旇闅愯棌鍦ㄦ墍鍦ㄧ殑綾葷殑鍐呴儴銆俻13
 
(2)綾葷殑浣跨敤鑰呭繀欏諱緷璧栫被鐨勫叡鏈夋帴鍙o紝浣嗙被涓嶈兘渚濊禆瀹冪殑浣跨敤鑰呫俻15
 
(3)灝介噺鍑忓皯綾葷殑鍗忚涓殑娑堟伅銆俻16
 
(4)瀹炵幇鎵鏈夌被閮界悊瑙g殑鏈鍩烘湰鍏湁鎺ュ彛[渚嬪錛屾嫹璐濇搷浣?娣辨嫹璐濆拰嫻呮嫹璐?銆佺浉絳夋у垽鏂佹紜緭鍑哄唴瀹廣佷粠ASCII鎻忚堪瑙f瀽絳夌瓑]銆?p16
 
(5)涓嶈鎶婂疄鐜扮粏鑺?渚嬪鏀劇疆鍏辯敤浠g爜鐨勭鏈夊嚱鏁?鏀懼埌綾葷殑鍏湁鎺ュ彛涓俻17
濡傛灉綾葷殑涓や釜鏂規(guī)硶鏈変竴孌靛叕鍏變唬鐮侊紝閭d箞灝卞彲浠ュ垱寤轟竴涓槻姝㈣繖浜涘叕鍏變唬鐮佺殑縐佹湁鍑芥暟銆?/td>
 
(6)涓嶈浠ョ敤鎴鋒棤娉曚嬌鐢ㄦ垨涓嶆劅鍏磋叮鐨勪笢瑗挎壈涔辯被鐨勫叕鏈夋帴鍙c俻17
 
(7)綾諱箣闂村簲璇ラ浂鑰﹀悎錛屾垨鑰呭彧鏈夊鍑鴻﹀悎鍏崇郴銆備篃鍗籌紝涓涓被瑕佷箞鍚屽彟涓涓被姣棤鍏崇郴錛岃涔堝彧浣跨敤鍙︿竴涓被鐨勫叕鏈夋帴鍙d腑鐨勬搷浣溿?p18
 
(8)綾誨簲璇ュ彧琛ㄧず涓涓叧閿娊璞°俻19
鍖呬腑鐨勬墍鏈夌被瀵逛簬鍚屼竴綾繪ц川鐨勫彉鍖栧簲璇ユ槸鍏卞悓灝侀棴鐨勩備竴涓彉鍖栬嫢瀵逛竴涓寘褰卞搷錛屽垯灝嗗鍖呬腑鐨勬墍鏈夌被浜х敓褰卞搷錛岃屽鍏朵粬鐨勫寘涓嶉犳垚浠諱綍褰卞搷 .
 
(9)鎶婄浉鍏崇殑鏁版嵁鍜岃涓洪泦涓斁緗俻19
璁捐鑰呭簲褰撶暀鎰忛偅浜涢氳繃get涔嬬被鎿嶄綔浠庡埆鐨勫璞′腑鑾峰彇鏁版嵁鐨勫璞°傝繖縐嶇被鍨嬬殑琛屼負鏆楃ず鐫榪欐潯緇忛獙鍘熷垯琚繚鍙嶄簡銆?/td>
 
(10)鎶婁笉鐩稿叧鐨勪俊鎭斁鍦ㄥ彟涓涓被涓?涔熷嵆錛氫簰涓嶆矡閫氱殑琛屼負)銆俻19
鏈濈潃紼沖畾鐨勬柟鍚戣繘琛屼緷璧?
 
(11)紜繚浣犱負涔嬪緩妯$殑鎶借薄姒傚康鏄被錛岃屼笉鍙槸瀵硅薄鎵紨鐨勮鑹層俻23
 
(12)鍦ㄦ按騫蟲柟鍚戜笂灝藉彲鑳界粺涓鍦板垎甯冪郴緇熷姛鑳斤紝涔熷嵆錛氭寜鐓ц璁★紝欏跺眰綾誨簲褰撶粺涓鍦板叡浜伐浣溿俻30
 
(13)鍦ㄤ綘鐨勭郴緇熶腑涓嶈鍒涘緩鍏ㄨ兘綾?瀵硅薄銆傚鍚嶅瓧鍖呭惈Driver銆丮anager銆丼ystem銆丼usystem鐨勭被瑕佺壒鍒鍔犲皬蹇冦俻30
瑙勫垝涓涓帴鍙h屼笉鏄疄鐜頒竴涓帴鍙c?/td>
 
(14)瀵瑰叕鍏辨帴鍙d腑瀹氫箟浜嗗ぇ閲忚闂柟娉曠殑綾誨鍔犲皬蹇冦傚ぇ閲忚闂柟娉曟剰鍛崇潃鐩稿叧鏁版嵁鍜岃涓烘病鏈夐泦涓瓨鏀俱俻30
 
(15)瀵瑰寘鍚お澶氫簰涓嶆矡閫氱殑琛屼負鐨勭被澶氬姞灝忓績銆俻31
榪欎釜闂鐨勫彟涓琛ㄧ幇鏄湪浣犵殑搴旂敤紼嬪簭涓殑綾葷殑鍏湁鎺ュ彛涓垱寤轟簡寰堝鐨刧et鍜宻et鍑芥暟銆?/td>
 
(16)鍦ㄧ敱鍚岀敤鎴風(fēng)晫闈氦浜掔殑闈㈠悜瀵硅薄妯″瀷鏋勬垚鐨勫簲鐢ㄧ▼搴忎腑錛屾ā鍨嬩笉搴旇渚濊禆浜庣晫闈紝鐣岄潰鍒欏簲褰撲緷璧栦簬妯″瀷銆俻33
 
(17)灝藉彲鑳藉湴鎸夌収鐜板疄涓栫晫寤烘ā(鎴戜滑甯稿父涓轟簡閬靛畧緋葷粺鍔熻兘鍒嗗竷鍘熷垯銆侀伩鍏嶅叏鑳界被鍘熷垯浠ュ強闆嗕腑鏀劇疆鐩稿叧鏁版嵁鍜岃涓虹殑鍘熷垯鑰岃繚鑳岃繖鏉″師鍒? 銆俻36
 
(18)浠庝綘鐨勮璁′腑鍘婚櫎涓嶉渶瑕佺殑綾匯俻38
涓鑸潵璇達紝鎴戜滑浼氭妸榪欎釜綾婚檷綰ф垚涓涓睘鎬с?/td>
 
(19)鍘婚櫎緋葷粺澶栫殑綾匯俻39
緋葷粺澶栫殑綾葷殑鐗圭偣鏄紝鎶借薄鍦扮湅瀹冧滑鍙線緋葷粺棰嗗煙鍙戦佹秷鎭絾騫朵笉鎺ュ彈緋葷粺棰嗗煙鍐呭叾浠栫被鍙戝嚭鐨勬秷鎭?
 
(20)涓嶈鎶婃搷浣滃彉鎴愮被銆傝川鐤戜換浣曞悕瀛楁槸鍔ㄨ瘝鎴栬呮淳鐢熻嚜鍔ㄨ瘝鐨勭被錛岀壒鍒槸鍙湁涓涓湁鎰忎箟琛屼負鐨勭被銆傝冭檻涓涓嬮偅涓湁鎰忎箟鐨勮涓烘槸鍚﹀簲褰撹縼縐誨埌宸茬粡瀛樺湪鎴栬呭皻鏈彂鐜扮殑鏌愪釜綾諱腑銆俻40
 
(21)鎴戜滑鍦ㄥ垱寤哄簲鐢ㄧ▼搴忕殑鍒嗘瀽妯″瀷鏃跺父甯稿紩鍏ヤ唬鐞嗙被銆傚湪璁捐闃舵錛屾垜浠父浼氬彂鐜板緢澶氫唬鐞嗘病鏈夌敤鐨勶紝搴斿綋鍘婚櫎銆俻43
 
(22)灝介噺鍑忓皯綾葷殑鍗忎綔鑰呯殑鏁伴噺銆俻52
涓涓被鐢ㄥ埌鐨勫叾浠栫被鐨勬暟鐩簲褰撳敖閲忓皯銆?
 
(23)灝介噺鍑忓皯綾誨拰鍗忎綔鑰呬箣闂翠紶閫掔殑娑堟伅鐨勬暟閲忋俻55
 
(24)灝介噺鍑忓皯綾誨拰鍗忎綔鑰呬箣闂寸殑鍗忎綔閲忥紝涔熷嵆錛氬噺灝戠被鍜屽崗浣滆呬箣闂翠紶閫掔殑涓嶅悓娑堟伅鐨勬暟閲忋俻55
 
(25)灝介噺鍑忓皯綾葷殑鎵囧嚭錛屼篃鍗籌細鍑忓皯綾誨畾涔夌殑娑堟伅鏁板拰鍙戦佺殑娑堟伅鏁扮殑涔樼Н銆俻55
 
(26)濡傛灉綾誨寘鍚彟涓涓被鐨勫璞★紝閭d箞鍖呭惈綾誨簲褰撶粰琚寘鍚殑瀵硅薄鍙戦佹秷鎭備篃鍗籌細鍖呭惈鍏崇郴鎬繪槸鎰忓懗鐫浣跨敤鍏崇郴銆俻55
 
(27)綾諱腑瀹氫箟鐨勫ぇ澶氭暟鏂規(guī)硶閮藉簲褰撳湪澶у鏁版椂闂撮噷浣跨敤澶у鏁版暟鎹垚鍛樸俻57
 
(28)綾誨寘鍚殑瀵硅薄鏁扮洰涓嶅簲褰撹秴榪囧紑鍙戣呯煭鏈熻蹇嗙殑瀹歸噺銆傝繖涓暟鐩父甯告槸6銆俻57
褰撶被鍖呭惈澶氫簬6涓暟鎹垚鍛樻椂錛屽彲浠ユ妸閫昏緫鐩稿叧鐨勬暟鎹垚鍛樺垝鍒嗕負涓緇勶紝鐒跺悗鐢ㄤ竴涓柊鐨勫寘鍚被鍘誨寘鍚繖涓緇勬垚鍛樸?
 
(29)璁╃郴緇熷姛鑳藉湪紿勮屾繁鐨勭戶鎵夸綋緋諱腑鍨傜洿鍒嗗竷銆俻58
 
(30)鍦ㄥ疄鐜拌涔夌害鏉熸椂錛屾渶濂芥牴鎹被瀹氫箟鏉ュ疄鐜般傝繖甯稿父浼氬鑷寸被娉涙互鎴愮伨錛屽湪榪欑鎯呭喌涓嬶紝綰︽潫搴斿綋鍦ㄧ被鐨勮涓轟腑瀹炵幇錛岄氬父鏄湪鏋勯犲嚱鏁頒腑瀹炵幇錛屼絾涓嶆槸蹇呴』濡傛銆俻60
 
(31)鍦ㄧ被鐨勬瀯閫犲嚱鏁頒腑瀹炵幇璇箟綰︽潫鏃訛紝鎶婄害鏉熸祴璇曟斁鍦ㄦ瀯閫犲嚱鏁伴鍩熸墍鍏佽鐨勫敖閲忔繁鐨勫寘鍚眰嬈′腑銆俻60
 
(32)綰︽潫鎵渚濊禆鐨勮涔変俊鎭鏋滅粡甯告敼鍙橈紝閭d箞鏈濂芥斁鍦ㄤ竴涓泦涓紡鐨勭3鏂瑰璞′腑銆俻60
 
(33)綰︽潫鎵渚濊禆鐨勮涔変俊鎭鏋滃緢灝戞敼鍙橈紝閭d箞鏈濂藉垎甯冨湪綰︽潫鎵娑夊強鐨勫悇涓被涓俻60
 
(34)綾誨繀欏葷煡閬撳畠鍖呭惈浠涔堬紝浣嗘槸涓嶈兘鐭ラ亾璋佸寘鍚畠銆俻61
 
(35)鍏變韓瀛楅潰鑼冨洿(涔熷氨鏄鍚屼竴涓被鎵鍖呭惈)鐨勫璞$浉浜掍箣闂翠笉搴斿綋鏈変嬌鐢ㄥ叧緋匯俻61
 
(36)緇ф壙鍙簲琚敤鏉ヤ負鐗瑰寲灞傛緇撴瀯寤烘ā銆俻74
 
(37)媧劇敓綾誨繀欏葷煡閬撳熀綾伙紝鍩虹被涓嶅簲璇ョ煡閬撳叧浜庡畠浠殑媧劇敓綾葷殑浠諱綍淇℃伅銆俻74
 
(38)鍩虹被涓殑鎵鏈夋暟鎹兘搴斿綋鏄鏈夌殑錛屼笉瑕佷嬌鐢ㄤ繚鎶ゆ暟鎹俻75
綾葷殑璁捐鑰呮案榪滈兘涓嶅簲璇ユ妸綾葷殑浣跨敤鑰呬笉闇瑕佺殑涓滆タ鏀懼湪鍏湁鎺ュ彛涓?
 
(39)鍦ㄧ悊璁轟笂錛岀戶鎵垮眰嬈′綋緋誨簲褰撴繁涓鐐癸紝瓚婃繁瓚婂ソ銆俻77
 
(40)鍦ㄥ疄璺典腑錛岀戶鎵垮眰嬈′綋緋葷殑娣卞害涓嶅簲褰撹秴鍑轟竴涓櫘閫氫漢鐨勭煭鏈熻蹇嗚兘鍔涖備竴涓箍涓烘帴鍙楃殑娣卞害鍊兼槸6銆俻77
 
(41)鎵鏈夌殑鎶借薄綾婚兘搴斿綋鏄熀綾匯俻81
 
(42)鎵鏈夌殑鍩虹被閮藉簲褰撴槸鎶借薄綾匯俻82
 
(43)鎶婃暟鎹佽涓哄拰/鎴栨帴鍙g殑鍏辨у敖鍙兘鍦版斁鍒扮戶鎵垮眰嬈′綋緋葷殑楂樼銆俻85
 
(44)濡傛灉涓や釜鎴栨洿澶氫釜綾誨叡浜叕鍏辨暟鎹?浣嗘病鏈夊叕鍏辮涓?錛岄偅涔堝簲褰撴妸鍏叡鏁版嵁鏀懼湪涓涓被涓紝姣忎釜鍏變韓榪欎釜鏁版嵁鐨勭被閮藉寘鍚繖涓被銆?p88
 
(45)濡傛灉涓や釜鎴栨洿澶氫釜綾繪湁鍏卞悓鐨勬暟鎹拰琛屼負(灝辨槸鏂規(guī)硶)錛岄偅涔堣繖浜涚被鐨勬瘡涓涓兘搴斿綋浠庝竴涓〃紺轟簡榪欎簺鏁版嵁鍜屾柟娉曠殑鍏叡鍩虹被緇ф壙銆?p89
 
(46)濡傛灉涓や釜鎴栨洿澶氫釜綾誨叡浜叕鍏辨帴鍙?鎸囩殑鏄秷鎭紝鑰屼笉鏄柟娉?錛岄偅涔堝彧鏈変粬浠渶瑕佽澶氭佸湴浣跨敤鏃訛紝浠栦滑鎵嶅簲褰撲粠涓涓叕鍏卞熀綾葷戶鎵褲?p89
 
(47)瀵瑰璞$被鍨嬬殑鏄劇ず鐨勫垎鎯呭喌鍒嗘瀽涓鑸槸閿欒鐨勩傚湪澶у鏁拌繖鏍風(fēng)殑鎯呭喌涓嬶紝璁捐鑰呭簲褰撲嬌鐢ㄥ鎬併俻89
 
(48)瀵瑰睘鎬у肩殑鏄劇ず鐨勫垎鎯呭喌鍒嗘瀽甯稿父鏄敊璇殑銆傜被搴斿綋瑙h﹀悎鎴愪竴涓戶鎵垮眰嬈$粨鏋勶紝姣忎釜灞炴у奸兘琚彉鎹㈡垚涓涓淳鐢熺被銆?p96
 
(49)涓嶈閫氳繃緇ф壙鍏崇郴鏉ヤ負綾葷殑鍔ㄦ佽涔夊緩妯°傝瘯鍥劇敤闈欐佽涔夊叧緋繪潵涓哄姩鎬佽涔夊緩妯′細瀵艱嚧鍦ㄨ繍琛屾椂鍒囨崲綾誨瀷銆俻97
 
(50)涓嶈鎶婄被鐨勫璞″彉鎴愭淳鐢熺被銆傚浠諱綍鍙湁涓涓疄渚嬬殑媧劇敓綾婚兘瑕佸鍔犲皬蹇冦俻99
 
(51)濡傛灉浣犺寰楅渶瑕佸湪榪愯鏃跺埢鍒涘緩鏂扮殑綾伙紝閭d箞閫鍚庝竴姝ヤ互璁ゆ竻浣犺鍒涘緩鐨勬槸瀵硅薄銆傜幇鍦紝鎶婅繖浜涘璞℃鎷垚涓涓被銆?p103
 
(52)鍦ㄦ淳鐢熺被涓敤絀烘柟娉?涔熷氨鏄粈涔堜篃涓嶅仛鐨勬柟娉?鏉ヨ鍐欏熀綾諱腑鐨勬柟娉曞簲褰撴槸闈炴硶鐨勩俻103
 
(53)涓嶈鎶婂彲閫夊寘鍚悓瀵圭戶鎵跨殑闇瑕佺浉娣鋒穯銆傛妸鍙夊寘鍚緩妯℃垚緇ф壙浼氬甫鏉ユ硾婊ユ垚鐏劇殑綾匯俻108
 
(54)鍦ㄥ垱寤虹戶鎵垮眰嬈℃椂錛岃瘯鐫鍒涘緩鍙鐢ㄧ殑妗嗘灦錛岃屼笉鏄彲澶嶇敤鐨勭粍浠躲俻112
 
(55)濡傛灉浣犲湪璁捐涓嬌鐢ㄤ簡澶氶噸緇ф壙錛屽厛鍋囪浣犵姱浜嗛敊璇傚鏋滄病鐘敊璇紝浣犻渶瑕佽娉曡瘉鏄庛俻120
 
(56)鍙鍦ㄩ潰鍚戝璞¤璁′腑鐢ㄥ埌浜嗙戶鎵匡紝闂嚜宸變袱涓棶棰橈細(1)媧劇敓綾繪槸鍚︽槸瀹冪戶鎵跨殑閭d釜涓滆タ鐨勪竴涓壒孌婄被鍨嬶紵(2)鍩虹被鏄笉鏄淳鐢熺被鐨勪竴閮ㄥ垎錛焢121
 
(57)濡傛灉浣犲湪涓涓潰鍚戝璞¤璁′腑鍙戠幇浜嗗閲嶇戶鎵垮叧緋伙紝紜繚娌℃湁鍝釜鍩虹被瀹為檯涓婃槸鍙︿竴涓熀綾葷殑媧劇敓綾匯俻122
 
(58)鍦ㄩ潰鍚戝璞¤璁′腑濡傛灉浣犻渶瑕佸湪鍖呭惈鍏崇郴鍜屽叧鑱斿叧緋婚棿浣滃嚭閫夋嫨錛岃閫夋嫨鍖呭惈鍏崇郴銆俻123
 
(59)涓嶈鎶婂叏灞鏁版嵁鎴栧叏灞鍑芥暟鐢ㄤ簬綾葷殑瀵硅薄鐨勮杽璁板伐浣溿傚簲褰撲嬌鐢ㄧ被鍙橀噺鎴栫被鏂規(guī)硶銆俻140
 
(60)闈㈠悜瀵硅薄璁捐鑰呬笉搴斿綋璁╃墿鐞嗚璁″噯鍒欐潵鐮村潖浠栦滑鐨勯昏緫璁捐銆備絾鏄紝鍦ㄥ閫昏緫璁捐浣滃嚭鍐崇瓥鐨勮繃紼嬩腑鎴戜滑緇忓父鐢ㄥ埌鐗╃悊璁捐鍑嗗垯銆?p149
 
(61)涓嶈緇曞紑鍏叡鎺ュ彛鍘諱慨鏀瑰璞$殑鐘舵併俻164
 


Kira-2006 2008-04-26 18:40 鍙戣〃璇勮
]]>
Ant鎿嶄綔hsql鏁版嵁搴?/title><link>http://www.tkk7.com/Kira-2006/articles/196291.html</link><dc:creator>Kira-2006</dc:creator><author>Kira-2006</author><pubDate>Sat, 26 Apr 2008 10:25:00 GMT</pubDate><guid>http://www.tkk7.com/Kira-2006/articles/196291.html</guid><wfw:comment>http://www.tkk7.com/Kira-2006/comments/196291.html</wfw:comment><comments>http://www.tkk7.com/Kira-2006/articles/196291.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.tkk7.com/Kira-2006/comments/commentRss/196291.html</wfw:commentRss><trackback:ping>http://www.tkk7.com/Kira-2006/services/trackbacks/196291.html</trackback:ping><description><![CDATA[<p>浣跨敤Ant鎿嶄綔hsql鏁版嵁搴撶殑渚嬪瓙錛?br /> <br /> <?xml version="1.0"?></p> <p><project name="timexdb"><br />  <property name="hjar" value="WebRoot/WEB-INF/lib/hsqldb.jar" /><br />  <property name="hclass" value="org.hsqldb.Server" /><br />  <property name="hfile" value="-database.0 data/gogoudb" /><br />  <property name="halias" value="gogou" /><br />  <property name="hport" value="9005" /></p> <p> <target name="starthsql"><br />   <java fork="true" <br />    classname="${hclass}" <br />    classpath="${hjar}" <br />    args="${hfile} -dbname.0 ${halias} -port ${hport}" /><br />  </target></p> <p> <target name="execddl"><br />   <sql classpath="${hjar}" <br />    driver="org.hsqldb.jdbcDriver" <br />    url="jdbc:hsqldb:hsql://localhost:${hport}/${halias}" <br />    userid="sa" <br />    password="" <br />    print="yes"><br /> <br /> -- SQL script for TimeX<br /> -- Step 1: Drop objects if they exist<br /> DROP TABLE Department IF EXISTS;<br /> DROP TABLE Employee IF EXISTS;<br /> DROP TABLE Timesheet IF EXISTS;<br /> DROP INDEX TimesheetIndex IF EXISTS;<br /> DROP INDEX DepartmentCodeIndex IF EXISTS;<br /> DROP INDEX EmployeeIdIndex IF EXISTS;<br /> DROP TABLE customer IF EXISTS;<br /> DROP TABLE Item IF EXISTS;<br /> DROP TABLE Item_subType IF EXISTS;<br /> DROP TABLE Item_superType IF EXISTS;<br /> DROP TABLE orders IF EXISTS;<br />    <br /> -- Step 2: Create tables<br /> CREATE TABLE Item_superType<br /> (<br />    superID BIGINT primary key,<br />    superTypeName VARCHAR(20) NOT NULL<br /> );</p> <p>CREATE TABLE Item_subType<br /> (<br />    subID BIGINT primary key,<br />    superID BIGINT,<br />    subTypeName VARCHAR(20) NOT NULL,<br />    FOREIGN KEY(superID) REFERENCES Item_superType(superID) <br /> );</p> <p>CREATE TABLE Item<br /> (<br />    itemID BIGINT primary key,<br />    subID BIGINT,<br />    itemName VARCHAR(20) NOT NULL,<br />    Introduce VARCHAR(50) ,<br />    Price VARCHAR(6) NOT NULL,<br />    nowPrice VARCHAR(6) NOT NULL,<br />    smallPicture VARCHAR(10) NOT NULL,<br />    bigPicture VARCHAR(10) NOT NULL,<br />    inTime datetime ,<br />    newItem INT ,<br />    Rebate INT ,<br />    Hit INT ,<br />    FOREIGN KEY(subID) REFERENCES Item_subType(subID)<br /> );</p> <p>CREATE TABLE customer<br /> (<br />     userID BIGINT IDENTITY,<br />     username VARCHAR(20) NOT NULL,<br />     Password  VARCHAR(20) NOT NULL,<br />     userCity  VARCHAR(20) ,<br />     userEmail  VARCHAR(20) NOT NULL,<br />     userAge  INT ,<br />     userSex  INT<br />  );<br />      <br /> CREATE TABLE orders<br /> (<br />  orderID BIGINT IDENTITY,<br />     consigneeName VARCHAR(20) NOT NULL,<br />     consigneeAddress VARCHAR(20) NOT NULL,<br />     Postalcode VARCHAR(6) NOT NULL,<br />     Telephone VARCHAR(20) NOT NULL,<br />     carryMethod VARCHAR(10) NOT NULL,<br />     Orderdate  datetime   <br /> );<br />        <br /> CREATE TABLE visualOrder<br /> (<br />      id BIGINT  IDENTITY, <br />      itemID BIGINT,<br />      userID BIGINT,<br />      orderID BIGINT,<br />      itemNumber BIGINT NOT NULL,<br />      FOREIGN KEY(itemID) REFERENCES Item(itemID),<br />      FOREIGN KEY(userID) REFERENCES customer(userID),<br />      FOREIGN KEY(orderID) REFERENCES orders(orderID)<br /> );<br /> <br /> -- Step 3: Create indexes<br /> CREATE UNIQUE INDEX visualOrderIndex ON visualOrder (userID);<br /> CREATE UNIQUE INDEX ItemIndex ON Item (itemID);<br /> CREATE UNIQUE INDEX userIdIndex ON customer (userId);<br />    <br /> create view newItem_statistic as  select * from item where item.newItem = 1;<br /> create view saleItem_statistic as  select * from item where item.Rebate = 1;</p> <p>-- Step 4: Insert some reference and test data<br /> INSERT INTO customer (userName, Password,userEmail) <br />         VALUES ('kira', 'kira','xuguoliang@sina.com');</p> <p><br /> -- Step 5: Verify tables and test data look ok<br /> SELECT * FROM customer;</p> <p>      </sql><br />  </target><br />  <target name="hsqldm"><br />   <java fork="true" classpath="${hjar}" classname="org.hsqldb.util.DatabaseManagerSwing" /><br />  </target><br />  <target name="sqltool"><br />   <java fork="true" classpath="${hjar}" classname="org.hsqldb.util.SqlTool" args="localhost-sa" /><br />  </target><br /> </project></p> <img src ="http://www.tkk7.com/Kira-2006/aggbug/196291.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.tkk7.com/Kira-2006/" target="_blank">Kira-2006</a> 2008-04-26 18:25 <a href="http://www.tkk7.com/Kira-2006/articles/196291.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>Hibernate鐢熸垚鍣?/title><link>http://www.tkk7.com/Kira-2006/articles/196287.html</link><dc:creator>Kira-2006</dc:creator><author>Kira-2006</author><pubDate>Sat, 26 Apr 2008 10:15:00 GMT</pubDate><guid>http://www.tkk7.com/Kira-2006/articles/196287.html</guid><wfw:comment>http://www.tkk7.com/Kira-2006/comments/196287.html</wfw:comment><comments>http://www.tkk7.com/Kira-2006/articles/196287.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.tkk7.com/Kira-2006/comments/commentRss/196287.html</wfw:commentRss><trackback:ping>http://www.tkk7.com/Kira-2006/services/trackbacks/196287.html</trackback:ping><description><![CDATA[<p><!--璁劇疆涓婚敭鏄犲皠--><br /> <id  name=""  column=""  type=""><br />     <generator  class="">  璁劇疆涓婚敭鐢熸垚鍣?br /> </id><br /> Hibernate妗嗘灦鍐呭緩涓轟富閿彁渚涗簡澶氱鐢熸垚鍣紝鍏蜂綋鍖呮嫭濡備笅鍐呭錛?br /> 1. increment錛氱敤浜庝負long錛宻hort錛宨nt綾誨瀷鐢熸垚鍞竴鏍囪瘑銆?br /> 2. identity錛氬DB2錛孧ySQL錛孧S SQL Server錛孲ybase鍜孒ypersonicSQL鐨勫唴緗爣璇嗗瓧孌墊彁渚涙敮鎸併?br /> 3. sequence錛氬湪DB2錛孭ostgreSQL錛孫racle錛孲APDB錛孧cKoi涓嬌鐢ㄥ簭鍒楋紙sequence錛夛紝鑰屽湪Interbase涓嬌鐢ㄧ敓鎴愬櫒錛坓enerator錛夈?br /> 4. hilo錛氫嬌鐢ㄤ竴涓珮/浣庝綅綆楁硶楂樻晥鐢熸垚long錛宻hort鎴杋nt綾誨瀷鐨勬爣璇嗙銆傜粰瀹氫竴涓〃鍜屽瓧孌碉紙榛樿鍒嗗埆鏄痟ibernate_unique_key鍜宯ext錛変綔涓洪珮浣嶅肩殑鏉ユ簮銆傞珮/浣庝綅綆楁硶鐢熸垚鐨勬爣璇嗙鍙湪涓涓壒瀹氱殑鏁版嵁搴撲腑鏄敮涓鐨勩?br /> 5. seqhilo錛氫嬌鐢ㄤ竴涓珮/浣庝綅綆楁硶楂樻晥鐢熸垚long錛宻hort鎴杋nt綾誨瀷鐨勬爣璇嗙錛岀粰瀹氫竴涓暟鎹簱搴忓垪錛坰equence錛夌殑鍚嶅瓧銆?br /> 6. uuid.hex錛氱敤涓涓?28-bit鐨刄UID綆楁硶鐢熸垚瀛楃涓茬被鍨嬬殑鏍囪瘑絎︺傚湪涓涓綉緇滀腑鏄敮涓鐨勶紙浣跨敤浜咺P鍦板潃錛夈俇UID琚紪鐮佷綅涓涓?2浣?6榪涘埗鏁板瓧鐨勫瓧絎︿覆銆?br /> 7. uuid.string錛氫嬌鐢ㄥ悓鏍風(fēng)殑UUID綆楁硶銆俇UID琚紪鐮佷綅涓涓?6涓瓧絎﹂暱鐨勪換鎰廇SCII瀛楃緇勬垚鐨勫瓧絎︿覆銆?br /> 8. native錛氭牴鎹簳灞傛暟鎹簱鐨勮兘鍔涢夋嫨identity銆乻equence銆乭ilo涓殑涓涓?br /> 9. assigned錛氳搴旂敤紼嬪簭鍦ㄦ彃琛ㄤ箣鍓嶄負瀵硅薄鍒嗛厤涓涓爣璇嗙銆?br /> 10. foreign錛氫嬌鐢ㄥ彟涓涓浉鍏寵仈鐨勫璞$殑鏍囪瘑絎︺傞氬父琚敤鍦ㄦ湁鍏寵仈鍏崇郴鐨勮〃涓?br /> <br /> <span style="color: red">涓鑸潵璇達紝鍦℉ibernate涓紝涓嶆帹鑽愮敤assigned浣滀負涓婚敭鐢熸垚鍣ㄣ傚洜涓哄鏁版嵁搴撹〃鏉ヨ錛屼互涓氬姟閫昏緫瀛楁浣滀負涓婚敭鏈夋綔鍦ㄧ殑鍗遍櫓鎬с傚綋璇ヤ笟鍔¢昏緫瀛楁鍦ㄥ皢鏉ラ渶瑕佹敼鍙樼殑鏃跺欙紝浣滀負涓婚敭鐨勫簲鐢ㄥ氨浼氱浉褰撻夯鐑︺傚父鐢ㄧ殑鎵嬫鏄敤涓涓拰涓氬姟鏃犲叧鐨勫瓧孌典綔涓轟富閿紝鑰屽湪PO涓畾涔夎繖涓瓧孌墊垚涓哄彉閲忓睘鎬э紝鍚屼簨鍙堜綔涓鴻瀵硅薄鐨勬儫涓鏍囪瘑銆?/span></p> <img src ="http://www.tkk7.com/Kira-2006/aggbug/196287.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.tkk7.com/Kira-2006/" target="_blank">Kira-2006</a> 2008-04-26 18:15 <a href="http://www.tkk7.com/Kira-2006/articles/196287.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item><item><title>hsqldb緙栧啓鎵瑰鐞嗘枃浠跺惎鍔ㄨ嚜宸卞垱寤虹殑鏁版嵁搴?/title><link>http://www.tkk7.com/Kira-2006/articles/190208.html</link><dc:creator>Kira-2006</dc:creator><author>Kira-2006</author><pubDate>Tue, 01 Apr 2008 13:54:00 GMT</pubDate><guid>http://www.tkk7.com/Kira-2006/articles/190208.html</guid><wfw:comment>http://www.tkk7.com/Kira-2006/comments/190208.html</wfw:comment><comments>http://www.tkk7.com/Kira-2006/articles/190208.html#Feedback</comments><slash:comments>1</slash:comments><wfw:commentRss>http://www.tkk7.com/Kira-2006/comments/commentRss/190208.html</wfw:commentRss><trackback:ping>http://www.tkk7.com/Kira-2006/services/trackbacks/190208.html</trackback:ping><description><![CDATA[<span lang="EN-US" style="font-size: 12pt; font-family: 瀹嬩綋; mso-bidi-font-family: 瀹嬩綋; mso-font-kerning: 0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA">    hsql</span><span style="font-size: 12pt; font-family: 瀹嬩綋; mso-bidi-font-family: 瀹嬩綋; mso-font-kerning: 0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA">鏁版嵁搴撴槸涓嬈劇函<span lang="EN-US">Java</span>緙栧啓鐨勫厤璐規(guī)暟鎹簱錛岃鍙槸<span lang="EN-US">BSD-style</span>鐨勫崗璁紝濡傛灉浣犳槸浣跨敤<span lang="EN-US">Java</span>緙栫▼鐨勮瘽錛屼笉鍑¤冭檻涓涓嬩嬌鐢ㄥ畠錛岀浉瀵瑰叾浠栨暟鎹簱鏉ヨ錛屽叾浣撶Н灝忥紝鎴戜嬌鐢ㄧ殑鏄痟sqldb1_8_0_7,鍘嬬緝鍖呭ぇ灝忎負3.12M銆備粎涓涓?span lang="EN-US">hsqldb.jar</span>鏂囦歡灝卞寘鎷簡鏁版嵁搴撳紩鎿庯紝鏁版嵁搴撻┍鍔紝榪樻湁鍏朵粬鐢ㄦ埛鐣岄潰鎿嶄綔絳夊唴瀹廣?br />     鐪嬩簡涓涓嬬綉涓婄殑涓浜沨sqldb鐨勮祫鏂欙紝澶у鏁版暟鎹簱鐨勫惎鍔ㄥ拰鐢ㄦ埛鐣岄潰鐨勬搷浣滈兘鍦ㄥ懡浠よ涓繘琛屾搷浣滐紝o(∩_∩)o...鍝堝搱錛屾劅瑙夋湁鐐歸夯鐑︺傚湪hsqldb鐨勫帇緙╁寘涓紝鏈変釜鑷甫鐨勬暟鎹簱test錛屽畠鐨勫惎鍔ㄥ拰鐢ㄦ埛鐣岄潰鎿嶄綔閮芥槸鐩存帴鏈変竴涓壒澶勭悊鏂囦歡鏉ユ墽琛岋紝寰堟柟渚褲傚叾瀹炴垜浠氨鍙互鏍規(guī)嵁榪欎袱涓壒澶勭悊鏂囦歡鏉ュ啓鑷繁鍒涘緩鐨勬暟鎹簱鐨勬壒澶勭悊鏂囦歡銆?br />     hsqldb鑷甫鏁版嵁搴撶殑鍚姩鎵瑰鐞嗘枃浠訛紝鍦ㄥ帇緙╁寘涓紝demo/runServer.bat鏂囦歡錛屽彸閿?#8220;緙栬緫”錛屽彲浠ョ湅鍒版枃浠朵腑鐨勫唴瀹逛負錛?br /> <font face="瀹嬩綋">cd ..\data<br /> @java -classpath ../lib/hsqldb.jar org.hsqldb.Server %1 %2 %3 %4 %5 %6 %7 %8 %9<br /> </font>鍗沖惎鍔ㄥ湪data鐩綍涓嬬殑緋葷粺鑷甫鐨勬暟鎹簱test銆?br /> 濡傛灉浣犺鍦╠b鐩綍涓嬪垱寤猴紝騫跺惎鍔ㄦ暟鎹簱mydb銆傚氨鍙互緙栧啓鎵瑰鐞嗘枃浠訛細<br /> cd ..\db<br /> @java -classpath ../lib/hsqldb.jar org.hsqldb.Server -database.0 mydb -dbname.0 mydb<br /> 鐢ㄦ埛鐣岄潰鐨勬搷浣滃彲浠ュ悓鏍風(fēng)殑鏂瑰紡榪涜緙栧啓鎵瑰鐞嗘枃浠躲?/span> <img src ="http://www.tkk7.com/Kira-2006/aggbug/190208.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.tkk7.com/Kira-2006/" target="_blank">Kira-2006</a> 2008-04-01 21:54 <a href="http://www.tkk7.com/Kira-2006/articles/190208.html#Feedback" target="_blank" style="text-decoration:none;">鍙戣〃璇勮</a></div>]]></description></item></channel></rss> <footer> <div class="friendship-link"> <p>感谢您访问我们的网站,您可能还对以下资源感兴趣:</p> <a href="http://www.tkk7.com/" title="亚洲av成人片在线观看">亚洲av成人片在线观看</a> <div class="friend-links"> </div> </div> </footer> 主站蜘蛛池模板: <a href="http://3344088.com" target="_blank">一区免费在线观看</a>| <a href="http://haoda8.com" target="_blank">亚洲精品老司机在线观看</a>| <a href="http://dt677.com" target="_blank">久久九九AV免费精品</a>| <a href="http://imqun.com" target="_blank">噜噜噜亚洲色成人网站</a>| <a href="http://0755host.com" target="_blank">亚洲AV无码乱码麻豆精品国产</a>| <a href="http://kfdingrui.com" target="_blank">亚洲热线99精品视频</a>| <a href="http://dddd20.com" target="_blank">亚洲国产精品日韩专区AV</a>| <a href="http://606059.com" target="_blank">麻豆成人精品国产免费</a>| <a href="http://0827fang.com" target="_blank">国产a视频精品免费观看</a>| <a href="http://bjmyhfc.com" target="_blank">久久青草免费91线频观看不卡</a>| <a href="http://zblinghang.com" target="_blank">免费在线观看自拍性爱视频</a>| <a href="http://www-qwh.com" target="_blank">亚洲熟妇无码av另类vr影视</a>| <a href="http://sxhnyl.com" target="_blank">亚洲国产成人手机在线电影bd</a>| <a href="http://yg1617.com" target="_blank">亚洲人成网站影音先锋播放</a>| <a href="http://x5k9.com" target="_blank">亚洲乱码中文字幕综合</a>| <a href="http://zanyoo.com" target="_blank">久久激情亚洲精品无码?V </a>| <a href="http://conghui8.com" target="_blank">亚洲精品在线电影</a>| <a href="http://xdxsw.com" target="_blank">亚洲国产精品一区第二页</a>| <a href="http://wwkk3.com" target="_blank">亚洲男人av香蕉爽爽爽爽</a>| <a href="http://thegaybdsm.com" target="_blank">国产一级淫片免费播放电影 </a>| <a href="http://xyjxnhcl.com" target="_blank">亚洲乱码无人区卡1卡2卡3</a>| <a href="http://yy12345.com" target="_blank">亚洲精品一卡2卡3卡三卡四卡</a>| <a href="http://4husese.com" target="_blank">久久精品国产亚洲香蕉 </a>| <a href="http://pjwys.com" target="_blank">精品成在人线AV无码免费看</a>| <a href="http://1897tao.com" target="_blank">久久久免费的精品</a>| <a href="http://oupur.com" target="_blank">无码av免费一区二区三区试看</a>| <a href="http://k8h9.com" target="_blank">全黄大全大色全免费大片</a>| <a href="http://qsqse1.com" target="_blank">国产免费一区二区三区免费视频</a>| <a href="http://91xqq.com" target="_blank">全部一级一级毛片免费看</a>| <a href="http://jiajuco.com" target="_blank">一级成人毛片免费观看</a>| <a href="http://km9c.com" target="_blank">国产免费黄色无码视频</a>| <a href="http://www-60060.com" target="_blank">中国性猛交xxxxx免费看</a>| <a href="http://whlnrsqsie.com" target="_blank">久久精品无码免费不卡</a>| <a href="http://zqsplc.com" target="_blank">a毛片在线免费观看</a>| <a href="http://pecbj.com" target="_blank">久久精品一区二区免费看</a>| <a href="http://www-63228.com" target="_blank">免费A级毛片av无码</a>| <a href="http://52xingai.com" target="_blank">最近免费mv在线电影</a>| <a href="http://aiwoqi.com" target="_blank">免费AA片少妇人AA片直播</a>| <a href="http://otkaxap.com" target="_blank">成人毛片免费观看视频大全</a>| <a href="http://77133144.com" target="_blank">国产做床爱无遮挡免费视频</a>| <a href="http://m8va.com" target="_blank">亚洲成A人片在线观看中文</a>| <script> (function(){ var bp = document.createElement('script'); var curProtocol = window.location.protocol.split(':')[0]; if (curProtocol === 'https') { bp.src = 'https://zz.bdstatic.com/linksubmit/push.js'; } else { bp.src = 'http://push.zhanzhang.baidu.com/push.js'; } var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(bp, s); })(); </script> </body>