money oh money

MONEY

Money can buy a House
But not a Home

Money can buy a Bed
But not Sleep

It can buy a Clock
But not Time

It can buy you a Book
But not Knowledge

Money can buy you a Position
But not Respect

Money can buy you Medicine
But not Health

Money can buy you Blood
But not Life

Money can buy you Sex
But not Love

Money isn't everything
It often causes pain and suffering

I tell you this
cause I'm your friend
and want to take away
your pain and suffering
So send me all your money
and I will suffer for you

I ACCEPT CASH, MONEY ORDERS,
PERSONAL CHECKS, CASHIERS
CHECKS, BAGS OF GOLD,
BARS OF PLATINUM, GRADE 5 PLUTONIUM,
ETC...

free premium template from rockettheme

Being a blogger, it is useful to present the best we can. like a shop, design template is everything. Because when the visitors come from anywhere in the world, they will immediately remove possible if you see the look of your website that are not attractive.
The first impression visitors have we won our blog. This is apt strategy to win the hearts of visitors. for this reason, this time I will share with you, to share-based WordPress Blog Templates that I have from RocketTheme. This morning I see it cost to get the templates from RocketTheme is $ 50 for 60 days. $ 75 for 180 days and $ 90 for one full year of membership.

You do not have to bother with, and mnegeluarkan much money, I'll share with you one template called solar sentinel. This template is good, [since this is a premium template, which I share for you]. Universities in Indonesia, one that uses this template is Paramadina University. You can check yourself at paramadina.ac.id

there is screen shoot from solar sentinel

* New: RokMicroNews

* New: RokNewsFlash

* New: RokStories

* RokBox

* Source Ordered Layout

* RokMooMenu

* 10 Preset Styles

* 9 Widget Variations

* 10 Widget Positions

* Fully translatable

* FF3, Opera 9.6, Safari 3, IE6,7,8 Compatible

* W3C XHTML 1.0 Transitional. W3C CSS Valid

if you want, you can download there

Get Into the best shape of your life fast

have a good shape is dream every people. at general, they want have body to be slim. actually, i think the effective way is with boot camps. what is boot camps? Boot camp refers colloquially to military recruit training. there, we have many training. Each training session runs for 45-90mins, with each course as challenging as the next, activities can include: pad work, running/ interval training, kettlebell training, endurance circuits SAQ, circuit training, tabata, core training, resistance training steep step running, assault course, swimming, tyre challenge, biathlon, stretching and more.
now, we can called fitness boot camps. in there, we will be have a good shape. through exercise, we will see a effect. All inclusive Weekend to get Lean in Surrey,Sussex & Kent. then, not only training but also, we have protected our nutrition. As optimum nutrition is key for effective breaking down of fat for energy, our targeted menus and meal plans are put together and Nutritional workshop delivered by our highly acclaimed Nutritionist accredited by the British Association of Nutrition Therapists (BANT).

Sistem Basis Data

Minggu ini adalah minggu terakhir dari perkuliahan kita. berikut adalah materi yang akan digunakan untuk UAS. semua materi sudah Anda dapatkan baik sebelum UTS atau sesudah UTS. materi ini mencakup relasi dua tabel, klausa Where, dsb.

sebelumnya Anda harus membuat dua tabel dengan struktur sebagai berikut

