import java.sql.SQLException;
import org.gjt.mm.mysql.jdbc2.ResultSet;
import java.io.Reader;
import java.io.BufferedReader;
import java.io.Serializable;

public class Football implements Serializable {
private String id;
private String footballName;
private String viewURL;
private String downURL;
private int clicks;
private String sort;
private String intro;
private int commend;
private String date;
private int bad;
private int length;

//-------------------------------
public void setId(String id){
this.id=id;
}
public String getId(){
return id;
}
//-------------------------------
public void setFootballName(String name){
this.footballName=name;
}
public String getFootballName(){
return footballName;
}
//-------------------------------
public void setViewURL(String url){
this.viewURL=url;
}
public String getViewURL(){
return viewURL;
}
//-------------------------------
public void setDownURL(String url){
this.downURL=url;
}
public String getDownURL(){
return downURL;
}
//-------------------------------
public void setClicks(int clicks){
this.clicks=clicks;
}
public int getClicks(){
return clicks;
}
//-------------------------------
public void setSort(String sort){
this.sort=sort;
}
public String getSort(){
return sort;
}
//-------------------------------
public void setIntro(String intro){
this.intro=intro;
}
public String getIntro(){
return intro;
}
//-------------------------------
public void setCommend(int commend){
this.commend=commend;
}
public int getCommend(){
return commend;
}
//-------------------------------
public void setDate(String date){
this.date=date;
}
public String getDate(){
return date;
}
//-------------------------------
public void setBad(int bad){
this.bad=bad;
}
public int getBad(){
return bad;
}
//-------------------------------
public void setLength(int length){
this.length=length;
}
public int getLength(){
return length;
}

public static Football load(ResultSet rs) throws SQLException{
Football football=new Football();
String strValue=null;
int intValue=0;

strValue=rs.getString("id");
if(strValue!=null)
football.setId(strValue);

strValue=rs.getString("footballName");
if(strValue!=null)
football.setFootballName(strValue);

strValue=rs.getString("viewURL");
if(strValue!=null)
football.setViewURL(strValue);

strValue=rs.getString("downURL");
if(strValue!=null)
football.setDownURL(strValue);

intValue=rs.getInt("clicks");
if(intValue > 0)
football.setClicks(intValue);

strValue=rs.getString("sort");
if(strValue!=null)
football.setSort(strValue);

/*
try{
Reader reader=rs.getCharacterStream("intro");
BufferedReader bReader=new BufferedReader(reader);
String inLine;
strValue="";
while((inLine=bReader.readLine())!= null){
strValue=strValue+inLine;
}
}catch(Exception e){e.printStackTrace();}
*/
strValue=rs.getString("intro");
if(strValue!=null)
football.setIntro(strValue);

intValue=rs.getInt("commend");
if(intValue > 0)
football.setCommend(intValue);

strValue=rs.getString("date");
if(strValue!=null)
football.setDate(strValue);

intValue=rs.getInt("bad");
if(intValue > 0)
football.setBad(intValue);

intValue=rs.getInt("length");
if(intValue > 0)
football.setLength(intValue);

return football;
}
}

import org.gjt.mm.mysql.jdbc2.ResultSet;
import java.sql.SQLException;
import java.io.Reader;
import java.io.BufferedReader;
import java.io.Serializable;

