FARNETANI

CREATE TABLE `user` (
  `userID` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`userID`)
);

package tt;
public class UserDAO {

	private Connection conn = null;
	private PreparedStatement pst = null;
	private Statement stm = null;

	public Connection getConnection()throws Exception {
		if(conn == null){
			Class.forName("org.gjt.mm.mysql.Driver");
			conn = DriverManager.getConnection("jdbc:mysql://localhost/exemplo?user=root&password=xxxx");
			conn.setAutoCommit(false);
		}
		return conn;
	}

	public void save(String name, String email)throws Exception{
		try{
			conn = getConnection();
			pst = conn.prepareStatement("INSERT INTO user(name, email) values(?, ?)");
			pst.setString(1, name);
			pst.setString(2, email);
			pst.executeUpdate();
			conn.commit();
		}
		catch(Exception e){
			e.printStackTrace();
			conn.rollback();
		}
		finally{
			pst.close();
			conn.close();
		}
	}

	public void delete(int userID)throws Exception{
		try{
			conn = getConnection();
			pst = conn.prepareStatement("DELETE FROM user where userID = ?");
			pst.setInt(1, userID);
			pst.executeUpdate();
			conn.commit();
		}
		catch(Exception e){
			e.printStackTrace();
			conn.rollback();
		}
		finally{
			pst.close();
			conn.close();
		}
	}

	public ArrayList list()throws Exception{
		ArrayList<User> list = null;
		try{
			conn = getConnection();
			stm = conn.createStatement();
			ResultSet rs = stm.executeQuery("SELECT * FROM user order by userID DESC");
			list = new ArrayList<User>();
			while(rs.next()){

				User u = new User();
				u.setUserID(rs.getInt("userID"));
				u.setName(rs.getString("name"));
				u.setEmail(rs.getString("email"));

				list.add(u);
			}
		}
		catch(Exception e){
			e.printStackTrace();
			conn.rollback();
		}
		finally{
			stm.close();
			conn.close();
		}
		return list;
	}
}

package tt;
public class User{

	public int userID;
	public String name;
	public String email;

	public String getEmail() {
		return email;
	}
	public void setEmail(String email) {
		this.email = email;
	}
	public int getUserID() {
		return userID;
	}
	public void setUserID(int userID) {
		this.userID = userID;
	}
	public String getName() {
		return name;
	}
	public void setName(String nome) {
		this.name = nome;
	}

}

package tt;
public class UserService {

	public UserService() {
	}

	public void save(String name, String email)throws Exception{
		new UserDAO().save(name, email);
	}

	public ArrayList list()throws Exception{
		return new UserDAO().list();
	}

	public void delete(int userID)throws Exception{
		new UserDAO().delete(userID);
	}
}

<?xml version="1.0" encoding="UTF-8"?>
<web-app id="WebApp_ID" version="2.4"
	xmlns="http://java.sun.com/xml/ns/j2ee"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
	<!-- openamf gateways -->
	<servlet>
		<description>DefaultGateway</description>
		<display-name>DefaultGateway</display-name>
		<servlet-name>DefaultGateway</servlet-name>
		<servlet-class>org.openamf.DefaultGateway</servlet-class>
		<init-param>
			<description>Location of the OpenAMF config file.</description>
			<param-name>OPENAMF_CONFIG</param-name>
			<param-value>/WEB-INF/openamf-config.xml</param-value>
		</init-param>
		<load-on-startup>1</load-on-startup>
	</servlet>
	<servlet-mapping>
		<servlet-name>DefaultGateway</servlet-name>
		<url-pattern>/gateway</url-pattern>
	</servlet-mapping>
	<welcome-file-list>
		<welcome-file>index.html</welcome-file>
	</welcome-file-list>
</web-app>

- ant.jar
- astranslator-1.5.9.jar
- commons-beanutils-1.7.0.jar
- commons-codec-1.3.jar
- commons-collections-3.1.jar
- commons-digester.jar
- commons-discovery.jar
- commons-httpclient-3.0.jar
- commons-lang-2.1.jar
- commons-logging-1.0.4.jar
- junit-3.8.1.jar
- mysql-connector-java-3.1.12-bin.jar
- openamf.jar
- saaj.jar
- wsdl4j.jar

package tt
{
	import flash.net.NetConnection;
	import flash.net.ObjectEncoding;
	public class RemotingConnection extends NetConnection
	{
		public var sURL:String = "http://localhost:8080/sua_app_web/gateway";
	    public function RemotingConnection(){
            objectEncoding = ObjectEncoding.AMF0;
            connect(sURL);
        }
	}
}

<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute" width="531" height="312" initialize="initApp()">
	<mx:Script>
	<![CDATA[
		import mx.collections.ArrayCollection;
		import mx.controls.Alert;
		import tt.RemotingConnection;
        import flash.net.Responder;
        public var service : RemotingConnection;
	    [Bindable]
	    public var users:ArrayCollection;

		public function initApp(): void{
			service = new RemotingConnection();
			list();
		}

        public function save() : void{
			if(txtName.text != "" && txtEmail.text != ""){
	        	var name:String = txtName.text;
    	    	var email:String = txtEmail.text;
        	    service.call( "tt.UserService.save", new Responder(saveResult, resultFault), name, email);
			}
			else{
				Alert.show("Você deve informar Nome e Email !");
			}
        }

        public function saveResult( result : String ) : void
        {
        	Alert.show("Salvo com Sucesso !");
        	txtName.text = "";
        	txtEmail.text = "";
           	list();
        }

        public function resultFault( fault : String ) : void
        {
            Alert.show( "Falha !!" + fault.toString());
        }

        public function list() : void{
            service.call( "tt.UserService.list", new Responder(listResult, resultFault));
        }
        public function listResult( result : Array ) : void
        {
			users = new ArrayCollection(result);
        }

        public function delet(): void{
        	if(gridUsers.selectedItem != null){
	        	var userID:int = gridUsers.selectedItem.userID;
	            service.call( "tt.UserService.delete", new Responder(deletResult, resultFault), userID);
        	}
        	else{
        		Alert.show("Selecione uma linha !");
        	}
        }
        public function deletResult( result : String ) : void
        {
        	Alert.show("Excluído com Sucesso !");
           	list();
        }
	]]>
</mx:Script>
	<mx:Panel x="52" y="19" width="427" height="267" layout="absolute" title="Manutenção de Usuários">
		<mx:Button x="332" y="45" label="Salvar" id="btnSalvar" click="save();"/>
		<mx:Label x="10" y="21" text="Nome:"/>
		<mx:TextInput x="60" y="17" width="337" id="txtName"/>
		<mx:Label x="12" y="47" text="Email:"/>
		<mx:TextInput x="60" y="45" width="264" id="txtEmail"/>
		<mx:DataGrid x="10" y="73" width="387" height="117" dataProvider="{users}" id="gridUsers">
			<mx:columns>
				<mx:DataGridColumn headerText="ID" dataField="userID"/>
				<mx:DataGridColumn headerText="Nome" dataField="name"/>
				<mx:DataGridColumn headerText="Email" dataField="email"/>
			</mx:columns>
		</mx:DataGrid>
		<mx:Button x="333" y="198" label="Excluir" id="btnExcluir" click="delet();"/>
	</mx:Panel>
</mx:Application>