如何将Android与Oracle数据库连接? [英] How to connect Android with Oracle database?

问题描述

我是android开发的新手.我想开发一个可从oracle数据库更新数据的android应用程序.有人可以帮我吗?

I am new to android development. I want to develop a android application that update data from a oracle database. Could anyone help me out?

先谢谢了.

推荐答案

使用Apache Server将android连接到pc

Use Apache Server to connect android to pc

在php.ini中打开oci8.dll

In php.ini open oci8.dll

在htdocs中制作php文件.您的php代码是

in htdocs make php file. Your php code is

<?PHP

 $con=
"(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Your_ip)(PORT = 1521))
(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = Your_db_name)
)
)";
$conn = ocilogon( "User_name", "Password",$con,"WE8ISO8859P15");

$query = "select * from table_name";
        $parseresults = ociparse($conn, $query);

        ociexecute($parseresults);

    while($row=oci_fetch_assoc($parseresults))

 $output[]=$row;

 print json_encode($output);

oci_free_statement($parseresults);
oci_close($conn);

?>

在android中:

public class UploadActivity extends AsyncTask<Void, Void, String> {
Context context;

String result;

public UploadActivity(Context context) {
    this.context = context;
}

@SuppressWarnings("static-access")
@Override
protected void onPreExecute() {
    super.onPreExecute();


}

@Override
protected String doInBackground(Void... params) {
    // TODO Auto-generated method stub


    final List<Pair<String, String>> postParameters = new ArrayList<>();




        for (int i = 0; i < activity[0].length; i++) {

            //postParameters.add(new Pair<>("var1", activity[i][0]);

            result = null;


            try {

                String response = CustomHttpClient.execute(
                        URL + "Your_php.php", postParameters);
                result = response.toString();
                result = result.replaceAll("(\r\n|\n)", "");

            } catch (Exception e) {

                Log.e("log_tag_ms", "Error in http connection!!" + e.toString());

            }

        }


    return null;
}

protected void onPostExecute(String result) {
    super.onPostExecute(result);


    }  }

这篇关于如何将Android与Oracle数据库连接?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！