hai everybody,
i am new to flex environment and i am presently working on remote
object service.
in this regard i need a help,
i am trying to retrieve values from sql and output them to datagrid,
i am unable to see the values outputed to datagrid
my sql db contains two columns cname and email, and i am working on
flex 1.5
here is my mxml,as,java file to solve the above problem.
LoginchkAB.java
import java.sql.*;
import java.util.ArrayList;
public class LoginchkAB{
Connect q=new Connect();
public void LoginchkAB()
{
}
public ArrayList getList()
{
ArrayList list = new ArrayList();
try
{
Connection Conn=q.establish_Connection();
Statement s = Conn.createStatement();
ResultSet rs= s.executeQuery("select cname,email from
deepa123456");
System.out.println("ramana");
while (rs.next
()) {
list.add(new ViewuserVO
(rs.getString(1),rs.getString(2)));
System.out.println("ramana");
}
s.close();
Conn.close();
}
catch(Exception e)
{
System.out.println("TechRP"+e);
}
return list;
}
public static void main(String args[])
{
LoginchkAB q=new LoginchkAB();
}
}
ViewuserVO.as file
class ViewuserVO {
public var cname : String;
public var email : String;
static var registered=Object.registerClass("ViewuserVO",
ViewuserVO);
}
UsingRemoteObj1.mxml
<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.macromedia.com/2003/mxml";
verticalGap="10">
<mx:Button label="Get user List" click="getusers()"/>
<mx:DataGrid id="dg" dataProvider="{loginchkA.list}" width="100%"
height="100%">
<mx:columns>
<mx:Array>
<mx:DataGridColumn columnName="cname"
headerText="cname" />
<mx:DataGridColumn columnName="email"
headerText="email"/>
</mx:Array>
</mx:columns>
</mx:DataGrid>
<mx:Script>
var list;
</mx:Script>
<mx:Script>
<![CDATA[
function getusers()
{
loginchkA.getList();
}
]]>
</mx:Script>
<mx:RemoteObject id="loginchkA" result="list=event.result"
source="LoginchkAB" fault="alert(event.fault.faultstring, 'Error')">
<mx:method name="getList"/>
</mx:RemoteObject>
</mx:Application>
i would be thankful for the help regarding this.
Thank u all
Ramana
--
Flexcoders Mailing List
FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt
Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/flexcoders/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/flexcoders/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
