主要由: message.jsp MessageForm MessageAction Player.hbm.xml struts-config.xml MeisaiBean.java 来实现: 先看数据库结构: CREATE TABLE player ( PLAYER_ID VARCHAR(32) PRIMARY KEY, TEAM VARCHAR(3), displayName VARCHAR(100), LAST_NAME VARCHAR(100), MIDDLE_NAME VARCHAR(100), STATUS VARCHAR(32), POS VARCHAR(1), PPG INTEGER default 25 );
INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''2113999'''',''''DAL'''',''''Dirk'''',null,'''''''',null,''''F''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''30361'''',''''IND'''',''''Ron'''',''''Artest'''','''''''',''''A'''',''''G''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''30273'''',''''ORL'''',''''Tracy'''',''''McGrady'''','''''''',''''A'''',''''F''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''30190'''',''''LAL'''',''''Kobe'''',''''Bryant'''','''''''',''''A'''',''''G''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''30328'''',''''SEA'''',''''Rashard'''',''''Lewis'''','''''''',''''A'''',''''G''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''30197'''',''''NJN'''',''''Kerry'''',''''Kittles'''','''''''',''''A'''',''''G''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''30341'''',''''HOU'''',''''Steve'''',''''Francis'''','''''''',''''A'''',''''G''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''30146'''',''''MIN'''',''''Kevin'''',''''Garnett'''','''''''',''''A'''',''''F''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''2113993'''',''''BOS'''',''''Paul'''',''''Pierce'''','''''''',''''A'''',''''G''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''30050'''',''''NJN'''',''''Jason'''',''''Kidd'''','''''''',''''A'''',''''G''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''30215'''',''''ATL'''',''''Shareef'''',''''Abdur-Rahim'''','''''''',''''I'''',''''F''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''1861922'''',''''ORL'''',''''Mike'''',''''Miller'''','''''''',''''I'''',''''F''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''30144'''',''''ATL'''',''''Glenn'''',''''Robinson'''','''''''',''''A'''',''''F''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''2019703'''',''''GSW'''',''''Gilbert'''',''''Arenas'''','''''''',''''A'''',''''G''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''2028505'''',''''UTH'''',''''Andrei'''',''''Kirilenko'''','''''''',''''I'''',''''F''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''30382'''',''''PHO'''',''''Shawn'''',''''Marion'''','''''''',''''A'''',''''F''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''29941'''',''''SEA'''',''''Brent'''',''''Barry'''','''''''',''''A'''',''''G''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''2114000'''',''''DAL'''',''''Michael'''',''''Finley'''','''''''',''''A'''',''''G''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''30187'''',''''BOS'''',''''Antoine'''',''''Walker'''','''''''',''''A'''',''''F''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''30234'''',''''SAC'''',''''Bobby'''',''''Jackson'''','''''''',''''A'''',''''G''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''29968'''',''''WAS'''',''''Jerry'''',''''Stackhouse'''','''''''',''''A'''',''''G''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''29944'''',''''SAC'''',''''Doug'''',''''Christie'''','''''''',''''I'''',''''G''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''30095'''',''''CHI'''',''''Donyell'''',''''Marshall'''','''''''',''''A'''',''''F''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''2028865'''',''''ATL'''',''''Ira'''',''''Newble'''','''''''',''''A'''',''''F''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''30029'''',''''SEA'''',''''Gary'''',''''Payton'''','''''''',''''A'''',''''G''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''30141'''',''''TOR'''',''''Voshon'''',''''Lenard'''','''''''',''''A'''',''''G''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''30020'''',''''MIL'''',''''Toni'''',''''Kukoc'''','''''''',''''A'''',''''F''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''30154'''',''''NOR'''',''''P.J.'''',''''Brown'''','''''''',''''A'''',''''F''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''30125'''',''''MIA'''',''''Eddie'''',''''Jones'''','''''''',''''A'''',''''G''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''30359'''',''''ATL'''',''''Jason'''',''''Terry'''','''''''',''''A'''',''''G''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''30291'''',''''UTH'''',''''Matt'''',''''Harpring'''','''''''',''''A'''',''''F''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''30228'''',''''MIL'''',''''Ray'''',''''Allen'''','''''''',''''A'''',''''G''''); INSERT INTO player (PLAYER_ID,TEAM,displayName,LAST_NAME,MIDDLE_NAME,STATUS,POS) VALUES (''''2028503'''',''''SEA'''',''''Vladimir'''',''''Radmanovic'''','''''''',''''A'''',''''F''''); 对应的player.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>
<!-- test player--> <class name="com.ecc.hibernate.hbm.Player" table="PLAYER"> <id name="PlayerId" column="player_id" type="string" length="32"> <generator class="uuid.string"/> </id> <property name="Team" column="team" type="string" length="3"/> <property name="DisplayName" column="displayname" type="string" length="100"/> <property name="LastName" column="last_name" type="string" length="100"/> <property name="MiddleName" column="middle_name" type="string" length="100"/> <property name="Status" column="status" type="string" length="32"/> <property name="Pos" column="pos" type="string" length="1"/> <property name="Ppg" column="ppg" type="long" length="22"/> </class> </hibernate-mapping> 现在看MeisaiBean.java package com.ecc.util;
import java.io.Serializable;
public class MeisaiBean implements Serializable{
public MeisaiBean() { }
public String label_1 = ""; public void setLabel_1(String str) { this.label_1 = str; }
public String getLabel_1() { return this.label_1; }
public String label_2 = ""; public void setLabel_2(String str) { this.label_2 = str; }
public String getLabel_2() { return this.label_2; }
public String label_3 = ""; public void setLabel_3(String str) { this.label_3 = str; }
public String getLabel_3() { return this.label_3; }
public String label_4 = ""; public void setLabel_4(String str) { this.label_4 = str; }
public String getLabel_4() { return this.label_4; }
public String label_5 = ""; public void setLabel_5(String str) { this.label_5 = str; }
public String getLabel_5() { return this.label_5; }
public String label_6 = ""; public void setLabel_6(String str) { this.label_6 = str; }
public String getLabel_6() { return this.label_6; }
public String label_7 = ""; public void setLabel_7(String str) { this.label_7 = str; }
public String getLabel_7() { return this.label_7; }
public String label_8 = ""; public void setLabel_8(String str) { this.label_8 = str; }
public String getLabel_8() { return this.label_8; }
public String label_9 = ""; public void setLabel_9(String str) { this.label_9 = str; }
public String getLabel_9() { return this.label_9;
[1] [2] [3] 下一页 [系统软件]EXP-00008: ORACLE error 904 encountered的解决方… [常用软件]PB7 连接 Oracle 的配置方法 [Web开发]oracle Export and Import 简介 [Web开发]ADO访问Oracle结果集的心得 [JAVA开发]Struts+Spring+Hibernate组装web应用 [JAVA开发]JAVA:Hibernate 3新增XML关系持久性介绍 [JAVA开发]扩展 Hibernate 对各类数据源支持 [JAVA开发]Hibernate 3.0 的Formulas编程 [JAVA开发]Hibernate 3.0 的规则应用分析 [JAVA开发]Hibernate 3新增XML关系持久性介绍
|