create table elements (id integer(3) IDENTITY,
name char(30),
number char(30),
mass char(30),
symbol char(2));
CREATE UNIQUE INDEX ui_elements_pk ON elements (symbol)insert into elements ( name, number, mass, symbol) values ('Manganese','25','55','Mn');insert into elements ( name, number, mass, symbol) values ('Zinc','30','65','Zn');insert into elements ( name, number, mass, symbol) values ('Thulium','69','169','Tm');insert into elements ( name, number, mass, symbol) values ('Californium','98','251','Cf');insert into elements ( name, number, mass, symbol) values ('Gold','79','197','Au');insert into elements ( name, number, mass, symbol) values ('Ytterbium','70','173','Yb');insert into elements ( name, number, mass, symbol) values ('Molybdenum','42','96','Mo');insert into elements ( name, number, mass, symbol) values ('Palladium','46','106','Pd');
package com.strutsrecipes.hibernate.beans;public class Element ...{
private String name;
private String symbol;
private String number;
private String mass;
private int id;
public Element() ...{ super();
} public Element(String name, String symbol, String number, String mass) ...{
this.name = name;
this.symbol = symbol;
this.number = number;
this.mass = mass;
} public int getId() ...{ return id;
} public void setId(int id) ...{ this.id = id;
} public String getMass() ...{ return mass;
} public String getName() ...{ return name;
} public String getNumber() ...{ return number;
} public String getSymbol() ...{ return symbol;
} public void setMass(String mass) ...{ this.mass = mass;
} public void setName(String name) ...{ this.name = name;
} public void setNumber(String number) ...{ this.number = number;
} public void setSymbol(String symbol) ...{ this.symbol = symbol;
}}
<?xml version="1.0"?><!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN" "http://hibernate.sf.net/hibernate-mapping-2.0.dtd"><hibernate-mapping>
<class name="com.strutsrecipes.hibernate.beans.Element" table="elements">
<id name="id" column="id">
<generator class="native"/>
</id>
<property name="name" column="name"/>
<property name="number" column="number"/>
<property name="mass" column="mass"/>
<property name="symbol" column="symbol"/>
</class></hibernate-mapping>
<?xml version='1.0' encoding='utf-8'?><!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN" "http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd"><hibernate-configuration>
<session-factory>
<property name="dialect">net.sf.hibernate.dialect.HSQLDialect</property>
<property name="connection.driver_class">org.hsqldb.jdbcDriver</property>
<property name="connection.username">sa</property> <property name="connection.password"></property> <property name="connection.url">jdbc:hsqldb:hsql://127.0.0.1</property>
<property name="show_sql"> </property> <property name="">true</property>
<mapping resource="/com/strutscookbook/hibernate/beans/Element.hbm.xml"/></session-factory></hibernate-configuration>
| 第1页:
Struts处方:Hibernate与Struts} <... |