Insert Data pada MySQL

1. New Project dan pilih Empty Activity

2. Beri Nama Project
3. Buka [Link] dan tambahkan baris berikut tepat diatas
<application>

<uses-permission android:name="[Link]" />

<uses-permission android:name="[Link].ACCESS_NETWORK_STATE" />

Sehingga Android Manifest menjadi seperti berikut ini:

4. Buka Gradle Scripts -> [Link] (app) dan tambahkan baris berikut pada
bagian akhir tag android

useLibrary '[Link]'
packagingOptions {
exclude 'META-INF/DEPENDENCIES'
}

5. Tambahkan baris berikut sebelum tag <dependencies>

repositories {
maven { url = '[Link] }
}

6. Tambahkan baris berikut pada akhir sebelum penutup tag dependencies

implementation '[Link]:httpcore:4.4.1'
implementation '[Link]:httpclient:4.5'
implementation '[Link]:volley:1.1.0'
7. Sehingga [Link] (app) menjadi seperti berikut:

8. Pastikan Komputer atau Laptop anda terhubung dengan Internet, dan Klik
build
9. Setelah proses build selesai, buka activity_main.xml, lalu sesuaikan dengan
baris berikut:
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="[Link]
xmlns:app="[Link]
xmlns:tools="[Link]
android:layout_width="match_parent"
android:layout_height="match_parent"
tools:context=".MainActivity"
android:orientation="vertical">
<LinearLayout
android:layout_width="match_parent"
android:layout_height="match_parent"
android:orientation="vertical"
android:padding="20dp">

<EditText
android:id="@+id/editNIM"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:ems="10"
android:inputType="number"
android:hint="NIM"/>

<EditText
android:id="@+id/editNama"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:ems="10"
android:inputType="text"
android:hint="Nama" />

<EditText
android:id="@+id/editAlamat"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:ems="10"
android:inputType="text"
android:hint="Alamat"/>

<Button
android:id="@+id/button"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="Submit"
android:background="#f7bb1a"/>
</LinearLayout>
</LinearLayout>
[Link] tampilan aplikasi menjadi seperti dibawah ini:
[Link] [Link] dan tambahkan fungsi berikut setelah tag penutup
onCreate

public class onButtonClick extends AsyncTask<Object, Object, Integer> {

private ProgressDialog progressDialog = new ProgressDialog([Link]);

private Context context;

@Override
protected void onPreExecute() {
[Link]();
progressDialog = new ProgressDialog([Link]);
[Link](true);
[Link]("Please Wait");
[Link](false);
[Link]();
}

@Override
protected Integer doInBackground(Object... objects) {
byte[] result = null;
String str = "";

HttpClient httpClient = new DefaultHttpClient();

HttpPost httpPost = new HttpPost(url);

Log.e("URL: ", url);

try {
HttpResponse response = [Link](httpPost);
} catch (ClientProtocolException e) {
[Link]();
[Link]([Link], "Client Protocol"+[Link]().toString(), Toast.LENGTH_LONG).show();
} catch (IOException e) {
[Link]();
}
return 1;
}

@Override
protected void onPostExecute(Integer integer) {
[Link](integer);

if (progressDialog != null && [Link]()) {

[Link]();
}
}
}

Fungsi tersebut digunakan untuk mengirim data, guna dimasukkan dalam database.
[Link] variable berikut sebelum fungsi onCreate

Button button;
EditText editTextNIM, editTextNama, editTextAlamat;
String serverAddress = "[Link]
String temp, url;
String nim, nama, alamat;

[Link] fungsi onCreate, tambahkan baris berikut setelah setContentView

editTextNIM = findViewById([Link]);
editTextNama = findViewById([Link]);
editTextAlamat = findViewById([Link]);
button = findViewById([Link]);

[Link](new [Link]() {
@Override
public void onClick(View view) {
nim=[Link]().toString();
nama=[Link]().toString();
alamat=[Link]().toString();

temp=serverAddress+"nim="+nim+"&nama="+nama+"&alamat="+alamat;
url = [Link](" ", "%20");
new onButtonClick().execute();

}
});
[Link] akan menjadi seperti berikut:
package [Link];

import [Link];

import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];
import [Link];

import [Link];
import [Link];
import [Link];
import [Link];
import [Link];

import [Link];

public class MainActivity extends AppCompatActivity {

Button button;
EditText editTextNIM, editTextNama, editTextAlamat;
String serverAddress = "[Link]
String temp, url;
String nim, nama, alamat;

@Override
protected void onCreate(Bundle savedInstanceState) {
[Link](savedInstanceState);
setContentView([Link].activity_main);
editTextNIM = findViewById([Link]);
editTextNama = findViewById([Link]);
editTextAlamat = findViewById([Link]);
button = findViewById([Link]);

[Link](new [Link]() {
@Override
public void onClick(View view) {
nim=[Link]().toString();
nama=[Link]().toString();
alamat=[Link]().toString();

temp=serverAddress+"nim="+nim+"&nama="+nama+"&alamat="+alamat;
url = [Link](" ", "%20");
new onButtonClick().execute();

}
});

public class onButtonClick extends AsyncTask<Object, Object, Integer> {

private ProgressDialog progressDialog = new

ProgressDialog([Link]);

private Context context;

 @Override
protected void onPreExecute() {
[Link]();
progressDialog = new ProgressDialog([Link]);
[Link](true);
[Link]("Please Wait");
[Link](false);
[Link]();
}

@Override
protected Integer doInBackground(Object... objects) {
byte[] result = null;
String str = "";

HttpClient httpClient = new DefaultHttpClient();

HttpPost httpPost = new HttpPost(url);

Log.e("URL: ", url);

try {
HttpResponse response = [Link](httpPost);
} catch (ClientProtocolException e) {
[Link]();
[Link]([Link], "Client
Protocol"+[Link]().toString(), Toast.LENGTH_LONG).show();
} catch (IOException e) {
[Link]();
}
return 1;
}

@Override
protected void onPostExecute(Integer integer) {
[Link](integer);

if (progressDialog != null && [Link]()) {

[Link]();
}
}
}

15. Jalankan Program, dan lakukan proses insert data. Pastikan data yang
dimasukkan muncul di [Link]