displayview.java

web版的进销存系统

package jxc.util;

import jxc.com.DBConnect;
import java.lang.String;
import java.sql.ResultSet;

public class DisplayView {

	private String str = "";	   

	public String parent_list() throws Exception {

		DBConnect dbc  = new DBConnect(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
		String sql = "select * from wptype where parentid=0 order by ID asc";
		ResultSet rs = dbc.executeQuery(sql);

		while (rs.next()) {
			str += "<tr bgcolor=#Ffffff><td class='small'>&nbsp;+&nbsp;"
					+ rs.getString("wptypename") + "</td>" +
					"<td width='15%' class='small'><a href='sptype_Add.jsp?id="+rs.getInt("ID")+"'><div align=center>添加子类</div></a></td>" +
					"<td width='15%' class='small'><a href='spxx_Add.jsp?id="+rs.getInt("ID")+"'><div align=center>添加商品</div></a></td>" +
					"<td width='10%' class='small'><a href='sptype_Edit.jsp?id="+rs.getInt("ID")+"'><div align=center>修改</div></a></td>" +
					"<td width='10%' class='small'><a href='sptype_Del.jsp?id="+rs.getInt("ID")+"' onClick='return ConfirmDel();'><div align=center>删除</div></a></td></tr>";
			int id0 = rs.getInt("ID");
			this.sub_list(id0);
		}
		return str;
	}

	public void sub_list(int ID) throws Exception {
		
		DBConnect dbc  = new DBConnect(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
		String sql1 = "select * from wptype where parentid='" + ID
		+ "' order by ID asc";		
		ResultSet rs1 = dbc.executeQuery(sql1);		
		
		while (rs1.next()) {
			int id1 = rs1.getInt("ID");
			String name1 = rs1.getString("wptypename");
			int depth1 = rs1.getInt("depth");

			String path = "";
			for (int i = 0; i <= depth1; i++) {
				path = "&nbsp;&nbsp;" + path;
			}

			str += "<tr bgcolor=#F6f6f6><td class='small'>" + path + "-" + name1
					+ "</td>" +
					"<td class='small'><a href='sptype_Add.jsp?id="+id1+"'><div align=center>添加子类</div></a></td>" +
					"<td class='small'><a href='spxx_Add.jsp?id="+id1+"'><div align=center>添加商品</div></a></td>" +
					"<td class='small'><a href='sptype_Edit.jsp?id="+id1+"'><div align=center>修改</div></a></td>" +
					"<td class='small'><a href='sptype_Del.jsp?id="+id1+"' onClick='return ConfirmDel();'><div align=center>删除</div></a></td></tr>";
			sub_list(id1);

		}

	}

}