这个是dao文件
public class NewsDao {
private Integer newsid;
private String title;
private String content;
private Data publishDate;
private String author;
private Integer typeld;
public List getNewsList(){
List newsList=new ArrayList();
Connection connection=null;
Statement statement=null;
ResultSet resultset=null;
try {
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/","root","123");
statement=connection.createStatement();
resultset = statement.executeQuery("select * from t_news ");
while(resultset.next()){
int newId = resultset.getInt("newsid");
String newsTitle= resultset.getString("title");
String newsContent = resultset.getString("content");
String newsAuthor = resultset.getString("author");
int newtypeLd= resultset.getInt("typeld");
Date newsPublishDate = resultset.getDate("publishDate");
News news= new News(newsid, title, content, publishDate, author, typeld);
newsList.add(news);
}
} catch (Exception e) {
e.printStackTrace();
}finally {
if(resultset!=null){
try {
resultset.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}if(statement!=null){
try {
statement.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}if(connection!=null){
try {
connection.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
return newsList;
}
}
这个是jdbc文件
public class News {
private Integer newsid;
private String title;
private String content;
private Data publishDate;
private String author;
private Integer typeld;
public Integer getNewsid() {
return newsid;
}
public void setNewsid(Integer newsid) {
this.newsid = newsid;
}
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;
}
public Data getPublishDate() {
return publishDate;
}
public void setPublishDate(Data publishDate) {
this.publishDate = publishDate;
}
public String getAuthor() {
return author;
}
public void setAuthor(String author) {
this.author = author;
}
public Integer getTypeld() {
return typeld;
}
public void setTypeld(Integer typeld) {
this.typeld = typeld;
}
public News(Integer newsid, String title, String content, Data publishDate, String author, Integer typeld) {
super();
this.newsid = newsid;
this.title = title;
this.content = content;
this.publishDate = publishDate;
this.author = author;
this.typeld = typeld;
}
public News() {
super();
}
这个是servlet文件
public class newsServlet extends HttpServlet {
private NewsDao newsDao;
@Override
public void init() throws ServletException {
newsDao=new NewsDao();
super.init();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doPost(request, response);
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
List<News>newsList=newsDao.getNewsList();
request.setAttribute("newList", newsList);
request.getRequestDispatcher("newsList.jsp").forward(request, response);
}
}
这个是jsp文件
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8" import="java.util.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
| 新闻编号 | 新闻标题 | 新闻内容 | 发布时间 | 作者 | 新闻id |
|---|---|---|---|---|---|
| ${news.newsid} | ${news.title} | ${news.content} | ${news.publishDate} | ${news.author} | ${news.typeld} |
request.setAttribute("newList", newsList); 你request 里面放的是newList 你页面贴一下 看你怎么解析的
嗷嗷，修改以后还是和之前一样，请问jsp页面自动调用servlet么
这个是web.xml页面
newsServlet
newsServlet
com.servlet.diaoyong.newsServlet
newsServlet
/newsServlet
newList.jsp
这个Demo我i做过，链接地址：http://download.csdn.net/download/mmyhs/9930362
不用积分，不过当初脑残了，用的是SQL数据库
用的是EL表达式？ 有没有引<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>？
javax.servlet.ServletException: java.lang.NoClassDefFoundError: javax/servlet/jsp/jstl/core/LoopTag
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:348)
javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
El有问题可能性挺多的，http://blog.csdn.net/lpy3654321/article/details/19164789
楼主搜索看看