Table Dosen
Field : Nid varchar (8)*
Nama varchar (15




untuk tabel gaji
Nid varchar (8)*
Lama Varchar (2)
Golongan varchar (4)
Gaji int (7)
Golongan varchar (4)




pertanyaan :
1. Dari dua table tersebut bentuk field berikut, Nid, Nama, Lama, Golongan, Gaji.
2. Tampilkan nama dosen yang memiliki Gaji diatas 3000000
3. Tampilkan semua dosen yang memiliki golongan IIA
4. Tampilkan semua dosen yang lama mengabdi antra 5 sampai 10 tahun.
5. Tampilkan semua dosen yang bergolongan I A dan gaji = 2.250.000
6. Tampilkan semua dosen yang bergolongan II A atau lama 8 tahun

klue nya:

no. 1 adalah menggabungkan dua buah tabel dengan perintah inner join. sedangkan no berikutnya menggunakan klausa where yang ada pada materi sebelum mid semester.

mysql> select dosen.nid, dosen.nama, gaji.lama, gaji.golongan, gaji.gaji
-> from dosen inner join gaji
-> on dosen.nid = gaji.nid
-> ;
+----------+-------------+------+----------+---------+
| nid | nama | lama | golongan | gaji |
+----------+-------------+------+----------+---------+
| U.00.115 | Rudi candra | 4 | IIA | 2500000 |
| U.00.105 | Jim neutron | 14 | IA | 2000000 |
| U.00.015 | Colin Powel | 11 | IIA | 2250000 |
| U.00.118 | Tim Huard | 8 | IIIA | 4500000 |
| U.00.001 | lary Page | 9 | IIA | 5000000 |
| U.00.077 | Tony Blair | 1 | IA | 2150000 |
| U.00.320 | Bill Gate | 2 | IVA | 3200000 |
| U.00.145 | Steve jobs | 5 | IA | 2750000 |
| U.00.450 | Bob Sadino | 7 | IIA | 4000000 |
| U.00.003 | Ciputra | 3 | IA | 250000 |
+----------+-------------+------+----------+---------+
10 rows in set (0.27 sec)

jika Anda membutuhkan pentujunk, silahkan download file berikut
http://www.ziddu.com/download/11016030/LatihanSebelumUAS.rar.html

EditDatabase dengan JCreator

Materi ini ditujukan untuk kuliah tanggal 12 Juli 2010, matakuliah: PPA 2 Java. pada prinsip nya kita akan merubah data yang ada di Database [siswa.mdb yang kita sudah buat di praktikkum sebelumnya]. prinsip yang kita gunakan adalah prinsip update yang ada pada perinah SQL. dasarnya adalah update set A from datasiswa where id = 'xxxx'; berikut scriptnya, tapi dianjurkan untuk mengetik ulang karena dimungkinkan font yang ada berbeda dengan font yang ada di JCreator. jika langsung copy paste kemungkinan akan error.
siapkan JCreatornya.

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.io.*;

public class editdata
{
public static void main(String args[])
{
JFrame frame = new JFrame ("EDIT DATA");
frame.setSize(300,100);
frame.setDefaultCloseOperation (JFrame.EXIT_ON_CLOSE);

JLabel lblnis = new JLabel("NIS");
final JTextField txtnis = new JTextField(4);

JLabel lblnama = new JLabel("NAMA");
final JTextField txtnama = new JTextField(20);

JLabel lblnilai = new JLabel("NILAI");
final JTextField txtnilai = new JTextField(4);

final JTextField txtcari = new JTextField(4);

JButton btncari = new JButton("Cari");
JButton btnedit = new JButton("Edit");

btncari.addActionListener(new ActionListener()
{
public void actionPerformed (ActionEvent e)
{
try
{
final String cari=txtcari.getText();

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String koneksi="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=siswa.mdb";
Connection connection = DriverManager.getConnection(koneksi);
Statement statement = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
String sql="select * from datasiswa where nis like '"+cari+"'";
ResultSet rs=statement.executeQuery(sql);

if(rs.next())
{
txtnis.setText(rs.getString(1));
txtnama.setText(rs.getString(2));
txtnilai.setText(rs.getString(3));
}
else
{
System.out.println("Data tidak ada");
}

statement.close();
connection.close();
}
catch(Exception ev)
{
System.out.println("Error :"+ev);
}
}
});

btnedit.addActionListener(new ActionListener()
{
public void actionPerformed (ActionEvent e2)
{
try
{
final String nis=txtnis.getText();
final String nama=txtnama.getText();
final String nilai=txtnilai.getText();

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String koneksi="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=siswa.mdb";
Connection connection = DriverManager.getConnection(koneksi);
Statement statement = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
String sql="update datasiswa set nilai='"+nilai+"' where Nis ='"+nis+"'" ;
statement.executeUpdate(sql);
statement.close();
connection.close();
System.out.println("Data Telah Diubah");
}
catch(Exception e)
{
System.out.println("Error :"+e);
}
}
});

frame.getContentPane().setLayout(new GridLayout(6,4));
txtnis.setEditable(false);
txtnama.setEditable(false);
frame.getContentPane().add(txtcari);
frame.getContentPane().add(btncari);
frame.getContentPane().add(lblnis);
frame.getContentPane().add(txtnis);
frame.getContentPane().add(lblnama);
frame.getContentPane().add(txtnama);
frame.getContentPane().add(lblnilai);
frame.getContentPane().add(txtnilai);
frame.getContentPane().add(btnedit);
frame.pack();
frame.setVisible(true);
}
}

-------------------------------

yang jadi bagian terpenting adalah bagian ini "String koneksi="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=siswa.mdb"; "
jadi tolong dipastikan file siswa.mdb berada pada satu folder dengan file editdata.java sehingga bisa berjalan dengan baik.
Apabila berjalan dengan baik, maka akan tampil seperti ini,

Prinsip nya, Anda isikan Nis kemudian tekan button Cari, maka Anda dapat meng-update Field Nilai. kemudian jika sudah dinilai benar, maka Anda dapat tekan button update.