Java开发网 - Spring+iBatis+JDom递归生成XML树

Java开发网

您没有登录

» Java开发网 » WebService/XML/JSON/SOAP/SOA » XML

打印话题 寄给朋友 订阅主题

作者

Spring+iBatis+JDom递归生成XML树

yahoo2009

发贴: 2
积分: 0

于 2009-08-15 20:28

先看看整体结构：
F:\WORKSPACE\TREEXML
│ .classpath
│ .mymetadata
│ .project
│ .treexml.txt
│ luanmad.xml
│
├─.myeclipse
├─.settings
│ .jsdtscope
│ org.eclipse.jdt.core.prefs
│ org.eclipse.wst.jsdt.ui.superType.container
│ org.eclipse.wst.jsdt.ui.superType.name
│
├─ibatisfactory
│ abator.jar
│ abatorConfig.xml
│
├─src
│ │ applicationContext.xml
│ │ jdbc.properties
│ │ log4j.properties
│ │ sqlmapclient.xml
│ │ treexml.sql
│ │
│ └─cn
│ └─luanmad
│ ├─dao
│ │ │ TreeXMLDAO.java
│ │ │
│ │ └─impl
│ │ TreeXMLDAOImpl.java
│ │
│ ├─ibatis
│ │ TreeXMLDO.java
│ │ treexml_SqlMap.xml
│ │
│ ├─manager
│ │ │ TreeXMLManager.java
│ │ │
│ │ └─impl
│ │ TreeXMLManagerImpl.java
│ │
│ └─treexml
│ TreeXML.java
│
└─WebRoot
│ index.jsp
│
├─META-INF
│ MANIFEST.MF
│
└─WEB-INF
│ web.xml
│
├─classes
│ │ applicationContext.xml
│ │ jdbc.properties
│ │ log4j.properties
│ │ sqlmapclient.xml
│ │ treexml.sql
│ │
│ └─cn
│ └─luanmad
│ ├─dao
│ │ │ TreeXMLDAO.class
│ │ │
│ │ └─impl
│ │ TreeXMLDAOImpl.class
│ │
│ ├─ibatis
│ │ TreeXMLDO.class
│ │ treexml_SqlMap.xml
│ │
│ ├─manager
│ │ │ TreeXMLManager.class
│ │ │
│ │ └─impl
│ │ TreeXMLManagerImpl.class
│ │
│ └─treexml
│ TreeXML.class
│
└─lib
commons-dbcp.jar
commons-logging.jar
commons-pool.jar
ibatis-2.3.0.677.jar
jdom-1.0.jar
log4j-1.2.14.jar
mysql-connector-java-5.1.6-bin.jar
spring.jar

1.TreeXMLDAOImpl.java，DAO层的实现

代码:
package cn.luanmad.dao.impl;

import java.util.List;

import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;

import cn.luanmad.dao.TreeXMLDAO;

/**
* 类说明
*
* @author luanmad!
* @version V1.0 创建时间：2009-8-14 下午07:02:35
*/
public class TreeXMLDAOImpl extends SqlMapClientDaoSupport implements TreeXMLDAO
{

public List queryAllForList(String sql)
{
return this.getSqlMapClientTemplate().queryForList(sql);
}

}
2.TreeXMLDAO.java，DAO层的接口

代码:
package cn.luanmad.dao;

import java.util.List;

/**
* 类说明
*
* @author luanmad!
* @version V1.0 创建时间：2009-8-14 下午07:00:34
*/
public interface TreeXMLDAO
{
List queryAllForList(String sql);
}
3.实体TreeXMLDO.java，对就数据库treexml

代码:
package cn.luanmad.ibatis;

/**
*
* 类说明
*
* @author luanmad!
* @version V1.0 创建时间：2009-8-14 下午06:52:27
*
*/
public class TreeXMLDO
{
private Integer id;

private String name;

private Integer pid;

public Integer getId()
{
return id;
}

public void setId(Integer id)
{
this.id = id;
}

public String getName()
{
return name;
}

public void setName(String name)
{
this.name = name;
}

public Integer getPid()
{
return pid;
}

public void setPid(Integer pid)
{
this.pid = pid;
}
}
4.treexml_SqlMap.xml ，iBatis生成的SqlMap
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd" >
<sqlMap namespace="treexml" >
<typeAlias alias="treeXMLDO" type="cn.luanmad.ibatis.TreeXMLDO"/>
<resultMap id="treeXMLDOMap" class="treeXMLDO" >
<result column="id" property="id" jdbcType="INTEGER" />
<result column="name" property="name" jdbcType="VARCHAR" />
<result column="pid" property="pid" jdbcType="INTEGER" />
</resultMap>
<select id="treeXMLDO.selectAll" resultMap="treeXMLDOMap" parameterClass="treeXMLDO" >
select id, name, pid
from treexml
</select>
</sqlMap>

5.TreeXMLManagerImpl .java，Manager层的实现

