TUTORIAL PEMBUATAN Database(Part 1). PADA ADT BUNDLE ANDROID

1. Buat Project Baru
   
2. Desain interface baru untuk tampilan awal program
   
3. Buat Layout baru dengan nama create data dengan tampilan seperti berikut :
   
   
   4.Buat Class baru pada folder src dengan nama createData,tuliskan coding seperti di bawah ini:
   package com.example.dbandroid;
   
   
   import android.app.Activity;
   import android.os.Bundle;
   import android.view.View;
   import android.view.View.OnClickListener;
   import android.widget.Button;
   import android.widget.EditText;
   import android.widget.Toast;
   
   
   public class createData extends Activity implements OnClickListener {
   private Button Submit;
   private EditText nama,merk,harga;
   private DBDataSource datasource;
   @Override
   protected void onCreate(Bundle savedInstanceState) {
   // TODO Auto-generated method stub
   super.onCreate(savedInstanceState);
   setContentView(R.layout.createdata);
   
   Submit=(Button) findViewById(R.id.btnSubmit);
   Submit.setOnClickListener(this);
   nama=(EditText) findViewById(R.id.txtnama);
   merk=(EditText) findViewById(R.id.txtmerk);
   harga=(EditText) findViewById(R.id.txtharga);
   
   datasource=new DBDataSource(this);
   datasource.open();
   }
   public void onClick(View arg0){
   String nm=null;
   String mk=null;
   String hrg=null;
   
   Barang barang=null;
   
   if(nama.getText()!=null&&merk.getText()!=null && harga.getText()!=null){
   nm=nama.getText().toString();
   mk=merk.getText().toString();
   hrg=harga.getText().toString();
   }
   switch(arg0.getId())
   {
   case R.id.btnSubmit:
   barang=datasource.createBarang(nm,mk,hrg);
   Toast.makeText(this, "masuk Barang\n"+
   "nama"+barang.getNama_barang()+
   "merk"+barang.getMerk_barang()+
   "harga"+barang.getHarga_barang(),
   Toast.LENGTH_LONG).show();
   break;
   }
   
   }
   
   }
   5.Buat class baru dengan nama dbHelper,dan tuliskan coding berikut :
   package com.example.dbandroid;
   
   
   import android.content.Context;
   import android.database.sqlite.SQLiteDatabase;
   import android.database.sqlite.SQLiteOpenHelper;
   import android.util.Log;
   
   
   public class dbHelper extends SQLiteOpenHelper {
   public static final String TABLE_NAME="data_inventory";
   public static final String COLOUMN_ID="_id";
   public static final String COLOUMN_NAME="nama_barang";
   public static final String COLOUMN_MERK="merk_barang";
   public static final String COLOUMN_HARGA="harga_barang";
   private static final String db_name="inventory.db";
   private static final Integer db_version=1;
   
   private static final String db_create="create table"
   +TABLE_NAME+"("
   +COLOUMN_ID+"integer primary key autoincrement,"
   +COLOUMN_NAME+"varchar(50) not null,"
   +COLOUMN_MERK+"varchar(50) not null,"
   +COLOUMN_HARGA+"varchar(50) not null);";
   
   public dbHelper(Context sia){
   super(sia,db_name,null,db_version);
   }
   public void onCreate(SQLiteDatabase db){
   db.execSQL(db_create);
   }
   public void onUpgrade(SQLiteDatabase db,int oldVersion,int newVersion){
   Log.w(dbHelper.class.getName(),"Upgrading database from"+
   oldVersion+"to"+newVersion+"which will destroy all old data");
   db.execSQL("Drop Table If Exists"+TABLE_NAME);
   onCreate(db);
   }
   }
   6.Buat Class baru dengan namaDBDataSource dengan coding seperti berikut:
   package com.example.dbandroid;
   
   
   import android.content.ContentValues;
   import android.content.Context;
   import android.database.SQLException;
   import android.database.sqlite.SQLiteDatabase;
   
   
   public class DBDataSource {
   private SQLiteDatabase database;
   private dbHelper dbHelper;
   
   private String[] allcolomns={
   dbHelper.COLOUMN_ID,
   dbHelper.COLOUMN_NAME,
   dbHelper.COLOUMN_MERK,
   dbHelper.COLOUMN_HARGA
   };
   
   public DBDataSource(Context c){
   dbHelper=new dbHelper(c);
   }
   public void open()throws SQLException{
   database=dbHelper.getWritableDatabase();
   }
   public void close(){
   dbHelper.close();
   }
   public Barang createBarang(String nm,String mk,String hrg){
   ContentValues values=new ContentValues();
   values.put(dbHelper.COLOUMN_NAME, nm);
   values.put(dbHelper.COLOUMN_MERK, mk);
   values.put(dbHelper.COLOUMN_HARGA, hrg);
   
   long insertId=database.insert(dbHelper.TABLE_NAME,null, values);
   Cursor cursor=database.query(distinct, table, columns, selection, selectionArgs, groupBy, having, orderBy, limit, cancellationSignal)
   }
   
   }
   
   
   
   
   
   

Read More

Tutorial Menampilkan Gambar & Identitas Pada Form 2 C#

