android+json+php+mysql实现用户反馈功能方法解析

前端技术 2023/09/04 Android
相信每个项目都会有用户反馈建议等功能，这个实现的方法很多，下面是我实现的方法，供大家交流。首先看具体界面，三个字段。名字，邮箱为选填，可以为空，建议不能为空。如有需要可以给我留言。
 
下面贴出布局代码，这里用到一个<include layout=\"@layout/uphead\">就是把另外一个布局文件引入到这个布局中。
复制代码 代码如下:

<?xml version=\"1.0\" encoding=\"utf-8\"?>
<LinearLayout xmlns:android=\"http://schemas.android.com/apk/res/android\"
android:layout_width=\"match_parent\"
android:layout_height=\"match_parent\"
android:orientation=\"vertical\"
android:background=\"@color/bg_gray\" >
<include layout=\"@layout/uphead\"/>
<!-- Name Label -->
<TextView android:layout_width=\"fill_parent\"
android:layout_height=\"wrap_content\"
android:text=\"名字(选填)\"
android:paddingLeft=\"10dip\"
android:paddingRight=\"10dip\"
android:textColor=\"@color/coffee\"
android:paddingTop=\"10dip\"
android:textSize=\"12sp\"/>
<!-- Input Name -->
<EditText android:id=\"@+id/inputName\"
android:layout_width=\"fill_parent\"
android:layout_height=\"wrap_content\"
android:layout_margin=\"5dip\"
android:layout_marginBottom=\"15dip\"
android:singleLine=\"true\"/>
<!-- Price Label -->
<TextView android:layout_width=\"fill_parent\"
android:layout_height=\"wrap_content\"
android:text=\"邮箱(选填)\"
android:paddingLeft=\"10dip\"
android:paddingRight=\"10dip\"
android:textColor=\"@color/coffee\"
android:paddingTop=\"10dip\"
android:textSize=\"12sp\"/>
<!-- Input Price -->
<EditText android:id=\"@+id/inputEmail\"
android:layout_width=\"fill_parent\"
android:layout_height=\"wrap_content\"
android:layout_margin=\"5dip\"
android:layout_marginBottom=\"15dip\"
android:singleLine=\"true\"/>
<!-- Description Label -->
<TextView android:layout_width=\"fill_parent\"
android:layout_height=\"wrap_content\"
android:text=\"建议(必填)\"
android:paddingLeft=\"10dip\"
android:paddingRight=\"10dip\"
android:paddingTop=\"10dip\"
android:textColor=\"@color/coffee\"
android:textSize=\"12sp\"/>
<!-- Input description -->
<EditText android:id=\"@+id/inputDesc\"
android:layout_width=\"fill_parent\"
android:layout_height=\"wrap_content\"
android:layout_margin=\"5dip\"
android:layout_marginBottom=\"15dip\"
android:lines=\"4\"
android:gravity=\"top\"/>
<!-- Button Create Product -->
<Button android:id=\"@+id/btnCreateProduct\"
android:layout_width=\"fill_parent\"
android:layout_height=\"wrap_content\"
android:text=\"提交\"
android:textSize=\"20sp\"
android:textColor=\"@color/coffee\"
/>
</LinearLayout>

下面贴出uphead的布局代码，里面用到一个TextView,一个Button为返回按钮。
复制代码 代码如下:

<?xml version=\"1.0\" encoding=\"utf-8\"?>
<RelativeLayout xmlns:android=\"http://schemas.android.com/apk/res/android\"
android:layout_width=\"fill_parent\"
android:layout_height=\"50dp\"
android:background=\"@drawable/top\" >
<TextView
android:id=\"@+id/tv_head\"
android:layout_width=\"wrap_content\"
android:layout_height=\"wrap_content\"
android:layout_centerInParent=\"true\"
android:shadowColor=\"#ff000000\"
android:shadowDx=\"2\"
android:shadowDy=\"0\"
android:shadowRadius=\"1\"
android:text=\"\"
android:textColor=\"@color/white\"
android:textSize=\"18sp\"
android:textStyle=\"bold\" />
<Button
android:id=\"@+id/upback\"
android:layout_width=\"wrap_content\"
android:layout_height=\"wrap_content\"
android:layout_alignParentLeft=\"true\"
android:layout_centerVertical=\"true\"
android:layout_marginLeft=\"17dp\"
android:drawableLeft=\"@id/tv_head\"
android:background=\"@drawable/back\" />
</RelativeLayout>

