java - 我的数据进入了我的MySQL数据库，但是在出现Java错误SingleClientConnManager的同时，它仍然给出重复的输入错误

我正在尝试为我的Android应用程序创建注册页面。
我已经成功创建了一个登录页面，现在正在尝试使注册页面正常工作。

我设法将通过注册页面发送的数据获取到数据库中。我正在使用php脚本将数据传输到我的mysql数据库中。

但是每次我注册时，它都会发送数据并回显回显，表明用户名/邮件已经存在。

它还在Java中显示此错误：SingleClientConnManager的无效使用：连接仍被分配。

我已经尝试修复了几个小时，但找不到任何有帮助的方法。

这是我的数据库：

id - primary key AI
mail - unique
password
username - unique

这是我的PHP脚本

<?php
 $hostname_memolink = "localhost";
 $database_memolink = "memolink";
 $username_memolink = "android";
 $password_memolink ="f3.W2TmM}8yO";
 $memolink = mysql_connect($hostname_memolink, $username_memolink, $password_memolink) or trigger_error(mysql_error(), E_USER_ERROR);

 mysql_select_db($database_memolink, $memolink);

 $mail = $_POST['mail'];
 $password = $_POST['password'];
 $username = $_POST['username'];

 if (trim($password) == "" or trim($username) == "" or trim($mail) == "")
 {
 echo "variables are null";
 exit;
 }
 else
 {
 $resultUsername = mysql_query("SELECT * FROM tbl_user WHERE username='$username'");
 $resultMail = mysql_query("SELECT * FROM tbl_user WHERE mail='$mail'");
 $num_rows_username = mysql_num_rows($resultUsername);
 $num_rows_mail = mysql_num_rows($resultMail);

 if ($num_rows_username >= 1 && $num_rows_mail >= 1) {
  echo "username or email already exists";
  die();
 }
 else
 {
  mysql_query("INSERT INTO tbl_user (id, mail, password, username) VALUES('', '$mail', '$password', '$username')") or die(mysql_error());
  echo "registration complete";
 }
 }
?>

这是我的Java方法，它将数据发送到我的php文件：

    HttpPost httpPost;
StringBuffer buffer;
HttpResponse response;
HttpClient httpClient;
List<NameValuePair> registerData;

public void register(){
    try{

        httpClient = new DefaultHttpClient();
        httpPost = new HttpPost("http://www.memo-link.be/php/register.php");
        registerData = new ArrayList<NameValuePair>(2);
        EditText mailBox = (EditText) findViewById(R.id.mail_box);
        EditText userBox = (EditText) findViewById(R.id.username_box);
        EditText passBox = (EditText) findViewById(R.id.password_box);

        String mail = mailBox.getText().toString();
        String username = userBox.getText().toString();
        String password = passBox.getText().toString();

        registerData.add(new BasicNameValuePair("mail", mail));
        registerData.add(new BasicNameValuePair("username", username));
        registerData.add(new BasicNameValuePair("password", password));
        httpPost.setEntity(new UrlEncodedFormEntity(registerData));

        response = httpClient.execute(httpPost); //send data to Internet

        ResponseHandler<String> responseHandler = new BasicResponseHandler();
        String response = httpClient.execute(httpPost, responseHandler);
        System.out.println("Response : " + response.toString());

        if (response.equalsIgnoreCase("username or email already exists")){
            runOnUiThread(new Runnable(){
                public void run(){
                    dialog.dismiss();
                }
        });
            Vibrator v = (Vibrator) getSystemService(Context.VIBRATOR_SERVICE);
            v.vibrate(250);
            Toast toast = Toast.makeText(RegisterActivity.this, "Username already exists!", Toast.LENGTH_SHORT);
            toast.show();
        }else if(response.toString().equalsIgnoreCase("username or email already exists")){
            runOnUiThread(new Runnable(){
                public void run(){
                    dialog.dismiss();
                }
        });
            Vibrator v = (Vibrator) getSystemService(Context.VIBRATOR_SERVICE);
            v.vibrate(250);
            Toast toast = Toast.makeText(RegisterActivity.this, "Mail address already in use!", Toast.LENGTH_SHORT);
            toast.show();
        }else if(response.toString().equalsIgnoreCase("registration complete")){
            runOnUiThread(new Runnable(){
                public void run(){
                    Toast toast = Toast.makeText(RegisterActivity.this, "Registration Succesfull", Toast.LENGTH_SHORT);
                    toast.show();
                }
            });
            startActivity(new Intent(RegisterActivity.this, DashboardActivity.class));
        }

        runOnUiThread(new Runnable(){
            public void run(){
                dialog.dismiss();
            }
    });

    }catch (Exception e){
        dialog.dismiss();
        System.out.println("Exception : " + e.getMessage());
    }
}

提前致谢

最佳答案

如果有帮助，请查看此信息。让我们知道您是否需要更多帮助。

Android: Invalid use of SingleClientConnManager: connection still allocated

另外，在您的代码中，您执行了两次查询，第一次正常执行，并且在第二次查询（因为已经插入数据）后立即满足该条件并打印错误消息。希望这会有所帮助。

关于java - 我的数据进入了我的MySQL数据库，但是在出现Java错误SingleClientConnManager的同时，它仍然给出重复的输入错误，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/20034090/