Export Import vmdk di vsphere
Export
1. kita pilih dulu virtual yang akan kita impotr. Disini penulis mengunakan virtual yang sudah dibuat bernama server.
2. klik meni bar "File > Export > Export OVF Template...
3. kemudian akan muncul kotak dialog pilih select File
-pilih tempat penyimpanan. Setelah itu Pilih Ok.
-tunggu sampai proses Export selesai.
Import
1.Di vmware vsphere yang satu, dimenu bar pilih File > Deploy OVF Template...
2. akan muncul kotak dialog.pilih Browse
3. pilih file yang kita export tadi. kemudian Next
4. detai virtual akan muncul, kemudian pilih Next
5. Kotak dialog Ubah nama Virtula akan muncul.setelah itu Next.
6. kotak dialog datastore akan muncul pilih Next
7. Terakhir akan muncul Kotak dialog spesifik virtual yang di import , kemudian Pilih Finish. dan tungguh sampai proses import selesai.
terimakasi!
Laporan Praktikum 4 | Membuat Crud Input Data Nilai Mahasiswa
Pada Praktikum Kali ini saya akan membuat aplikasi sederhana yaitu crud Input nilai mahasiswa
berikut ini langkah membuat aplikasinya
1. langkah pertama kita jalankan xamppnya. perhatikan gambar berikut
2. setelah itu akses localhost/phpmyadmin. kemudiana kita buatkan database beri nama inputdata
3. sekarang kita akan buat tabel beri nama table_biodata
4. langkah selanjutnya kita buat java di src. perhatikan gambar berikut
berikut ini langkah membuat aplikasinya
1. langkah pertama kita jalankan xamppnya. perhatikan gambar berikut
3. sekarang kita akan buat tabel beri nama table_biodata
4. langkah selanjutnya kita buat java di src. perhatikan gambar berikut
5. berikut ini sourcode java diatas. perhatikan berikut ini
Biodata.java
package www.crud.com;
public class Biodata extends Koneksi {
String URL = "http://10.0.2.2/inputData/crud.php";
String url = "";
String response = "";
public String tampilBiodata() {
try {
url = URL + "?operasi=view";
System.out.println("URL Tampil Biodata: " + url);
response = call(url);
} catch (Exception e) {
}
return response;
}
public String insertBiodata(String nim, String nama, String semester, String matkul, String nilai) {
try {
url = URL + "?operasi=insert&nim=" + nim + "&nama=" + nama + "&semester=" + semester + "&matkul=" + matkul + "&nilai=" + nilai;
System.out.println("URL Insert Biodata : " + url);
response = call(url);
} catch (Exception e) {
}
return response;
}
public String getBiodataById(int id) {
try {
url = URL + "?operasi=get_biodata_by_id&id=" + id;
System.out.println("URL Insert Biodata : " + url);
response = call(url);
} catch (Exception e) {
}
return response;
}
public String updateBiodata(String id, String nim, String nama, String semester, String matkul, String nilai) {
try {
url = URL + "?operasi=update&id=" + id + "&nim=" + nim + "&nama=" + nama + "&semester=" + semester + "&matkul=" + matkul + "&nilai=" + nilai;
System.out.println("URL Insert Biodata : " + url);
response = call(url);
} catch (Exception e) {
}
return response;
}
public String deleteBiodata(int id) {
try {
url = URL + "?operasi=delete&id=" + id;
System.out.println("URL Insert Biodata : " + url);
response = call(url);
} catch (Exception e) {
}
return response;
}
}
Koneksi.java
package www.crud.com;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.net.HttpURLConnection;
import java.net.URL;
import java.net.URLConnection;
public class Koneksi {
public String call(String url) {
int BUFFER_SIZE = 2000;
InputStream in = null;
try {
in = OpenHttpConnection(url);
} catch (IOException e) {
e.printStackTrace();
return "";
}
InputStreamReader isr = new InputStreamReader(in);
int charRead;
String str = "";
char[] inputBuffer = new char[BUFFER_SIZE];
try {
while ((charRead = isr.read(inputBuffer)) > 0) {
String readString = String.copyValueOf(inputBuffer, 0, charRead);
str += readString;
inputBuffer = new char[BUFFER_SIZE];
}
in.close();
} catch (IOException e) {
// Handle Exception
e.printStackTrace();
return "";
}
return str;
}
private InputStream OpenHttpConnection(String url) throws IOException {
InputStream in = null;
int response = -1;
URL url1 = new URL(url);
URLConnection conn = url1.openConnection();
if (!(conn instanceof HttpURLConnection))
throw new IOException("Not An Http Connection");
try {
HttpURLConnection httpconn = (HttpURLConnection) conn;
httpconn.setAllowUserInteraction(false);
httpconn.setInstanceFollowRedirects(true);
httpconn.setRequestMethod("GET");
httpconn.connect();
response = httpconn.getResponseCode();
if (response == HttpURLConnection.HTTP_OK) {
in = httpconn.getInputStream();
}
} catch (Exception e) {
throw new IOException("Error connecting2");
}
return in;
}
}
Menu.java
package www.crud.com;
import java.util.ArrayList;
import www.crud.com.R;
import org.json.JSONArray;
import org.json.JSONException;
import org.json.JSONObject;
import android.app.Activity;
import android.app.AlertDialog;
import android.content.DialogInterface;
import android.graphics.Color;
import android.os.Bundle;
import android.support.v4.view.ViewPager.LayoutParams;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.LinearLayout;
import android.widget.TableLayout;
import android.widget.TableRow;
import android.widget.TextView;
import android.widget.Toast;
public class Menu extends Activity implements OnClickListener {
Biodata biodata = new Biodata();
TableLayout tabelBiodata;
Button buttonTambahBiodata;
ArrayList<Button> buttonEdit = new ArrayList<Button>();
ArrayList<Button> buttonDelete = new ArrayList<Button>();
JSONArray arrayBiodata;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
tabelBiodata = (TableLayout) findViewById(R.id.tableBiodata);
buttonTambahBiodata = (Button) findViewById(R.id.buttonTambahBiodata);
buttonTambahBiodata.setOnClickListener(this);
TableRow barisTabel = new TableRow(this);
barisTabel.setBackgroundColor(Color.CYAN);
TextView viewHeaderId = new TextView(this);
TextView viewHeaderNim = new TextView(this);
TextView viewHeaderNama = new TextView(this);
TextView viewHeaderSemester = new TextView(this);
TextView viewHeaderMatkul = new TextView(this);
TextView viewHeaderNilai = new TextView(this);
TextView viewHeaderAction = new TextView(this);
viewHeaderId.setText("ID");
viewHeaderNim.setText("Nim");
viewHeaderNama.setText("Nama");
viewHeaderSemester.setText("Semester");
viewHeaderMatkul.setText("Matkul");
viewHeaderNilai.setText("Nilai");
viewHeaderAction.setText("Action");
viewHeaderId.setPadding(10,1, 10, 1);
viewHeaderNim.setPadding(10,1, 10, 1);
viewHeaderNama.setPadding(10,1, 10, 1);
viewHeaderSemester.setPadding(10,1, 10, 1);
viewHeaderMatkul.setPadding(10,1, 10, 1);
viewHeaderNilai.setPadding(10,1, 10, 1);
viewHeaderAction.setPadding(10,1, 10, 1);
barisTabel.addView(viewHeaderId);
barisTabel.addView(viewHeaderNim);
barisTabel.addView(viewHeaderNama);
barisTabel.addView(viewHeaderSemester);
barisTabel.addView(viewHeaderMatkul);
barisTabel.addView(viewHeaderNilai);
barisTabel.addView(viewHeaderAction);
tabelBiodata.addView(barisTabel, new TableLayout.LayoutParams(LayoutParams.WRAP_CONTENT,
LayoutParams.WRAP_CONTENT));
try {
arrayBiodata = new JSONArray(biodata.tampilBiodata());
for (int i = 0; i < arrayBiodata.length(); i++) {
JSONObject jsonChildNode = arrayBiodata.getJSONObject(i);
String nim = jsonChildNode.optString("nim");
String nama = jsonChildNode.optString("nama");
String semester = jsonChildNode.optString("semester");
String matkul = jsonChildNode.optString("matkul");
String nilai = jsonChildNode.optString("nilai");
String id = jsonChildNode.optString("id");
System.out.println("Nim :" + nim);
System.out.println("Nama :" + nama);
System.out.println("Semester :" + semester);
System.out.println("Matkul :" + matkul);
System.out.println("Nilai :" + nilai);
System.out.println("ID :" + id);
barisTabel = new TableRow(this);
if (i % 100 == 0) {
barisTabel.setBackgroundColor(Color.LTGRAY);
}
TextView viewId = new TextView(this);
viewId.setText(id);
viewId.setPadding(20, 3, 20, 3);
barisTabel.addView(viewId);
TextView viewNim = new TextView(this);
viewNim.setText(nim);
viewNim.setPadding(20, 3, 20, 3);
barisTabel.addView(viewNim);
TextView viewNama = new TextView(this);
viewNama.setText(nama);
viewNama.setPadding(20, 3, 20, 3);
barisTabel.addView(viewNama);
TextView viewSemester = new TextView(this);
viewSemester.setText(semester);
viewSemester.setPadding(20, 3, 20, 3);
barisTabel.addView(viewSemester);
TextView viewMatkul = new TextView(this);
viewMatkul.setText(matkul);
viewMatkul.setPadding(20, 3, 20, 3);
barisTabel.addView(viewMatkul);
TextView viewNilai = new TextView(this);
viewNilai.setText(nilai);
viewNilai.setPadding(20, 3, 20, 3);
barisTabel.addView(viewNilai);
buttonEdit.add(i, new Button(this));
buttonEdit.get(i).setId(Integer.parseInt(id));
buttonEdit.get(i).setTag("Edit");
buttonEdit.get(i).setText("Edit");
buttonEdit.get(i).setOnClickListener(this);
barisTabel.addView(buttonEdit.get(i));
buttonDelete.add(i, new Button(this));
buttonDelete.get(i).setId(Integer.parseInt(id));
buttonDelete.get(i).setTag("Delete");
buttonDelete.get(i).setText("Delete");
buttonDelete.get(i).setOnClickListener(this);
barisTabel.addView(buttonDelete.get(i));
tabelBiodata.addView(barisTabel, new TableLayout.LayoutParams(LayoutParams.MATCH_PARENT,
LayoutParams.MATCH_PARENT));
}
} catch (JSONException e) {
e.printStackTrace();
}
}
public void onClick(View view) {
if (view.getId() == R.id.buttonTambahBiodata) {
// Toast.makeText(MainActivity.this, "Button Tambah Data",
// Toast.LENGTH_SHORT).show();
tambahBiodata();
} else {
/*
* Melakukan pengecekan pada data array, agar sesuai dengan index
* masing-masing button
*/
for (int i = 0; i < buttonEdit.size(); i++) {
/* jika yang diklik adalah button edit */
if (view.getId() == buttonEdit.get(i).getId() && view.getTag().toString().trim().equals("Edit")) {
// Toast.makeText(MainActivity.this, "Edit : " +
// buttonEdit.get(i).getId(), Toast.LENGTH_SHORT).show();
int id = buttonEdit.get(i).getId();
getDataByID(id);
} /* jika yang diklik adalah button delete */
else if (view.getId() == buttonDelete.get(i).getId() && view.getTag().toString().trim().equals("Delete")) {
// Toast.makeText(MainActivity.this, "Delete : " +
// buttonDelete.get(i).getId(), Toast.LENGTH_SHORT).show();
int id = buttonDelete.get(i).getId();
deleteBiodata(id);
}
}
}
}
public void deleteBiodata(int id) {
biodata.deleteBiodata(id);
/* restart acrtivity */
finish();
startActivity(getIntent());
}
public void getDataByID(int id) {
String nimEdit = null, namaEdit = null, semesterEdit = null, matkulEdit = null, nilaiEdit = null;
JSONArray arrayPersonal;
try {
arrayPersonal = new JSONArray(biodata.getBiodataById(id));
for (int i = 0; i < arrayPersonal.length(); i++) {
JSONObject jsonChildNode = arrayPersonal.getJSONObject(i);
nimEdit = jsonChildNode.optString("nim");
namaEdit = jsonChildNode.optString("nama");
semesterEdit = jsonChildNode.optString("semester");
matkulEdit = jsonChildNode.optString("matkul");
nilaiEdit = jsonChildNode.optString("nilai");
}
} catch (JSONException e) {
e.printStackTrace();
}
LinearLayout layoutInput = new LinearLayout(this);
layoutInput.setOrientation(LinearLayout.VERTICAL);
// buat id tersembunyi di alertbuilder
final TextView viewId = new TextView(this);
viewId.setText(String.valueOf(id));
viewId.setTextColor(Color.TRANSPARENT);
layoutInput.addView(viewId);
final EditText editNim = new EditText(this);
editNim.setText(nimEdit);
layoutInput.addView(editNim);
final EditText editNama = new EditText(this);
editNama.setText(namaEdit);
layoutInput.addView(editNama);
final EditText editSemester = new EditText(this);
editSemester.setText(semesterEdit);
layoutInput.addView(editSemester);
final EditText editMatkul = new EditText(this);
editMatkul.setText(matkulEdit);
layoutInput.addView(editMatkul);
final EditText editNilai = new EditText(this);
editNilai.setText(nilaiEdit);
layoutInput.addView(editNilai);
AlertDialog.Builder builderEditBiodata = new AlertDialog.Builder(this);
builderEditBiodata.setTitle("Update Biodata");
builderEditBiodata.setView(layoutInput);
builderEditBiodata.setPositiveButton("Update", new DialogInterface.OnClickListener() {
@Override
public void onClick(DialogInterface dialog, int which) {
String nim = editNim.getText().toString();
String nama = editNama.getText().toString();
String semester = editSemester.getText().toString();
String matkul = editMatkul.getText().toString();
String nilai = editNilai.getText().toString();
System.out.println("Nim : " + nim + "Nama : " + nama + " Semester : " + semester + " Matkul : " + matkul + " Nilai : " + nilai);
String laporan = biodata.updateBiodata(viewId.getText().toString(), editNim.getText().toString(),
editNama.getText().toString(), editSemester.getText().toString(), editMatkul.getText().toString(),
editNilai.getText().toString());
Toast.makeText(Menu.this, laporan, Toast.LENGTH_SHORT).show();
/* restart acrtivity */
finish();
startActivity(getIntent());
}
});
builderEditBiodata.setNegativeButton("Cancel", new DialogInterface.OnClickListener() {
@Override
public void onClick(DialogInterface dialog, int which) {
dialog.cancel();
}
});
builderEditBiodata.show();
}
public void tambahBiodata() {
/* layout akan ditampilkan pada AlertDialog */
LinearLayout layoutInput = new LinearLayout(this);
layoutInput.setOrientation(LinearLayout.VERTICAL);
final EditText editNim = new EditText(this);
editNim.setHint("Nim");
layoutInput.addView(editNim);
final EditText editNama = new EditText(this);
editNama.setHint("Nama");
layoutInput.addView(editNama);
final EditText editSemester = new EditText(this);
editSemester.setHint("Semester");
layoutInput.addView(editSemester);
final EditText editMatkul = new EditText(this);
editMatkul.setHint("Matkul");
layoutInput.addView(editMatkul);
final EditText editNilai = new EditText(this);
editNilai.setHint("Nilai");
layoutInput.addView(editNilai);
AlertDialog.Builder builderInsertBiodata = new AlertDialog.Builder(this);
builderInsertBiodata.setTitle("Insert Biodata");
builderInsertBiodata.setView(layoutInput);
builderInsertBiodata.setPositiveButton("Insert", new DialogInterface.OnClickListener() {
@Override
public void onClick(DialogInterface dialog, int which) {
String nim = editNim.getText().toString();
String nama = editNama.getText().toString();
String semester = editSemester.getText().toString();
String matkul = editMatkul.getText().toString();
String nilai = editNilai.getText().toString();
System.out.println("Nilai : " + nilai + " Nama : " + nama + " Semester : " + semester + " Matkul : " + matkul + " Nilai : " + nilai);
String laporan = biodata.insertBiodata(nim, nama, semester, matkul, nilai);
Toast.makeText(Menu.this, laporan, Toast.LENGTH_SHORT).show();
/* restart acrtivity */
finish();
startActivity(getIntent());
}
});
builderInsertBiodata.setNegativeButton("Cancel", new DialogInterface.OnClickListener() {
@Override
public void onClick(DialogInterface dialog, int which) {
dialog.cancel();
}
});
builderInsertBiodata.show();
}
}
setelah itu buatkan layoutnya.perhatikan gambar berikut ini
kemudian masukan sourcodenya. perhatikan gambar berikut
main.xml
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:tools="http://schemas.android.com/tools"
android:id="@+id/LinearLayout1"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:layout_gravity="center"
android:orientation="vertical"
tools:context=".MainActivity" >
<Button
android:id="@+id/buttonTambahBiodata"
android:layout_width="186dp"
android:layout_height="wrap_content"
android:layout_gravity="center"
android:text="Tambah Nilai Mahasiswa" />
<HorizontalScrollView
android:id="@+id/horizontalScrollView"
android:layout_width="match_parent"
android:layout_height="wrap_content" >
<ScrollView
android:id="@+id/verticalScrollView"
android:layout_width="wrap_content"
android:layout_height="wrap_content" >
<TableLayout
android:id="@+id/tableBiodata"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_marginTop="80dp" >
</TableLayout>
</ScrollView>
</HorizontalScrollView>
</LinearLayout>
sekarang kita buatkan folder inputData di xampp/htdocs/. dalam folder tersebut kita buatkan servernya beri nama crud.php dan admin.php berikut ini sourcodenya
crud.php
<?php
$server = "localhost";
$username = "root";
$password = "";
$database = "inputdata";
mysql_connect($server, $username, $password) or die("<h1>Koneksi Mysql Error : </h1>" . mysql_error());
mysql_select_db($database) or die("<h1>Koneksi Kedatabase Error : </h1>" . mysql_error());
@$operasi = $_GET['operasi'];
switch ($operasi) {
case "view":
/* Source code untuk Menampilkan Biodata */
$query_tampil_biodata = mysql_query("SELECT * FROM tabel_biodata") or die(mysql_error());
$data_array = array();
while ($data = mysql_fetch_assoc($query_tampil_biodata)) {
$data_array[] = $data;
}
echo json_encode($data_array);
break;
case "insert":
/* Source code untuk Insert data */
@$nim = $_GET['nim'];
@$nama = $_GET['nama'];
@$semester = $_GET['semester'];
@$matkul = $_GET['matkul'];
@$nilai = $_GET['nilai'];
$query_insert_data = mysql_query("INSERT INTO tabel_biodata (nim, nama, semester, matkul, nilai) VALUES('$nim', '$nama', '$semester', '$matkul', '$nilai')");
if ($query_insert_data) {
echo "Data Berhasil Disimpan";
} else {
echo "Error Inser Biodata " . mysql_error();
}
break;
case "get_biodata_by_id":
/* Source code untuk Edit data dan mengirim data berdasarkan id yang diminta */
@$id = $_GET['id'];
$query_tampil_biodata = mysql_query("SELECT * FROM tabel_biodata WHERE id='$id'") or die(mysql_error());
$data_array = array();
$data_array = mysql_fetch_assoc($query_tampil_biodata);
echo "[" . json_encode($data_array) . "]";
break;
case "update":
/* Source code untuk Updatedata */
@$nim = $_GET['nim'];
@$nama = $_GET['nama'];
@$semester = $_GET['semester'];
@$matkul = $_GET['matkul'];
@$nilai = $_GET['nilai'];
@$id = $_GET['id'];
$query_update_biodata = mysql_query("UPDATE tabel_biodata SET nim='$nim', nama='$nama', semester='$semester', matkul='$matkul', nilai='$nilai' WHERE id='$id'");
if ($query_update_biodata) {
echo "Update Data Berhasil";
} else {
echo mysql_error();
}
break;
case "delete":
/* Source code untuk Deletedata */
@$id = $_GET['id'];
$query_delete_biodata = mysql_query("DELETE FROM tabel_biodata WHERE id='$id'");
if ($query_delete_biodata) {
echo "Delete Data Berhasil";
} else {
echo mysql_error();
}
break;
default:
break;
}
?>
admin.php
<html>
<head><title>Input Data</title></head>
<meta http-equiv="refresh" content="30">
</html>
<?php
mysql_connect("localhost","root","");
mysql_select_db("inputdata");
//=======================================================
// Menampilkan user
//=======================================================
$sql = "SELECT * FROM tabel_biodata ";
$result = mysql_query($sql);
$row = mysql_num_rows ($result);
// Bagian ini hanya akan dikerjakan bila
// hasil query mereturn > 0 row
if ($row != 0){
// membuat title table
// title disimpan pada variable $show
echo "<center>DAFTAR NILAI MAHASISWA</center><br><table
bgcolor='black' width='100%'><tr bgcolor='#CCFFFF'><td width='25%'
align='center'>NIM</td><td width='25%' align='center'> NAMA </td><td width='25%'
align='center'> SEMESTER </td><td width='25%' align='center'> MATAKULIAH</td><td width='25%'
align='center'>NILAI</td></tr>";
$show = "";
// membuat isi tabel yang akan ditampilkan
// isi tabel disambung pada variable $show
while ($data = mysql_fetch_array($result)){
$nim = $data["nim"];
$nama = $data["nama"];
$semester = $data["semester"];
$matkul = $data["matkul"];
$nilai = $data["nilai"];
$show .= "<tr bgcolor='#CCFFFF'><td align='center'>$nim</td><td
align='center'> $nama </td><td align='center'>$semester</td>
<td align='center'>$matkul</td><td align='center'>$nilai</td></tr>";
}
// cetak ke layar
// yang dicetak adalah variabel $show
echo $show;
echo "</table>";
}
else {
echo "<tr><td>No User</td></tr>";
}
echo "<br><br><br>";
?>
sekarang kita jalankan projectnya. klik kanan pada projectnya Run-Android. maka hasilnya seperti gambar berikut
Subscribe to:
Posts (Atom)