db设计

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- 
    Mapping file autogenerated by MyEclipse Persistence Tools
-->
<hibernate-mapping>
    <class name="com.feiying.lottery.pojo.Commission" table="Commission">
        <id name="id" type="java.lang.Integer">
            <column name="id" />
            <generator class="native">
            <param name="sequence">COMMISSION_SEQ</param>
            </generator>
        </id>
        <property name="no" type="java.lang.Integer">
            <column name="no" length="11" />
        </property>
        <property name="user_operatorId" type="java.lang.Integer">
            <column name="user_operatorid" length="11" />
        </property>
        <property name="user_operatorAcc" type="java.lang.String">
            <column name="user_operatoracc" length="255" />
        </property>         
        <property name="commission_type" type="java.lang.String">
            <column name="commission_type" length="255" />
        </property>
        <property name="commission_name" type="java.lang.String">
            <column name="commission_name" length="255" />
        </property>
        <property name="commission_singleMin" type="java.lang.Integer">
            <column name="commission_singlemin" length="11" />
        </property>
        <property name="commission_singleMax" type="java.lang.Integer">
            <column name="commission_singlemax" length="11" />
        </property>
        <property name="commission_singleProMax" type="java.lang.Integer">
            <column name="commission_singlepromax" length="11" />
        </property>
        <property name="commission_startNumber" type="java.lang.Integer">
            <column name="commission_startnumber" length="11" />
        </property>
        <property name="commission_endNumber" type="java.lang.Integer">
            <column name="commission_endnumber" length="11" />
        </property>
        <property name="commission_percent" type="java.lang.Float">
            <column name="commission_percent" length="11" />
        </property>  
        <property name="commission_otherPercent" type="java.lang.Float">
            <column name="commission_otherpercent" length="11" />
        </property> 
        <property name="commission_desc" type="java.lang.String">
            <column name="commission_desc" length="255" />
        </property> 
    </class>
</hibernate-mapping>

package com.feiying.lottery.pojo;


import java.io.Serializable;
import java.util.Date;


public class Commission implements Serializable {
/**
* 
*/
private static final long serialVersionUID = -6945221782176629115L;
private int id;
private int no;
private int user_operatorId;
private String user_operatorAcc;
private String commission_type;
private String commission_name;
private int commission_singleMin;
private int commission_singleMax;
private int commission_singleProMax;
private int commission_startNumber;
private int commission_endNumber;
private float commission_percent;
private float commission_otherPercent;
private String commission_desc;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public int getNo() {
return no;
}
public void setNo(int no) {
this.no = no;
}
public int getUser_operatorId() {
return user_operatorId;
}
public void setUser_operatorId(int user_operatorId) {
this.user_operatorId = user_operatorId;
}
public String getUser_operatorAcc() {
return user_operatorAcc;
}
public void setUser_operatorAcc(String user_operatorAcc) {
this.user_operatorAcc = user_operatorAcc;
}
public String getCommission_type() {
return commission_type;
}
public void setCommission_type(String commission_type) {
this.commission_type = commission_type;
}
public String getCommission_name() {
return commission_name;
}
public void setCommission_name(String commission_name) {
this.commission_name = commission_name;
}
public int getCommission_singleMin() {
return commission_singleMin;
}
public void setCommission_singleMin(int commission_singleMin) {
this.commission_singleMin = commission_singleMin;
}
public int getCommission_singleMax() {
return commission_singleMax;
}
public void setCommission_singleMax(int commission_singleMax) {
this.commission_singleMax = commission_singleMax;
}
public int getCommission_singleProMax() {
return commission_singleProMax;
}
public void setCommission_singleProMax(int commission_singleProMax) {
this.commission_singleProMax = commission_singleProMax;
}
public int getCommission_startNumber() {
return commission_startNumber;
}
public void setCommission_startNumber(int commission_startNumber) {
this.commission_startNumber = commission_startNumber;
}
public int getCommission_endNumber() {
return commission_endNumber;
}
public void setCommission_endNumber(int commission_endNumber) {
this.commission_endNumber = commission_endNumber;
}
public float getCommission_percent() {
return commission_percent;
}
public void setCommission_percent(float commission_percent) {
this.commission_percent = commission_percent;
}
public float getCommission_otherPercent() {
return commission_otherPercent;
}
public void setCommission_otherPercent(float commission_otherPercent) {
this.commission_otherPercent = commission_otherPercent;
}
public String getCommission_desc() {
return commission_desc;
}
public void setCommission_desc(String commission_desc) {
this.commission_desc = commission_desc;
}
}

dba setting:

-- ----------------------------

