createtreexml.jsp.bak

用javascript写的树型目录,可加链接

<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="conn.*,java.sql.*,java.sql.Statement,
                 java.io.*,java.io.File.*,
                 java.util.*,java.math.*"
 %>

<%!
  SqlData2 sqlData2 = new SqlData2();
  SqlData2 sqlData3 = new SqlData2();
  public String createItem(String name,String content,String code){
     String str = null ;
     if ( code.indexOf("-00-") > 0 )
         str = "<menu2 id='"+code+"' title='" + name + "、" + content + "' haschild='false'></menu2>" ;
     else
         str = "<menu3 id='"+code+"' title='" + name + "、" + content + "' haschild='false'></menu3>" ;
      return str;
  }

  public String createSection(String zhang) throws SQLException {
      String str = "";
      String sql = "select count(*) from AccusalDictionary where charindex('"+zhang+"',AccusalCode)=1 and charindex('-000',AccusalCode)>0 ";
      ResultSet rs = sqlData3.executeQuery(sql);
      rs.next();
      int count = rs.getInt(1);
      count--;
      String istr = "";

      for( int j=1; j<= count;j++)
       { if( j < 10 ) istr = "0"+ String.valueOf(j);
         else istr = String.valueOf(j);

         sql = "select AccusalName,Content,AccusalCode from AccusalDictionary where charindex('"+zhang+"-"+istr+"',AccusalCode)=1 order by AccusalCode";
         rs = sqlData3.executeQuery(sql);
         rs.next();
         str = str + "<menu2 id='"+rs.getString("AccusalCode")+"' title='" + rs.getString("AccusalName") + "、" + rs.getString("Content") + "' haschild='true'>";
         while( rs.next() )
           {  str = str + createItem(rs.getString(1),rs.getString(2),rs.getString(3));
           }
         str = str + "</menu2>";
       }
   return str;
  }
 %>
<%  String outstring = "<?xml version='1.0' encoding='gb2312' ?><?xml-stylesheet type='text/xsl' href='accusal.xsl' ?><menu>";        // at last , "outstring" output to the file of "accusal.xml"

    String sql = "select count(*) from AccusalDictionary where charindex('00-000',AccusalCode)>0 ";
    ResultSet rs = sqlData2.executeQuery1(sql);  //带游标的
    rs.next();
    int accusalCount = rs.getInt(1);  // 章 的数目
      out.print(accusalCount);
    String istr = "";
    for( int i=1 ; i <= accusalCount ; i++ )
     {   if( i < 10 ) istr = "0"+ String.valueOf(i);
         else istr = String.valueOf(i);
         sql = "select AccusalName,Content,AccusalCode from AccusalDictionary where charindex('"+istr+"',AccusalCode)=1 order by AccusalCode";
         rs = sqlData2.executeQuery1(sql);
         rs.next();
         outstring = outstring + "<menu1 id='"+rs.getString("AccusalCode")+"' title='" + rs.getString("AccusalName") + "、" + rs.getString("Content") + "' haschild='true'>";

       //生成第二层
         rs.next();
         String checkStr = rs.getString("AccusalCode");
         if (checkStr.indexOf("-00-")>0)  //获得 章 下所有的条
           {  rs.previous();
              while(rs.next())
               {outstring = outstring + createItem(rs.getString(1),rs.getString(2),rs.getString(3));
               }
           }
         else
           outstring = outstring + createSection(istr);

         outstring = outstring + "</menu1>";

     }
  outstring = outstring + "</menu>";

sqlData2.dbclose1();
sqlData3.dbclose();
 %>
<%   String fileUri = "webapps/";
     String filePerson = "shenpan/AccusalTree/zl.xml";
     File outfile = new File(fileUri+filePerson);
     String aPath = outfile.getAbsolutePath().toString();   //\u53D6\u5F97\u8BE5\u6587\u4EF6\u7684\u7EDD\u5BF9\u8DEF\u5F84
     outfile = new File(aPath);         //\u5229\u7528\u7EDD\u5BF9\u8DEF\u5F84\u6307\u5B9A\u6587\u4EF6

   //if the file doesn't exist , create the file
    try
     { if(outfile.exists())
          outfile.delete();
       outfile.createNewFile();
     }
    catch(IOException e_createfile )
     { out.println(e_createfile.getMessage());
     }

    FileOutputStream fileoutput = new FileOutputStream(outfile);
    fileoutput.write(outstring.getBytes());
    fileoutput.close();
 %>