今天在写程序的时候出现了一个问题
两张表 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;
}
不知道行业里还有没有更好的方法