Hibernate 查询 view

package com.SAFAS.mobilecatch.server.hibernate.model;

/**
* V4cDiseasesprevention entity.
*
* @author MyEclipse Persistence Tools
*/

public class V4cDiseasesprevention implements java.io.Serializable {

// Fields

private V4cDiseasespreventionId id;

// Constructors

/** default constructor */
public V4cDiseasesprevention() {
}

/** full constructor */
public V4cDiseasesprevention(V4cDiseasespreventionId id) {
this.id = id;
}

// Property accessors

public V4cDiseasespreventionId getId() {
return this.id;
}

public void setId(V4cDiseasespreventionId id) {
this.id = id;
}

}

package com.SAFAS.mobilecatch.server.hibernate.model;

/**
* V4cDiseasespreventionId entity.
*
* @author MyEclipse Persistence Tools
*/

public class V4cDiseasespreventionId implements java.io.Serializable {

// Fields

private Integer produceClassify4id;
private String produceClassify4name;
private Short qualityStandardId;
private Short environmentStandardId;
private Short producingRuleId;
private Short produceSampleStandardId;
private String producingRuleCode;
private String producingRuleName;
private String remark;
private String pesticideName;
private String preventionMethod;

// Constructors

/** default constructor */
public V4cDiseasespreventionId() {
}

/** minimal constructor */
public V4cDiseasespreventionId(Integer produceClassify4id) {
this.produceClassify4id = produceClassify4id;
}

/** full constructor */
public V4cDiseasespreventionId(Integer produceClassify4id,
String produceClassify4name, Short qualityStandardId,
Short environmentStandardId, Short producingRuleId,
Short produceSampleStandardId, String producingRuleCode,
String producingRuleName, String remark, String pesticideName,
String preventionMethod) {
this.produceClassify4id = produceClassify4id;
this.produceClassify4name = produceClassify4name;
this.qualityStandardId = qualityStandardId;
this.environmentStandardId = environmentStandardId;
this.producingRuleId = producingRuleId;
this.produceSampleStandardId = produceSampleStandardId;
this.producingRuleCode = producingRuleCode;
this.producingRuleName = producingRuleName;
this.remark = remark;
this.pesticideName = pesticideName;
this.preventionMethod = preventionMethod;
}

// Property accessors

public Integer getProduceClassify4id() {
return this.produceClassify4id;
}

public void setProduceClassify4id(Integer produceClassify4id) {
this.produceClassify4id = produceClassify4id;
}

public String getProduceClassify4name() {
return this.produceClassify4name;
}

public void setProduceClassify4name(String produceClassify4name) {
this.produceClassify4name = produceClassify4name;
}

public Short getQualityStandardId() {
return this.qualityStandardId;
}

public void setQualityStandardId(Short qualityStandardId) {
this.qualityStandardId = qualityStandardId;
}

public Short getEnvironmentStandardId() {
return this.environmentStandardId;
}

public void setEnvironmentStandardId(Short environmentStandardId) {
this.environmentStandardId = environmentStandardId;
}

public Short getProducingRuleId() {
return this.producingRuleId;
}

public void setProducingRuleId(Short producingRuleId) {
this.producingRuleId = producingRuleId;
}

public Short getProduceSampleStandardId() {
return this.produceSampleStandardId;
}

public void setProduceSampleStandardId(Short produceSampleStandardId) {
this.produceSampleStandardId = produceSampleStandardId;
}

public String getProducingRuleCode() {
return this.producingRuleCode;
}

public void setProducingRuleCode(String producingRuleCode) {
this.producingRuleCode = producingRuleCode;
}

public String getProducingRuleName() {
return this.producingRuleName;
}

public void setProducingRuleName(String producingRuleName) {
this.producingRuleName = producingRuleName;
}

public String getRemark() {
return this.remark;
}

public void setRemark(String remark) {
this.remark = remark;
}

public String getPesticideName() {
return this.pesticideName;
}

public void setPesticideName(String pesticideName) {
this.pesticideName = pesticideName;
}

public String getPreventionMethod() {
return this.preventionMethod;
}

public void setPreventionMethod(String preventionMethod) {
this.preventionMethod = preventionMethod;
}

public boolean equals(Object other) {
if ((this == other))
return true;
if ((other == null))
return false;
if (!(other instanceof V4cDiseasespreventionId))
return false;
V4cDiseasespreventionId castOther = (V4cDiseasespreventionId) other;

return ((this.getProduceClassify4id() == castOther
.getProduceClassify4id()) || (this.getProduceClassify4id() != null
&& castOther.getProduceClassify4id() != null && this
.getProduceClassify4id().equals(
castOther.getProduceClassify4id())))
&& ((this.getProduceClassify4name() == castOther
.getProduceClassify4name()) || (this
.getProduceClassify4name() != null
&& castOther.getProduceClassify4name() != null && this
.getProduceClassify4name().equals(
castOther.getProduceClassify4name())))
&& ((this.getQualityStandardId() == castOther
.getQualityStandardId()) || (this
.getQualityStandardId() != null
&& castOther.getQualityStandardId() != null && this
.getQualityStandardId().equals(
castOther.getQualityStandardId())))
&& ((this.getEnvironmentStandardId() == castOther
.getEnvironmentStandardId()) || (this
.getEnvironmentStandardId() != null
&& castOther.getEnvironmentStandardId() != null && this
.getEnvironmentStandardId().equals(
castOther.getEnvironmentStandardId())))
&& ((this.getProducingRuleId() == castOther
.getProducingRuleId()) || (this.getProducingRuleId() != null
&& castOther.getProducingRuleId() != null && this
.getProducingRuleId().equals(
castOther.getProducingRuleId())))
&& ((this.getProduceSampleStandardId() == castOther
.getProduceSampleStandardId()) || (this
.getProduceSampleStandardId() != null
&& castOther.getProduceSampleStandardId() != null && this
.getProduceSampleStandardId().equals(
castOther.getProduceSampleStandardId())))
&& ((this.getProducingRuleCode() == castOther
.getProducingRuleCode()) || (this
.getProducingRuleCode() != null
&& castOther.getProducingRuleCode() != null && this
.getProducingRuleCode().equals(
castOther.getProducingRuleCode())))
&& ((this.getProducingRuleName() == castOther
.getProducingRuleName()) || (this
.getProducingRuleName() != null
&& castOther.getProducingRuleName() != null && this
.getProducingRuleName().equals(
castOther.getProducingRuleName())))
&& ((this.getRemark() == castOther.getRemark()) || (this
.getRemark() != null
&& castOther.getRemark() != null && this.getRemark()
.equals(castOther.getRemark())))
&& ((this.getPesticideName() == castOther.getPesticideName()) || (this
.getPesticideName() != null
&& castOther.getPesticideName() != null && this
.getPesticideName()
.equals(castOther.getPesticideName())))
&& ((this.getPreventionMethod() == castOther
.getPreventionMethod()) || (this.getPreventionMethod() != null
&& castOther.getPreventionMethod() != null && this
.getPreventionMethod().equals(
castOther.getPreventionMethod())));
}

public int hashCode() {
int result = 17;

result = 37
* result
+ (getProduceClassify4id() == null ? 0 : this
.getProduceClassify4id().hashCode());
result = 37
* result
+ (getProduceClassify4name() == null ? 0 : this
.getProduceClassify4name().hashCode());
result = 37
* result
+ (getQualityStandardId() == null ? 0 : this
.getQualityStandardId().hashCode());
result = 37
* result
+ (getEnvironmentStandardId() == null ? 0 : this
.getEnvironmentStandardId().hashCode());
result = 37
* result
+ (getProducingRuleId() == null ? 0 : this.getProducingRuleId()
.hashCode());
result = 37
* result
+ (getProduceSampleStandardId() == null ? 0 : this
.getProduceSampleStandardId().hashCode());
result = 37
* result
+ (getProducingRuleCode() == null ? 0 : this
.getProducingRuleCode().hashCode());
result = 37
* result
+ (getProducingRuleName() == null ? 0 : this
.getProducingRuleName().hashCode());
result = 37 * result
+ (getRemark() == null ? 0 : this.getRemark().hashCode());
result = 37
* result
+ (getPesticideName() == null ? 0 : this.getPesticideName()
.hashCode());
result = 37
* result
+ (getPreventionMethod() == null ? 0 : this
.getPreventionMethod().hashCode());
return result;
}

}

