请问Android怎样连接远程MySQL数据库?

Android客户端直接连接远程MySQL数据库的方法如下：

String result = ""

//首先使用NameValuePair封装将要查询的年数和关键字绑定

ArrayList<NameValuePair>nameValuePairs = new ArrayList<NameValuePair>()

nameValuePairs.add(new BasicNameValuePair("year","1980"))

//使用HttpPost封装整个SQL语句

//使用HttpClient发送HttpPost对象

try{

HttpClient httpclient = new DefaultHttpClient()

HttpPost httppost = new HttpPost("http://example.com/getAllPeopleBornAfter.php")

httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs))

HttpResponse response = httpclient.execute(httppost)

HttpEntity entity = response.getEntity()

InputStream is = entity.getContent()

}catch(Exception e){

Log.e("log_tag", "Error in http connection "+e.toString())

}

//将HttpEntity转化为String

try{

BufferedReader reader = new BufferedReader(new InputStreamReader(is,"iso-8859-1"),8)

StringBuilder sb = new StringBuilder()

String line = null

while ((line = reader.readLine()) != null) {

sb.append(line + "\n")

}

is.close()

result=sb.toString()

}catch(Exception e){

Log.e("log_tag", "Error converting result "+e.toString())

}

//将String通过JSONArray解析成最终结果

try{

JSONArray jArray = new JSONArray(result)

for(int i=0i<jArray.length()i++){

JSONObject json_data = jArray.getJSONObject(i)

Log.i("log_tag","id: "+json_data.getInt("id")+

", name: "+json_data.getString("name")+

", sex: "+json_data.getInt("sex")+

", birthyear: "+json_data.getInt("birthyear")

)

}

}

}catch(JSONException e){

Log.e("log_tag", "Error parsing data "+e.toString())

}

虽然Android开发中可以直接连接数据库，但是实际中却不建议这么做，应该使用服务器端中转下完成。

1、打开Tableau软件。

2、在连接中，找到红框位置的MySQL，点击开始连接Mysql。

3、在d出的连接界面，输入Mysql服务器地址、端口、用户名、密码。

4、输入完成后，点击红框位置 确认 进行连接。

5、此时已经连接到MySQL服务器上，为了测试 我们点击红框位置 选择数据库查看一下。

android 链接mysql数据库实例：

package com.hl

import java.sql.DriverManager

import java.sql.ResultSet

import com.mysql.jdbc.Connection

import com.mysql.jdbc.Statement

import android.app.Activity

import android.os.Bundle

import android.view.View

import android.view.View.OnClickListener

import android.widget.Button

import android.widget.TextView

public class AndroidMsql extends Activity {

@Override

public void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState)

setContentView(R.layout.main)

Button btn=(Button)findViewById(R.id.btn)

btn.setOnClickListener(new OnClickListener() {

@Override

public void onClick(View v) {

sqlCon()

}

})

}

private void mSetText(String str){

TextView txt=(TextView)findViewById(R.id.txt)

txt.setText(str)

}

private void sqlCon(){

try {

Class.forName("com.mysql.jdbc.Driver")

} catch (Exception e) {

e.printStackTrace()

}

try {

String url ="jdbc:mysql://192.168.142.128:3306/mysql?user=zzfeihua&password=12345&useUnicode=true&characterEncoding=UTF-8"//链接数据库语句

Connection conn= (Connection) DriverManager.getConnection(url)//链接数据库

Statement stmt=(Statement) conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE)

String sql="select * from user"//查询user表语句

ResultSet rs=stmt.executeQuery(sql)//执行查询

StringBuilder str=new StringBuilder()

while(rs.next()){

str.append(rs.getString(1)+"\n")

}

mSetText(str.toString())

rs.close()

stmt.close()

conn.close()

} catch (Exception e) {

e.printStackTrace()

}

}

}

不过eclipse老是提示：

warning: Ignoring InnerClasses attribute for an anonymous inner class that doesn't come with an associated EnclosingMethod attribute. (This class was probably produced by a broken compiler.)

---