public class Fun implements Serializable {
private String id;
private String funName;
private String viewURL;
private String downURL;
private int clicks;
private String sort;
private String intro;
private int commend;
private String date;
private int bad;
private int length;

//-------------------------------
public void setId(String id){
this.id=id;
}
public String getId(){
return id;
}
//-------------------------------
public void setFunName(String name){
this.funName=name;
}
public String getFunName(){
return funName;
}
//-------------------------------
public void setViewURL(String url){
this.viewURL=url;
}
public String getViewURL(){
return viewURL;
}
//-------------------------------
public void setDownURL(String url){
this.downURL=url;
}
public String getDownURL(){
return downURL;
}
//-------------------------------
public void setClicks(int clicks){
this.clicks=clicks;
}
public int getClicks(){
return clicks;
}
//-------------------------------
public void setSort(String sort){
this.sort=sort;
}
public String getSort(){
return sort;
}
//-------------------------------
public void setIntro(String intro){
this.intro=intro;
}
public String getIntro(){
return intro;
}
//-------------------------------
public void setCommend(int commend){
this.commend=commend;
}
public int getCommend(){
return commend;
}
//-------------------------------
public void setDate(String date){
this.date=date;
}
public String getDate(){
return date;
}
//-------------------------------
public void setBad(int bad){
this.bad=bad;
}
public int getBad(){
return bad;
}
//-------------------------------
public void setLength(int length){
this.length=length;
}
public int getLength(){
return length;
}

public static Fun load(ResultSet rs) throws SQLException{
Fun fun=new Fun();
String strValue=null;
int intValue=0;

strValue=rs.getString("id");
if(strValue!=null)
fun.setId(strValue);

strValue=rs.getString("funName");
if(strValue!=null)
fun.setFunName(strValue);

strValue=rs.getString("viewURL");
if(strValue!=null)
fun.setViewURL(strValue);

strValue=rs.getString("downURL");
if(strValue!=null)
fun.setDownURL(strValue);

intValue=rs.getInt("clicks");
if(intValue > 0)
fun.setClicks(intValue);

strValue=rs.getString("sort");
if(strValue!=null)
fun.setSort(strValue);

/*
try{
Reader reader=rs.getCharacterStream("intro");
BufferedReader bReader=new BufferedReader(reader);
String inLine;
strValue="";
while((inLine=bReader.readLine())!= null){
strValue=strValue+inLine;
}
}catch(Exception e){e.printStackTrace();}
*/
strValue=rs.getString("intro");
if(strValue!=null)
fun.setIntro(strValue);

intValue=rs.getInt("commend");
if(intValue > 0)
fun.setCommend(intValue);

strValue=rs.getString("date");
if(strValue!=null)
fun.setDate(strValue);

intValue=rs.getInt("bad");
if(intValue > 0)
fun.setBad(intValue);

intValue=rs.getInt("length");
if(intValue > 0)
fun.setLength(intValue);

return fun;
}
}

import org.gjt.mm.mysql.jdbc2.ResultSet;
import java.sql.SQLException;
import java.io.Reader;
import java.io.BufferedReader;
import java.io.Serializable;

public class Movie implements Serializable {
private String id;
private String movieName;
private String viewURL;
private String downURL;
private int clicks;
private String sort;
private String intro;
private int commend;
private String date;
private int bad;
private int length;

//-------------------------------
public void setId(String id){
this.id=id;
}
public String getId(){
return id;
}
//-------------------------------
public void setMovieName(String name){
this.movieName=name;
}
public String getMovieName(){
return movieName;
}
//-------------------------------
public void setViewURL(String url){
this.viewURL=url;
}
public String getViewURL(){
return viewURL;
}
//-------------------------------
public void setDownURL(String url){
this.downURL=url;
}
public String getDownURL(){
return downURL;
}
//-------------------------------
public void setClicks(int clicks){
this.clicks=clicks;
}
public int getClicks(){
return clicks;
}
//-------------------------------
public void setSort(String sort){
this.sort=sort;
}
public String getSort(){
return sort;
}
//-------------------------------
public void setIntro(String intro){
this.intro=intro;
}
public String getIntro(){
return intro;
}
//-------------------------------
public void setCommend(int commend){
this.commend=commend;
}
public int getCommend(){
return commend;
}
//-------------------------------
public void setDate(String date){
this.date=date;
}
public String getDate(){
return date;
}
//-------------------------------
public void setBad(int bad){
this.bad=bad;
}
public int getBad(){
return bad;
}
//-------------------------------
public void setLength(int length){
this.length=length;
}
public int getLength(){
return length;
}

public static Movie load(ResultSet rs) throws SQLException{
Movie movie=new Movie();
String strValue=null;
int intValue=0;

strValue=rs.getString("id");
if(strValue!=null)
movie.setId(strValue);

strValue=rs.getString("movieName");
if(strValue!=null)
movie.setMovieName(strValue);

strValue=rs.getString("viewURL");
if(strValue!=null)
movie.setViewURL(strValue);

strValue=rs.getString("downURL");
if(strValue!=null)
movie.setDownURL(strValue);

intValue=rs.getInt("clicks");
if(intValue > 0)
movie.setClicks(intValue);

strValue=rs.getString("sort");
if(strValue!=null)
movie.setSort(strValue);

/*
try{
Reader reader=rs.getCharacterStream("intro");
BufferedReader bReader=new BufferedReader(reader);
String inLine;
strValue="";
while((inLine=bReader.readLine())!= null){
strValue=strValue+inLine;
}
}catch(Exception e){e.printStackTrace();}
*/
strValue=rs.getString("intro");
if(strValue!=null)
movie.setIntro(strValue);

intValue=rs.getInt("commend");
if(intValue > 0)
movie.setCommend(intValue);

strValue=rs.getString("date");
if(strValue!=null)
movie.setDate(strValue);

intValue=rs.getInt("bad");
if(intValue > 0)
movie.setBad(intValue);

intValue=rs.getInt("length");
if(intValue > 0)
movie.setLength(intValue);

return movie;
}
}

