用el表达式取出mysql中的值_如何将数据库中的值经过servlet传入到jsp页面，并且用EL表达式显示出值...

方法一；通过id查询某一数据库表中具体的行，将值封装在相应的对象中，如下面的对象Notice

servlet中

String noticeId=request.getParameter("noticeId");

Notice displayEditnotice=publicnoticeservice.displayEditnotice(Integer.valueOf(noticeId));

request.setAttribute("list_displayEditnotice", displayEditnotice);

System.out.println("displayEditnotice="+displayEditnotice);

request.getRequestDispatcher("Editnotice.jsp").forward(request, response);

Editnotice.jsp页面

标题:
内容:	${list_displayEditnotice.getContext()}

dao中接口的实现方法

public Notice displayEditnotice(int noticeId) {

Notice notice=null;

String sql="select noticeId,title,context,publicerId,publicer,writeDate from notice where noticeId=?";

conn=super.getConnection();

try {

pstmt=conn.prepareStatement(sql);

pstmt.setInt(1, noticeId);

rs=pstmt.executeQuery();

while(rs.next()){

notice=new Notice();

notice.setNoticeId(rs.getInt("noticeId"));

notice.setTitle(rs.getString("title"));

notice.setContext(rs.getString("context"));

notice.setPublicerId(rs.getInt("publicerId"));

notice.setPublicer(rs.getString("publicer"));

notice.setWriteDate(rs.getTimestamp("writeDate"));

}

} catch (SQLException e) {

e.printStackTrace();

}finally{

super.closeAll(conn, pstmt, stmt, rs);

}

return notice;

}

方法二：将我数据库中表的所有数据显示出来，则将每一行的值封装在List集合中，在jsp页面用迭代显示出来

注意要加标签库：

servlet中

List displaynotice=publicnoticeservice.displaypublicnotice();

request.setAttribute("list_displaynotice",displaynotice);

request.getRequestDispatcher("displaypublicnotice.jsp").forward(request, response);

displaypublicnotice.jsp

序号	标题	内容	发布人	发布时间	操作
${i.count}	${notice.title}	${notice.context}	${notice.publicer}	${notice.writeDate}	删除 | target="middle" >编辑

dao中接口的实现方法

private Connection conn=null;

private PreparedStatement pstmt=null;

private Statement stmt=null;

private ResultSet rs=null;

public List displaypublicnotice() { List list=new ArrayList(); Notice notice=null; String sql="select noticeId,title,context,publicerId,publicer,writeDate from notice"; conn=super.getConnection(); try { pstmt=conn.prepareStatement(sql); rs=pstmt.executeQuery(); while(rs.next()){ notice=new Notice(); notice.setNoticeId(rs.getInt("noticeId")); notice.setTitle(rs.getString("title")); notice.setContext(rs.getString("context")); notice.setPublicerId(rs.getInt("publicerId")); notice.setPublicer(rs.getString("publicer")); notice.setWriteDate(rs.getTimestamp("writeDate")); list.add(notice); } } catch (SQLException e) { e.printStackTrace(); }finally{ // 7。关闭连接 super.closeAll(conn, pstmt, stmt, rs); } return list; }