[Android] 안드로이드 <-> PHP <-> Mysql 연동 완벽정리 (4) - Android (PHP) Mysql 연동

Android <-> PHP <-> Mysql 마지막입니다.

 

안드로이드 스튜디오에서 프로젝트를 만듭니다.

 

프로젝트명은 DBConnection 으로 생성하였습니다.

 

 

 

MainActivitiy.java

 

package com.jy.dbconnection; import android.app.Activity; import android.os.AsyncTask; import android.os.Bundle; import android.widget.ListAdapter; import android.widget.ListView; import android.widget.SimpleAdapter; import org.json.JSONArray; import org.json.JSONException; import org.json.JSONObject; import java.io.BufferedReader; import java.io.InputStreamReader; import java.net.HttpURLConnection; import java.net.URL; import java.util.ArrayList; import java.util.HashMap; public class MainActivity extends Activity { String myJSON; private static final String TAG_RESULTS = "result"; private static final String TAG_ID = "id"; private static final String TAG_NAME = "name"; private static final String TAG_ADD = "address"; JSONArray peoples = null; ArrayList<HashMap<String, String>> personList; ListView list; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); list = (ListView) findViewById(R.id.listView); personList = new ArrayList<HashMap<String, String>>(); getData("http://210.105.203.225/PHP_connection.php"); //수정 필요 } protected void showList() { try { JSONObject jsonObj = new JSONObject(myJSON); peoples = jsonObj.getJSONArray(TAG_RESULTS); for (int i = 0; i < peoples.length(); i++) { JSONObject c = peoples.getJSONObject(i); String id = c.getString(TAG_ID); String name = c.getString(TAG_NAME); String address = c.getString(TAG_ADD); HashMap<String, String> persons = new HashMap<String, String>(); persons.put(TAG_ID, id); persons.put(TAG_NAME, name); persons.put(TAG_ADD, address); personList.add(persons); } ListAdapter adapter = new SimpleAdapter( MainActivity.this, personList, R.layout.list_item, new String[]{TAG_ID, TAG_NAME, TAG_ADD}, new int[]{R.id.id, R.id.name, R.id.address} ); list.setAdapter(adapter); } catch (JSONException e) { e.printStackTrace(); } } public void getData(String url) { class GetDataJSON extends AsyncTask<String, Void, String> { @Override protected String doInBackground(String... params) { String uri = params[0]; BufferedReader bufferedReader = null; try { URL url = new URL(uri); HttpURLConnection con = (HttpURLConnection) url.openConnection(); StringBuilder sb = new StringBuilder(); bufferedReader = new BufferedReader(new InputStreamReader(con.getInputStream())); String json; while ((json = bufferedReader.readLine()) != null) { sb.append(json + "\n"); } return sb.toString().trim(); } catch (Exception e) { return null; } } @Override protected void onPostExecute(String result) { myJSON = result; showList(); } } GetDataJSON g = new GetDataJSON(); g.execute(url); } }

 

 

activitiy_main.xml

 

<?xml version="1.0" encoding="utf-8"?> <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="vertical" tools:context=".MainActivity"> <ListView android:id="@+id/listView" android:layout_width="match_parent" android:layout_height="wrap_content" /> </LinearLayout>

 

 

list_item.xml

 

<?xml version="1.0" encoding="utf-8"?> <LinearLayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="fill_parent" android:layout_height="wrap_content" android:orientation="vertical" android:padding="10dp" android:paddingLeft="10dp" android:paddingRight="10dp"> <TextView android:id="@+id/id" android:layout_width="fill_parent" android:layout_height="wrap_content" android:paddingBottom="2dip" android:paddingTop="6dip" android:textStyle="bold" /> <TextView android:id="@+id/name" android:layout_width="fill_parent" android:layout_height="wrap_content" android:paddingBottom="2dip" android:textStyle="bold" /> <TextView android:id="@+id/address" android:layout_width="wrap_content" android:layout_height="wrap_content" android:gravity="left" android:textStyle="bold" /> </LinearLayout>

 

 

manifests.xml

 

<?xml version="1.0" encoding="utf-8"?> <manifest xmlns:android="http://schemas.android.com/apk/res/android" package="com.jy.dbconnection"> <application android:allowBackup="true" android:icon="@mipmap/ic_launcher" android:label="@string/app_name" android:supportsRtl="true" android:theme="@style/AppTheme"> <activity android:name=".MainActivity"> <intent-filter> <action android:name="android.intent.action.MAIN" /> <category android:name="android.intent.category.LAUNCHER" /> </intent-filter> </activity> </application> <uses-permission android:name="android.permission.INTERNET" /> </manifest>

 

 

 

<uses-permission android:name="android.permission.INTERNET"/> 이부분 추가해야합니다.

 

 

 

 

 

 

 

쨘~ Android와 Mysql 을 연동하였습니다.

 

안되시거나 궁금하신점은 댓글로 남겨주시면 

알려드리겠습니다.

 

 

 

2017/06/28 - [Android 강의] - [Android 강의] 10. Android <-> PHP <-> Mysql 연동 (3) - Mysql PHP 연동