Java 动态树 dhtmlxtree

package com; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; /** * 数据库操作类 * @author huangshnagwen * @version 1.0 2009-8-10 * */ public class DBControl { //sql Information private static String sqlusername="sa";// 用户名 private static String sqlpassword="sa";// 密码 private static String sqlipaddress="192.168.0.23";// IP地址 private static String sqlport="1433";// 数据库端口 private static String sqldataname="treeDB";//数据库名称 private static Connection sqlcon = null; private static Statement sqlstm = null; private static ResultSet sqlrs = null; /** * 获取SQL数据库连接 * @return Connection */ public static Connection GetSQLConnection() { try { String classname = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; //数据库驱动器 String sqlurl = "jdbc:microsoft:sqlserver://"+DBControl.sqlipaddress+":"+DBControl.sqlport+";"+"databaseName="+DBControl.sqldataname;// 数据库连接URL Class.forName(classname); sqlcon = DriverManager.getConnection(sqlurl, DBControl.sqlusername,DBControl.sqlpassword); return sqlcon; } catch (Exception ex) { ex.printStackTrace(); return null; } } /** * 查询大类 * */ public static List getBigClassInfo() { List<String> list = new ArrayList<String>(); try { String sqlSQL = "select distinct(bigClassName) as bigClassName from bigClass "; sqlcon = DBControl.GetSQLConnection(); sqlstm = sqlcon.createStatement(); sqlrs = sqlstm.executeQuery(sqlSQL); while(sqlrs.next()){ String bigClassName = sqlrs.getString(1); list.add(bigClassName); } } catch (Exception ex) { ex.printStackTrace(); } DBControl.releaseSource(); return list; } /** * 查询小类 * */ public static List getSmallClassInfo(String bigClassName) { List<String> list = new ArrayList<String>(); try { String sqlSQL = "select distinct(smallClassName) as smallClassName from smallClass where bigClassName = '"+bigClassName+"'"; sqlcon = DBControl.GetSQLConnection(); sqlstm = sqlcon.createStatement(); sqlrs = sqlstm.executeQuery(sqlSQL); while(sqlrs.next()){ String smallClassName = sqlrs.getString(1); list.add(smallClassName); } } catch (Exception ex) { ex.printStackTrace(); } DBControl.releaseSource(); return list; } /** * 查询本地语言 * */ public static List getLanguageInfo(String smallClassName) { List<String> list = new ArrayList<String>(); try { String sqlSQL = "select distinct(locallanguage) as language from language where samllClassName = '"+smallClassName+"'"; sqlcon = DBControl.GetSQLConnection(); sqlstm = sqlcon.createStatement(); sqlrs = sqlstm.executeQuery(sqlSQL); while(sqlrs.next()){ String language = sqlrs.getString(1); list.add(language); } } catch (Exception ex) { ex.printStackTrace(); } DBControl.releaseSource(); return list; } //释放资源 public static void releaseSource() { try { if(sqlrs!=null){ sqlrs.close(); } if(sqlstm!=null){ sqlstm.close(); } if(sqlcon!=null){ sqlcon.close(); } } catch (SQLException e) { e.printStackTrace(); } } }