read AppFuse 11-实践-业务信息person的建立

read AppFuse 11-实践-业务信息person的建立

●     按照AppFuse帮助，进行AppFuse开发实践

（1）     创建POJO

package org.dudu.model;

/**

 * @hibernate.class table="person"

 */

public class Person extends BaseObject

{

   private Long id;

   private String firstName;

   private String lastName;

       /**

    * @return Returns the id

    * @hibernate.id column="id"

    * generator-class="increment" unsaved-value="null"

    */

   public long getId() {

       return id;

   }

       /**

    * @return Returns thd first name

    * @struts.validator type="required"

 * @hibernate.property column="first_name" length="50" not-null="true"

    */

   public String getFirstName() {

       return firstName;

   }

   /**

    * @return Returns the last name

    * @struts.validator type="required"

    * @hibernate.property column="last_name" length="50" not-null="true"

    */

   public String getLastName() {

       return lastName;

   }

   /**

    * @param l

    */

   public void setId(long l) {

       id = l;

   }

   /**

    * @param string

    */

   public void setFirstName(String string) {

       firstName = string;

   }

   /**

    * @param string

    */

   public void setLastName(String string) {

       lastName = string;

   }

   /* （非 Javadoc）

    * @see java.lang.Object#equals(java.lang.Object)

    */

   public boolean equals(Object o) {

       // TODO 自动生成方法存根

       return false;

   }

   /* （非 Javadoc）

    * @see java.lang.Object#hashCode()

    */

   public int hashCode() {

       return 0;

   }

   public String toString() {

       return null;

   }

 

}

Ø Hibernate是一个对象/关系(O/R) 框架，它允许你将一个Java对象同一个表关联。

Ø 要确保对象的id属性的getter是当前类的第一个方法，否则生成的JSP的页面可能会有一个脚本错误

Ø 注意：所有的 @hibernate.* tag必须放在你的POJO的getter的Javadoc中

Ø 如果你想更改列的长度, 更改@hibernate.property标记的length属性。如果你希望它是一个必填的字段(NOT NULL)，那么你要添加not-null="true"。

Ø 添加column属性的唯一原因是:表的列名和对象的属性名字不一致。如果他们一致，就不需要添加column属性。[引用]

 

（2）     使用Ant根据Person对象创建一个person新表和名为Person.hbm.xml的映射文件。

E:/dudu>ant setup-db

Buildfile: build.xml

 

init:

 

db-create:

     [echo] Detected MySQL, creating database...

     [echo] Creating database with: mysql-create.sql

     [echo] URL: jdbc:mysql://localhost/mysql

      [sql] Executing file: E:/dudu/metadata/sql/mysql-create.sql

      [sql] 3 of 3 SQL statements executed successfully

 

clean:

     [echo] Cleaning build and distribution directories

   [delete] Deleting directory E:/dudu/build

   [delete] Deleting directory E:/dudu/dist

   [delete] Deleting: E:/dudu/database.properties

 

build.properties.missing:

 

prepare:

     [echo] Preparing target directory 'E:/dudu/build/dudu'

    [mkdir] Created dir: E:/dudu/build/dudu

    [mkdir] Created dir: E:/dudu/build/dudu/WEB-INF

    [mkdir] Created dir: E:/dudu/dist/webapps

 

hibernatedoclet:

[hibernatedoclet] (XDocletMain.start                   47  ) Running <hibernate/

>

 

[hibernatedoclet] Generating mapping file for org.dudu.model.User.

[hibernatedoclet]    org.dudu.model.User

[hibernatedoclet] Generating mapping file for org.dudu.model.Person.

[hibernatedoclet]    org.dudu.model.Person

[hibernatedoclet] Generating mapping file for org.dudu.model.Role.

[hibernatedoclet]    org.dudu.model.Role

[hibernatedoclet] Generating mapping file for org.dudu.model.UserCookie.

[hibernatedoclet]    org.dudu.model.UserCookie

 

compile-dao:

 

compile-module:

     [echo] Compiling dao...

    [mkdir] Created dir: E:/dudu/build/dao/classes

    [mkdir] Created dir: E:/dudu/build/test/dao/classes

    [javac] Compiling 16 source files to E:/dudu/build/dao/classes

    [javac] Note: E:/dudu/src/dao/org/dudu/model/User.java uses unchecked or uns

afe operations.

    [javac] Note: Recompile with -Xlint:unchecked for details.

 