import org.gjt.mm.mysql.jdbc2.ResultSet;
import java.sql.SQLException;
import java.io.Reader;
import java.io.BufferedReader;
import java.io.Serializable;

public class Mtv implements Serializable {
private String id;
private String mtvName;
private String viewURL;
private String downURL;
private int clicks;
private String sort;
private String intro;
private int commend;
private String date;
private int bad;
private int length;

//-------------------------------
public void setId(String id){
this.id=id;
}
public String getId(){
return id;
}
//-------------------------------
public void setMtvName(String name){
this.mtvName=name;
}
public String getMtvName(){
return mtvName;
}
//-------------------------------
public void setViewURL(String url){
this.viewURL=url;
}
public String getViewURL(){
return viewURL;
}
//-------------------------------
public void setDownURL(String url){
this.downURL=url;
}
public String getDownURL(){
return downURL;
}
//-------------------------------
public void setClicks(int clicks){
this.clicks=clicks;
}
public int getClicks(){
return clicks;
}
//-------------------------------
public void setSort(String sort){
this.sort=sort;
}
public String getSort(){
return sort;
}
//-------------------------------
public void setIntro(String intro){
this.intro=intro;
}
public String getIntro(){
return intro;
}
//-------------------------------
public void setCommend(int commend){
this.commend=commend;
}
public int getCommend(){
return commend;
}
//-------------------------------
public void setDate(String date){
this.date=date;
}
public String getDate(){
return date;
}
//-------------------------------
public void setBad(int bad){
this.bad=bad;
}
public int getBad(){
return bad;
}
//-------------------------------
public void setLength(int length){
this.length=length;
}
public int getLength(){
return length;
}

public static Mtv load(ResultSet rs) throws SQLException{
Mtv mtv=new Mtv();
String strValue=null;
int intValue=0;

strValue=rs.getString("id");
if(strValue!=null)
mtv.setId(strValue);

strValue=rs.getString("mtvName");
if(strValue!=null)
mtv.setMtvName(strValue);

strValue=rs.getString("viewURL");
if(strValue!=null)
mtv.setViewURL(strValue);

strValue=rs.getString("downURL");
if(strValue!=null)
mtv.setDownURL(strValue);

intValue=rs.getInt("clicks");
if(intValue > 0)
mtv.setClicks(intValue);

strValue=rs.getString("sort");
if(strValue!=null)
mtv.setSort(strValue);

/*
try{
Reader reader=rs.getCharacterStream("intro");
BufferedReader bReader=new BufferedReader(reader);
String inLine;
strValue="";
while((inLine=bReader.readLine())!= null){
strValue=strValue+inLine;
}
}catch(Exception e){e.printStackTrace();}
*/
strValue=rs.getString("intro");
if(strValue!=null)
mtv.setIntro(strValue);

intValue=rs.getInt("commend");
if(intValue > 0)
mtv.setCommend(intValue);

strValue=rs.getString("date");
if(strValue!=null)
mtv.setDate(strValue);

intValue=rs.getInt("bad");
if(intValue > 0)
mtv.setBad(intValue);

intValue=rs.getInt("length");
if(intValue > 0)
mtv.setLength(intValue);

return mtv;
}
}

import java.sql.Connection;
import org.gjt.mm.mysql.jdbc2.ResultSet;
import java.sql.PreparedStatement;
import java.sql.Statement;
import java.sql.SQLException;
import java.util.LinkedList;

