打印本文 打印本文 关闭窗口 关闭窗口
STRUTS+HIBERNATE+ORACLE分页
作者:武汉SEO闵涛  文章来源:敏韬网  点击数2725  更新时间:2009/4/22 22:04:15  文章录入:mintao  责任编辑:mintao

主要由:
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]  下一页

打印本文 打印本文 关闭窗口 关闭窗口