Android ebook Project Training "Project description" "1"

Overview:

The training program is an undergraduate course, an Android program that is designed to train Android apps to access servers, get server data, parse, and present the process. The main features include:

1. User Registration

2. Login

3. View Documents

4. Download ebook

5. Reading ebook

6. User Management

Design Description:

The training program needs to develop Android client and server-side applications.

The server side uses STRUTS2 to access the MySQL database directly using JDBC.

The client uses the Xutils framework to access the action and get the JSON string.

Development environment:

Server-side uses MyEclipse, version can use 9, 10, etc., the database uses MySQL

Android with Adt-bundle Eclipse 4.2

Database design:

SET foreign_key_checks=0;--------------------------------Table structure for ' tb_accountinfo '--------------------- ---------DROP TABLE IF EXISTS ' tb_accountinfo '; CREATE TABLE ' tb_accountinfo ' (' id ' int (one) not null auto_increment, ' loginName ' varchar () ' is not null, ' Loginpwd ' Varc Har (+) not NULL, ' level ' int (one) not null, ' lastlogindate ' timestamp null DEFAULT null on UPDATE current_timestamp, ' Lastloginip ' varchar ' DEFAULT null, ' score ' int (one) not NULL, PRIMARY KEY (' id ')) engine=innodb auto_increment=6 DEFA ULT Charset=utf8;--------------------------------Records of tb_accountinfo------------------------------INSERT Into ' Tb_accountinfo ' VALUES (' 1 ', ' admin ', ' admin ', ' 1 ', ' 2015-06-25 10:13:18 ', ' 127.0.0.1 ', ' + '); INSERT into ' Tb_accou Ntinfo ' VALUES (' 2 ', ' aaa ', ' 123 ', ' 0 ', ' 2015-07-06 15:39:03 ', ' 10.2.212.18 ', ' 0 '); INSERT into ' tb_accountinfo ' values (' 3 ', ' abc ', ' 111 ', ' 0 ', ' 2015-07-06 15:39:39 ', ' 10.2.212.18 ', ' 0 '); INSERT into ' Tb_accountinfo ' VALUES (' 4 ', ' ', '', ' 0 ', ' 2015-07-06 15:42:38 ', ' 10.2.212.18 ', ' 0 '); INSERT into ' Tb_accountinfo ' VALUES (' 5 ', ' BBB ', ' 123 ', ' 0 ', ' 2015-07-0 6 15:49:52 ', ' 10.2.212.18 ', ' 0 ');--------------------------------Table structure for ' tb_ebookcomment '-------------- ----------------DROP TABLE IF EXISTS ' tb_ebookcomment '; CREATE TABLE ' tb_ebookcomment ' (' id ' int (one) not null auto_increment, ' comment ' varchar ($) NOT null, ' Ebookid ' int (1 1) Not NULL, ' accountId ' int (one) not null, ' createdate ' timestamp null DEFAULT null on UPDATE current_timestamp, Primar Y key (' ID '), key ' AccountId ' (' accountId '), key ' Tb_ebookcomment_ibfk_1 ' (' Ebookid '), CONSTRAINT ' TB_EBOOKCOMMENT_IBFK _1 ' FOREIGN KEY (' ebookid ') REFERENCES ' tb_ebookinfo ' (' ID ') on the DELETE NO ACTION, CONSTRAINT ' tb_ebookcomment_ibfk_2 ' for Eign KEY (' accountId ') REFERENCES ' tb_accountinfo ' (' id ') on DELETE NO ACTION) engine=innodb auto_increment=27 DEFAULT CHA Rset=utf8,--------------------------------Records of tb_ebookcomment------------------------------insert INTO ' tb_ebookcomment ' VALUES (' 1 ', ' Verygood ', ' 1 ', ' 1 ', ' 2015-07-01 16:41:14 '); insert INTO ' tb_ebookcomme NT ' VALUES (' 2 ', ' dfdjsfsdlfjslfsd ', ' 1 ', ' 1 ', ' 2015-07-01 16:41:43 '); INSERT into ' tb_ebookcomment ' values (' 5 ', ' Test ', ' 3 ', ' 1 ', ' 2015-07-01 16:42:05 '); INSERT into ' tb_ebookcomment ' VALUES (' + ', ' Test ', ' 4 ', ' 1 ', ' 2015-07-01 16:46:26 '); inser T into ' tb_ebookcomment ' values (' + ', ' Test ', ' 4 ', ' 1 ', ' 2015-07-01 16:46:46 '); INSERT into ' tb_ebookcomment ' values (' 15 ' , ' Test ', ' 5 ', ' 1 ', ' 2015-07-09 10:20:37 '); INSERT into ' tb_ebookcomment ' VALUES (' + ', ' Test ', ' 4 ', ' 1 ', ' 2015-07-01 16:46 : "+"); insert INTO ' tb_ebookcomment ' VALUES (' + ', ' Test ', ' 4 ', ' 1 ', ' 2015-07-01 16:46:46 '); insert INTO ' tb_ebookcomment ' V Alues (' + ', ' Test ', ' 7 ', ' 1 ', ' 2015-07-09 10:20:44 '); INSERT into ' tb_ebookcomment ' VALUES (' + ', ' Test ', ' 4 ', ' 1 ', ' 2015- 07-01 16:46:47 '); insert INTO ' tb_ebookcomment ' VALUES (' + ', ' Test ', ' 4 ', ' 1 ', ' 2015-07-01 16:46:47 '); insert INTO ' Tb_eboo Kcomment ' VALUES (' 21 ', 'Googodoodogogoododgodo ', ' 1 ', ' 1 ', ' 2015-07-10 15:46:50 '); INSERT into ' tb_ebookcomment ' VALUES (' n ', ' okkkk ', ' 1 ', ' 1 ', ' 2015-07-10 15:47:19 '); insert INTO ' tb_ebookcomment ' VALUES (' + ', ' new log ', ' 2 ', ' 1 ', ' 2015-07-10 15:48:23 '); INSERT into  ' Tb_ebookcomment ' values (' + ', ' viery goood hehe ', ' 2 ', ' 1 ', ' 2015-07-10 15:48:45 '); INSERT into ' tb_ebookcomment ' values (' + ', ' oooppp ', ' 1 ', ' 1 ', ' 2015-07-10 16:09:27 '); INSERT into ' tb_ebookcomment ' VALUES (' + ', ' teswts log ', ' 3 ', ' 1 ', ' 20 15-07-10 16:10:12 ');--------------------------------Table structure for ' tb_ebookinfo '---------------------------- --drop TABLE IF EXISTS ' tb_ebookinfo ';  CREATE TABLE ' tb_ebookinfo ' (' id ' int (one) not null auto_increment, ' bookname ' varchar () ' is not null, ' BookType ' int (11) Not null, ' Bookscore ' int (one) not null, ' author ' varchar () default NULL, ' bookdes ' varchar ($) default NULL, ' book Path ' varchar ' NOT NULL, ' bookfacepath ' varchar ($) default null, ' uploaddate ' date default null, ' Istop ' tinyint (4) DEFAULT NULL, PRIMARY key (' ID '), key ' BookType ' (' BookType '), CONSTRAINT ' Tb_ebookinfo_ibfk_1 ' FOREIGN key (' BookType ') REFERENCES ' Tb_ebooktype ' (' id ') on DELETE NO ACTION) engine=innodb auto_increment=10 DEFAULT Charset=utf8;------------- -------------------Records of Tb_ebookinfo------------------------------INSERT into ' tb_ebookinfo ' VALUES (' 1 ', ' General Patton ', ' 7 ', ' 5 ', ' anon ', ' General Patton Army Horse Life, the strongest commander in World War II ... ', '/books/01.txt ', '/faces/01.jpg ', ' 2015-06-25 ', ' 1 '); INSERT into ' tb_ Ebookinfo ' VALUES (' 2 ', ' Kingdoms ', ' 2 ', ' 4 ', ' Luo Guan ', ' chaos of the Three Kingdoms ... ', '/books/01.txt ', '/faces/02.jpg ', ' 2015-06-25 ', ' 1 '); INSERT in To ' Tb_ebookinfo ' VALUES (' 3 ', ' Han Dynasty ', ' 2 ', ' 0 ', ' anon ', ' A Concise history through the Han Dynasty ... ', '/books/02.txt ', '/faces/02.jpg ', ' 2015-06-25 ', ' 1 '); INSERT into ' tb_ebookinfo ' VALUES (' 4 ', ' Escape from Earth ', ' 3 ', ' 0 ', ' anon ', ' after the Third World War, the Earth's nuclear pollution is serious ... ', '/books/01.txt ', '/faces/02.jpg ', ' 2 015-06-25 ', ' 1 '); INSERT into ' Tb_ebookinfo ' VALUES (' 5 ', ' Lion King ', ' 4 ', ' 0 ', ' pony ', ' Lion King ' Registration day, every demon incarnate ... ') ', '/books/01.txt ', '/fa Ces/02.jpg ', ' 2015-06-' 1 '); INSERT into ' Tb_ebookinfo ' VALUES (' 6 ', ' Home ', ' 5 ', ' 0 ', ' Ba Jin ', ' Ba Jin ' one of the most representative works ... '), '/books/01.txt ', '/faces/02.jpg ', ' 2015-06-25 ', ' 1 '); INSERT into ' Tb_ebookinfo ' VALUES (' 7 ', ' Tagore's poetry ', ' 6 ', ' 0 ', ' anon ', ' A jewel in World poetry ... ') ', '/books/01.txt ', '/FAC Es/02.jpg ', ' 2015-06-25 ', ' 1 '); INSERT into ' Tb_ebookinfo ' VALUES (' 8 ', ' Cold weapon era ', ' 1 ', ' 0 ', ' anon ', ' in the history of the War of the last 2000 years of cold weaponry ... '), '/bo Oks/01.txt ', '/faces/03.jpg ', ' 2015-06-25 ', ' 1 '); INSERT into ' Tb_ebookinfo ' VALUES (' 9 ', ' Steve Jobs biography ', ' 7 ', ' 0 ', ' anon ', ' Create Albert, The singular man of the world ... ', '/books/01.txt ', '/faces/04.jpg ', ' 2015-06-25 ', ' 1 ');--------------------------------Table structure for ' Tb_ebooktype '------------------------------DROP TABLE IF EXISTS ' Tb_ebooktype '; CREATE TABLE ' Tb_ebooktype ' (' id ' int (one) not null auto_increment, ' typeName ' varchar () is not NULL, PRIMARY KEY (' id ') ) Engine=innodb auto_increment=8 DEFAULT Charset=utf8;--------------------------------Records of Tb_ebooktype------- -----------------------INSERT into ' tb_ebooktype ' VALUES (' 1 ', ' military '); INSERT into ' tb_ebooktype ' values (' 2 ', ' history '); insert INTO ' tb_ebooktype ' values (' 3 ', ' sci-fi '); insert INTO ' tb_ebooktype ' values (' 4 ', ' magic '); insert INTO ' tb_ebooktype ' values (' 5 ', ' literature '); insert INTO ' tb_ebooktype ' values (' 6 ', ' poetry '); insert INTO ' tb_e BookType ' VALUES (' 7 ', ' biographies ');--------------------------------Table structure for ' tb_userinfo '-------------------- ----------DROP TABLE IF EXISTS ' tb_userinfo '; CREATE TABLE ' tb_userinfo ' (' id ' int (one) not null auto_increment, ' userName ' varchar () ' is not null, ' userphone ' varchar (one) not null, ' usermail ' varchar (+) default NULL, ' Usersex ' char (2) default null, ' useraddress ' varchar ($) Default NULL, ' usermajor ' varchar DEFAULT null, ' accountId ' int (one) not NULL, PRIMARY key (' ID '), key ' AccountId ' (' Accoun TId '), CONSTRAINT ' Tb_userinfo_ibfk_1 ' FOREIGN KEY (' accountId ') REFERENCES ' tb_accountinfo ' (' id ') on DELETE NO ACTION) Engine=innodb auto_increment=4 DEFAULT Charset=utf8;--------------------------------Records of Tb_userInfo------------------------------INSERT into ' tb_userinfo ' VALUES (' 1 ', ' Caocao ', ' 13900001234 ', ' [email protected] ', ' Male ', ' Tianjin Xiqing District University City ', ' Student ', ' 1 '); INSERT into ' Tb_userinfo ' VALUES (' 3 ', ' Liu Bei ', ' 13800001234 ', null, ' Male ', ' Beijing ', null, ' 1 ');

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Android ebook Project Training "Project description" "1"