package-dao:

     [copy] Copying 1 file to E:/dudu/build/dao/gen

      [jar] Building jar: E:/dudu/dist/dudu-dao.jar

 

db-prepare:

 

generate.database.properties:

     [echo] generating database.properties from build.properties

[propertyfile] Creating new property file: E:/dudu/database.properties

[schemaexport] (cfg.Environment                     478 ) Hibernate 2.1.7

[schemaexport] (cfg.Environment                     507 ) hibernate.properties n

ot found

[schemaexport] (cfg.Environment                     538 ) using CGLIB reflection

 optimizer

[schemaexport] (cfg.Environment                     567 ) using JDK 1.4 java.sql

.Timestamp handling

[schemaexport] (cfg.Configuration                   169 ) Mapping file: E:/dudu/

build/dao/gen/org/dudu/model/Person.hbm.xml

[schemaexport] (cfg.Binder                          230 ) Mapping class: org.dud

u.model.Person -> person

[schemaexport] (cfg.Configuration                   169 ) Mapping file: E:/dudu/

build/dao/gen/org/dudu/model/Role.hbm.xml

[schemaexport] (cfg.Binder                          230 ) Mapping class: org.dud

u.model.Role -> role

[schemaexport] (cfg.Configuration                   169 ) Mapping file: E:/dudu/

build/dao/gen/org/dudu/model/User.hbm.xml

[schemaexport] (cfg.Binder                          230 ) Mapping class: org.dud

u.model.User -> app_user

[schemaexport] (cfg.Binder                          572 ) Mapping collection: or

g.dudu.model.User.roles -> user_role

[schemaexport] (cfg.Configuration                   169 ) Mapping file: E:/dudu/

build/dao/gen/org/dudu/model/UserCookie.hbm.xml

[schemaexport] (cfg.Binder                          230 ) Mapping class: org.dud

u.model.UserCookie -> user_cookie

[schemaexport] (dialect.Dialect                     86  ) Using dialect: net.sf.

hibernate.dialect.MySQLDialect

[schemaexport] (cfg.Configuration                   632 ) processing one-to-many

 association mappings

[schemaexport] (cfg.Configuration                   641 ) processing one-to-one

association property references

[schemaexport] (cfg.Configuration                   666 ) processing foreign key

 constraints

[schemaexport] (cfg.Configuration                   632 ) processing one-to-many

 association mappings

[schemaexport] (cfg.Configuration                   641 ) processing one-to-one

association property references

[schemaexport] (cfg.Configuration                   666 ) processing foreign key

 constraints

[schemaexport] (hbm2ddl.SchemaExport                98  ) Running hbm2ddl schema

 export

[schemaexport] (hbm2ddl.SchemaExport                112 ) writing generated sche

ma to file: create-tables.sql

[schemaexport] (hbm2ddl.SchemaExport                117 ) exporting generated sc

hema to database

[schemaexport] (connection.DriverManagerConnectionProvider 42  ) Using Hibernate

 built-in connection pool (not for production use!)

[schemaexport] (connection.DriverManagerConnectionProvider 43  ) Hibernate conne

ction pool size: 20

[schemaexport] (connection.DriverManagerConnectionProvider 77  ) using driver: c

om.mysql.jdbc.Driver at URL: jdbc:mysql://localhost/dudu?autoReconnect=true&useU

nicode=true&characterEncoding=utf-8

[schemaexport] (connection.DriverManagerConnectionProvider 78  ) connection prop

erties: {user=test, password=test, show_sql=true}

[schemaexport] alter table user_role drop foreign key FK143BF 46A 14048CB4;

[schemaexport] alter table user_role drop foreign key FK143BF46AF02988D6;

[schemaexport] drop table if exists user_role;

[schemaexport] drop table if exists app_user;

[schemaexport] drop table if exists person;

[schemaexport] drop table if exists user_cookie;

[schemaexport] drop table if exists role;

[schemaexport] create table user_role (

[schemaexport]    username varchar(20) not null,

[schemaexport]    role_name varchar(20) not null,

[schemaexport]    primary key (username, role_name)

[schemaexport] );

