<o:p>?</o:p>

現在的這個小項目除了完成基本的添刪改查，還有一個簡單的分頁功能。這個分頁功能不僅前臺分頁，而且在后臺數據庫也進行了分頁處理。

<o:p>?</o:p>

現在就來編寫 Dao 層的代碼。

首先寫好 pojo 的代碼：

在 com.game.products.model 中新建 products.hbm.xml 類，代碼如下：

<o:p></o:p>

?

<? xml?version="1.0"?encoding="GB2312" ?>
<! DOCTYPE?hibernate-mapping?PUBLIC?"-//Hibernate/Hibernate?Mapping?DTD?3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >

< hibernate-mapping >
????? < class? name ="com.game.products.model.Products" ?table ="products" ? >
????????? < id? name ="gameId" ?type ="string" >
???????????? < column? name ="game_id" ?length ="5" ? />
???????????? < generator? class ="assigned" ? />
???????? </ id >
???????? < property? name ="gameNameCn" ?type ="string" >
???????????? < column? name ="game_name_cn" ?length ="100" ? />
???????? </ property >
????????? < property? name ="gameNameEn" ?type ="string" >
???????????? < column? name ="game_name_en" ?length ="100" ? />
???????? </ property >
???????? < property? name ="gameCapacity" ?type ="string" >
???????????? < column? name ="game_capacity" ?length ="4" ? />
???????? </ property >
????????? < property? name ="gameVersion" ?type ="string" >
???????????? < column? name ="game_version" ?length ="4" ? />
???????? </ property >
?????????? < property? name ="gameMedia" ?type ="string" >
???????????? < column? name ="game_media" ?length ="4" ? />
???????? </ property >
???????? < property? name ="gameCopyright" ?type ="string" >
???????????? < column? name ="game_copyright" ?length ="4" ? />
???????? </ property >
???????? < property? name ="gamePrice" ?type ="string" >
???????????? < column? name ="game_price" ?length ="4" ? />
???????? </ property > ?
????????? < property? name ="gameContent" ?type ="string" >
???????????? < column? name ="game_content" ?length ="100" ? />
???????? </ property >
????? </ class >
</ hibernate-mapping >

?

注意這里的 ID 不是數據庫自動生成的，而是根據需要由程序生成，一般項目中的主鍵 ID 都是采取這種方式。

然后在這個包中再新建 Products 類，代碼如下：

<o:p></o:p>

package ?com.game.products.model;

public ? class ?Products? {
???? // ????Fields?
???? private ?String?gameId; // 編號
???? private ?String?gameNameCn; // 中文名稱
???? private ?String?gameNameEn; // 英文名稱
???? private ?String?gameCapacity; // 碟數
???? private ?String?gameVersion; // 版本
???? private ?String?gameMedia; // 介質
???? private ?String?gameCopyright; // 版權
???? private ?String?gamePrice; // 價格
???? private ?String?gameContent; // 攻略
????
???? // ????Constructors
???? public ?Products() {}
????
???? // ????Property?accessors
???? public ?String?getGameCapacity()? {
???????? return ?gameCapacity;
????}

???? public ? void ?setGameCapacity(String?gameCapacity)? {
???????? this .gameCapacity? = ?gameCapacity;
????}

???? public ?String?getGameId()? {
???????? return ?gameId;
????}

???? public ? void ?setGameId(String?gameId)? {
???????? this .gameId? = ?gameId;
????}

???? public ?String?getGameNameCn()? {
???????? return ?gameNameCn;
????}

???? public ? void ?setGameNameCn(String?gameNameCn)? {
???????? this .gameNameCn? = ?gameNameCn;
????}

???? public ?String?getGameNameEn()? {
???????? return ?gameNameEn;
????}

???? public ? void ?setGameNameEn(String?gameNameEn)? {
???????? this .gameNameEn? = ?gameNameEn;
????}

???? public ?String?getGameVersion()? {
???????? return ?gameVersion;
????}

???? public ? void ?setGameVersion(String?gameVersion)? {
???????? this .gameVersion? = ?gameVersion;
????}

???? public ?String?getGameMedia()? {
???????? return ?gameMedia;
????}

???? public ? void ?setGameMedia(String?gameMedia)? {
???????? this .gameMedia? = ?gameMedia;
????}

???? public ?String?getGameCopyright()? {
???????? return ?gameCopyright;
????}

???? public ? void ?setGameCopyright(String?gameCopyright)? {
???????? this .gameCopyright? = ?gameCopyright;
????}

???? public ?String?getGameContent()? {
???????? return ?gameContent;
????}

???? public ? void ?setGameContent(String?gameContent)? {
???????? this .gameContent? = ?gameContent;
????}

???? public ?String?getGamePrice()? {
???????? return ?gamePrice;
????}

???? public ? void ?setGamePrice(String?gamePrice)? {
???????? this .gamePrice? = ?gamePrice;
????}

}

?

需要注意的是，我這里都是采用了 string 類型，因為在項目中傳遞數據，用 string 類型最為方便，同時也便于代碼的編寫。只是在前臺需要編寫驗證代碼，免得有字符數據插入整數字段而造成數據庫異常。

<o:p>?</o:p>

在 com.game.products.dao.iface 包中新建 ProductsDao 接口。 <o:p></o:p>

代碼如下所示： <o:p></o:p>

<o:p></o:p>

struts+spring+hibernate的web應用 Dao層代碼編寫