public class DisplayWelcome {
Connection conn;
public void setConn(Connection conn){
this.conn=conn;
}

/**
* 取得按照加入顺序（依靠ID号）倒排的前十条数据
* @param conn
* @return
* @throws SQLException
*/
public LinkedList getFootballList() throws SQLException{
LinkedList footballList;
if(conn==null)
throw new SQLException("No Connection in DisplayWelcomeAction");

PreparedStatement pstmt = null;
ResultSet rs = null;
footballList=new LinkedList();
try {
// Prepare the query SQL
pstmt = conn.prepareStatement("select * from football order by id desc");
// Execute the query and copy the results
// to a List
rs = (org.gjt.mm.mysql.jdbc2.ResultSet)pstmt.executeQuery();
int i=0;
while (rs.next() && i < 10) {
footballList.add(Football.load(rs));
i++;
}
}
finally {
if (rs != null)
rs.close();
if (pstmt != null)
pstmt.close();
}
return footballList;
}

/**
* 取得按照加入顺序（依靠ID号）倒排的前十条数据
* @param conn
* @return
* @throws SQLException
*/
public LinkedList getFunList() throws SQLException{
LinkedList funList;
if(conn==null)
throw new SQLException("No Connection in DisplayWelcomeAction");

PreparedStatement pstmt = null;
ResultSet rs = null;
funList=new LinkedList();
try {
// Prepare the query SQL
pstmt = conn.prepareStatement("select * from fun order by id desc");
// Execute the query and copy the results
// to a List
rs = (org.gjt.mm.mysql.jdbc2.ResultSet)pstmt.executeQuery();
int i=0;
while (rs.next() && i < 10) {
funList.add(Fun.load(rs));
i++;
}
}
finally {
if (rs != null)
rs.close();
if (pstmt != null)
pstmt.close();
}
return funList;
}

/**
* 取得按照加入顺序（依靠ID号）倒排的前十条数据
* @param conn
* @return
* @throws SQLException
*/
public LinkedList getMovieList() throws SQLException{
LinkedList movieList;
if(conn==null)
throw new SQLException("No Connection in DisplayWelcomeAction");

PreparedStatement pstmt = null;
ResultSet rs = null;
movieList=new LinkedList();
try {
// Prepare the query SQL
pstmt = conn.prepareStatement("select * from movie order by id desc");
// Execute the query and copy the results
// to a List
rs = (org.gjt.mm.mysql.jdbc2.ResultSet)pstmt.executeQuery();
int i=0;
while (rs.next() && i < 10) {
movieList.add(Movie.load(rs));
i++;
}
}
finally {
if (rs != null)
rs.close();
if (pstmt != null)
pstmt.close();
}
return movieList;
}

/**
* 取得按照加入顺序（依靠ID号）倒排的前十条数据
* @param conn
* @return
* @throws SQLException
*/
public LinkedList getMtvList() throws SQLException{
LinkedList mtvList;
if(conn==null)
throw new SQLException("No Connection in DisplayWelcomeAction");

PreparedStatement pstmt = null;
ResultSet rs = null;
mtvList=new LinkedList();
try {
// Prepare the query SQL
pstmt = conn.prepareStatement("select * from mtv order by id desc");
// Execute the query and copy the results
// to a List
rs = (org.gjt.mm.mysql.jdbc2.ResultSet)pstmt.executeQuery();
int i=0;
while (rs.next() && i < 10) {
mtvList.add(Mtv.load(rs));
i++;
}
}
finally {
if (rs != null)
rs.close();
if (pstmt != null)
pstmt.close();
}
return mtvList;
}
}

import vod.model.DisplayWelcome;
import java.io.IOException;
import java.util.LinkedList;
import java.util.Locale;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpSession;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionError;
import org.apache.struts.action.ActionErrors;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionServlet;
import org.apache.struts.util.MessageResources;
import java.sql.Connection;
import java.sql.SQLException;
import javax.sql.DataSource;

