android edittext显示数据,android editText在mysql数据库中显示为0的文本？

我创建了一个简单的登录和注册用户界面一切工作正常，除了用户名editText字段输入的文本总是在mysql数据库中显示为0。android editText在mysql数据库中显示为0的文本？

这里是一个使用排枪和处理JSON响应，并创建一个新的意图，是以用户在登录屏幕的类：

public class RegisterActivity extends AppCompatActivity {

@Override

protected void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.activity_register);

final EditText etAge = (EditText) findViewById(R.id.etAge);

final EditText etName = (EditText) findViewById(R.id.etName);

final EditText etUserName = (EditText) findViewById(R.id.etUsername);

final EditText etPassword = (EditText) findViewById(R.id.etPassword);

final Button bRegister = (Button) findViewById(R.id.bRegister);

bRegister.setOnClickListener(new View.OnClickListener() {

@Override

public void onClick(View view) {

final String name = etName.getText().toString();

final String username = etUserName.getText().toString();

final String password = etPassword.getText().toString();

final int age = Integer.parseInt(etAge.getText().toString());

Response.Listener responseListener = new Response.Listener() {

@Override

public void onResponse(String response) {

try {

JSONObject jsonResponse = new JSONObject(response);

Boolean success = jsonResponse.getBoolean("success");

if (success) {

Intent intent = new Intent(RegisterActivity.this, LoginActivity.class);

RegisterActivity.this.startActivity(intent);

} else {

AlertDialog.Builder builder = new AlertDialog.Builder(RegisterActivity.this);

builder.setMessage("Register Failed")

.setNegativeButton("Retry", null)

.create()

.show();

}

} catch (JSONException e) {

e.printStackTrace();

}

}

};

RegisterRequest registerRequest = new RegisterRequest(name, username, age, password, responseListener);

RequestQueue queue = Volley.newRequestQueue(RegisterActivity.this);

queue.add(registerRequest);

}

});

}

}

这里是发送请求，使连接类：

public class RegisterRequest extends StringRequest{

private static final String REGISTER_REQUEST_URL = "http://192.168.100.105/register.php";

private Map params;

public RegisterRequest(String name, String username, int age, String password, Response.Listener listener) {

super(Method.POST, REGISTER_REQUEST_URL, listener, null);

params = new HashMap<>();

params.put("name", name);

params.put("username", username);

params.put("password", password);

params.put("age", age + "");

}

@Override

public Map getParams() {

return params;

}

}

这里是用来验证，连接和查询数据库的PHP文件：

$con = mysqli_connect("localhost", "root", "password", "androidtest");

$name = $_POST["name"];

$age = $_POST["age"];

$username = $_POST["username"];

$password = $_POST["password"];

$statement = mysqli_prepare($con, "INSERT INTO users (name, username, age,

password) VALUES (?, ?, ?, ?)");

mysqli_stmt_bind_param($statement, "siss", $name, $username, $age,

$password);

mysqli_stmt_execute($statement);

$response = array();

$response["success"] = true;

echo json_encode($response);

?>

，因为我不允许上传附加图像，这里是数据库的截图链接：

2017-09-24

N00B

+0

在onClick是字符串用户名持有值？ –

+0

是的，它与所有其他变量相同 –

+0

然后我可以想到的是，什么是变量类型的用户名列。 –