1、網(wǎng)絡(luò)協(xié)議分析實(shí)驗(yàn)報(bào)告實(shí)驗(yàn)名稱學(xué)生姓名成績(jī)專業(yè)班級(jí)網(wǎng)工15101學(xué)號(hào)201517030130實(shí)驗(yàn)日期2018/5/29一、實(shí)驗(yàn)?zāi)康?、掌握Android程序如何連接服務(wù)器2、掌握使用AndroidAPP如何與服務(wù)器交換數(shù)據(jù)的方法二、實(shí)驗(yàn)設(shè)備與環(huán)境Win7主機(jī)手機(jī)一部（Android系統(tǒng)的）javaEE平臺(tái)eclipse開發(fā)平臺(tái)AndroidStudio三、實(shí)驗(yàn)步驟首先我們需要?jiǎng)?chuàng)建數(shù)據(jù)庫(kù)，然后在搭建web服務(wù)器程序，最后搭建Android客戶端程序，實(shí)現(xiàn)Android客戶端與服務(wù)器端的通信。3.1 創(chuàng)建數(shù)據(jù)庫(kù)在Navicat工具中連接好mysql,創(chuàng)建jdbc數(shù)據(jù)庫(kù)，接著創(chuàng)建user_info數(shù)據(jù)

2、表，在表中添加如下字段：userid,realname,uuid,walletid,并添加數(shù)據(jù)記錄。字段名長(zhǎng)度主鍵useridint10是realnameint10否uuidint10否walletidint10否3.2 創(chuàng)建javaweb項(xiàng)目在eclpce中創(chuàng)建javaweb項(xiàng)目（jdbc），利用java的Servlet接收Android發(fā)送的數(shù)據(jù)包。Servlet容器負(fù)責(zé)Servlet和用戶的通信以及調(diào)用Servlet的方法。Servlet和用戶的通信采用請(qǐng)求/響應(yīng)模式。用于以動(dòng)態(tài)響應(yīng)客戶機(jī)請(qǐng)求形式擴(kuò)展Web服務(wù)器(WebContainer)的功能。HttpServlet主要接收HTTP協(xié)

3、議中g(shù)et()方法和POST()方法發(fā)送的數(shù)據(jù)。四、實(shí)驗(yàn)結(jié)果圖服務(wù)器端：tintin)oy»<4+»+Xftltclr*«Inw«widIUti4frwuttrld«at«nt4njcy"Rftiri.QfounciIfwTMtfWrvlMN'u”f'：tafitiwijoy'uLii4rL：l，gllTid：r'EM-Lll>b.，a1periwiguddm*麗ijinJid=EMIJnw':廣.Lbcfi11*巾"JitT:1«VJm1"A

4、Hui<?？*】手機(jī)端:*Q11:53jsonServletAndrddHelloWcxkllAAAAAMAAAAM.1L«ST£MBE£H)DSTRINGLLETMAP五、關(guān)鍵源碼Java中連接數(shù)據(jù)庫(kù)的字段：privatefinalStringUSERNAME="root"/?privatefinalStringPASSWORD="123456"/?privatefinalStringDRIVER="com.mysql.jdbc.Driver"privatefinalStringdriverNam

5、e="com.mysql.jdbc.Driver"privatefinalStringwebUrl="jdbc:mysql:/:3306"privatefinalStringdbName="/jdbc"/?privatefinalStringURL="jdbc:mysql:/:3306/jdbc"privatefinalStringdbUrl=webUrl+dbName+"?characterEncoding=utf8&useSSL=true"Java

6、服務(wù)器端數(shù)據(jù)處理語(yǔ)句：tryResultSetresultSet=jdbcUtils.exeselectquery(sql_select);/while(resultSet.next()System.out.println("UserServicegetInfofound");Useruser=newUser(resultSet.getString(userid),resultSet.getString("uuid"),resultSet.getString("walletid"),resultSet.getString("

7、realname");list.add(user);/?resultSet.close();/jdbcUtils.releaseConn();/?catch(SQLExceptione)e.printStackTrace();手機(jī)端連接服務(wù)器語(yǔ)句：switch(v.getId()caseRid.btnPerson:/Stringpath="http:/10.022:8080/jsonServer/servlet/JsonAction?action_flag=person"/Stringpath=":8080/jsonServe

8、r/servlet/JsonAction"/StringjsonString=MyHttpPost.executeHttpPost(path,params);getUserInfo("tantanjoy");break;caseRid.btnListEmbededPerson:Stringpath2="43:8084/jsonServer/servlet/JsonAction?action_flag=persons"StringjsonString2=HttpUtils.getJsonContent(path2);

9、Log.i(TAG"ThejsonString:"+jsonString2);List<Person>list2=JSONToolsgetPersons("persons",jsonString2);Log"(TAG"Thepersons:"+Iist2.toString();break;caseRid.btnListEmbeddedString:Stringpath3="43:8084/jsonServer/servlet/JsonAction?action_flag=l

10、istString"StringjsonString3=HttpUtils.getJsonContent(path3);Log.i(TAG"ThejsonString:"+jsonString3);List<String>list3=JSONToolsgetListString("listString",jsonString3);Log.i(TAG"ThelistString:"+list3.toString();break;caseRid.btnListMap:Stringpath4="http:/1

11、43:8084/jsonServer/servlet/JsonAction?action_flag=listMap"StringjsonString4=HttpUtils.getJsonContent(path4);Log.i(TAG"ThejsonString:"+jsonString4);List<Map=String,Object>>list4=JSONToolsgetListMaps("listMap",jsonString4);Log"(TAG"ThelistMap:"+

12、list4.toString();break;手機(jī)端數(shù)據(jù)提交語(yǔ)句：publicclassMyHttpPost/服務(wù)器地址privatestaticStringSERVER="43:8084"/項(xiàng)目地址privatestaticStringPROJECT="/SeeTogetherServer/"/請(qǐng)求超時(shí)privatestaticfinalintREQUEST_TIMEOUT;/讀取超時(shí)privatestaticfinalintSO_TIMEOU=T0;/通過(guò)POST方式獲取HTTP1艮務(wù)器數(shù)據(jù)publicstaticStr

13、ingexecuteHttpPost(Stringservlet,List<NameValuePair>params)/StringbaseURL=SERVER+PROJECT+servlet;StringbaseURLservlet;StringresponseMsg="FAILED"try/連接到服務(wù)器端相應(yīng)的ServletHttpPostrequest=newHttpPost(baseURL;/POST方式/request.addHeader("Content-Type","application/json;charset=u

14、tf-8");request.setEntity(newUrlEncodedFormEntity(params,HTTPUTF_8);BasicHttpParamshttpParams=newBasicHttpParams();HttpConnectionParams.setConnectionTimeout(httpParams,REQUEST_TIMEOUTHttpConnectionParams.setSoTimeout(httpParams,SO_TIMEOU;THttpClientclient=newDefaultHttpClient(httpParams)；/client

15、.getParams().setParameter("tocol.content-charset","UTF-8");HttpResponseresponse=client.execute(request);if(response.getStatusLine().getStatusCode()=200)/是否成功收取信息responseMsg=EntityUtils.toString(response.getEntity(),HTTPUTF_8;catch(Exceptione)e.printStackTrace();Log.i("tag","server"+SERVER;try/解密Log-i("tag","1HttpPost:responseMsg="+URLDecoderdecode(responseMsg"utf-8&