javaweb_17

/**
	 * 根据编号查询所有数据
	 */
	public List<Article> queryArticleByAid(int aid);

@Override
	public List<Article> queryArticleByAid(int aid) {
        String sql="select * from e_article where typeId=?";
        List<Article> list=new ArrayList<Article>();
        Type type=null;
        ResultSet rs=this.executeQuery(sql, aid);
        try {
        	 while(rs.next()) {
          	   list.add(new Article(rs.getInt(1), rs.getString(2), rs.getInt(3), rs.getString(4), rs.getString(5), rs.getString(6), type));
             }
		} catch (Exception e) {
          e.printStackTrace();
		} finally {
			DBHelper.myClose(conn, ps, rs);
		}
		return list;
	}

<!-- 显示内容 -->
					<div id="myDiv">
						<div id="cba"
							style="border-color: #CCCCCC; border-style: inset; height: 130px; width: 272px; border-width: 1px; float: left;">
							<img src="image/cen01.jpg" />
							<ul>
								<!-- 显示数据 -->
								<jsp:include page="index_type.jsp">
									<jsp:param value="1" name="typeId" />
								</jsp:include>
								<!-- <li>JavaBase的使用</li>
								<li>java项目案例</li>
								<li>java知识大全</li> -->
							</ul>
						</div>
 
						<div id="cba"
							style="border-color: #CCCCCC; border-style: inset; height: 130px; width: 272px; border-width: 1px; float: left; margin-left: 30px;">
							<img src="image/cen02.jpg" width="272px" />
							<ul>
								<jsp:include page="index_type.jsp">
									<jsp:param value="2" name="typeId" />
								</jsp:include>
								<!-- <li>#.NET学习笔记</li>
								<li>#.NET学习笔记</li>
								<li>#.NET学习笔记</li> -->
							</ul>
						</div>
 
 
						<div id="cba"
							style="border-color: #CCCCCC; border-style: inset; height: 130px; width: 272px; border-width: 1px; float: left; margin-top: 5px;">
							<img src="image/cen03.jpg" width="272px" />
							<ul>
								<jsp:include page="index_type.jsp">
									<jsp:param value="3" name="typeId" />
								</jsp:include>
								<!-- <li>心情日记</li>
								<li>心情日记</li>
								<li>心情日记</li> -->
							</ul>
 
 
						</div>
 
						<div id="cba"
							style="border-color: #CCCCCC; border-style: inset; height: 130px; width: 272px; border-width: 1px; float: left; margin-left: 30px; margin-top: 5px;">
							<img src="image/cen04.jpg" width="272px" />
							<ul>
								<jsp:include page="index_type.jsp">
									<jsp:param value="4" name="typeId" />
								</jsp:include>
								<!-- <li>伟人传记</li>
								<li>伟人传记</li>
								<li>伟人传记</li> -->
							</ul>
						</div>