flex显示数据库表中的所有数据

flex显示数据库表中的所有数据,我通过调用远程对象来实现。

flex调用远程对象，服务器端我使用的是BlazeDS,我的另一篇文章讲到了如何搭建BlazeDS环境，

文章地址是：http://www.voidcn.com/article/p-rhuiaqup-wz.html

在此不再敖述BlazeDS.

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

看下数据库表截图：

------------------------------------------------------------------------------------------------------------------

flex程序效果截图

----------------------------------------------------------------------------------------------------------------------------------

服务器端java代码：

public class AdminDAOImpl implements AdminDAO{

	@Override
	public List<Admin> GetAllAdmin() { //获取数据库表中的所有用户信息
		try {
			List<Admin> list=new ArrayList();
			String sql="select * from tbAdmin";
			ResultSet rs=DbCRUD.Select(sql);
			while(rs.next())
			{
				Admin admin=new Admin();
				admin.setId(rs.getInt("id"));
				admin.setUsrName(rs.getString("usrName"));
				admin.setUsrPass(rs.getString("usrPass"));
				list.add(admin);
				//System.out.println(rs.getString(1)+"---"+rs.getString(2));
			}
			return list;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return null;
	}

	@Override
	public Admin GetAdmin(int id) {
		try {
			String sql="select * from tbAdmin where id='1'";
			sql=sql.replace("1",String.valueOf(id));
			//System.out.println(sql);
			ResultSet rs=DbCRUD.Select(sql);
			int row=0;
			Admin admin=new Admin();
			while(rs.next())
			{
				admin.setId(rs.getInt("id"));
				admin.setUsrName(rs.getString("usrName"));
				admin.setUsrPass(rs.getString("usrPass"));
				//System.out.println(rs.getString(1)+"---"+rs.getString(2));
			}
			return admin;
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return null;
	}
	
}

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

remoting-config.xml文件配置：

<?xml version="1.0" encoding="UTF-8"?>
<service id="remoting-service" 
    class="flex.messaging.services.RemotingService">

    <adapters>
        <adapter-definition id="java-object" class="flex.messaging.services.remoting.adapters.JavaAdapter" default="true"/>
    </adapters>

    <default-channels>
        <channel ref="my-amf"/>
    </default-channels>

	<destination id="adminDAOImpl">  
        <properties>  
            <source>dao.impl.AdminDAOImpl</source>  
        </properties>  
	</destination>  
</service>

以上主要是配置远程对象adminDAOImpl，这样flex才能调用它。

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

flex代码：

<fx:Declarations>
		<!-- 将非可视元素（例如服务、值对象）放在此处 -->
		<s:RemoteObject id="roAdmin" destination="adminDAOImpl">  
			<s:method name="GetAllAdmin" result="rstGetAllAdmin(event)" fault="fltGetAllAdmin(event)"/>  
		</s:RemoteObject> 
</fx:Declarations>
	
			[Bindable]
			var ac:ArrayCollection=new ArrayCollection();//定义数据绑定对象ac
			
			//远程对象调用成功时
			private function rstGetAllAdmin(evt:ResultEvent):void
			{
				ac=evt.result as ArrayCollection;
				dgUser.dataProvider=ac;
			}
			
			//远程对象调用失败时
			private function fltGetAllAdmin(evt:FaultEvent):void
			{
				Alert.show(evt.message as String);
			}
			
			//显示所有
			protected function btnViewAll_clickHandler(event:MouseEvent):void
			{
				roAdmin.GetAllAdmin();//调用远程对象
			}

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

再贴一下效果截图:

---------------------------------------------------------------------------------------------------------------------------------

您的十分满意是我追求的宗旨。

您的一点建议是我后续的动力。