代码:
package cn.luanmad.manager.impl;

import java.util.List;

import cn.luanmad.dao.TreeXMLDAO;
import cn.luanmad.manager.TreeXMLManager;

/**
* 类说明
*
* @author luanmad!
* @version V1.0 创建时间：2009-8-14 下午07:19:59
*/
public class TreeXMLManagerImpl implements TreeXMLManager
{
private TreeXMLDAO treeXMLDAO;

public TreeXMLDAO getTreeXMLDAO()
{
return treeXMLDAO;
}

public void setTreeXMLDAO(TreeXMLDAO treeXMLDAO)
{
this.treeXMLDAO = treeXMLDAO;
}

public List queryAllForList(String sql) throws Exception
{
return treeXMLDAO.queryAllForList(sql);
}

}
6.TreeXMLManager .java ,Manager层的接口

代码:
package cn.luanmad.manager;

import java.util.List;

/**
* 类说明
*
* @author luanmad!
* @version V1.0 创建时间：2009-8-14 下午07:19:32
*/
public interface TreeXMLManager
{
List queryAllForList(String sql)throws Exception;
}
7.TreeXML.java，JDOM递归生成XML树

代码:
package cn.luanmad.treexml;

import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

import org.jdom.Document;
import org.jdom.Element;
import org.jdom.output.XMLOutputter;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import cn.luanmad.ibatis.TreeXMLDO;
import cn.luanmad.manager.TreeXMLManager;
import cn.luanmad.manager.impl.TreeXMLManagerImpl;

/**
* 类说明
* JDom递归生成XML树
* @author luanmad!
* @version V1.0 创建时间：2009-8-14 下午23:51:56
*/
public class TreeXML
{

// 创建根节点 TREENODES;
Element root = new Element("LuanmadNodes");

// 根节点添加到文档中；
Document doc = new Document(root);

Element elements = null;

@SuppressWarnings("unchecked")
private boolean hasChild(List list, Integer pid)
{
Iterator iterator = list.iterator();
boolean bool = false;
while (iterator.hasNext())
{
TreeXMLDO t = (TreeXMLDO) iterator.next();
if (pid.equals(t.getPid()))
{
bool = true;
break;
}
}
return bool;
}

private void createFile(Integer pid, Element p, List list)
{
if (p == null)
p = root;
StringBuffer stringBuffer = new StringBuffer();
for (int i = 0; i < list.size(); i++)
{
TreeXMLDO temp = (TreeXMLDO) list.get Light Bulb

;

// 创建当前节点对象
Element nowNode = new Element("luanmadNode");

/* 存入ID时的规则(1.只用当前ID;2.用父ID+当前ID) */
stringBuffer.delete(0, stringBuffer.length());
stringBuffer.append(temp.getId());

nowNode.setAttribute("id", stringBuffer.toString());
nowNode.setAttribute("pid", temp.getPid().toString());
nowNode.setAttribute("name", temp.getName());

// 找到指定级别的子类
if (pid.equals(temp.getPid()))
{
// 这里是打印,可以换成输出,或是做别的处理
System.out.println("id="+temp.getId()+ ",pid=" + pid+",name="+ temp.getName() );
p.addContent(nowNode); // 加入当前节点到父节点

// 判断是否存在下级节点,若存在读取所有节点
if (hasChild(list, temp.getId()))
createFile(temp.getId(), nowNode, list);
}

}
saveXmlFile();
}

/*把数据写入文件*/
private void saveXmlFile()
{
XMLOutputter xmlout = new XMLOutputter();
String path = "luanmad.xml";
try
{

xmlout.output(doc, new FileOutputStream(path));
}
catch (FileNotFoundException e)
{
e.printStackTrace();
}
catch (IOException e)
{
e.printStackTrace();
}
}

/* 创建树的入口 */
private void start(List list)
{
Element e = null;
createFile(0, e, list);
}

@SuppressWarnings("unchecked")
/*Spring和iBatis整合从数据库里获得数据*/
public List getTreeXMLList()
{
ApplicationContext context = new ClassPathXmlApplicationContext(
"classpath:applicationContext.xml");
TreeXMLManager treeXMLManager = (TreeXMLManagerImpl) context
.getBean("treeXMLManager");

List list = new ArrayList();
try
{

list = (List) treeXMLManager
.queryAllForList("treeXMLDO.selectAll");
Iterator iterator = list.iterator();
System.out.println("----------------原来顺序-----------------");
while (iterator.hasNext())
{
TreeXMLDO treeXMLDO = (TreeXMLDO) iterator.next();
System.out.println("id=" + treeXMLDO.getId() + ",pid="
+ treeXMLDO.getPid() + ",name=" + treeXMLDO.getName());
}
System.out.println("----------------构树后顺序-----------------");
}
catch (Exception e)
{
e.printStackTrace();
}
return list;
}

@SuppressWarnings("unchecked")
public static void main(String[] argStrings)
{

TreeXML treeXML= new TreeXML();

treeXML.start(treeXML.getTreeXMLList());

}

}
8.applicationContext.xml，spring配置
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd ">


<bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PreferencesPlaceholderConfigurer">
<property name="location">
<value>classpath:jdbc.properties</value>
</property>
</bean>

<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"
value="${jdbc.driver}">
</property>
<property name="url"
value="${jdbc.url}">
</property>
<property name="username" value="${jdbc.user}"></property>
<property name="password" value="${jdbc.password}"></property>
</bean>

<bean id="sessionFactory"
class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="configLocation">
<value>classpath:sqlmapclient.xml</value>
</property>
</bean>

<bean id="treeXMLDAO" class="cn.luanmad.dao.impl.TreeXMLDAOImpl">
<property name="dataSource" ref="dataSource"></property>
<property name="sqlMapClient" ref="sessionFactory"></property>
</bean>

<bean id="treeXMLManager" class="cn.luanmad.manager.impl.TreeXMLManagerImpl">
<property name="treeXMLDAO" ref="treeXMLDAO"></property>
</bean>


<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"></property>
</bean>


<tx:advice id="methodAdvice" transaction-manager="transactionManager">
<tx:attributes>
<tx:method name="select*" read-only="true"/>
<tx:method name="update*" propagation="REQUIRED"/>
<tx:method name="delete*"/>
<tx:method name="insert*"/>
<tx:method name="*"/>
</tx:attributes>
</tx:advice>



</beans>

9.数据库jdbc.properties配置
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:2008/luanmad
jdbc.user=root
jdbc.password=admin

10.日志配置

log4j.rootLogger=DEBUG, stdout

log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%c{1} - %m%n

log4j.logger.java.sql.PreparedStatement=DEBUG

11.sqlmapclient.xml配置

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMapConfig
PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-config-2.dtd">


<sqlMapConfig>
<settings
cacheModelsEnabled="true"
enhancementEnabled="true"
lazyLoadingEnabled="true"
errorTracingEnabled="true"
maxRequests="32"
maxSessions="10"
maxTransactions="5"
useStatementNamespaces="false"
/>



<sqlMap resource="cn/luanmad/ibatis/treexml_SqlMap.xml" />
</sqlMapConfig>

11.treexml.sql，创建数据
/*
SQLyog 浼佷笟鐗? - MySQL GUI v7.14
MySQL - 6.0.5-alpha-community : Database - luanmad
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

CREATE DATABASE /*!32312 IF NOT EXISTS*/`luanmad` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE `luanmad`;

/*Table structure for table `treexml` */

DROP TABLE IF EXISTS `treexml`;

CREATE TABLE `treexml` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(20) NOT NULL,
`pid` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

/*Data for the table `treexml` */

insert into `treexml`(`id`,`name`,`pid`) values (1,'aaa',0),(2,'bbb',0),(3,'ccc',1),(4,'ddd',3),(5,'eee',3),(6,'fff',2),(7,'ggg',4),(8,'hhh',6);

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

12.用ibator.jar自动生成SQLMAP的配置

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE abatorConfiguration PUBLIC "-//Apache Software Foundation//DTD Abator for iBATIS Configuration 1.0//EN"
"http://ibatis.apache.org/dtd/abator-config_1_0.dtd">

<abatorConfiguration>
<abatorContext>
<jdbcConnection driverClass="com.mysql.jdbc.Driver"
c userId="root"
password="admin">

<classPathEntry
location="..\WebRoot\WEB-INF\lib\mysql-connector-java-5.1.6-bin.jar" />
</jdbcConnection>
<javaModelGenerator targetPackage="cn.luanmad.ibatis"
targetProject="..\src" />
<sqlMapGenerator targetPackage="cn.luanmad.ibatis" targetProject="..\src" />
<daoGenerator type="IBATIS" targetPackage="dao"
targetProject="..\src" />

<table schema="luanmad" tableName="treexml" domainObjectName="TreeXMLDO">
</table>
</abatorContext>
</abatorConfiguration>

本人用的是myeclipse7.1没有找到好的ibatis生成sqlmap的插件。本例是用ibator.jar自动手动生成的sqlmap。在 DOS下先切换到ibator.jar的目录下（如F:\workspace\TreeXML\ibatisfactory），然后输入命令
F:\workspace\TreeXML\ibatisfactory>java -jar abator.jar abatorConfig.xml true
就会自动生成cn\luanmad\ibatis目录，并生成treexml_SqlMap.xml和TreeXMLDO（只留此两文件就行，其余可以去掉）
还会生成cn\luanmad\dao目录，并生成TreeXMLDAO.java文件和TreeXMLDAOImpl.java，自已动手建个 cn\luanmad\dao\impl目录，将TreeXMLDAOImpl.java文件放入。到此基本上可以了。赶快试试吧！

下载：TreeXML.rar

已读帖子

新的帖子

被删除的帖子