public class DisplayWelcomeAction extends Action {
Connection connection;

LinkedList footballList;
LinkedList funList;
LinkedList movieList;
LinkedList mtvList;

/**
* 通过vod.model.DisplayWeclome各个类别0取得排名前十的条目，将其放入request
* @param mapping
* @param form
* @param request
* @param response
* @return
* @throws IOException
* @throws ServletException
*/
public ActionForward perform(ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws IOException, ServletException{
ActionErrors errors = new ActionErrors();
try {
DataSource dataSource =servlet.findDataSource(null);
connection =dataSource.getConnection();

footballList=new LinkedList();
funList=new LinkedList();
movieList=new LinkedList();
mtvList=new LinkedList();
DisplayWelcome displaywelcome=new DisplayWelcome();
displaywelcome.setConn(connection);
footballList=displaywelcome.getFootballList();
funList=displaywelcome.getFunList();
movieList=displaywelcome.getMovieList();
mtvList=displaywelcome.getMtvList();

if (footballList==null) {
saveErrors(request, errors);
return (new ActionForward("No footballList in vod.controller.DisplayWelcomeAction"));
}
if (funList==null) {
saveErrors(request, errors);
return (new ActionForward("No funList in vod.controller.DisplayWelcomeAction"));
}
if (movieList==null) {
saveErrors(request, errors);
return (new ActionForward("No movieList in vod.controller.DisplayWelcomeAction"));
}
if (mtvList==null) {
saveErrors(request, errors);
return (new ActionForward("No mtvList in vod.controller.DisplayWelcomeAction"));
}

HttpSession session = request.getSession();
session.setAttribute("footballTop",footballList);
session.setAttribute("funTop",funList);
session.setAttribute("movieTop",movieList);
session.setAttribute("mtvTop",mtvList);

//do what you wish with myConnection
} catch (SQLException sqle) {
getServlet().log("Connection.process", sqle);
} finally {
//enclose this in a finally block to make
//sure the connection is closed
if(connection!=null)
try {
connection.close();
} catch (SQLException e) {
getServlet().log("Connection.close", e);
}
}

return (mapping.findForward("success"));
}
}

<!--指明action类所在的位置 -->
<servlet>
<servlet-name>action</servlet-name>
<servlet-class>org.apache.struts.action.ActionServlet</servlet-class>
<init-param>
<!--指明ApplicationResources文件所在的位置 -->
<param-name>application</param-name>
<param-value>vod.ApplicationResources</param-value>
</init-param>
<init-param>
<!--指明struts-config.xml文件所在的位置 -->
<param-name>config</param-name>
<param-value>/WEB-INF/struts-config.xml</param-value>
</init-param>
<init-param>
<param-name>debug</param-name>
<param-value>2</param-value>
</init-param>
<init-param>
<param-name>detail</param-name>
<param-value>2</param-value>
</init-param>
<init-param>
<param-name>validate</param-name>
<param-value>true</param-value>
</init-param>
<load-on-startup>2</load-on-startup>
</servlet>
<!--经所有.do结尾的请求映射倒第一行指定的名为action的org.apache.struts.action.ActionServlet -->
<servlet-mapping>
<servlet-name>action</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>

<!--指明首页文件的名称 -->
<welcome-file-list>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>

<!--指明/struts-bean.tld文件的位置 -->
<taglib>
<!--在网页中引用这个标签的URI -->
<taglib-uri>/WEB-INF/struts-bean.tld</taglib-uri>
<taglib-location>/WEB-INF/struts-bean.tld</taglib-location>
</taglib>

<!--指明struts-html.tld文件的位置 -->
<taglib>
<!--在网页中引用这个标签的URI -->
<taglib-uri>/WEB-INF/struts-html.tld</taglib-uri>
<taglib-location>/WEB-INF/struts-html.tld</taglib-location>
</taglib>

<!--指明struts-logic.tld文件的位置 -->
<taglib>
<!--在网页中引用这个标签的URI -->
<taglib-uri>/WEB-INF/struts-logic.tld</taglib-uri>
<taglib-location>/WEB-INF/struts-logic.tld</taglib-location>
</taglib>

<!DOCTYPE struts-config PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 1.0//EN"
"http://jakarta.apache.org/struts/dtds/struts-config_1_0.dtd">
<struts-config>

<!-- ========== 数据库连接池的相关设置=============================== -->
<data-sources>
<data-source>
<set-property property="autoCommit"
value="false"/>
<set-property property="description"
value="Data Source Configuration"/>
<!-- 数据库的JDBC驱动程序地址 -->
<set-property property="driverClass"
value="org.gjt.mm.mysql.Driver"/>
<!-- 最大数据库连接数 -->
<set-property property="maxCount"
value="200"/>
<!-- 最小数据库连接数 -->
<set-property property="minCount"
value="20"/>
<set-property property="password"
value="你的数据库密码"/>
<set-property property="url"
value="jdbc:mysql://localhost/gdmovie"/>
<set-property property="user"
value="你的数据库的用户名"/>
</data-source>
</data-sources>

<!-- ========== Global Forward Definitions ============================== -->
<!--全局的跳转，将在本程序的index.jsp中使用-->
<global-forwards>
<forward name="welcome" path="/welcome.do"/>
</global-forwards>

<!-- ========== Action Mapping Definitions ============================== -->
<action-mappings>

<!-- Enter into Welcome Page -->
<!--
path:请求的URL
type:action所处的位置
forward：如果action执行成功，那么跳转到welcome页
-->
<action path="/welcome"
type="vod.controller.DisplayWelcomeAction">
<forward name="success" path="/welcome.jsp"/>
</action>

</action-mappings>

</struts-config>

<action-mappings>

<!-- Global Forward Declarations -->
<forward name="welcome" path="/welcome.do"/>

<!-- Process a user logon -->
<action path="/welcome"
actionClass="vod.controller.DisplayWelcomeAction">
<forward name="success" path="/welcome.jsp"/>
</action>

</action-mappings>