下面贴出android客户端代码，三个类，一个用于与服务器交互发送post请求，以及json的传递。还有一个Dailog实例。
复制代码 代码如下:

package com.android.up;
import java.util.ArrayList;
import java.util.List;
import org.apache.http.HttpResponse;
import org.apache.http.NameValuePair;
import org.apache.http.client.ClientProtocolException;
import org.apache.http.message.BasicNameValuePair;
import org.json.JSONObject;
import com.android.MainActivity;
import com.android.R;
import com.anroid.net.DialogUtil;
import android.app.Activity;
import android.app.ProgressDialog;
import android.content.Intent;
import android.os.AsyncTask;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;
public class up extends Activity {
// Progress Dialog
private ProgressDialog pDialog;
private TextView tv_head;
JSONParser jsonParser = new JSONParser();
EditText inputName;
EditText inputEmail;
EditText inputDesc;
Button upback;
// url to create new product
private static String url_up = \"http://10.0.2.2/up/up.php\";//此处写的是你的服务器端的地址
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.up);
tv_head = (TextView)findViewById(R.id.tv_head);
tv_head.setText(\"建议\");
// Edit Text
inputName = (EditText) findViewById(R.id.inputName);
inputEmail = (EditText) findViewById(R.id.inputEmail);
inputDesc = (EditText) findViewById(R.id.inputDesc);
upback = (Button)findViewById(R.id.upback);
upback.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View arg0) {
// TODO Auto-generated method stub
Intent back = new Intent(up.this,MainActivity.class);
back.setFlags(Intent.FLAG_ACTIVITY_CLEAR_TOP);
startActivity(back);
up.this.finish();
}
});
// Create button
Button btnCreateProduct = (Button) findViewById(R.id.btnCreateProduct);
// button click event
btnCreateProduct.setOnClickListener(new View.OnClickListener() {
public void onClick(View view) {
// creating new product in background thread
if(validate()){
new Up().execute();
}
}
});
}
private boolean validate()
{
String description = inputDesc.getText().toString().trim();
if (description.equals(\"\"))
{
DialogUtil.showDialog(this, \"您还没有填写建议\", false);
return false;
}
return true;
}
/**
* Background Async Task to Create new product
* */
class Up extends AsyncTask<String, String, String> {
/**
* Before starting background thread Show Progress Dialog
* */
@Override
protected void onPreExecute() {
super.onPreExecute();
pDialog = new ProgressDialog(up.this);
pDialog.setMessage(\"正在上传..\");
pDialog.setIndeterminate(false);
pDialog.setCancelable(true);
pDialog.show();
}
/**
* Creating product
* */
protected String doInBackground(String... args) {
String name = inputName.getText().toString();
String price = inputEmail.getText().toString();
String description = inputDesc.getText().toString();
// Building Parameters
List<NameValuePair> params = new ArrayList<NameValuePair>();
params.add(new BasicNameValuePair(\"name\", name));
params.add(new BasicNameValuePair(\"email\", price));
params.add(new BasicNameValuePair(\"description\", description));
// getting JSON Object
// Note that create product url accepts POST method
try{
JSONObject json = jsonParser.makeHttpRequest(url_up,
\"POST\", params);
}catch(Exception e){
e.printStackTrace();
}
// check for success tag
return null;
}
/**
* After completing background task Dismiss the progress dialog
* **/
protected void onPostExecute(String file_url) {
pDialog.setMessage(\"上传成功\");
pDialog.dismiss();

}
}
}

下面贴出Dailog实例类
复制代码 代码如下:

/**
*
*/
package com.anroid.net;
import android.app.AlertDialog;
import android.content.Context;
import android.content.DialogInterface;
import android.content.DialogInterface.OnClickListener;
import android.view.View;
import android.app.Activity;
public class DialogUtil
{
// 定义一个显示消息的对话框
public static void showDialog(final Context ctx
, String msg , boolean closeSelf)
{
// 创建一个AlertDialog.Builder对象
AlertDialog.Builder builder = new AlertDialog.Builder(ctx)
.setMessage(msg).setCancelable(false);
if(closeSelf)
{
builder.setPositiveButton(\"确定\", new OnClickListener()
{
public void onClick(DialogInterface dialog, int which)
{
// 结束当前Activity
((Activity)ctx).finish();
}
});
}
else
{
builder.setPositiveButton(\"确定\", null);
}
builder.create().show();
}
// 定义一个显示指定组件的对话框
public static void showDialog(Context ctx , View view)
{
AlertDialog.Builder builder = new AlertDialog.Builder(ctx)
.setView(view).setCancelable(false)
.setPositiveButton(\"确定\", null);
builder.create()
.show();
}
}

剩下就是如何与服务器端交互了不多说，代码如下
复制代码 代码如下:

package com.android.up;
import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.io.UnsupportedEncodingException;
import java.util.List;
import org.apache.http.HttpEntity;
import org.apache.http.HttpResponse;
import org.apache.http.NameValuePair;
import org.apache.http.client.ClientProtocolException;
import org.apache.http.client.entity.UrlEncodedFormEntity;
import org.apache.http.client.methods.HttpPost;
import org.apache.http.impl.client.DefaultHttpClient;
import org.apache.http.protocol.HTTP;
import org.json.JSONException;
import org.json.JSONObject;
import android.util.Log;
public class JSONParser {
static InputStream is = null;
static JSONObject jObj = null;
static String json = \"\";
// constructor
public JSONParser() {
}
// function get json from url
// by making HTTP POST
public JSONObject makeHttpRequest(String url, String method,
List<NameValuePair> params) {
// Making HTTP request
try {
// request method is POST
// defaultHttpClient
DefaultHttpClient httpClient = new DefaultHttpClient();
HttpPost httpPost = new HttpPost(url);
httpPost.setEntity(new UrlEncodedFormEntity(params,HTTP.UTF_8));
HttpResponse httpResponse = httpClient.execute(httpPost);
HttpEntity httpEntity = httpResponse.getEntity();
is = httpEntity.getContent();
} catch (UnsupportedEncodingException e) {
e.printStackTrace();
} catch (ClientProtocolException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
try {
BufferedReader reader = new BufferedReader(new InputStreamReader(
is, \"UTF-8\"));
StringBuilder sb = new StringBuilder();
String line = null;
while ((line = reader.readLine()) != null) {
sb.append(line + \"\\n\");
}
is.close();
json = sb.toString();
} catch (Exception e) {
Log.e(\"Buffer Error\", \"Error converting result \" + e.toString());
Log.d(\"json\", json.toString());
}
// try parse the string to a JSON object
try {
jObj = new JSONObject(json);
} catch (JSONException e) {
Log.e(\"JSON Parser\", \"Error parsing data \" + e.toString());
}
// return JSON String
return jObj;
}
}

到此android客户端已经完成，后天服务器端用php+mysql实现，当然这里只是个实例，存取到数据库里面，没有进行展示，代码如下
复制代码 代码如下:

<?php
// array for JSON response
$response = array();
include(\"conn.php\");
// check for required fields
if (isset($_POST[\'name\']) && isset($_POST[\'email\']) && isset($_POST[\'description\'])) {
$name = $_POST[\'name\'];
$price = $_POST[\'email\'];
$description = $_POST[\'description\'];
$result = mysql_query(\"INSERT INTO up(name, email, description) VALUES(\'$name\', \'$email\', \'$description\')\");
echo $result;
// check if row inserted or not
if ($result) {
// successfully inserted into database
$response[\"success\"] = 1;
$response[\"message\"] = \"Product successfully created.\";
// echoing JSON response
echo json_encode($response);
} else {
// failed to insert row
$response[\"success\"] = 0;
$response[\"message\"] = \"Oops! An error occurred.\";
// echoing JSON response
echo json_encode($response);
}
} else {
// required field is missing
$response[\"success\"] = 0;
$response[\"message\"] = \"Required field(s) is missing\";
// echoing JSON response
echo json_encode($response);
}
?>

数据库表结构如下，连接数据库代码就不贴出了，记得把编码设置为UTF-8就行了。


到此就完成了一个用户反馈的基本功能，后台数据里展示。如有问题欢迎给我留言。

本文地址：https://www.stayed.cn/item/10260

转载请注明出处。

本站部分内容来源于网络,如侵犯到您的权益,请 联系我

我的博客

人生若只如初见，何事秋风悲画扇。

我的标签

随笔档案