displayfind.java

web版的进销存系统

package jxc.util;


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


public class DisplayFind {

	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;" +
					"<a href='find_spxx.jsp?id="+rs.getInt("ID")+"' target='main'>"
					+ rs.getString("wptypename") + "</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 + "-<a href='find_spxx.jsp?id="+rs1.getInt("ID")+"' target='main'>" + name1
					+ "</a></td></tr>";
			sub_list(id1);

		}

	}

}