亚洲免费在线-亚洲免费在线播放-亚洲免费在线观看-亚洲免费在线观看视频-亚洲免费在线看-亚洲免费在线视频

Hibernate集合排序之?dāng)?shù)據(jù)庫(kù)排序

系統(tǒng) 1598 0

使用order-by屬性,我們可以通過hbm文件執(zhí)行生成的SQL如何使用order by 查詢子句以返回排序后的結(jié)果集

數(shù)據(jù)庫(kù)結(jié)構(gòu):

?

create ? table ?teamOrder?(id? varchar ( 32 ),teamname? varchar ( 32 ));
create ? table ?studentOrder?(id? varchar ( 32 ),name? varchar ( 32 ),description? varchar ( 32 ),team_id? varchar ( 32 ));
insert ? into ?teamOrder? values (" 1 ","team1");
insert ? into ?studentOrder? values (" 1 ","a","a"," 1 ");
insert ? into ?studentOrder? values (" 2 ","b","b"," 1 ");
insert ? into ?studentOrder? values (" 3 ","c","c"," 1 ");

?

pojo:

?

package ?Collection.Order;

import ?java.util.Set;

public ? class ?Team? ... {
???
private ?String?id;
???
private ?String?teamname;
???
private ?Set?students;
public ?String?getId()? ... {
????
return ?id;
}

public ? void ?setId(String?id)? ... {
????
this .id? = ?id;
}

public ?String?getTeamname()? ... {
????
return ?teamname;
}

public ? void ?setTeamname(String?teamname)? ... {
????
this .teamname? = ?teamname;
}

public ?Set?getStudents()? ... {
????
return ?students;
}

public ? void ?setStudents(Set?students)? ... {
????
this .students? = ?students;
}


}




package ?Collection.Order;

public ? class ?Student? ... {
??
private ?String?id;
??
private ?String?name;
??
private ?String?description;
??
private ?Team?team;
public ?String?getId()? ... {
????
return ?id;
}

public ? void ?setId(String?id)? ... {
????
this .id? = ?id;
}

public ?String?getName()? ... {
????
return ?name;
}

public ? void ?setName(String?name)? ... {
????
this .name? = ?name;
}

public ?String?getDescription()? ... {
????
return ?description;
}

public ? void ?setDescription(String?description)? ... {
????
this .description? = ?description;
}


public ?Team?getTeam()? ... {
????
return ?team;
}

public ? void ?setTeam(Team?team)? ... {
????
this .team? = ?team;
}

}

?

Hibernate.cfg.xml

?

<? xml?version='1.0'?encoding='UTF-8' ?>
<! DOCTYPE?hibernate-configuration?PUBLIC
??????????"-//Hibernate/Hibernate?Configuration?DTD?3.0//EN"
??????????"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"
>

<!-- ?Generated?by?MyEclipse?Hibernate?Tools.??????????????????? -->
< hibernate-configuration >

< session-factory >
????
< property? name ="connection.username" > root </ property >
????
< property? name ="connection.url" >
????????jdbc:mysql://localhost:3306/schoolproject?characterEncoding=gb2312
&amp; useUnicode=true
????
</ property >
????
< property? name ="dialect" >
????????org.hibernate.dialect.MySQLDialect
????
</ property >
????
< property? name ="myeclipse.connection.profile" > mysql </ property >
????
< property? name ="connection.password" > 1234 </ property >
????
< property? name ="connection.driver_class" >
????????com.mysql.jdbc.Driver
????
</ property >
????
< property? name ="hibernate.dialect" >
????????org.hibernate.dialect.MySQLDialect
????
</ property >
????
< property? name ="hibernate.show_sql" > true </ property >
????
< property? name ="current_session_context_class" > thread </ property >
????
< property? name ="jdbc.batch_size" > 15 </ property >
????
< mapping? resource ="Collection/Order/Student.hbm.xml" ? />
????
< mapping? resource ="Collection/Order/Team.hbm.xml" ? />




</ session-factory >

</ hibernate-configuration >

Student.hbm.xml

?

<? xml?version="1.0"?encoding="utf-8" ?>
<! DOCTYPE?hibernate-mapping?PUBLIC?"-//Hibernate/Hibernate?Mapping?DTD?3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"
>
<!-- ?
????Mapping?file?autogenerated?by?MyEclipse?-?Hibernate?Tools
-->
< hibernate-mapping >
< class? name ="Collection.Order.Student" ?table ="studentOrder" ? >
????
< id? name ="id" ?unsaved-value ="null" >
??????
< generator? class ="uuid.hex" ></ generator >
????
</ id >
??
????
< property? name ="name" ?type ="string" ?column ="name" ></ property >
???
????
< property? name ="description" ?type ="string" ?column ="description" ></ property > ?
????
< many-to-one? name ="team" ?
?????????????????column
="team_id"
?????????????????class
="Collection.Order.Team" ?
?????????????????cascade
="none" ?
?????????????????fetch
="join" >
????
</ many-to-one >
</ class >

