Android客户端结合PHP服务端

第1 页/ 共4页XXXX 大 学Android 平台开发基础实验报告实验名称 实验四 Android 综合程序设计日期专业班级 地点 实验人 XXX学号 XXX同组人单独完成一、 实验目的(1) 掌握Android+PHP 的客户端与服务器端网络连接和访问 (2) 掌握Android HttpClient 的使用方法 (3) 熟悉MySQL 数据库与SQLite 数据库 (4) 掌握Android 多线程和AsyncTask 使用方法 (5) 掌握Android APP 的综合设计方法二、实验要求(1) 熟悉MySQL 数据库及PHP 基本设计方法； (2) 掌握Android 多线程和网络访问的使用方法； (3) 掌握Android 操作MySQL 数据库的方法。

三、实验内容设计实现基于Android+PHP 的客户端/服务器端的注册和登录，要求数据存储在Mysql 数据库，PHP 做后台，Android APP 为前端访问。

四、实验过程和结果PHP 后台代码： conn.php 连接数据库：<?php$servername = "localhost"; $username = "root"; $password = ""; $dbname = "mydb"; // 创建连接$conn = mysqli_connect($servername, $username, $password,$dbname);// 连接失败，打印错误信息 if (!$conn) { echo 'error'; } ?>par_login.php 登录验证： <?php //家长登录验证include( 'conn.php' ); //获取家长的用户名和密码 $phone=$_POST["phone"]; $paswd=$_POST["paswd"];$sql ="SELECT * FROM user where phonenum='$phone' and paswd='$paswd'"; $result = $conn->query($sql); if ($result->num_rows > 0) { echo 'success'; } else { e cho "0";}$conn->close(); ?>register.php 响应用户注册，插入数据 <?php //家长登录验证include( 'conn.php' );//获取家长的用户名和密码 $phone=$_POST["phone"]; $paswd=$_POST["paswd"];$sql ="insert into user values ('$phone','$paswd')"; $result = $conn->query($sql);$conn->close(); ?>Android 前端关键代码：1.HttpLogin.java 连接数据库发送post 请求public class HttpLogin { //登入的方法public boolean gotoLogin(String phonenum, String password, String connectUrl) { String result = ""; // 用来取得返回的String boolean isLoginSucceed = false;HttpClient httpClient = new DefaultHttpClient();// 发送post 请求HttpPost httpRequest = new HttpPost(connectUrl);// Post运作传送变数必须用NameValuePair[]阵列储存List<NameValuePair> params = new ArrayList<NameValuePair>();//BasicNameValuePair存储键值对的类params.add(new BasicNameValuePair("phone", phonenum));params.add(new BasicNameValuePair("paswd", password));try {// 发出HTTP请求转为带参数的HTTP网络地址httpRequest.setEntity(new UrlEncodedFormEntity(params,"utf-8"));// 取得HTTP responseHttpResponse httpResponse = httpClient.execute(httpRequest);result = EntityUtils.toString(httpResponse.getEntity());System.out.println(result);} catch (Exception e) {e.printStackTrace();}// 判断返回的数据是否为php中成功登入是时输出的successif (result.equals("success")) {isLoginSucceed = true;}return isLoginSucceed;}}2.LoginActivity.java和activity_login.xml绑定xml的组件响应的点击事件public void onClick(View v) {switch (v.getId()) {case R.id.forget_paswd: //忘记密码弹出修改密码界面break;case R.id.clean: //清空输入的账户和密码信息phone_edit.setText("");paswd_edit.setText("");break;case R.id.regester_user: //注册新用户Intent intent=new Intent(LoginActivity.this,RegeActivity.class);startActivity(intent);break;case R.id.login: //登录if (reme_box.isChecked()) {//保存数据SharedPreferences preferences=getSharedPreferences("user_mes",Activity.MODE_PRIVATE);SharedPreferences.Editor editor=preferences.edit();editor.putString("phone",phone_edit.getText().toString().equals("")?"":phone_edit.getText().toString());editor.putString("paswd",paswd_edit.getText().toString().equals("")?"":paswd_edit.getText().toString());//将数据提交mit();}//这里调用向后台发送请求的方法,判断是否正确输入用户名和密码Thread thread=new Thread(runnable);thread.start();default:break;}}//启动一个新的线程用来登录进行耗时操作Runnable runnable=new Runnable() {@Overridepublic void run() {HttpLogin httpLogin=new HttpLogin();String phone=phone_edit.getText().toString();String paswd=paswd_edit.getText().toString();// 连接到服务器的地址String connectURL = "http://39.177.95.84/test/par_login.php";flag=httpLogin.gotoLogin(phone, paswd, connectURL);if (flag) {Intent intent2=new Intent(LoginActivity.this,SucesActivity.class);//传入手机号用来在me_layout界面显示//成功后启动ActivityBundle bundle=new Bundle();bundle.putString("phone", phone);intent2.putExtras(bundle);startActivity(intent2);}else {Looper.prepare();Toast.makeText(LoginActivity.this, "登陆失败，账号不存在或密码错误", Toast.LENGTH_SHORT).show();Looper.loop();}}};3.RegeActivity.java和activity_rege.xml注册界面register_username.setOnFocusChangeListener(new View.OnFocusChangeListener(){public void onFocusChange(View v, boolean hasFocus) {// TODO Auto-generated method stubif(!hasFocus){if(register_username.getText().toString().trim().length()<2){Toast.makeText(RegeActivity.this, "用户名不能小于2个字符", Toast.LENGTH_SHORT).show();} } } });register_passwd.setOnFocusChangeListener(new View.OnFocusChangeListener(){@Overridepublic void onFocusChange(View v, boolean hasFocus) {// TODO Auto-generated method stubif(!hasFocus){if(register_passwd.getText().toString().trim().length()<3){Toast.makeText(RegeActivity.this, "密码不能小于3个字符", Toast.LENGTH_SHORT).show();} } } });reregister_passwd.setOnFocusChangeListener(new View.OnFocusChangeListener(){@Overridepublic void onFocusChange(View v, boolean hasFocus) {if(!hasFocus){if(!reregister_passwd.getText().toString().trim().equals(register_passwd.getText().toString().trim())){Toast.makeText(RegeActivity.this, "两次密码输入不一致", Toast.LENGTH_SHORT).show();} } } });register_submit.setOnClickListener(new View.OnClickListener(){@Overridepublic void onClick(View v) {if(!checkEdit()){return;}//服务端PHP地址String httpUrl="http://39.177.95.84/test/register.php";HttpPost httpRequest=new HttpPost(httpUrl);List<NameValuePair> params=new ArrayList<NameValuePair>();params.add(new BasicNameValuePair("phone",register_username.getText().toString().trim()));params.add(new BasicNameValuePair("paswd",register_passwd.getText().toString().trim()));HttpEntity httpentity = null;try {httpentity = new UrlEncodedFormEntity(params,"utf8");} catch (UnsupportedEncodingException e) {// TODO Auto-generated catch blocke.printStackTrace();}httpRequest.setEntity(httpentity);HttpClient httpclient=new DefaultHttpClient();HttpResponse httpResponse = null;try {httpResponse = httpclient.execute(httpRequest);} catch (ClientProtocolException e) {e.printStackTrace();} catch (IOException e) {e.printStackTrace();}if(httpResponse.getStatusLine().getStatusCode()==200){String strResult = null;try {strResult = EntityUtils.toString(httpResponse.getEntity());} catch (ParseException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (IOException e) {// TODO Auto-generated catch blocke.printStackTrace();}Toast.makeText(RegeActivity.this, strResult, Toast.LENGTH_SHORT).show();}else{Toast.makeText(RegeActivity.this, "请求错误", Toast.LENGTH_SHORT).show();} } });}private boolean checkEdit(){if(register_username.getText().toString().trim().equals("")){Toast.makeText(RegeActivity.this, "用户名不能为空", Toast.LENGTH_SHORT).show(); }else if(register_passwd.getText().toString().trim().equals("")){Toast.makeText(RegeActivity.this, "密码不能为空", Toast.LENGTH_SHORT).show();}else if(!register_passwd.getText().toString().trim().equals(reregister_passwd.getText().toString().trim())){ Toast.makeText(RegeActivity.this, "两次密码输入不一致", Toast.LENGTH_SHORT).show(); }else{return true; }return false; }4.SucesActivity.java 的activity_suces.xml 仅以TextView 显示登陆成功实验截图：注册后刷新数据库看到：五、实验总结本次实验掌握Android+PHP 的客户端与服务器端网络连接和访问，Android HttpClient 的使用方法，MySQL 数据库与SQLite 数据库 ，Android 多线程和AsyncTask 使用方法，Android APP 的综合设计方法 熟悉MySQL 数据库及PHP 基本设计方法， 掌握Android 多线程和网络访问的使用方法，Android 操作MySQL 数据库的方法。