V4cDiseasesprevention.hbm.xml

<?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.pickedpoint.SAFAS.mobilecatch.server.hibernate.model.V4cDiseasesprevention" table="v_4c_diseasesprevention" catalog="safas">
<composite-id name="id" class="com.pickedpoint.SAFAS.mobilecatch.server.hibernate.model.V4cDiseasespreventionId">
<key-property name="produceClassify4id" type="java.lang.Integer">
<column name="produceClassify_4ID" />
</key-property>
<key-property name="produceClassify4name" type="java.lang.String">
<column name="produceClassify_4Name" length="20" />
</key-property>
<key-property name="qualityStandardId" type="java.lang.Short">
<column name="qualityStandardID" />
</key-property>
<key-property name="environmentStandardId" type="java.lang.Short">
<column name="environmentStandardID" />
</key-property>
<key-property name="producingRuleId" type="java.lang.Short">
<column name="producingRuleID" />
</key-property>
<key-property name="produceSampleStandardId" type="java.lang.Short">
<column name="produceSampleStandardID" />
</key-property>
<key-property name="producingRuleCode" type="java.lang.String">
<column name="producingRuleCode" />
</key-property>
<key-property name="producingRuleName" type="java.lang.String">
<column name="producingRuleName" length="50" />
</key-property>
<key-property name="remark" type="java.lang.String">
<column name="remark" />
</key-property>
<key-property name="pesticideName" type="java.lang.String">
<column name="pesticideName" length="50" />
</key-property>
<key-property name="preventionMethod" type="java.lang.String">
<column name="preventionMethod" />
</key-property>
</composite-id>
</class>
</hibernate-mapping>

public List Query(){
Session session = HibernateSessionFactory.getSession();
Query query = session.createQuery("from V4cDiseasesprevention");
List list = query.list();
if(session.isOpen()){
session.close();
}
return list;
}

public List QueryByName(String produceClassify4name){
Session session = HibernateSessionFactory.getSession();
Query query = session.createQuery("from V4cDiseasesprevention where produceClassify4name = '" + produceClassify4name + "'");
List list = query.list();
if(session.isOpen()){
session.close();
}
return list;
}//不要使用别名~

//或者

public List QueryByName(String produceClassify4name){
Session session = HibernateSessionFactory.getSession();
Query query = session.createQuery("from V4cDiseasesprevention v where v.id.produceClassify4name = '" + produceClassify4name + "'");
List list = query.list();
if(session.isOpen()){
session.close();
}
return list;
}