struts面试 考题

create database if not exists news;
drop table if exists newssort;
create table newssort
(
 nid int primary key AUTO_INCREMENT
 sort varchar(50)
);

drop table if exists news;
create table news
(
 cid int primary key AUTO_INCREMENT
 title varchar(50) not null
 content varchar(500) not null
 nid int null
);

insert into newssort values(null'娱乐');
insert into newssort values(null'时事');

insert into news values(null'好事''好事连连哈哈'1);
insert into news values(null'坏事''坏事不断'1);
insert into news values(null'爱情是什么''爱情是什么啊还没知道呢'2);
insert into news values(null'什么啊''测试内容'2);

select * from news;
select * from newssort;

package com.vo;

import java.io.Serializable;

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

@SuppressWarnings("serial")
@Entity
@Table(name="news")
public class News implements Serializable
{
 private Integer cid;
 private String title;
 private String content;
 @Id
 @GeneratedValue(strategy=GenerationType.AUTO)
 public Integer getCid()
 {
 return cid;
 }

 public void setCid(Integer cid)
 {
 this.cid = cid;
 }

 public String getTitle()
 {
 return title;
 }

 public void setTitle(String title)
 {
 this.title = title;
 }

 public String getContent()
 {
 return content;
 }

 public void setContent(String content)
 {
 this.content = content;
 }
}

package com.vo;

import java.io.Serializable;
import java.util.ArrayList;
import java.util.List;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.OneToMany;
import javax.persistence.Table;

import org.hibernate.annotations.LazyCollection;
import org.hibernate.annotations.LazyCollectionOption;

@SuppressWarnings("serial")
@Entity
@Table(name = "newssort")
public class Newssort implements Serializable
{
 private Integer nid;
 private String sort;
 private List news = new ArrayList();
 @OneToMany
 @JoinColumn(name="nid")
 @LazyCollection(LazyCollectionOption.FALSE)
 public List getNews()
 {
 return news;
 }

 public void setNews(List news)
 {
 this.news = news;
 }

 @Id
 @GeneratedValue(strategy = GenerationType.AUTO)
 public Integer getNid()
 {
 return nid;
 }

 public void setNid(Integer nid)
 {
 this.nid = nid;
 }
 
 public String getSort()
 {
 return sort;
 }

 public void setSort(String sort)
 {
 this.sort = sort;
 }
}