Listing 1. Pierwsza aplikacja







Listing 2. Dodajemy stopk








Listing 3. FlexForum.mxml







































Listing 4. Register.mxml

































Listing 5. FlexForum.as
import mx.managers.PopUpManager;
import mx.rpc.events.ResultEvent;
import views.Register;
public function login() : void {
var p : Object = new Object();
p.login = loginTextInput.text;
p.password = passwordTextInput.text;
srv.send(p);
}
public function logout() : void {
this.currentState='';
}
public function showRegisterPopUp() : void {
PopUpManager.createPopUp(this, views.Register, true);
}
public function srvResult(event : ResultEvent) : void {
var tmp : String = event.result.login;
if (tmp == "Success")
this.currentState = 'logged';
else if (tmp == "Failure")
PopUpManager.createPopUp(this, views.LoginFail, true);
}




Listing 6. Register.as
import mx.managers.PopUpManager;
import mx.rpc.events.ResultEvent;
public function hideRegisterPopUp() : void {
PopUpManager.removePopUp(this)
}
public function register() : void {
var params : Object = new Object();
params.login = login.text;
params.password = password.text;
params.email = email.text;
params.gender = (male.selected ? "male" : "female");
srv.send(params);
}
public function srvResult(event : ResultEvent) : void {
var tmp : String = event.result.registration;
if (tmp == "Success") {
hideRegisterPopUp();
this.parentApplication.currentState = 'logged';
} else if (tmp == "Failure")
PopUpManager.createPopUp(this, views.RegisterFail, true);
}

Listing 7. Uwidaczniamy nasz klas


flex.Forum.Forum






Listing 8. Forum.java
package flex.Forum;
import java.sql.Connection;
import java.sql.PreparedStatement;
import javax.servlet.http.HttpServlet;
public class Forum extends HttpServlet {
public boolean login(String login, String password) {
// TODO
return true;
}
public boolean logout(String login) {
//TODO
return true;
}
public boolean register(String login, String password, String email, String gender) {
Connection c = null;
PreparedStatement ps = null;
try {
c = ConnectionHelper.getConnection();
ps = c.prepareStatement("INSERT INTO user (login, password, email, gender, type) VALUES (?, ?, ?, ?, ?)");
ps.setString(1, login);
ps.setString(2, password);
ps.setString(3, email);
ps.setString(4, gender);
ps.setString(5, "user");
ps.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
} finally {
ConnectionHelper.close(c);
}
return true;
}
}

Listing 9. Register.jsp
<%@ page import="flex.Forum.Forum" contentType="text/html"%>

<%
Forum f = new Forum();
if (f.register(request.getParameter("login"), request.getParameter("password"), request.getParameter("email"), request.getParameter("gender")) == true) {
%>
Success
<%
} else {
%>
Failure
<%
}
%>




Listing 10. login.jsp
<%@ page import="flex.Forum.Forum" contentType="text/html"%>

<%
Forum f = new Forum();
if (f.login(request.getParameter("login"), request.getParameter("password")) == false) {
%>
Success
<%
} else {
%>
Failure
<%
}
%>

Listing 11. flexdemodb.script
CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE USER(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,LOGIN VARCHAR(40),PASSWORD VARCHAR(128),EMAIL VARCHAR(65),GENDER VARCHAR(6),TYPE VARCHAR(9),LOGGED BOOLEAN,IP VARCHAR(15))
ALTER TABLE USER ALTER COLUMN ID RESTART WITH 12
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 20
SET SCHEMA PUBLIC