通过Android使用jdbc将数据插入mysql.遇到此错误的困难无法解析方法createStatemen() [英] Insert data into mysql using jdbc through android. Facing difficulty in this error cannot resolve method createStatemen()

问题描述

protected String doInBackground(String... params) {
    try {
        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }

        Connection conn = (Connection) DriverManager.getConnection(DB_Url, user_name, pass);
        if (conn == null) {
            msg = "Connection failed";

        } else {
            String query = "INSERT INTO mytable (data) VALUES('" + input_data + "')";
            Statement statement = conn.createStatement();

        }
    } catch (SQLException e) {
        e.printStackTrace();
    }

    return msg;
}

该类用于后台进程，通过JDBC库的帮助，通过Android应用程序将数据插入MySQL的每件事都很好，但是方法 createStatement()无法解析

this Class is for background process to insert data into MySQL through Android application, with the help of JDBC library every thing fine but the method createStatement() is unresolvable

这是错误消息:

在此处输入图像描述

推荐答案

程序的每件事都很好，您只需要完成它即可，您应该像这样执行语句:

Every thing is fine with your program you need just to complete it so, you should to execute your statement like this :

Statement statement = conn.createStatement();
int res = statement.executeUpdate(query);

然后，如果要检查查询是否成功插入，则可以这样检查:

Then if you want to check your query is insert with success or not, you can check like this :

int res = statement.executeUpdate(query);
if(res>0){
    //success
}else{
    //failed
}

因此，如果语句成功执行，它将返回一个大于1的整数，它等于查询的整数，否则将返回0，这意味着查询失败.

So if the statement execute with success it will return an int great than one it dippend of your query else it will return 0 and that mean your query is failed.

注意

使用语句可能会导致语法错误或sql注入，因此为避免这种情况，您可以使用

Using statement can cause a syntax error or an sql injection, so to avoid that you can use PrepapredStatement it is more secure and more helpful, so instead your way you can use this :

String query = "INSERT INTO mytable (data) VALUES(?)";
PreparedStatement preparedStatement = connection.prepareStatement(query);
preparedStatement.setString(1, input_data);

int res = preparedStatement.executeUpdate();

祝你好运.

这篇关于通过Android使用jdbc将数据插入mysql.遇到此错误的困难无法解析方法createStatemen()的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！