dorado 在页面展示表格【表格的实体类不和数据库中单一表关联】

最新推荐文章于 2021-11-16 15:51:04 发布

puspos

最新推荐文章于 2021-11-16 15:51:04 发布

阅读量172

点赞数

分类专栏： dorado

本文链接：https://blog.csdn.net/puspos/article/details/113885659

版权

dorado 专栏收录该内容

61 篇文章 4 订阅

订阅专栏

本文介绍了如何实现Serializable的CheckOrder类，包括构造函数、getter和setter方法，以及重写toString、hashCode和equals方法。同时展示了如何通过SQL查询从数据库中获取数据并转换为CheckOrder对象列表。

摘要由CSDN通过智能技术生成

创建实体类

//实现Serializable ,有参无参，set,get,equal,toString,hashCode
import java.io.Serializable;
import java.math.BigDecimal;

public class CheckOrder implements Serializable {
	private String apiName;
	private Integer num;
	
	public CheckOrder() {
		super();
	}

	public CheckOrder(String apiName, Integer num) {
		super();
		this.apiName = apiName;
		this.num = num;
		
	}

	public String getApiName() {
		return apiName;
	}

	public void setApiName(String apiName) {
		this.apiName = apiName;
	}

	public Integer getNum() {
		return num;
	}

	public void setNum(Integer num) {
		this.num = num;
	}

	

	@Override
	public String toString() {
		return "CheckOrder [apiName=" + apiName + ", num=" + num
				+  "]";
	}

	@Override
	public int hashCode() {
		final int prime = 31;
		int result = 1;
		result = prime * result + ((apiName == null) ? 0 : apiName.hashCode());
		
		result = prime * result
				+ ((num == null) ? 0 : num.hashCode());
		
		return result;
	}

	@Override
	public boolean equals(Object obj) {
		if (this == obj)
			return true;
		if (obj == null)
			return false;
		if (getClass() != obj.getClass())
			return false;
		CheckOrder other = (CheckOrder) obj;
		if (apiName == null) {
			if (other.apiName != null)
				return false;
		} else if (!apiName.equals(other.apiName))
			return false;
		
		if (num == null) {
			if (other.num != null)
				return false;
		} else if (!num.equals(other.num))
			return false;
		
		return true;
	}
	
	
}

后台

//集成到了HelpDao中,只需要helpDao.find即可
String sql="select api.name apiName,pm.num num "+ 
				"from papr "+ 
				"left join pm on papr.package_id=pm.id  "+ 
				"left join api on pm.api_id=api.id where api.id=1 and pm.num=10000 and papr.level=0";
SQLQuery q = s.createSQLQuery(sql);
q.addScalar("apiName",StandardBasicTypes.STRING);
q.addScalar("num",StandardBasicTypes.INTEGER);
q.setResultTransformer(Transformers.aliasToBean(Entity.class));
List<CheckOrder> list2 = q.list();