</ hibernate-mapping >

Team.hbm.xml

?

?

<? xml?version="1.0"?encoding="utf-8" ?>
<! DOCTYPE?hibernate-mapping?PUBLIC?"-//Hibernate/Hibernate?Mapping?DTD?3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"
>
<!-- ?
????Mapping?file?autogenerated?by?MyEclipse?-?Hibernate?Tools
-->
< hibernate-mapping >
< class? name ="Collection.Order.Team" ?table ="teamOrder" ? >
????
< id? name ="id" ?unsaved-value ="null" >
??????
< generator? class ="uuid.hex" ></ generator >
????
</ id >
????
< property? name ="teamname" ?type ="string" ?column ="teamname" ></ property >
????
<!-- ?以名稱降序返回student集合? -->
????
< set? name ="students" ?table ="studentOrder" ?cascade ="all" ?order-by ="name?desc" >
??????
< key? column ="team_id" ></ key >
??????
< one-to-many? class ="Collection.Order.Student" />
????
</ set >
</ class >

</ hibernate-mapping >

?

測(cè)試代碼:

?

package ?Collection.Order;


import ?java.io.File;
import ?java.util.Iterator;
import ?java.util.Set;

import ?org.hibernate.Session;
import ?org.hibernate.SessionFactory;
import ?org.hibernate.Transaction;
import ?org.hibernate.cfg.Configuration;

Hibernate集合排序之?dāng)?shù)據(jù)庫(kù)排序


更多文章、技術(shù)交流、商務(wù)合作、聯(lián)系博主

微信掃碼或搜索:z360901061

微信掃一掃加我為好友

QQ號(hào)聯(lián)系: 360901061

您的支持是博主寫作最大的動(dòng)力,如果您喜歡我的文章,感覺我的文章對(duì)您有幫助,請(qǐng)用微信掃描下面二維碼支持博主2元、5元、10元、20元等您想捐的金額吧,狠狠點(diǎn)擊下面給點(diǎn)支持吧,站長(zhǎng)非常感激您!手機(jī)微信長(zhǎng)按不能支付解決辦法:請(qǐng)將微信支付二維碼保存到相冊(cè),切換到微信,然后點(diǎn)擊微信右上角掃一掃功能,選擇支付二維碼完成支付。

【本文對(duì)您有幫助就好】

您的支持是博主寫作最大的動(dòng)力,如果您喜歡我的文章,感覺我的文章對(duì)您有幫助,請(qǐng)用微信掃描上面二維碼支持博主2元、5元、10元、自定義金額等您想捐的金額吧,站長(zhǎng)會(huì)非常 感謝您的哦!!!

發(fā)表我的評(píng)論
最新評(píng)論 總共0條評(píng)論
主站蜘蛛池模板: 狠狠躁夜夜躁人人爽天天天天 | 久久在线视频免费观看 | 成年女人毛片免费播放人 | 午夜欧美精品久久久久久久 | 国产精品国产欧美综合一区 | 一级在线 | 欧洲 | 亚洲爽爽 | 四虎影视1304t | 亚洲第一区视频在线观看 | 四虎永久在线免费观看 | 欲色综合| 国内精品中文字幕 | 免费观看国产网址你懂的 | 久久国产精品99精品国产 | 伊人久久波多野结衣中文字幕 | 欧美亚洲国产激情一区二区 | 成人毛片18女人毛片 | 黄色毛片小视频 | 欧美精品亚洲精品日韩专区va | 久热中文字幕在线 | 色片在线免费观看 | 99热这里只有免费国产精品 | 亚洲一区在线日韩在线深爱 | 一本色道久久爱88av俺来也 | 一级特黄特色aa大片 | 国产在线观看a | 欧美一区二区三区精品影视 | 国人精品视频在线观看 | 久操视频在线免费观看 | 亚洲一区国产 | 日韩中文字幕高清在线专区 | 涩涩97在线观看视频 | 伊人一区二区三区 | 日韩亚洲一区中文字幕 | 亚洲欧美综合网站 | 亚洲精品亚洲人成在线 | 黄色成人在线视频 | 亚洲欧美日韩成人网 | 日韩在线成人 | 久久成人精品免费播放 | 欧美日韩视频精品一区二区 |