一道Struts面试题

题目是这样的 
有两张表 
一张为新闻类别表 
有２个字段： 

nid(pk)         sort 


有一张新闻内容表 

有三个字段 

cid(pk)       nid(fk)     title     content 

要求通过下拉列表框的方法选择新闻类别然后显示该类别的新闻标题（在当前页中显示）
 我是用Struts2+Hibernate3.2+JPA实现的.
数据库脚本:

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;

两个VO类:
News.java:

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;
    }
}

 Newssort.java:

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> news = new ArrayList<News>();
    @OneToMany
    @JoinColumn(name="nid")
    @LazyCollection(LazyCollectionOption.FALSE)
    public List<News> getNews()
    {
        return news;
    }

    public void setNews(List<News> 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;
    }
}

写个测试类先测试一个持久层操作:

package  com.test;

import  java.util.Iterator;
import  org.hibernate.Session;
import  org.hibernate.cfg.AnnotationConfiguration;
import  org.junit.After;
import  org.junit.Before;

import  com.vo.News;
import  com.vo.Newssort;
public  class  Test
{
    private Session session ;
    @Before
    public void setUp()
    {
        session = new AnnotationConfiguration().configure().buildSessionFactory().openSession();
    }
    @After
    public void tearDown()
    {
        session.close();
    }
    
    @SuppressWarnings("unchecked")
    @org.junit.Test
    public void testFind()
    {
        @SuppressWarnings("unused")
        //List<Newssort> newssort = session.createCriteria(Newssort.class).list();
        Newssort newssort = (Newssort) session.load(Newssort.class, 2);
        for(Iterator<News> i = newssort.getNews().iterator();i .hasNext();)
        {
            String title = i.next().getTitle();
            System.out.println(title);
        }
    }
}

好了写Action
NewsAction:

package  com.web.action;

import  java.util.List;
import  java.util.Map;

import  org.hibernate.Session;
import  org.hibernate.cfg.AnnotationConfiguration;

import  com.opensymphony.xwork2.ActionContext;
import  com.opensymphony.xwork2.ActionSupport;
import  com.vo.News;
import  com.vo.Newssort;

@SuppressWarnings(  { "serial", "unchecked" } )
public  class  NewsAction extends  ActionSupport
{
    private Session session;
    private Integer sortid;

    public Integer getSortid()
    {
        return sortid;
    }

    public void setSortid(Integer sortid)
    {
        this.sortid = sortid;
    }

    public void init()
    {
        session = new AnnotationConfiguration().configure()
                .buildSessionFactory().openSession();
    }

    public String findNewssort()
    {
        this.init();
        List<Newssort> sorts = session.createCriteria(Newssort.class).list();
        Map request = (Map) ActionContext.getContext().get("request");
        request.put("sorts", sorts);
        session.close();
        return SUCCESS;
    }
    
    public String findNews()
    {
        this.init();
        System.out.println("findNews");
        List<Newssort> sorts = session.createCriteria(Newssort.class).list();
        Newssort newssort = (Newssort) session.load(Newssort.class, sortid);
        List<News> news = newssort.getNews();
        Map request = (Map) ActionContext.getContext().get("request");
        request.put("sorts", sorts);
        request.put("news", news);
        session.close();
        return SUCCESS;
    }
}

hibernate.cfg.xml:

<? xml version="1.0" encoding="UTF-8"?>
<! DOCTYPE hibernate-configuration PUBLIC
    "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
    "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
< hibernate-configuration>
    < session-factory>
        < property  name="dialect"> org.hibernate.dialect.MySQLDialect</ property>
        < property  name="connection.driver_class"> com.mysql.jdbc.Driver</ property>
        < property  name="connection.url"> jdbc:mysql://localhost:3306/news</ property>
        < property  name="connection.username"> root</ property>
        < property  name="connection.password"> root</ property>
        < property  name="show_sql"> true</ property>
         <!--  实体类映射  -->
        < mapping  class="com.vo.News"/>
        < mapping  class="com.vo.Newssort"/>
    </ session-factory>
</ hibernate-configuration>     

struts.xml:

<? xml version="1.0" encoding="UTF-8"?>
<! DOCTYPE struts PUBLIC
    "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
    "http://struts.apache.org/dtds/struts-2.0.dtd">
< struts>
    < package  name="com"  extends="struts-default">
        < action  name="findNewssort"  class="com.web.action.NewsAction"  method="findNewssort">
            < result  name="success"> /index.jsp</ result>
        </ action>
        
        < action  name="findNews"  class="com.web.action.NewsAction"  method="findNews">
            < result  name="success"> /index.jsp</ result>
        </ action>
    </ package>
</ struts>     

web.xml:

<? xml version="1.0" encoding="UTF-8" ?>
< web-app  version ="2.4"  xmlns ="http://java.sun.com/xml/ns/j2ee"
    xmlns:xsi ="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation ="http://java.sun.com/xml/ns/j2ee 
    http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd" >
     < filter >
         < filter-name >struts2 </ filter-name >
         < filter-class >
            org.apache.struts2.dispatcher.FilterDispatcher
         </ filter-class >
     </ filter >
     < filter-mapping >
         < filter-name >struts2 </ filter-name >
         < url-pattern >/* </ url-pattern >
     </ filter-mapping >
     < welcome-file-list >
         < welcome-file >prepare.jsp </ welcome-file >
     </ welcome-file-list >
</ web-app >

前台有两个jsp:
prapare.jsp:

<% @ page language="java" pageEncoding="GB18030" %>
< html >
   < head >
     < title >My JSP 'index.jsp' starting page </ title >
     < script  type ="text/javascript" >
        window.location = "findNewssort.action";
     </ script >
   </ head >
   < body >
   </ body >
</ html >

index.jsp:

<% @ page language="java" pageEncoding="GB18030" %>
<% @taglib uri="/struts-tags" prefix="s"  %>
< html >
   < head >
     < title >My JSP 'index.jsp' starting page </ title >
     < script  type ="text/javascript" >
        function findNews()
        {
            var sort = document.getElementById("sort");
            window.location = "findNews.action?sortid=" + sort.value;
        }
     </ script >
   </ head >
   < body >
       < select  id ="sort"  name ="sortid"  onchange ="findNews();" >
       < option >请选择 </ option >
           < s:iterator  value ="#request['sorts']"  id ="sort"   >
               < option  value ="<s:property value='#sort.nid'/>"   >< s:property  value ="#sort.sort"   /></ option >
           </ s:iterator >
       </ select >
       < hr  />
       < s:iterator  value ="#request['news']"  id ="news" >
           < s:property  value ="#news.title" />< br  />
       </ s:iterator >
   </ body >
</ html >

好了,一切OK,打开浏览器测试一切正常.
 源码可以在我的网盘下载.  下载