level 1
十几多年
楼主
shownews.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@taglib prefix="s" uri="/struts-tags"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
显示新闻列表信息：
<table border="1">
<tr>
<td>新闻标题</td>
<td>新闻内容</td>
</tr>
<s:iterator value="newsList" var="new">
<tr>
<td><s:property value="#new.title"/></td>
<td><s:property /></td>
</tr>
</s:iterator>
</table>
</body>
</html>
NewsAction.java
package nuc.sw.xiaomi.action;
import java.util.List;
import nuc.sw.xiaomi.dao.NewsDAO;
import nuc.sw.xiaomi.entity.News;
import com.opensymphony.xwork2.ActionSupport;
public class NewsAction extends ActionSupport {
private static final long serialVersionUID = 1L;
private List<News> newsList = null;
public List<News> getNewsList() {
return newsList;
}
public void setNewsList(List<News> newsList) {
this.newsList = newsList;
}
private String title; //页面提交过来的news名
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
public String findAllNews(){
NewsDAO nd = new NewsDAO();
newsList = nd.findAll();
for(int i=0;i<newsList.size();i++){
System.out.println(newsList.get(i).getId());
System.out.println(newsList.get(i).getNews());
System.out.println(newsList.get(i).getTitle());
System.out.println("--------------\n");
}
return "newsAllOK";
}
}
NewsDAO.java
package nuc.sw.xiaomi.dao;
import nuc.sw.xiaomi.entity.*;
import nuc.sw.xiaomi.dbc.SQLCon;
import java.util.List;
import java.util.ArrayList;
import java.sql.*;
public class NewsDAO {
private Connection conn=null;
private PreparedStatement ps=null;
private ResultSet rs=null;
//查询所有的news数据
public List<News> findAll() {
List<News> newss = new ArrayList<News>();
conn=SQLCon.getConnection();
String sql="select * from news";
try{
ps=conn.prepareStatement(sql);
rs=ps.executeQuery();
News news=null;
while(rs.next()){
news =new News();
news.setId(rs.getInt(1));
news.setTitle(rs.getString(2));
news.setNews(rs.getString(3));
newss.add(news);
}
}catch(SQLException e){
e.printStackTrace();
}
return newss;
}
}
News.java
package nuc.sw.xiaomi.entity;
public class News {
private int id;
private String title;
private String news;
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 getNews() {
return news;
}
public void setNews(String news) {
this.news = news;
}
}
struts.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 2.3//EN"
"http://struts.apache.org/dtds/struts-2.3.dtd">
<struts>
<package name="NewsAction" namespace="/" extends="struts-default" >
<action name="newsAction*" method="find{1}News" class="nuc.sw.xiaomi.action.NewsAction">
<result name="news{1}OK">/shownews.jsp</result>
</action>
</package>
</struts>
2016年01月17日 04点01分
1
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@taglib prefix="s" uri="/struts-tags"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
显示新闻列表信息：
<table border="1">
<tr>
<td>新闻标题</td>
<td>新闻内容</td>
</tr>
<s:iterator value="newsList" var="new">
<tr>
<td><s:property value="#new.title"/></td>
<td><s:property /></td>
</tr>
</s:iterator>
</table>
</body>
</html>
NewsAction.java
package nuc.sw.xiaomi.action;
import java.util.List;
import nuc.sw.xiaomi.dao.NewsDAO;
import nuc.sw.xiaomi.entity.News;
import com.opensymphony.xwork2.ActionSupport;
public class NewsAction extends ActionSupport {
private static final long serialVersionUID = 1L;
private List<News> newsList = null;
public List<News> getNewsList() {
return newsList;
}
public void setNewsList(List<News> newsList) {
this.newsList = newsList;
}
private String title; //页面提交过来的news名
public String getTitle() {
return title;
}
public void setTitle(String title) {
this.title = title;
}
public String findAllNews(){
NewsDAO nd = new NewsDAO();
newsList = nd.findAll();
for(int i=0;i<newsList.size();i++){
System.out.println(newsList.get(i).getId());
System.out.println(newsList.get(i).getNews());
System.out.println(newsList.get(i).getTitle());
System.out.println("--------------\n");
}
return "newsAllOK";
}
}
NewsDAO.java
package nuc.sw.xiaomi.dao;
import nuc.sw.xiaomi.entity.*;
import nuc.sw.xiaomi.dbc.SQLCon;
import java.util.List;
import java.util.ArrayList;
import java.sql.*;
public class NewsDAO {
private Connection conn=null;
private PreparedStatement ps=null;
private ResultSet rs=null;
//查询所有的news数据
public List<News> findAll() {
List<News> newss = new ArrayList<News>();
conn=SQLCon.getConnection();
String sql="select * from news";
try{
ps=conn.prepareStatement(sql);
rs=ps.executeQuery();
News news=null;
while(rs.next()){
news =new News();
news.setId(rs.getInt(1));
news.setTitle(rs.getString(2));
news.setNews(rs.getString(3));
newss.add(news);
}
}catch(SQLException e){
e.printStackTrace();
}
return newss;
}
}
News.java
package nuc.sw.xiaomi.entity;
public class News {
private int id;
private String title;
private String news;
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 getNews() {
return news;
}
public void setNews(String news) {
this.news = news;
}
}
struts.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 2.3//EN"
"http://struts.apache.org/dtds/struts-2.3.dtd">
<struts>
<package name="NewsAction" namespace="/" extends="struts-default" >
<action name="newsAction*" method="find{1}News" class="nuc.sw.xiaomi.action.NewsAction">
<result name="news{1}OK">/shownews.jsp</result>
</action>
</package>
</struts>