[schemaexport] create table app_user (

[schemaexport]    username varchar(20) not null,

[schemaexport]    version integer not null,

[schemaexport]    password varchar(255) not null,

[schemaexport]    first_name varchar(50) not null,

[schemaexport]    last_name varchar(50) not null,

[schemaexport]    address varchar(150),

[schemaexport]    city varchar(50) not null,

[schemaexport]    province varchar(100),

[schemaexport]    country varchar(100),

[schemaexport]    postal_code varchar(15) not null,

[schemaexport]    email varchar(255) not null unique,

[schemaexport]    phone_number varchar(255),

[schemaexport]    website varchar(255),

[schemaexport]    password_hint varchar(255),

[schemaexport]    primary key (username)

[schemaexport] );

[schemaexport] create table person (

[schemaexport]    id bigint not null,

[schemaexport]    first_name varchar(50) not null,

[schemaexport]    last_name varchar(50) not null,

[schemaexport]    primary key (id)

[schemaexport] );

[schemaexport] create table user_cookie (

[schemaexport]    id bigint not null,

[schemaexport]    username varchar(30) not null,

[schemaexport]    cookie_id varchar(100) not null,

[schemaexport]    date_created datetime not null,

[schemaexport]    primary key (id)

[schemaexport] );

[schemaexport] create table role (

[schemaexport]    name varchar(20) not null,

[schemaexport]    version integer not null,

[schemaexport]    description varchar(255),

[schemaexport]    primary key (name)

[schemaexport] );

[schemaexport] alter table user_role add index FK143BF 46A 14048CB4 (role_name), a

dd constraint FK143BF 46A 14048CB4 foreign key (role_name) references role (name);

 

[schemaexport] alter table user_role add index FK143BF46AF02988D6 (username), ad

d constraint FK143BF46AF02988D6 foreign key (username) references app_user (user

name);

[schemaexport] create index user_cookie_username_cookie_id on user_cookie (usern

ame, cookie_id);

[schemaexport] (hbm2ddl.SchemaExport                160 ) schema export complete

 

[schemaexport] (connection.DriverManagerConnectionProvider 143 ) cleaning up con

nection pool: jdbc:mysql://localhost/dudu?autoReconnect=true&useUnicode=true&cha

racterEncoding=utf-8

 

db-load:

(connection.DriverManagerConnectionProvider 143 ) cleaning up connection pool: j

dbc:mysql://localhost/dudu?autoReconnect=true&useUnicode=true&characterEncoding=

utf-8

   [dbunit] Executing operation: CLEAN_INSERT

   [dbunit]           on   file: E:/dudu/metadata/sql/sample-data.xml

   [dbunit]           with format: xml

 

setup-db:

 

BUILD SUCCESSFUL

Total time: 1 minute 6 seconds

 

    Ø 生成的person表

    mysql> desc person;

+------------+-------------+------+-----+---------+-------+

| Field      | Type        | Null | Key | Default | Extra |

+------------+-------------+------+-----+---------+-------+

| id         | bigint(20)  |      | PRI | 0       |       |

| first_name | varchar(50) |      |     |         |       |

| last_name  | varchar(50) |      |     |         |       |

+------------+-------------+------+-----+---------+-------+

3 rows in set (0.00 sec)

 

Ø 生成的Person..hbm.xml

    <?xml version="1.0" encoding="UTF-8"?>

 

<!DOCTYPE hibernate-mapping PUBLIC

    "-//Hibernate/Hibernate Mapping DTD 2.0//EN"

    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

 

<hibernate-mapping>

    <class

        name="org.dudu.model.Person"

        table="person"

        dynamic-update="false"

        dynamic-insert="false"

        select-before-update="false"

        optimistic-lock="version"

    >

        <id

            name="id"

            column="id"

            type="java.lang.Long"

            unsaved-value="null"

        >

            <generator class="increment">

              <!-- 

                  To add non XDoclet generator parameters, create a file named

                  hibernate-generator-params-Person.xml

                  containing the additional parameters and place it in your merge dir.

              -->

            </generator>

        </id>

        <property

            name="firstName"

            type="java.lang.String"

            update="true"

            insert="true"

            access="property"

            column="first_name"

            length="50"

            not-null="true"

        />

        <property

            name="lastName"

            type="java.lang.String"

            update="true"

            insert="true"

            access="property"

            column="last_name"

            length="50"

            not-null="true"

        />

        <!--

            To add non XDoclet property mappings, create a file named

                hibernate-properties-Person.xml

            containing the additional properties and place it in your merge dir.

        -->

    </class>

</hibernate-mapping>