Voting Tool: Unterschied zwischen den Versionen
Aus Java Student User Group Austria - Java + JVM in Wien Österreich / Vienna Austria
(Die Seite wurde neu angelegt: This site contains a short overview of the JSUG Voting tool hosted at [http://code.google.com/p/jsugvoting/ googlecode]. Its frontend is realized with Adobe Flex, where...) |
(kein Unterschied)
|
Version vom 19. Januar 2009, 16:26 Uhr
This site contains a short overview of the JSUG Voting tool hosted at googlecode. Its frontend is realized with Adobe Flex, whereas the complete backend is written in PHP.
Inhaltsverzeichnis
Hard Facts
Whole communication is done via sending/parsing simple XML.
Flex Frontend
- Flex SDK 3.2
- FlexBuilder 3.0.2
- Cairngorm
PHP Backend
- PHP5
- Simple XML for parsing communication data
- FrontController
- PDO
- MySQL and SQLite implementations
Sources
You can check out the full source code by:
# Non-members may check out a read-only working copy anonymously over HTTP. svn checkout http://jsugvoting.googlecode.com/svn/jsugvoting-read-only
Or just browse it via the url: http://code.google.com/p/jsugvoting/source/browse/
Data Model
+====================================================+ | user | +====================================================+ | *) user_id: INTEGER, PRIMARY KEY | | *) username: VARCHAR(80) | | *) password: VARCHAR(80) | +----------------------------------------------------+ +====================================================+ | category | +====================================================+ | | | *) category_id: INTEGER, PRIMARY KEY | | *) title: VARCHAR(255) | | | +----------------------------------------------------+ +====================================================+ | topic | +====================================================+ | *) topic_id: INTEGER, PRIMARY KEY | | *) title: VARCHAR(255) | +----------------------------------------------------+ +====================================================+ | offered_topic | +====================================================+ | *) offered_topic_id: INTEGER, PRIMARY KEY | | *) topic_id: INTEGER, REF(topic.topic_id) | | *) user_id: INTEGER, REF(user.user_id) | +----------------------------------------------------+ +====================================================+ | needed_topic | +====================================================+ | *) needed_topic_id: INTEGER, PRIMARY KEY | | *) topic_id: INTEGER, REF(topic.topic_id) | | *) category_id: INTEGER, REF(category.category_id) | +----------------------------------------------------+ +====================================================+ | vote | +====================================================+ | *) user_id: INTEGER, REF(user.user_id) | | *) topic_id: INTEGER, REF(topic.topic_id) | +----------------------------------------------------+
Requirements
Important
- Login/Logout
- View topics + details
- Add topic
- Submit vote
Luxury
- Search ... with continuous filtering
- Use already existing wiki-users instead of separate User database table