package?com.service;
import?java.sql.*;

public?class?TreeService?{

	private?Connection?con;
	private?PreparedStatement?pstmt;
	private?ResultSet?rs;
	
	
	public?void?getConnection（）{
		
		
		try{
			Class.forName（“oracle.jdbc.driver.OracleDriver“）;
			String?url=“jdbc:oracle:thin:@10.119.40.61:1521:orcl“;
			con=DriverManager.getConnection（url“utdp““sinosoft“）;
		}catch（Exception?se）{
			se.printStackTrace（）;
		}
	}
	
	public?String?getNodesInfo（Integer?pid）{
		String?condition=null;
		if（pid==null）
			condition=“?and?ORG_PARENT?is?null“;
		else{
			condition=“?and?ORG_PARENT=“+pid;
		}
		
		String?sql=“select?permission_idpermission_namecount（permission_id）?as?c?from?permission“+
				“?where?1=1?“+condition+“?group?by?permission_idpermission_name“;
		String?osql=“select?o.IDo.ORG_cnamecase?when?exists（select?*?from?uump_organ?uo?where?uo.ORG_PARENT=o.id）?then?‘1‘?else?‘0‘?end??as?c?from?UUMP_ORGAN?o?where?1=1?“?+
				““+condition+“?order?by?o.ORG_ORDERBY“;
		
		//陡河電廠測試
		String?dsql=“select?o.id?o.ORG_CNAMEcase?when?exists（select?*?from?UTDP_ORGAN?uo?where?uo.ORG_PARENT=o.id）?then?‘1‘?else?‘0‘?end?as?c???from?UTDP_ORGAN?o?where?1=1“+
		?????condition+“?order?by?o.ORG_ORDERBY?“;
		
		
		StringBuffer?temp=new?StringBuffer（）;
		try?{
			getConnection（）;
			pstmt=con.prepareStatement（dsql）;
			rs=pstmt.executeQuery（）;
			while（rs.next（））{
				temp.append（rs.getLong（“id“）+““+rs.getString（“ORG_Cname“）+““+rs.getInt（“c“）+“|“）;
				
			}
	System.out.println（“the?string?value?is:“+temp+“:“+pid）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}finally{
			try?{
				rs.close（）;
				pstmt.close（）;
				con.close（）;
				
			}?catch?（SQLException?e）?{
				//?TODO????????catch???
				e.printStackTrace（）;
			}
		}
	
		return?temp.toString（）;
	}
}

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件???????1282??2014-03-06?16:14??DTreeTest\.project

?????文件???????1218??2014-03-06?17:05??DTreeTest\src\com\servlet\TreeServlet.java

?????文件???????1876??2014-03-10?14:34??DTreeTest\src\com\service\TreeService.java

?????文件?????284752??2008-03-27?22:39??DTreeTest\WebRoot\WEB-INF\lib\msbase.jar

?????文件??????64856??2008-03-27?22:39??DTreeTest\WebRoot\WEB-INF\lib\mssqlserver.jar

?????文件??????67235??2008-03-27?22:39??DTreeTest\WebRoot\WEB-INF\lib\msutil.jar

?????文件????1234433??2014-03-06?16:45??DTreeTest\WebRoot\WEB-INF\lib\Oracle9i?9.2.0.8?JDBC_classes12.jar

?????文件???????1747??2014-04-02?15:01??DTreeTest\WebRoot\WEB-INF\classes\com\servlet\TreeServlet.class

?????文件???????3770??2014-04-02?15:01??DTreeTest\WebRoot\WEB-INF\classes\com\service\TreeService.class

?????文件????????710??2008-03-27?20:35??DTreeTest\WebRoot\WEB-INF\web.xml

?????文件?????????39??2008-03-27?20:18??DTreeTest\WebRoot\meta-INF\MANIFEST.MF

?????文件???????1040??2008-03-27?20:18??DTreeTest\WebRoot\img\base.gif

?????文件????????239??2008-03-27?20:18??DTreeTest\WebRoot\img\cd.gif

?????文件?????????62??2008-03-27?20:18??DTreeTest\WebRoot\img\empty.gif

?????文件????????372??2008-03-27?20:18??DTreeTest\WebRoot\img\folder.gif

?????文件????????376??2008-03-27?20:18??DTreeTest\WebRoot\img\folderopen.gif

?????文件???????1095??2008-03-27?20:18??DTreeTest\WebRoot\img\globe.gif

?????文件????????622??2008-03-27?20:18??DTreeTest\WebRoot\img\imgfolder.gif

?????文件?????????69??2008-03-27?20:18??DTreeTest\WebRoot\img\join.gif

?????文件?????????66??2008-03-27?20:18??DTreeTest\WebRoot\img\joinbottom.gif

?????文件?????????66??2008-03-27?20:18??DTreeTest\WebRoot\img\line.gif

?????文件?????????86??2008-03-27?20:18??DTreeTest\WebRoot\img\minus.gif

?????文件?????????85??2008-03-27?20:18??DTreeTest\WebRoot\img\minusbottom.gif

?????文件????????633??2008-03-27?20:18??DTreeTest\WebRoot\img\musicfolder.gif

?????文件????????861??2008-03-27?20:18??DTreeTest\WebRoot\img\nolines_minus.gif

?????文件????????870??2008-03-27?20:18??DTreeTest\WebRoot\img\nolines_plus.gif

?????文件????????582??2008-03-27?20:18??DTreeTest\WebRoot\img\page.gif

?????文件?????????89??2008-03-27?20:18??DTreeTest\WebRoot\img\plus.gif

?????文件?????????88??2008-03-27?20:18??DTreeTest\WebRoot\img\plusbottom.gif

?????文件???????1044??2008-03-27?20:18??DTreeTest\WebRoot\img\question.gif

............此處省略30個(gè)文件信息