package com.galaxy.pub.rm.namespace;
import java.io.File;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.*;
import org.dom4j.Document;
import org.dom4j.DocumentException;
import org.dom4j.DocumentHelper;
import org.dom4j.Element;
import org.dom4j.Node;
import com.galaxy.pub.database.*;
import com.galaxy.pub.util.XMLUtil;
import com.galaxy.pub.util.enums.AlphaCase;
import com.galaxy.pub.util.enums.DATA_TYPE;
import com.galaxy.pub.util.enums.MODE;
import com.galaxy.pub.util.enums.NodeOrAttribute;
import com.galaxy.pub.util.enums.QUOTEMARK;
import com.galaxy.pub.database.ConnInfo;
import com.galaxy.pub.database.SystemConfigFile;
/**
* 用来获取命名空间下的数据，对象 只要是树状结构，都可以通过这个方法来操作。
*
* @author xwm
*
*/
public class NameSpace implements Tree{
protected String _nodeName = "node";
protected String _rootname = "";
protected String _tablename = "kp_modelnamespace";
protected String _data_tablename = "kp_modellib";// 挂在该节点下的表名。
protected String _data_nsid = "nsid";// 挂在该节点下的表的nsid字段名称。
protected String _data_label = "label";// 挂在该节点下的表的数据的显示名称。
protected String _nsid = "nsid";
protected String _parentid = "parentid";
protected String _displayorder = "displayorder";
protected String _nsname = "nsname";
protected String _label = "label";
protected String _strxml = "";
protected String _filter = "";
protected String _nsid_Type = "number";//nsid的字段类型，有number类型和string类型
protected String _parentid_Type = "number";//parentid的字段类型，有number类型和string类型
protected QUOTEMARK _symbol = QUOTEMARK.SINGLE;
protected NodeOrAttribute _attOrNode = NodeOrAttribute.ATTRIBUTE;
protected AlphaCase _case = AlphaCase.NOCHANGE;
protected MODE _mode = MODE.PINGMIAN;// 0：平行结构 1：层次结构
protected int _rootid = -1;
protected static boolean isInit = false;
public NameSpace() throws Exception {
System.out.println("init---------namespace()");
tree2memory();
}
public NameSpace(Connection conn) throws Exception {
System.out.println("init---------namespace(conn)");
tree2memory(conn);
}
public synchronized void refrash() throws Exception{
isInit = false;
tree2memory();
}
public synchronized void refrash(Connection conn) throws Exception{
isInit = false;
tree2memory(conn);
}
/**
* 设置一些参数值。
*
* @param tablename
* 表名
* @param nsid
* 根节点名称，默认是node
* @param nsid
* 主键名称
* @param parentid
* 父键名称
* @param displayorder
* 显示顺序字段名称
* @param nsname
* 英文名称
* @param label
* 中文名称
*/
public void init(String tablename, String rootname, String nsid,
String parentid, String displayorder, String nsname, String label,
int model, String nodeName) {
_tablename = tablename;
_nsid = nsid;
_parentid = parentid;
_displayorder = displayorder;
_nsname = nsname;
_label = label;
_nodeName = nodeName;
_rootname = rootname;
}
public void tree2memory() throws Exception {
Connection conn = null;
try {
tree2memory(conn);
} catch (Exception e) {
e.printStackTrace();
throw e;
} finally {
Query.close(conn);
}
}
public void tree2memory(Connection conn) throws Exception {
try {
if(!isInit){
String sql = "select * from " + _tablename;
MemoryDB.toAnotherConn(conn, sql, _tablename, MemoryDB
.getMemoConn());
isInit = true;
}
} catch (Exception e) {
e.printStackTrace();
throw e;
}
}
public NameSpace(String rootName, String nodeName,Connection conn) throws Exception {
this._rootname = rootName;
this._nodeName = nodeName;
tree2memory(conn);
}
public NameSpace(String rootName, String nodeName,String tablename,Connection conn) throws Exception {
this._rootname = rootName;
this._nodeName = nodeName;
this._tablename = tablename;
tree2memory(conn);
}
protected void addAttribute(MyHashMap map) throws SQLException {
String att = " ";
if("".equals(map.getString(_nsid))){
System.err.println("addAttribute(map) 的map.getString(_nsid)==空");
}
Connection conn = MemoryDB.getMemoConn();
try {
map.put("id", map.getString(_nsid));
String symbol = _nsid_Type.equals("string")?"'":"";
int childcount = new Query(conn, false)
.getFirstInt("select count(*) from " + _tablename
+ " where " + _parentid + "=" +symbol+ map.getString(_nsid)+symbol
+ "");
map.put("childcount", childcount);
String nsnameseq = getSeqence(conn, map.getString(_nsid), _nsname);
String labelseq = getSeqence(conn, map.getString(_nsid), _label);
String nsidseq = getSeqence(conn, map.getString(_nsid), _nsid);
int level = 0;
if (nsnameseq != null) {
level = nsnameseq.split("\\.").length - 1;
}
if (nsnameseq.startsWith(".")) {
nsnameseq = nsnameseq.substring(1);
labelseq = labelseq.substring(1);
level = level - 1;
}
map.put("nslevel", level);
map.put("nsid", map.getString(_nsid));
map.put("nsname", map.getString(_nsname));
map.put("label", map.getString(_label));
map.put("namesequence", nsnameseq);
map.put("labelsequence", labelseq);
map.put("nsidsequence", nsidseq);
map.put("idsequence", nsidseq);
map.put("nslevel", level);
if (childcount > 0) {
map.put("haschildren", "true");
map.put("isBranch", "true");
} else {
map.put("haschildren", "false");
map.put("isBranch", "false");
}
if(!map.getString("isdata").equals("true")){
map.put("isdata", "false");
}
} catch (SQLException e) {
throw e;
} finally {
// Query.close(conn);
}
}
/**
* 返回所有的孩子节点
*
* @param nsid
* @return
* @throws SQLException
*/
public String getAllChildNs(Connection conn, String nsid)
throws SQLException {
String str = "";
String symbol = _parentid_Type.equals("string")?"'":"";
List list = new Query(conn, false).get("select " + _nsid + " from "
+ _tablename + " where " + _parentid + "=" + symbol+ nsid+symbol
+ " order by " + _displayorder);
for (int i = 0; i < list.size(); i++) {
MyHashMap map = (MyHashMap) list.get(i);
System.out.println(map.getString(_nsid.toLowerCase()));
str += "," + map.getString(_nsid.toLowerCase())
+ getAllChildNs(conn, map.getString(_nsid.toLowerCase()));
}
return str;
}
/**
*
*/
public String getAllChildNs(String nsid) throws SQLException {
String str = "";
Connection conn = new ConnInfo().getConn();
try{
str = getAllChildNs(conn,nsid);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
Query.close(conn);
}
return str;
}
/**
* 取到所有的祖辈.
*
* @param conn
* @param nsid
* @return
* @throws SQLException
*/
public String getAllParentID(Connection conn, String nsid)
throws SQLException {
if (nsid == null || nsid.trim().equals(""))
return "";
if (conn == null) {
conn = new ConnInfo().getConn();
}
String symbol = _nsid_Type.equals("string")?"'":"";
String pname = new Query(conn, false).getFirstString("select "
+ _nsname + " from " + _tablename + " where " + _nsid
+ "=(select " + _parentid + " from " + _tablename + " where "
+ _nsid +"=" + symbol+ nsid +symbol+ ")");
String name = new Query(conn, false).getFirstString("select " + _nsname
+ " from " + _tablename + " where " + _nsid + "=" + symbol+nsid+symbol);
String pid = new Query(conn, false).getFirstStrin
galaxy-java 开源java框架。 （207个子文件） 
NameSpace.class 25KB Query.class 23KB FileUtil.class 20KB MetadataManage.class 19KB DataManage.class 19KB HttpClientUtil41.class 16KB Imp.class 16KB SystemConfigFile.class 14KB XMLUtil.class 12KB StringUtil.class 12KB Test.class 11KB ConnInfo.class 11KB FileVersion.class 10KB MyHashMap.class 8KB DBManager.class 8KB Escape.class 8KB MemoryDB.class 6KB TestSendBlog.class 6KB SchemaManage.class 6KB RequestUtil.class 4KB MailUtil.class 4KB Report.class 4KB DBVersion.class 3KB DBConnection.class 3KB MYSQLDBManager.class 3KB ACCESSDBManager.class 3KB RegexTest.class 3KB OracleDBManager.class 3KB MSSQLDBManager.class 2KB SYBASEDBManager.class 2KB DB2DBManager.class 2KB DataSource.class 2KB DataType.class 2KB RandomString.class 2KB Status.class 2KB WebUI.class 2KB CookieUtil.class 2KB TestRegular.class 2KB MailUtil$ByteArrayDataSource.class 1KB ConnectPool.class 1KB NodeOrAttribute.class 1KB Table.class 1KB QUOTEMARK.class 1KB AlphaCase.class 1KB Token.class 1KB DATA_TYPE.class 1KB MODE.class 1020B MailUtil$SmtpAuthenticator.class 925B Tree.class 730B SysInfo.class 394B EForm.class 280B .classpath 3KB style.css 7KB WeblishTree.css 3KB color.css 1KB
设计文档.docx 12KB
shareFile.gif 929B bt.gif 472B ftv2folderclosed.gif 374B bg.gif 50B
groovy-1.6.3.jar 3.72MB sqlitejdbc-v056.jar 2.56MB ojdbc14.jar 1.47MB hadoop-0.12.2-core.jar 1.04MB jython.jar 703KB mysql-connector-java-5.1.7-bin.jar 693KB c3p0-0.9.1.2.jar 596KB c3p0-0.9.1.2.jar 596KB commons-collections-3.1.jar 546KB dom4j-full.jar 490KB log4j-1.2.8.jar 344KB log4j-1.2.8.jar 344KB httpclient-4.1.jar 342KB backport-util-concurrent.jar 319KB cglib-nodep-2.1_3.jar 317KB dom4j-1.6.1.jar 307KB commons-lang-2.2.jar 237KB commons-lang-2.2.jar 237KB commons-beanutils-1.7.0.jar 184KB httpcore-4.1.jar 177KB commons-net-1.4.1.jar 177KB concurrent.jar 168KB commons-collections.jar 161KB galaxy-2011-01-22.jar 157KB commons-net-20021030.jar 155KB commons-digester-1.8.jar 140KB commons-validator-1.3.1.jar 136KB junit.jar 118KB commons-beanutils.jar 116KB commons-digester.jar 107KB commons-dbcp.jar 105KB httpclient-cache-4.1.jar 103KB servlet-api.jar 95KB servlet-api.jar 95KB commons-chain-1.1.jar 88KB jdbmonitor.jar 86KB commons-dbcp.jar 80KB servlet.jar 78KB commons-discovery-0.2.jar 70KB commons-discovery.jar 70KB共 207 条
- 1
- 2
- 3
资源评论
xiyang2014-07-01很好，需要好好研究一下- sadam2013-08-15没有配置成功，不敢确定是否好用
