使用Hibernate多对一关联表出现的小问题

今天在写程序的时候出现了一个问题

两张表 User 用户表 Article 文章表 

一个用户对应多个文章 一个文章只对应一个用户

下面是代码：

</pre>User.java<p><pre name="code" class="html">package ssh.entity;

import java.util.Date;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;

@Entity
public class User {

	private int id;
	private String username;
	private String password;
	private String gender;
	private Date reg_time;
	
	@Id
	@GeneratedValue
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	public String getGender() {
		return gender;
	}
	public void setGender(String gender) {
		this.gender = gender;
	}
	public Date getReg_time() {
		return reg_time;
	}
	public void setReg_time(Date reg_time) {
		this.reg_time = reg_time;
	}
}

Article.java

package ssh.entity;

import java.util.Date;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;

@Entity
public class Article {

	private int id;
	private String title;
	private String context;
	private User user;
	private Date publish_time;
	private float soccer;
	
	@Id
	@GeneratedValue
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getTitle() {
		return title;
	}
	public void setTitle(String title) {
		this.title = title;
	}
	public String getContext() {
		return context;
	}
	public void setContext(String context) {
		this.context = context;
	}
	
	@ManyToOne
	public User getUser() {
		return user;
	}
	public void setUser(User user) {
		this.user = user;
	}
	
	public Date getPublish_time() {
		return publish_time;
	}
	public void setPublish_time(Date publish_time) {
		this.publish_time = publish_time;
	}
	public float getSoccer() {
		return soccer;
	}
	public void setSoccer(float soccer) {
		this.soccer = soccer;
	}
}

问题来了 当我要在页面提取文章时 要显示文章的作者 但是数据表中 是以user_id 作为外键 来关联的 而不是username

然后我想了办法 创建了个新的Article表 ArticleVirtual表 ：

package ssh.entity;

import java.util.Date;

public class ArticleVirtual {

	private int id;
	private String title;
	private String context;
	private String username;
	private Date publish_time;
	private float soccer;
	
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getTitle() {
		return title;
	}
	public void setTitle(String title) {
		this.title = title;
	}
	public String getContext() {
		return context;
	}
	public void setContext(String context) {
		this.context = context;
	}
	public String getUsername() {
		return username;
	}
	public void setUsername(String username) {
		this.username = username;
	}
	public Date getPublish_time() {
		return publish_time;
	}
	public void setPublish_time(Date publish_time) {
		this.publish_time = publish_time;
	}
	public float getSoccer() {
		return soccer;
	}
	public void setSoccer(float soccer) {
		this.soccer = soccer;
	}
}

Article与ArticleVirtual的区别在于 后者以username来取代了user_id 这样我在提取数据的时候 可以显示文章作者的名字而不是id

public List<ArticleVirtual> getAll(){
		List<Article> articles = (List<Article>)hibernateTemplate.find("from Article");
		List<ArticleVirtual> articleVirtual = new ArrayList<ArticleVirtual>();
		for(int i=0; i<articles.size(); i++){
			
			int id = articles.get(i).getId();
			String title = articles.get(i).getTitle();
			String context = articles.get(i).getContext();
			String username = articles.get(i).getUser().getUsername();
			Date publish_time = articles.get(i).getPublish_time();
			float soccer = articles.get(i).getSoccer();
			
			ArticleVirtual articlevirtual = new ArticleVirtual();
			
			articlevirtual.setId(id);
			articlevirtual.setTitle(title);
			articlevirtual.setContext(context);
			articlevirtual.setPublish_time(publish_time);
			articlevirtual.setUsername(username);
			articlevirtual.setSoccer(soccer);
		
			articleVirtual.add(articlevirtual);
		}
		return articleVirtual;
	}

以后 需要显示显示文章和文章作者的时候 就用ArticleVirtual
不知道行业里还有没有更好的方法