package?bean;

import?java.io.*;
import?java.sql.*;
import?java.util.*;


/**
?*?實現無限級分類目錄樹的JavaBean
?*?完成數據庫的連接
?*?完成分類的查詢，增加，刪除等操作
?*?編寫日期：2007-10-05
?*?@author?何裕浩?*
?*/
public?class?SortBean?{

	public?int?Id;
	public?String?name;
	public?int?parentId;
	
	private?Connection?conn;
	private?Statement?stmt;
	public?ResultSet?rs;
	
	int?deleteCount=0;
	
	public?SortBean（）{
		
	}
	
//加載驅動程序，建立數據庫的連接
public?void?OpenConn（String?dsnString?userString?password）{
	try{
	dsn?=?“jdbc:mysql:“?+?dsn;
?????Class.forName（“com.mysql.jdbc.Driver“）;
?????conn?=?DriverManager.getConnection（dsnuserpassword）;
	}catch（Exception?e）{
	System.err.println（“aq.executeQuery:“+e.getMessage（））;
		}
	}

/**
?*?@return?id
?*/
public?int?getId（）?{
	return?Id;
}

/**

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-07-08?21:00??JSP無限級分類目錄樹\
?????目錄???????????0??2018-07-08?21:00??JSP無限級分類目錄樹\sortTree\
?????文件?????????433??2008-06-26?17:18??JSP無限級分類目錄樹\sortTree\.classpath
?????目錄???????????0??2018-07-08?17:39??JSP無限級分類目錄樹\sortTree\.myeclipse\
?????文件?????????297??2008-06-26?15:28??JSP無限級分類目錄樹\sortTree\.mymetadata
?????文件????????1226??2008-06-26?15:32??JSP無限級分類目錄樹\sortTree\.project
?????目錄???????????0??2018-07-08?17:39??JSP無限級分類目錄樹\sortTree\src\
?????目錄???????????0??2008-06-26?15:29??JSP無限級分類目錄樹\sortTree\src\bean\
?????文件????????2759??2008-06-26?15:29??JSP無限級分類目錄樹\sortTree\src\bean\SortBean.java
?????目錄???????????0??2008-06-26?15:29??JSP無限級分類目錄樹\sortTree\src\tree\
?????文件????????4005??2008-06-26?17:30??JSP無限級分類目錄樹\sortTree\src\tree\MySort.java
?????目錄???????????0??2018-07-08?17:39??JSP無限級分類目錄樹\sortTree\WebRoot\
?????目錄???????????0??2008-06-26?15:28??JSP無限級分類目錄樹\sortTree\WebRoot\meta-INF\
?????文件??????????39??2008-06-26?15:28??JSP無限級分類目錄樹\sortTree\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2008-06-26?15:30??JSP無限級分類目錄樹\sortTree\WebRoot\web\
?????目錄???????????0??2008-06-26?15:28??JSP無限級分類目錄樹\sortTree\WebRoot\WEB-INF\
?????目錄???????????0??2008-06-26?17:18??JSP無限級分類目錄樹\sortTree\WebRoot\WEB-INF\classes\
?????目錄???????????0??2008-06-26?17:18??JSP無限級分類目錄樹\sortTree\WebRoot\WEB-INF\classes\bean\
?????文件????????3436??2008-06-26?17:18??JSP無限級分類目錄樹\sortTree\WebRoot\WEB-INF\classes\bean\SortBean.class
?????目錄???????????0??2008-06-26?17:18??JSP無限級分類目錄樹\sortTree\WebRoot\WEB-INF\classes\tree\
?????文件????????5089??2008-06-26?17:30??JSP無限級分類目錄樹\sortTree\WebRoot\WEB-INF\classes\tree\MySort.class
?????目錄???????????0??2008-06-26?17:18??JSP無限級分類目錄樹\sortTree\WebRoot\WEB-INF\lib\
?????文件??????493105??2006-07-26?22:39??JSP無限級分類目錄樹\sortTree\WebRoot\WEB-INF\lib\mysql-connector-java-5.0.3-bin.jar
?????文件?????????428??2008-06-26?15:30??JSP無限級分類目錄樹\sortTree\WebRoot\WEB-INF\web.xml
?????文件????????1087??2008-06-27?09:07??JSP無限級分類目錄樹\sortTree\WebRoot\web\add.jsp
?????文件?????????724??2008-06-26?15:30??JSP無限級分類目錄樹\sortTree\WebRoot\web\add_exec.jsp
?????文件?????????430??2008-06-26?15:30??JSP無限級分類目錄樹\sortTree\WebRoot\web\bottom.jsp
?????文件?????????124??2008-06-27?09:11??JSP無限級分類目錄樹\sortTree\WebRoot\web\conn.jsp
?????文件?????????866??2008-06-26?15:30??JSP無限級分類目錄樹\sortTree\WebRoot\web\delete.jsp
?????文件????????1332??2008-06-26?15:30??JSP無限級分類目錄樹\sortTree\WebRoot\web\delete_exec.jsp
?????文件?????????418??2008-06-26?15:30??JSP無限級分類目錄樹\sortTree\WebRoot\web\delete_exec_conf.jsp
............此處省略22個文件信息