数据库需求分析: class(一级栏目信息):classId(自动编号),className(栏目名称) Nclass(二级栏目信息):NclassId(自动编号),NclassName(栏目名称),parentId(一级栏目id,与class表中的classId关联) <%@ page contentType="text/html; charset=GB2312" language="java" errorPage="../error.jsp" %> <%@ include file="../conn.jsp"%> <%@ include file="../ds.jsp"%> <%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %> <%request.setCharacterEncoding("gb2312"); %> <%String sql="select * from Nclass order by NclassId asc"; ResultSet rs=stmt.executeQuery(sql); %> |