-- Table structure for `commission`
-- ----------------------------
DROP TABLE IF EXISTS `commission`;
CREATE TABLE `commission` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `NO` int(11) NOT NULL,
  `USER_OPERATORID` int(12) NOT NULL,
  `USER_OPERATORACC` varchar(255) NOT NULL,
  `COMMISSION_TYPE` varchar(255) NOT NULL,
  `COMMISSION_NAME` varchar(255) NOT NULL,
  `COMMISSION_SINGLEMIN` int(11) NOT NULL,
  `COMMISSION_SINGLEMAX` int(11) NOT NULL,
  `COMMISSION_SINGLEPROMAX` int(11) NOT NULL,
  `COMMISSION_STARTNUMBER` int(11) DEFAULT NULL,
  `COMMISSION_ENDNUMBER` int(11) DEFAULT NULL,
  `COMMISSION_PERCENT` float(4,3) NOT NULL,
  `COMMISSION_OTHERPERCENT` float(4,3) NOT NULL,
  `COMMISSION_DESC` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=gbk;


-- ----------------------------
-- Records of commission
-- ----------------------------
INSERT INTO `commission` VALUES ('1', '1', '2', 'zdl', 'tema_apan', '特码', '2', '20000', '0', '0', '300000', '0.020', '0.130', '');
INSERT INTO `commission` VALUES ('2', '2', '2', 'zdl', 'zhengma', '正码', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('3', '3', '2', 'zdl', '2mian', '两面', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('4', '4', '2', 'zdl', '2quanzhong', '二全中', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('5', '5', '2', 'zdl', '2zhongte', '二中特', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('6', '6', '2', 'zdl', 'techuan', '特串', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('7', '7', '2', 'zdl', '3quanzhong', '三全中', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('8', '8', '2', 'zdl', '3zhong2', '三中二', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('9', '9', '2', 'zdl', 'bose', '波色', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('10', '10', '2', 'zdl', 'shengxiao', '生肖', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('11', '12', '2', 'zdl', 'zheng1te', '正1特', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('12', '13', '2', 'zdl', 'zheng2te', '正2特', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('13', '14', '2', 'zdl', 'zheng3te', '正3特', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('14', '15', '2', 'zdl', 'zheng4te', '正4特', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('15', '16', '2', 'zdl', 'zheng5te', '正5特', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('16', '17', '2', 'zdl', 'zheng6te', '正6特', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('17', '17', '2', 'zdl', 'weishu', '尾数', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('18', '19', '2', 'zdl', 'banbo', '半波', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('19', '20', '2', 'zdl', 'liuxiao', '六肖', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('20', '21', '2', 'zdl', 'yixiao', '一肖', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('21', '22', '2', 'zdl', '5buzhong', '五不中', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('22', '23', '2', 'zdl', '6buzhong', '六不中', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('23', '24', '2', 'zdl', '7buzhong', '七不中', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('24', '25', '2', 'zdl', '8buzhong', '八不中', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('25', '26', '2', 'zdl', '9buzhong', '九不中', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('26', '27', '2', 'zdl', '10buzhong', '十不中', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('27', '28', '2', 'zdl', '2xiaozhong', '二肖中', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('28', '29', '2', 'zdl', '3xiaozhong', '三肖中', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('29', '30', '2', 'zdl', '4xiaozhong', '四肖中', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('30', '31', '2', 'zdl', '2xiaobuzhong', '二肖不中', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('31', '32', '2', 'zdl', '3xiaobuzhong', '三肖不中', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('32', '33', '2', 'zdl', '4xiaobuzhong', '四肖不中', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('33', '34', '2', 'zdl', '2weizhong', '二尾中', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('34', '35', '2', 'zdl', '3weizhong', '三尾中', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('35', '36', '2', 'zdl', '4weizhong', '四尾中', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('36', '37', '2', 'zdl', '2weibuzhong', '二尾不中', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('37', '38', '2', 'zdl', '3weibuzhong', '三尾不中', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('38', '39', '2', 'zdl', '4weibuzhong', '四尾不中', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('39', '40', '2', 'zdl', '1xiaobuzhong', '一肖不中', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('40', '41', '2', 'zdl', 'weishubuzhong', '尾数不中', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('41', '42', '2', 'zdl', '5zhong1', '五中一', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('42', '45', '2', 'zdl', '6zhong1', '六中一', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('43', '44', '2', 'zdl', '7zhong1', '七中一', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('44', '45', '2', 'zdl', '8zhong1', '八中一', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('45', '46', '2', 'zdl', '9zhong1', '九中一', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('46', '47', '2', 'zdl', '10zhong1', '十中一', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('47', '48', '2', 'zdl', '7ma', '七码', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('48', '49', '2', 'zdl', '5xing', '五行', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('49', '50', '2', 'zdl', '1lirenzhong', '一粒任中', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('50', '51', '2', 'zdl', '2lirenzhong', '二粒任中', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('51', '52', '2', 'zdl', '3lirenzhong', '三粒任中', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('52', '53', '2', 'zdl', '4lirenzhong', '四粒任中', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('53', '54', '2', 'zdl', '5lirenzhong', '五粒任中', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');
INSERT INTO `commission` VALUES ('54', '11', '2', 'zdl', 'guoguan', '过关', '2', '20000', '0', '0', '300000', '0.010', '0.100', '');