object[]返回方法
public News[] getNewsByPreson(int mid,String hftimes) throws SQLException
{
String sql="select mid,hftimes,content,messages,Date from secondnews where mid='"+mid+"' and hftimes='"+hftimes+"' order by uid desc ";
News ret =null;
conn = dbconn.getConnection();
stmt = conn.createStatement();
rs=stmt.executeQuery(sql);
List list = new ArrayList();
while(rs.next())
{
list.add(new News(rs.getInt(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5)));
}
conn.close();
dbconn.closeConn();
if(list.size() == 0) return null;
News[] news = new News[list.size()];
return (News[])list.toArray(news);
}
下面是jsp代码，调用这个method.
//shows.jsp
<%@page contentType="text/html;charset=gb2312" %>
<link rel=stylesheet href="css/xprnweb.css" type="text/css"]
<%@page import="second.*"%>
<%
String uID=(String)session.getAttribute("uID1");
if(uID==null)
{
out.println("no login!!");
}
else
{
NewsDAO newsDao = new NewsDAO();
News[] news = newsDao.getNewsByPreson(1,uID);
for(int i=0;i<news.length;i++)
{
%>
<%=news<i>.getDate()%>
<%}
}
%>
Jason
2004-12-09 22:37:42
评论:0
阅读:2678
引用:0