displayoption.java

web版的进销存系统

package jxc.util;


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


public class DisplayOption {

	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 += "<option value=" + rs.getInt("ID") + ">"
			+ rs.getString("wptypename") + "</option>";
			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;" + path;
			}

			str += "<option value=" + id1 + ">" + path + "-" + name1
			+ "</option>";
			sub_list(id1);

		}

	}

}