Android+SSH開發商城App（1）資料庫的建立和環境的搭建

Android+SSH開發商城App（1）資料庫的建立和環境的搭建
項目簡介

該項目主要是使用SSH開發Android後端伺服器程式和前端App代碼的實現，主要技術包含：
Android AsyncTask 、常見自訂控制項、用戶端高層類封裝、Android HTTP通訊、使用者管理、購物流程、定位、二維碼等知識點，希望大家跟蹤查看最新的學習筆記。

資料庫的建立

資料庫使用的是MySQL5.6版本，指令碼代碼如下：

SET FOREIGN_KEY_CHECKS=0;DROP TABLE IF EXISTS `admin`;CREATE TABLE `admin` (  `ID` bigint(20) NOT NULL AUTO_INCREMENT,  `loginName` varchar(100) DEFAULT NULL,  `passowrd` varchar(64) DEFAULT NULL,  PRIMARY KEY (`ID`)) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;DROP TABLE IF EXISTS `cversion`;CREATE TABLE `cversion` (  `ID` bigint(20) NOT NULL AUTO_INCREMENT,  `versionName` varchar(100) DEFAULT NULL,  `versionCode` int(11) DEFAULT NULL,  `updateDate` datetime DEFAULT NULL,  `downloadUrl` varchar(200) DEFAULT NULL,  `apkSize` varchar(100) DEFAULT NULL,  `apkName` varchar(200) DEFAULT NULL,  `updateLog` varchar(500) DEFAULT NULL,  PRIMARY KEY (`ID`)) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;DROP TABLE IF EXISTS `goods`;CREATE TABLE `goods` (  `ID` bigint(20) NOT NULL AUTO_INCREMENT,  `shopID` bigint(20) DEFAULT NULL,  `code` varchar(100) DEFAULT NULL,  `name` varchar(200) DEFAULT NULL,  `thumbnail` varchar(200) DEFAULT NULL,  `price` decimal(8,0) DEFAULT NULL,  `weight` decimal(8,0) DEFAULT NULL,  `color` varchar(100) DEFAULT NULL,  `factoryAddr` varchar(200) DEFAULT NULL,  `producer` varchar(200) DEFAULT NULL,  `productedDate` datetime DEFAULT NULL,  `RegisterDate` datetime DEFAULT NULL,  `IsHost` char(1) DEFAULT NULL COMMENT '1為促銷商品；0為普通商品',  `describes` text,  PRIMARY KEY (`ID`)) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;DROP TABLE IF EXISTS `goodspic`;CREATE TABLE `goodspic` (  `ID` bigint(20) NOT NULL AUTO_INCREMENT,  `shopID` bigint(20) DEFAULT NULL,  `picurl` varchar(200) DEFAULT NULL,  `linkurl` varchar(200) DEFAULT NULL,  `orders` int(11) DEFAULT NULL,  `status` char(1) DEFAULT NULL COMMENT '1為顯示，0為隱藏',  PRIMARY KEY (`ID`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;DROP TABLE IF EXISTS `scanrecord`;CREATE TABLE `scanrecord` (  `ID` bigint(20) NOT NULL AUTO_INCREMENT,  `userID` bigint(20) DEFAULT NULL,  `code` varchar(100) DEFAULT NULL,  `scanTime` datetime DEFAULT NULL,  PRIMARY KEY (`ID`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;DROP TABLE IF EXISTS `shop`;CREATE TABLE `shop` (  `ID` bigint(20) NOT NULL AUTO_INCREMENT,  `name` varchar(200) DEFAULT NULL,  `logo` varchar(200) DEFAULT NULL,  `phoneNum` char(20) DEFAULT NULL,  `addr` varchar(200) DEFAULT NULL,  `lngitude` double(9,6) DEFAULT NULL,  `latitude` double(9,6) DEFAULT NULL,  `type` char(1) DEFAULT NULL,  `describes` text,  PRIMARY KEY (`ID`)) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;DROP TABLE IF EXISTS `users`;CREATE TABLE `users` (  `ID` bigint(20) NOT NULL AUTO_INCREMENT,  `UserName` varchar(200) DEFAULT NULL,  `password` varchar(32) DEFAULT NULL,  `felling` varchar(200) DEFAULT NULL,  `head` varchar(200) DEFAULT NULL,  `regtime` datetime DEFAULT NULL,  PRIMARY KEY (`ID`)) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;DROP VIEW IF EXISTS `v_goods`;CREATE ALGORITHM=UNDEFINED DEFINER=`videoadmin`@`` SQL SECURITY DEFINER VIEW `v_goods` AS select `goods`.`ID` AS `ID`,`goods`.`shopID` AS `shopID`,`goods`.`code` AS `code`,`goods`.`name` AS `goods_name`,`goods`.`thumbnail` AS `thumbnail`,`goods`.`price` AS `price`,`goods`.`weight` AS `weight`,`goods`.`color` AS `color`,`goods`.`factoryAddr` AS `factoryAddr`,`goods`.`producer` AS `producer`,`goods`.`productedDate` AS `productedDate`,`goods`.`RegisterDate` AS `RegisterDate`,`goods`.`IsHost` AS `IsHost`,`goods`.`describes` AS `goods_desc`,`shop`.`name` AS `shop_name`,`shop`.`logo` AS `logo`,`shop`.`phoneNum` AS `phoneNum`,`shop`.`addr` AS `addr`,`shop`.`lngitude` AS `lngitude`,`shop`.`latitude` AS `latitude`,`shop`.`type` AS `type`,`shop`.`describes` AS `shop_desc` from (`goods` join `shop`) where (`goods`.`shopID` = `shop`.`ID`);

建立資料庫如下：

SSH環境搭建

我們使用“純手工”的方式搭建自己的SSH環境
（1）建立一個Web Project（可以根據下邊的圖片建立工程）

注意：當我們建立config_struts、config_spring、config檔案的時候一定要在檔案上點擊右鍵build path–use as sources folder
這樣的話，在編譯的時候才會把這三個設定檔加入到class目錄中，否則會找不到。加入之後的話就像我中的一樣和src是同級目錄的，上邊有一個package的表徵圖的樣式！

（2）設定檔的簡單介紹：
log4j.properties

#log4j.rootLogger=INFO,stdoutlog4j.appender.stdout=org.apache.log4j.ConsoleAppenderlog4j.appender.stdout.layout=org.apache.log4j.PatternLayoutlog4j.appender.stdout.layout.ConversionPattern=%d %-5p [%t] %-17c{2} (%13F:%L) %3x - %m%n

applicationContext.xml

                            classpath:jdbc.properties                                        ${datasource.driverClassName}                            ${datasource.url}                            ${datasource.username}                            ${datasource.password}                                                                                                                        ${hibernate.dialect}                ${hibernate.show_sql}                ${hibernate.format_sql}                                ${hibernate.cache.provider_class}                ${hibernate.cache.use_query_cache}                ${hibernate.cache.use_second_level_cache}                                                                                                                                                                                

jdbc.properties

datasource.type=mysqldatasource.driverClassName=com.mysql.jdbc.Driverdatasource.url=jdbc:mysql://localhost:3306/lcgou?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8datasource.username=rootdatasource.password=1111datasource.maxActive=100datasource.maxIdle=2datasource.maxWait=120000datasource.whenExhaustedAction=1datasource.validationQuery=select 1 from dualdatasource.testOnBorrow=truedatasource.testOnReturn=false##########################  c3p0  ############################c3p0.acquireIncrement=3c3p0.acquireRetryAttempts=30c3p0.acquireRetryDelay=100c3p0.initialPoolSize=3c3p0.idleConnectionTestPeriod=900c3p0.minPoolSize=2c3p0.maxPoolSize=10c3p0.maxStatements=0c3p0.numHelperThreads=10c3p0.maxIdleTime=30#####################   Hibernate  ##################################hibernate.dialect=org.hibernate.dialect.MySQLDialecthibernate.jdbc.batch_size=25hibernate.jdbc.fetch_size=50hibernate.show_sql=truehibernate.connection.release_mode=after_transactionhibernate.format_sql=truehibernate.cache.provider_class=org.hibernate.cache.EhCacheProviderhibernate.cache.use_query_cache=truehibernate.cache.use_second_level_cache=true

struts.properties

#struts.custom.i18n.resources=messageResourcestruts.i18n.encoding=UTF-8struts.objectFactory.spring.useClassCache = truestruts.multipart.parser=jakartastruts.multipart.saveDir=struts.multipart.maxSize=2097152struts.serve.static=truestruts.serve.static.browserCache=truestruts.enable.DynamicMethodInvocation = truestruts.enable.SlashesInActionNames = falsestruts.tag.altSyntax=truestruts.devMode = falsestruts.i18n.reload=falsestruts.ui.theme=xhtmlstruts.ui.templateDir=templatestruts.ui.templateSuffix=ftlstruts.url.includeParams = getstruts.dispatcher.parametersWorkaround = falsestruts.freemarker.templatesCache=falsestruts.freemarker.wrapper.altMap=truestruts.xslt.nocache=falsestruts.configuration.files=struts-default.xml,struts-plugin.xml,struts.xml

struts.xml

web.xml

                webAppRootKey        iGouServer.root                contextConfigLocation        classpath:applicationContext*.xml                    log4jConfigLocation        classpath:log4j.properties                    org.springframework.web.util.Log4jConfigListener                    org.springframework.web.util.IntrospectorCleanupListener                org.springframework.web.context.ContextLoaderListener                    struts2        org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter                struts2        *.action                struts2        *.jsp                    encodingFilter        org.springframework.web.filter.CharacterEncodingFilter                    encoding            UTF-8                            forceEncoding            true                        encodingFilter        /*                    index.jsp    

上邊的設定檔，瞭解SSH的應該都比較清楚，不過多解釋，都有注釋

（3）關於使用Hibernate，因為我們沒有在項目中進行直接的逆向，而是使用jar直接匯入的，那麼我們就可以童工另一個項目HibernateImport 通過hibernate的逆向工程產生model，然後再複製到自己的專案檔下