Flex的Tree开发——与Java后台老板交互，实现增删改查
Flex的Tree开发——与Java后台交互，实现增删改查
本例子实现与JAVA后台交互操作也就是增删改功能。主要知识点：XML的生成，hibernate的CURD，Tree控件。
1.Flex主程序
<?xml version="1.0" encoding="utf-8"?> <s:Application xmlns:fx="http://ns.adobe.com/mxml/2009" xmlns:s="library://ns.adobe.com/flex/spark" xmlns:mx="library://ns.adobe.com/flex/mx" minWidth="955" minHeight="600" xmlns:components="components.*"> <fx:Declarations> <!-- 将非可视元素（例如服务、值对象）放在此处 --> </fx:Declarations> <components:FlexTree/> </s:Application>
2.Flex控件：FlexTree.mxml包：components）
<?xml version="1.0" encoding="utf-8"?>
<s:Group xmlns:fx="http://ns.adobe.com/mxml/2009"
xmlns:s="library://ns.adobe.com/flex/spark"
xmlns:mx="library://ns.adobe.com/flex/mx" width="100%" height="100%"
creationComplete="init()">
<fx:Script>
<![CDATA[
import mx.controls.Alert;
import mx.rpc.events.ResultEvent;
import mx.utils.URLUtil;
protected function init():void{
listResult.convertDataToXml();
}
var xmlList:XML;
protected function listResult_resultHandler(event:ResultEvent):void
{
xmlList=XML(event.result.toString());
mytree.dataProvider=xmlList;
}
protected function tree1_clickHandler(event:MouseEvent):void
{
if(mytree.selectedItem.hasOwnProperty("@value" ))
{
var u:URLRequest=new URLRequest(mytree.selectedItem.@value);
//navigateToURL(new URLRequest(mytree.selectedItem.@value));
navigateToURL(u);
} else
{
//没有那就展开，如果展开了就收缩
mytree.expandItem(mytree.selectedItem,!mytree.isItemOpen(mytree.selectedItem),true);
}
}
var child:XML;
//添加兄弟节点
protected function addBefore():void
{
var xml:XML=mytree.selectedItem as XML;
var text:String=nextName.text;
if(xml!=null && text.length>0) {
var parent:XML=xml.parent();
if(parent!=null) {
child=new XML("<node foddersortName=\"\" foddersortId=\"\" parentid=\"\" />");
child.@foddersortName=text;
parent.insertChildBefore(xml,child);
var v:URLVariables = new URLVariables("method=add&editName="+text+"&parentId="+parent.@foddersortId);
/*
也可以是这种方式
var vars: URLVariables = new URLVariables ();
vars["varName"] = varValue; //把参数键,值对放到vars对象中.
vars["var2Name"] = var2Value;
*/
var r:URLRequest = new URLRequest();
r.url = "http://localhost/Flex02_Tree_Java/servlet/CURD";
r.method = URLRequestMethod.POST;
r.data = v;
var l:URLLoader = new URLLoader();
l.load(r);
l.addEventListener(Event.COMPLETE,txtCompleteHandler);
} else {
Alert.show("不能选中根节点");
}
} else {
Alert.show("需要先选中节点和填入文字");
}
}
private function txtCompleteHandler(e:Event):void
{
var l:URLLoader = URLLoader(e.target);
var o:Object = URLUtil.stringToObject(l.data,";",true);
var result:String=o.result;
var operateId:String=o.operateId;
if(operateId!=null){
//Alert.show(o.operateId);
//每次添加完毕节点后，就需要将刚插入数据库中的最大的ID查询出来赋给刚刚新增的XML节点的属性中
child.@foddersortId=operateId;
}
if(result=="update"){
Alert.show("更新成功!");
}else if(result=="delete"){
Alert.show("删除成功!");
}else if(result=="add"){
Alert.show("新增成功!");
}else{
Alert.show("操作失败!");
}
}
protected function addAfter():void
{
var xml:XML=mytree.selectedItem as XML;
var text:String=nextName.text;
if(xml!=null && text.length>0) {
var parent:XML=xml.parent();
if(parent!=null) {
child=new XML("<node foddersortName=\"\" foddersortId=\"\" parentid=\"\" />");
child.@foddersortName=text;
parent.insertChildAfter(xml,child);
var v:URLVariables = new URLVariables("method=add&editName="+text+"&parentId="+parent.@foddersortId);
/*
也可以是这种方式
var vars: URLVariables = new URLVariables ();
vars["varName"] = varValue; //把参数键,值对放到vars对象中.
vars["var2Name"] = var2Value;
*/
var r:URLRequest = new URLRequest();
r.url = "http://localhost/Flex02_Tree_Java/servlet/CURD";
r.method = URLRequestMethod.POST;
r.data = v;
var l:URLLoader = new URLLoader();
l.load(r);
l.addEventListener(Event.COMPLETE,txtCompleteHandler);
} else {
Alert.show("不能选中根节点");
}
} else {
Alert.show("需要先选中节点和填入文字");
}
}
protected function addSon():void
{
var xml:XML=mytree.selectedItem as XML;
var text:String=nextName.text;
if(xml!=null && text.length>0) {
var parent:XML=xml.parent();
child=new XML("<node foddersortName=\"\" foddersortId=\"\" parentid=\"\" />");
child.@foddersortName=text;
xml.appendChild(child);
mytree.expandChildrenOf(xml,true);
var v:URLVariables = new URLVariables("method=add&editName="+text+"&parentId="+xml.@foddersortId);
/*
也可以是这种方式
var vars: URLVariables = new URLVariables ();
vars["varName"] = varValue; //把参数键,值对放到vars对象中.
vars["var2Name"] = var2Value;
*/
var r:URLRequest = new URLRequest();
r.url = "http://localhost/Flex02_Tree_Java/servlet/CURD";
r.method = URLRequestMethod.POST;
r.data = v;
var l:URLLoader = new URLLoader();
l.load(r);
l.addEventListener(Event.COMPLETE,txtCompleteHandler);
} else {
Alert.show("需要先选中节点和填入文字");
}
}
protected function editNode():void
{
var xml:XML=mytree.selectedItem as XML;
var text:String=nextName.text;
if(xml!=null && text.length>0) {
xml.@foddersortName=text;
} else {
Alert.show("需要先选中节点和填入文字");
}
var v:URLVariables = new URLVariables("method=update&editName="+text+"&parentId="+xml.@foddersortId);
/*
也可以是这种方式
var vars: URLVariables = new URLVariables ();
vars["varName"] = varValue; //把参数键,值对放到vars对象中.
vars["var2Name"] = var2Value;
*/
var r:URLRequest = new URLRequest();
r.url = "http://localhost/Flex02_Tree_Java/servlet/CURD";
r.method = URLRequestMethod.POST;
r.data = v;
var l:URLLoader = new URLLoader();
l.load(r);
l.addEventListener(Event.COMPLETE,txtCompleteHandler);
}
protected function deleteNode():void
{
var xml:XML=mytree.selectedItem as XML;
if(xml!=null) {
var list:Array=mytree.selectedItems as Array;
for(var k:int=0;k<list.length;k++) {
xml=list[k] as XML;
var parent:XML=xml.parent();
if(parent!=null) {
var children:XMLList=parent.children();
for(var i:int=0;i<children.length();i++) {
if(children[i]==xml) {
delete children[i];
var v:URLVariables = new URLVariables("method=delete&parentId="+xml.@foddersortId);
/*
也可以是这种方式
var vars: URLVariables = new URLVariables ();
vars["varName"] = varValue; //把参数键,值对放到vars对象中.
vars["var2Name"] = var2Value;
*/
var r:URLRequest = new URLRequest();
r.url = "http://localhost/Flex02_Tree_Java/servlet/CURD";
r.method = URLRequestMethod.POST;
r.data = v;
var l:URLLoader = new URLLoader();
l.load(r);
l.addEventListener(Event.COMPLETE,txtCompleteHandler);
break;
}
}
} else {
Alert.show("不能选中根节点");
}
}
} else {
Alert.show("需要先选中节点");
}
}
protected function selectNode():void
{
var text:String=nextName.text;
if(text.length>0) {
var items:Array=[];
var list:XMLList=new XMLList();
list[0]=mytree.dataProvider[0];
searchItems(list,text,items);
mytree.selectedItems=items;
} else {
Alert.show("输入查找的文字");
}
}
private function searchItems(list:XMLList,find:String,items:Array):void {
for(var i:int=0;i<list.length();i++) {
var one:XML=list[i];
var label:String=one.@foddersortName;
if(label!=null && label.indexOf(find)>=0) {
items.push(one);
}
searchItems(one.children(),find,items);
}
}
protected function closeAll():void{
mytree.openItems=[];
}
protected function openAll():void{
mytree.expandChildrenOf(mytree.selectedItem,true);
}
]]>
</fx:Script>
<fx:Declarations>
<!-- 将非可视元素（例如服务、值对象）放在此处 -->
<s:RemoteObject destination="findName" id="listResult" result="listResult_resultHandler(event)"/>
</fx:Declarations>
<s:TextInput id="nextName" x="432" y="40" />
<mx:Tree x="30" y="10" width="264" height="600" id="mytree" showRoot="false" labelField="@foddersortName" ></mx:Tree>
<s:Button x="443" y="82" label="增加为哥" click="addBefore()"/>
<s:Button x="443" y="111" label="增加为弟" click="addAfter()"/>
<s:Button x="444" y="144" click="addSon()" label="增加为孩子"/>
<s:Button x="444" y="178" click="editNode()" label="修改节点"/>
<s:Button x="444" y="211" click="deleteNode()" label="删除节点"/>
<s:Button x="443" y="244" click="selectNode()" label="选择节点"/>
<s:Button x="443" y="277" click="closeAll()" label="全部收缩"/>
<s:Button x="443" y="306" click="openAll()" label="全部展开"/>
</s:Group>
3.JavaBean：TCategory.java
package com.wcx.bean;
import java.util.HashSet;
import java.util.Set;
import javax.persistence.CascadeType;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.OneToMany;
import javax.persistence.Table;
@Entity
@Table(name = "t_category")
public class TCategory implements java.io.Serializable {
// Fields
@Override
public String toString() {
return "[ cateId=" + cateId + ", name=" + name + "]";
}
private Integer cateId;
private TCategory TCategory;
private String name;
private Set<TCategory> TCategories = new HashSet<TCategory>(0);
// Constructors
/** default constructor */
public TCategory() {
}
/** full constructor */
public TCategory(TCategory TCategory, String name,
Set<TCategory> TCategories) {
this.TCategory = TCategory;
this.name = name;
this.TCategories = TCategories;
}
// Property accessors
@Id
@GeneratedValue
@Column(name = "cate_id", unique = true, nullable = false)
public Integer getCateId() {
return this.cateId;
}
public void setCateId(Integer cateId) {
this.cateId = cateId;
}
@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "parent_id")
public TCategory getTCategory() {
return this.TCategory;
}
public void setTCategory(TCategory TCategory) {
this.TCategory = TCategory;
}
@Column(name = "name")
public String getName() {
return this.name;
}
public void setName(String name) {
this.name = name;
}
@OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY, mappedBy = "TCategory")
public Set<TCategory> getTCategories() {
return this.TCategories;
}
public void setTCategories(Set<TCategory> TCategories) {
this.TCategories = TCategories;
}
}
4.UserService.java
package com.wcx.service;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Set;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.AnnotationConfiguration;
import com.wcx.bean.TCategory;
public class UserService {
private SessionFactory sessionFactory = new AnnotationConfiguration()
.configure().buildSessionFactory();
public void add(TCategory cate) {
Session session = sessionFactory.openSession();
Transaction tc = session.beginTransaction();
session.save(cate);
tc.commit();
System.out.println("数据库插入完成") ;
session.close();
}
public void delete(TCategory cate) {
Session session = sessionFactory.openSession();
Transaction tc = session.beginTransaction();
session.delete(cate);
tc.commit();
System.out.println("数据库删除完成") ;
session.close();
}
public void update(TCategory cate) {
Session session = sessionFactory.openSession();
Transaction tc = session.beginTransaction();
session.merge(cate);
tc.commit();
System.out.println("数据库更新完成") ;
session.close();
}
public TCategory findById(String id) {
String hql = "from TCategory where cateId=:id";
return (TCategory) sessionFactory.openSession().createQuery(hql)
.setString("id", id).uniqueResult();
}
public List<TCategory> findChildCategories(String id) {
if (id.equals("cate_root") || id == null || id.equals(" ")) {
return findCategoriesTop();
} else {
return (List<TCategory>)(sessionFactory.openSession().createQuery(
"from TCategory cate where cate.TCategory.cateId=:id")
.setString("id", id).list());
}
}
public List<TCategory> findCategoriesTop() {
System.out.println("查询顶级父目录.................");
String hql = "select distinct cate,childs from TCategory cate left join fetch cate.TCategories childs where cate.TCategory.cateId is null";
return sessionFactory.openSession().createQuery(hql).list();
}
public List<TCategory> findCategoriesAll() {
System.out.println("查询所有的项目.................");
String hql = "from TCategory";
return sessionFactory.openSession().createQuery(hql).list();
}
public List<Map<String, String>> findNameById(String id) {
List<Map<String, String>> names = new ArrayList<Map<String, String>>();
UserService sf = new UserService();
Set<TCategory> cates = sf.findById(id).getTCategories();
for (TCategory cate : cates) {
Map<String, String> maps = new HashMap<String, String>();
maps.put("CATALOGSID", cate.getCateId().toString());
maps.put("CATALOGNAME", cate.getName());
names.add(maps);
}
return names;
}
public Integer findLastId() {
String hql = "select max(cateId) from TCategory";
return (Integer) sessionFactory.openSession().createQuery(hql)
.uniqueResult();
}
}
5.组装XML文件
package com.wcx.util;
import java.util.List;
import com.wcx.bean.TCategory;
import com.wcx.service.UserService;
public class FindTreeNode {
// 把数据库中的无限级联表中数据拼装成一个XML文档
public String convertDataToXml() {
UserService sf = new UserService();
List<TCategory> cates = sf.findCategoriesAll();
System.out.println(cates);
List<TCategory> listTop = sf.findCategoriesTop();
String treedata = "<?xml version='1.0' encoding='utf-8'?>\n<node foddersortId='0' foddersortName='所有分类'>\n";
for (TCategory cate : listTop) {
treedata = treedata + "<node foddersortId='" + cate.getCateId()
+ "' foddersortName='" + cate.getName() + "'>\n";
treedata = CreateXmlNode(cates, cate.getCateId(), treedata);
treedata = treedata + "</node>\n";
}
treedata = treedata + "</node>\n";
System.out.println(treedata);
return treedata;
}
/**
* 递归解析list –> Xml
*/
public String CreateXmlNode(List<TCategory> list, int nodepid,
String cratedata) {
for (int a = 0; a < list.size(); a++) {
TCategory cate = list.get(a);
if (cate.getTCategory() == null || cate.getTCategory().equals("")) {
} else {
if (cate.getTCategory().getCateId() == nodepid) {
if (cate.getTCategories() != null) {
cratedata = cratedata + "<node foddersortId='"
+ cate.getCateId() + "' foddersortName='"
+ cate.getName() + "' parentid='"
+ cate.getTCategory().getCateId() + "'>\n";
cratedata = CreateXmlNode(list, cate.getCateId(),
cratedata);
cratedata = cratedata + "</node>\n";
} else {
cratedata = cratedata + "<node foddersortId='"
+ cate.getCateId() + "'foddersortName='"
+ cate.getName() + "' parentid='"
+ cate.getTCategory().getCateId() + "'/>\n";
}
}
}
}
return cratedata;
}
}
6.Servlet接受页面的请求
package com.wcx.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.wcx.bean.TCategory;
import com.wcx.service.UserService;
public class CURD extends HttpServlet {
public CURD() {
super();
}
public void destroy() {
super.destroy(); // Just puts "destroy" string in log
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
System.out.println("执行了树操作。。。。。。。。。。。。。。。");
request.setCharacterEncoding("utf-8");
String childName = request.getParameter("editName");
String parentId = request.getParameter("parentId");
String method = request.getParameter("method");
UserService sf = new UserService();
response.setCharacterEncoding("utf-8");
try {
if (method.equals("delete")) {
System.out.println("此次删除的ID为" + parentId);
if (parentId != null) {
TCategory cate1 = sf.findById(parentId);
System.out.println(cate1);
sf.delete(cate1);
response.getWriter().write("result=delete");
}
} else if (method.equals("update")) {
System.out.println("此次更新的ID为" + parentId);
if (childName != null && parentId != null) {
TCategory cate1 = sf.findById(parentId);
cate1.setName(childName);
System.out.println(cate1);
sf.update(cate1);
response.getWriter().write("result=update");
}
} else if (method.equals("add")) {
if (childName != null && parentId != null) {
TCategory category = new TCategory();
category.setName(childName);
TCategory cate1 = sf.findById(parentId);
category.setTCategory(cate1);
sf.add(category);
Integer lastId = sf.findLastId();
response.getWriter()
.write("result=add;operateId=" + lastId);
}
}
} catch (Exception e) {
System.out.println(e.toString());
response.getWriter().write("result=error");
}
}
public void init() throws ServletException {
// Put your code here
}
}
7.remote-config配置文件
<destination id="findName" >
<properties>
<source>com.wcx.util.FindTreeNode</source>
</properties>
</destination>
8.数据库SQL语句
CREATE TABLE `t_category` ( `name` varchar(255) DEFAULT NULL, `parent_id` int(11) DEFAULT NULL, `cate_id` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`cate_id`), KEY `parent_id` (`parent_id`), CONSTRAINT `t_category_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `t_category` (`cate_id`) ) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8;