下边要说的这个例子是通过java查询数据库返回实体对象集合给Flex，Flex进行展示数据：
1、java中的实体类
[java]
package tobaccoTrans.entity;
import javax.persistence.Id;
import java.io.Serializable;
/**
* @author DWJ
*/
@javax.persistence.Entity
public class VIEW_CORP implements java.io.Serializable {
// Fields
@Id
private String code;
private String gbcode;
private String name;
private String simplename;
private String style;
private String parent;
private String flag;
public String getCode() {
return code;
}
public void setCode(String code) {
this.code = code;
}
public String getGbcode() {
return gbcode;
}
public void setGbcode(String gbcode) {
this.gbcode = gbcode;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getSimplename() {
return simplename;
}
public void setSimplename(String simplename) {
this.simplename = simplename;
}
public String getStyle() {
return style;
}
public void setStyle(String style) {
this.style = style;
}
public String getParent() {
return parent;
}
public void setParent(String parent) {
this.parent = parent;
}
public String getFlag() {
return flag;
}
public void setFlag(String flag) {
this.flag = flag;
}
}
package tobaccoTrans.entity;
import javax.persistence.Id;
import java.io.Serializable;
/**
* @author DWJ
*/
@javax.persistence.Entity
public class VIEW_CORP implements java.io.Serializable {
// Fields
@Id
private String code;
private String gbcode;
private String name;
private String simplename;
private String style;
private String parent;
private String flag;
public String getCode() {
return code;
}
public void setCode(String code) {
this.code = code;
}
public String getGbcode() {
return gbcode;
}
public void setGbcode(String gbcode) {
this.gbcode = gbcode;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getSimplename() {
return simplename;
}
public void setSimplename(String simplename) {
this.simplename = simplename;
}
public String getStyle() {
return style;
}
public void setStyle(String style) {
this.style = style;
}
public String getParent() {
return parent;
}
public void setParent(String parent) {
this.parent = parent;
}
public String getFlag() {
return flag;
}
public void setFlag(String flag) {
this.flag = flag;
}
}
2、JDBC连接Oracle的工具类：
3、Java查询方法：
[java]
package tobaccoTrans.dao.impl;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import tobaccoTrans.util.*;
import tobaccoTrans.entity.VIEW_CORP;
/**
* @author DWJ
*/
public class CorpDaoImpl extends ConnectionUtil {
private Connection con = null;
private Statement stmt = null;
private ResultSet rs = null;
/**
* 方法说明：执行查询SQL语句
* 输入参数：Connection con 数据库连接
* 输入参数：String sql 要执行的SQL语句
* 返回类型：void
*/
public List getAllCorp(String code,String gbcode,String name,String simplename,String style,String parent) {
List
try {