Çë½Ì¸öJavaÄÚ´æÐ¹Â¶ÎÊÌâ
ÎÒ×î½ü±à³Ìʱ Åöµ½ÁËJavaÄÚ´æÐ¹Â¶ÎÊÌ⣬ÄÇλ´ó¸çÄܰï°ïÎÒ ÈçºÎ±ÜÃâÕâ¸öÎÊÌâ
import java.util.*;
import java.sql.*;
public class OutputArticle{
Set <Article> articles = new HashSet <Article>();
public OutputArticle(){
Connection conn = DB.getConn();
tree(articles,conn,0);
for(Iterator <Article> it = articles.iterator();it.hasNext();){
Article b = it.next();
System.out.println(b.getTitle());
}
DB.close(conn);
}
public static void main(String[] args){
new OutputArticle();
}
private void tree(Set <Article> articles,Connection conn,int id){
String sql = "select * from article where pid="+id;
Statement stmt = DB.getStmt(conn);
ResultSet rs = DB.getResultSet(stmt,sql);
try{
while(rs.next()){
Article a = new Article();
a.setId(rs.getInt("id"));
a.setPid(rs.getInt("pid"));
a.setRootid(rs.getInt("rootid"));
a.setTitle(rs.getString("title"));
a.setPdate(rs.getTimestamp("pdate"));
a.setIsleaf(rs.getInt("isleaf&
Ïà¹ØÎÊ´ð£º
ÎÊÌâÃèÊö£ºÐ´ÈÕÖ¾¹¦ÄÜ£¬Ð´ºÃµÄдÈÕÖ¾·þÎñ£¬ÆäËûÓû§Í¨¹ýhttpµ÷Ó÷þÎñ£¬´«Èë²ÎÊý£¬È»ºó¼Ç¼ÈÕÖ¾£¬
ÎҵķþÎñ¸ÃÔõôд£¬ ±ðÈËÔõôͨ¹ýhttpµ÷ÓÃÎҵķþÎñ£¬ÎÒÓÃwebserviceдºÃÁËÒ»¸ö£¬¿ÉÊDz¢·¢ÓÐÉÏÏߣ¬Ïë¸ÄÓ ......
¸÷λ´ó¸ç:
ÏîÄ¿ÖÐÓö¼ûÒ»¸öÄÑÌâ,ÄǾÍÊÇÈçºÎÔÚÐÞ¸ÄÊý¾Ý¿âÀïÃæµÄij¸ö×Ö¶ÎÊÇÄܲúÉúÒ»¸öÏûÏ¢,ʵʱÌáÐѵ½Ê×Ò³ÄØ?
¶øÇÒ¿Í»§ÒªÇó¿ÉÒÔ×Ô¼º¶¨ÖÆÄÄЩ×Ö¶Î,±ÈÈçÓÐA,B,C×Ö¶Î,ÎÒ¿ÉÒÔÑ¡ÔñÆäÖÐÒ»¸ö»òÁ½¸ö×Ö¶Î,µ±ÕâÁ½¸ö×Ö¶Î ......
ÄÇλ´óÏÀÄܸøÎÒÒ»¸öJavaͨÓõķÖÒ³¿Ø¼þ£¬ÎÒ½«·Ç³£¸Ð¼¤¡£
ÆäÖÐ×îºÃÄܰüº¬SQL Server2000£¬SQL Server2005£¬Oracle¡¢MySqlµÈºÜ³£ÓõÄһЩÊý¾Ý¿â·ÖҳʵÏÖ¡£
×îºÃÄܼÓÉÏһЩʵÀý£¬±ãÓÚÎÒʹÓá£
ÎÒµÄÓÊÏäÊÇgaolihua889 ......