Android和PHP MYSQL交互开发实例

目录

• 总述
• 1.安卓客户端
• 2.服务器端
• 3.MYSQL数据库
• 4.总结

loginbtn.setOnClickListener(new View.OnClickListener() {
    @Override
    public void onClick(View v) {//登陆按钮监听事件
/*                ((App)getApplicationContext()).setTextData(et.getText().toString());
        location_x.setText(((App)getApplicationContext()).getTextData());*/
        new Thread(new Runnable() {
            @Override
            public void run() {
                try {
                    int result = login();
                    //login()为向php服务器提交请求的函数，返回数据类型为int
                    if (result == 1) {
                        Log.e("log_tag", "登陆成功！");
                        //Toast toast=null;
                        Looper.prepare();
                        Toast.makeText(PhpActivity.this, "登陆成功！", Toast.LENGTH_SHORT).show();
                        Looper.loop();
                    } else if (result == -2) {
                        Log.e("log_tag", "密码错误！");
                        //Toast toast=null;
                        Looper.prepare();
                        Toast.makeText(PhpActivity.this, "密码错误！", Toast.LENGTH_SHORT).show();
                        Looper.loop();
                    } else if (result == -1) {
                        Log.e("log_tag", "不存在该用户！");
                        //Toast toast=null;
                        Looper.prepare();
                        Toast.makeText(PhpActivity.this, "不存在该用户！", Toast.LENGTH_SHORT).show();
                        Looper.loop();
                    }
                } catch (IOException e) {
                    System.out.println(e.getMessage());
                }
            }
        }).start();
    }
});

//用户登录提交post请求
//向服务器提交数据1.user_id用户名，2.input_pwd密码
//返回JSON数据{"status":"1","info":"login success","sex":"0","nicename":""}
private int login() throws IOException {
    int returnResult=0;
    String user_id=et.getText().toString();
    String input_pwd=pwd.getText().toString();
    if(user_id==null||user_id.length()<=0){
        Looper.prepare();
        Toast.makeText(PhpActivity.this,"请输入账号", Toast.LENGTH_LONG).show();
        Looper.loop();
        return 0;
    }
    if(input_pwd==null||input_pwd.length()<=0){
        Looper.prepare();
        Toast.makeText(PhpActivity.this,"请输入密码", Toast.LENGTH_LONG).show();
        Looper.loop();
        return 0;
    }
    String urlstr="http://192.168.191.1/LBS/login.php";
    URL url = new URL(urlstr);
    HttpURLConnection http= (HttpURLConnection) url.openConnection();
    String params="uid="+user_id+'&'+"pwd="+input_pwd;
    http.setDoOutput(true);
    http.setRequestMethod("POST");
    OutputStream out=http.getOutputStream();
    out.write(params.getBytes());
    out.flush();
    out.close();
    BufferedReader bufferedReader=new BufferedReader(new InputStreamReader(http.getInputStream()));//获得输入流
    String line="";
    StringBuilder sb=new StringBuilder();
    while (null!=(line=bufferedReader.readLine())){
        sb.append(line);
    }
    String result= sb.toString();
    try {
        JSONObject jsonObject= new JSONObject(result);
        returnResult=jsonObject.getInt("status");
    } catch (Exception e) {
        Log.e("log_tag", "the Error parsing data "+e.toString());
    }
    return returnResult;
}

<?php  
/*
*用户登录，服务器进行的处理
*/
	include("conn.php");
    mysql_select_db("lbs");  
	$getid=$_POST['uid'];//客户端post过来的用户名
	$getpwd=$_POST['pwd'];//客户端post过来的密码
    $sql=mysql_query("SELECT * FROM user WHERE userid ='$getid'"); 
	$result=mysql_fetch_assoc($sql);
	if(!empty($result)){
		//存在该用户
		if($getpwd==$result['password']){
			//用户名密码匹配正确
			mysql_query("UPDATE user SET status='1' WHERE id =$result[id]");/*这里的数组不需要加单引号*/
			$back['status']="1";
			$back['info']="login success";
			$back['sex']=$result['sex'];
			$back['nicename']=$result['nicename'];
			echo(json_encode($back)); 
		}else{/*密码错误*/
			$back['status']="-2";
			$back['info']="password error";
			echo(json_encode($back)); 
		}
	}else{
		//不存在该用户
		$back['status']="-1";
		$back['info']="user not exist";
		echo(json_encode($back)); 
	}
    mysql_close();  
?> 

<?php
	error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED);
     $conn=mysql_connect("localhost","root","admin") or die("数据库服务器连接错误".mysql_error());
     mysql_select_db("mylocation",$conn) or die("数据库访问错误".mysql_error());
	 mysql_query("SET NAMES 'utf8'");
?>