Gambar 0.1

Gambar 0.1 adalah tampilan pada form 1 yang berisikan coding sebagai berikut :

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

namespace WindowsFormsApplication3

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

        private void checkBox1_CheckedChanged(object sender, EventArgs e)

        {

        }

        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)

        {

        }

        private void Form1_Load(object sender, EventArgs e)

        {

            comboBox1.Items.Add("Islam");

            comboBox1.Items.Add("Kristen");

            comboBox1.Items.Add("Katolik");

            comboBox1.Items.Add("Hindu");

            comboBox1.Items.Add("Budha");

        }

        private void button1_Click(object sender, EventArgs e)

        {

            string a, b, c, d, f;

            if (radioButton1.Checked == true)

            {

                a = "Laki-laki";

            }

             else

            {

                a = "Perempuan";

            }

            if (checkBox1.Checked == true)

            {

                b = "Sepak Bola";

            }

            else

            {

                b = "";

            }

            if (checkBox2.Checked == true)

            {

                c = "Badminton";

            }

            else

            {

                c = "";

            }

            if (checkBox3.Checked==true)

            {

                d = "Basket";

            }

            else

            {

                d="";

            }

            if (checkBox4.Checked==true)

            {

                f = "Volley";

            }

            else 

            {

                f="";

            }

            Form2 baru = new Form2();

            baru.richTextBox1.Text  

                = "\nNama\t\t: " + textBox1.Text + "\nAlamat\t\t: " + textBox2.Text +

                "\nJenis Kelamin\t: " + a + "\nHobi\t\t\t: " + b + c + d + f;

            baru.pictureBox1.Image = pictureBox1.Image;

            baru.Show();

            

        }

        private void tabPage2_Click(object sender, EventArgs e)

        {

        }

        private void button2_Click(object sender, EventArgs e)

        {

            openFileDialog1.ShowDialog();

            pictureBox1.Image = Image.FromFile(openFileDialog1.FileName);

        }

    }

}

Gambar 0.2

Pada Gambar 0.2 adalah tampilan form pada form 2,,jadi disini kita membuat form baru ,,dan akan menampilkannya pada form2 ,jadi kita menggabungkan 2 form dan ini kodingnya :

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

namespace WindowsFormsApplication3

{

    public partial class Form2 : Form

    {

        public Form2()

        {

            InitializeComponent();

        }

        private void button1_Click(object sender, EventArgs e)

        {

            Application.Exit();

        }

        private void richTextBox1_TextChanged(object sender, EventArgs e)

        {

        }

        private void Form2_Load(object sender, EventArgs e)

        {

        }

    }

}

Dan Gambar 0.3 adalah tampilan pada form1 bagian tab page .

Gambar 0.3

Dan Gambar 0.4 adalah Gambar Sebelum ditambahkannya gambar pada form 1 tab page 2 "

Gambar 0.4

Read More

Script windows form Pemesanan Tiket Kereta

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            cmbkereta.Items.Add("Mutiara Timur");
            cmbkereta.Items.Add("Purwojaya");
            cmbkereta.Items.Add("Logawa");
        }

        private void cmdproses_Click(object sender, EventArgs e)
        {
            /*button proses*/
            int harga;

            double diskon, total;

            if (cmbkereta.SelectedItem.ToString() == "Mutiara Timur")
            {
                harga = 125000;
            }
            else if (cmbkereta.SelectedItem.ToString() == "purwojaya")
            {
                harga = 97500;
            }
            else
            {
                harga = 45000;
            }

            /*radio button menggunakan .Checked*/
            if (optkaryawan.Checked == true)
            {
                diskon = 0.1;
            }
            else
            {
                diskon = 0;
            }



            /*rumus*/
            total = (harga * double.Parse(txtjumlah.Text)) - (harga * double.Parse(txtjumlah.Text) * diskon);
            MessageBox.Show("Total Bayar = " + total.ToString());

            /*Checkbox*/
            if (checkBox1.Checked == true)
            {
                total = total + 3500;
            }
            else if (checkBox2.Checked == true)
            {
                total = total + 6000;
            }
            else
            {
                total = total + 12500;
            }

            MessageBox.Show("Total = " + total.ToString());

        }
    }
}

Read More

Script Fibonacci c#

 Cara pertama:
============================================================================
//Fibonacci 1
==========================================================================
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace ConsoleApplication3
{
    class Program
    {
        static void Main(string[] args)
        {

          int x = 1, y = 1, z = 1;

          Console.Write("jumlah bilangan Fibonasi yang ingin ditampilkan =");
          int jumlah = Convert.ToInt32(Console.ReadLine());
          for (int i = 0; i < jumlah; i++)
           {
               Console.Write(z + " ");
               z = x + y;
               x = y;
               y = z;
           }
      

        }
    }
}

=========================================================================================




Cara ke-2.:

//Fibonacci 2
==========================================================================
public void fibonacci(int bil)
        {
            int a = 0;
            int b = 1;
            for (int i = 1; i <= bil; i++)
            {
                a = a + b;
                b = a - b;
                Console.Write (a + " ");
            }
        }










=============================================================================


Unduh File via 4shared Download disini !

Read More