连接WEB服务器

1、网络协议分析实验报告实验名称学生姓名成绩专业班级网工15101学号201517030130实验日期2018/5/29一、实验目的1、掌握Android程序如何连接服务器2、掌握使用AndroidAPP如何与服务器交换数据的方法二、实验设备与环境Win7主机手机一部（Android系统的）javaEE平台eclipse开发平台AndroidStudio三、实验步骤首先我们需要创建数据库，然后在搭建web服务器程序，最后搭建Android客户端程序，实现Android客户端与服务器端的通信。3.1 创建数据库在Navicat工具中连接好mysql,创建jdbc数据库，接着创建user_info数据

2、表，在表中添加如下字段：userid,realname,uuid,walletid,并添加数据记录。字段名长度主键useridint10是realnameint10否uuidint10否walletidint10否3.2 创建javaweb项目在eclpce中创建javaweb项目（jdbc），利用java的Servlet接收Android发送的数据包。Servlet容器负责Servlet和用户的通信以及调用Servlet的方法。Servlet和用户的通信采用请求/响应模式。用于以动态响应客户机请求形式扩展Web服务器(WebContainer)的功能。HttpServlet主要接收HTTP协

3、议中get()方法和POST()方法发送的数据。四、实验结果图服务器端：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<?？*】手机端:*Q11:53jsonServletAndrddHelloWcxkllAAAAAMAAAAM.1L«ST£MBE£H)DSTRINGLLETMAP五、关键源码Java中连接数据库的字段：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、服务器端数据处理语句：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();手机端连接服务器语句：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;手机端数据提交语句：publicclassMyHttpPost/服务器地址privatestaticStringSERVER="43:8084"/项目地址privatestaticStringPROJECT="/SeeTogetherServer/"/请求超时privatestaticfinalintREQUEST_TIMEOUT;/读取超时privatestaticfinalintSO_TIMEOU=T0;/通过POST方式获取HTTP1艮务器数据publicstaticStr

13、ingexecuteHttpPost(Stringservlet,List<NameValuePair>params)/StringbaseURL=SERVER+PROJECT+servlet;StringbaseURLservlet;StringresponseMsg="FAILED"try/连接到服务器端相应的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&