Senin, 07 Januari 2013

Software nya Bu'

Diposting oleh Unknown di 07.35 0 komentar
Program Java "Calculator"

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

class Calculator implements ActionListener
{
int c,n;
String s1,s2,s3,s4,s5;
Frame f;
JButton b1,b2,b3,b4,b5,b6,b7,b8,b9,b10,b11,b12,b13,b14,b15,b16;
Panel p;
TextField tf1;
GridLayout gl;
Calculator()
{
f=new Frame("Calculator");
p=new Panel();
b1=new JButton("0");
b1.addActionListener(this);
b2=new JButton("1");
b2.addActionListener(this);
b3=new JButton("2");
b3.addActionListener(this);
b4=new JButton("3");
b4.addActionListener(this);
b5=new JButton("4");
b5.addActionListener(this);
b6=new JButton("5");
b6.addActionListener(this);
b7=new JButton("6");
b7.addActionListener(this);
b8=new JButton("7");
b8.addActionListener(this);
b9=new JButton("8");
b9.addActionListener(this);
b10=new JButton("9");
b10.addActionListener(this);
b11=new JButton("+");
b11.addActionListener(this);
b12=new JButton("-");
b12.addActionListener(this);
b13=new JButton("x");
b13.addActionListener(this);
b14=new JButton("/");
b14.addActionListener(this);
b15=new JButton("=");
b15.addActionListener(this);
b16=new JButton("A/C");
b16.addActionListener(this);
tf1=new TextField(20);
p.add(tf1);
tf1.setBackground(Color.yellow);
gl=new GridLayout(4,4,10,20);
p.setLayout(gl);
p.add(b1);p.add(b2);p.add(b3);p.add(b4);p.add(b5);p.add(b6);p.add(b7);p.add(b8);p.add(b9);p.add(b10);p.add(b11);p.add(b12);p.add(b13);p.add(b14);p.add(b15);p.add(b16);
f.add(p);
f.setSize(100,200);
f.setVisible(true);
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==b1)
{
s3=tf1.getText();
s4="0";
s5=s3+s4;
tf1.setText(s5);
}
if(e.getSource()==b2)
{
s3=tf1.getText();
s4="1";
s5=s3+s4;
tf1.setText(s5);
}
if(e.getSource()==b3)
{
s3=tf1.getText();
s4="2";
s5=s3+s4;
tf1.setText(s5);
}
if(e.getSource()==b4)
{
s3=tf1.getText();
s4="3";
s5=s3+s4;
tf1.setText(s5);
}
if(e.getSource()==b5)
{
s3=tf1.getText();
s4="4";
s5=s3+s4;
tf1.setText(s5);
}
if(e.getSource()==b6)
{
s3=tf1.getText();
s4="5";
s5=s3+s4;
tf1.setText(s5);
}
if(e.getSource()==b7)
{
s3=tf1.getText();
s4="6";
s5=s3+s4;
tf1.setText(s5);
}
if(e.getSource()==b8)
{
s3=tf1.getText();
s4="7";
s5=s3+s4;
tf1.setText(s5);
}
if(e.getSource()==b9)
{
s3=tf1.getText();
s4="8";
s5=s3+s4;
tf1.setText(s5);
}
if(e.getSource()==b10)
{
s3=tf1.getText();
s4="9";
s5=s3+s4;
tf1.setText(s5);
}
if(e.getSource()==b11)
{
s1=tf1.getText();
tf1.setText("");
c=1;
}
if(e.getSource()==b12)
{
s1=tf1.getText();
tf1.setText("");
c=2;
}
if(e.getSource()==b13)
{
s1=tf1.getText();
tf1.setText("");
c=3;
}
if(e.getSource()==b14)
{
s1=tf1.getText();
tf1.setText("");
c=4;
}
if(e.getSource()==b15)
{
s2=tf1.getText();
if(c==1)
{
n=Integer.parseInt(s1)+Integer.parseInt(s2);
tf1.setText(String.valueOf(n));
}
else
if(c==2)
{
n=Integer.parseInt(s1)-Integer.parseInt(s2);
tf1.setText(String.valueOf(n));
}
else
if(c==3)
{
n=Integer.parseInt(s1)*Integer.parseInt(s2);
tf1.setText(String.valueOf(n));
}
else
if(c==4)
{
n=Integer.parseInt(s1)/Integer.parseInt(s2);
tf1.setText(String.valueOf(n));
}
}
if(e.getSource()==b16)
{
tf1.setText("");
}
}
public static void main(String args[])
{
Calculator c=new Calculator();
}
}
Semoga Bisa Membantu

Bahasa Basisdata untuk besok ujian ku

Diposting oleh Unknown di 06.21 0 komentar
 Basis Data

1.SELECT NAMA, GAJI FROM DOKTER
2.SELECT * FROM DOKTER WHERE NAMA = 'EMA UTAMI'
3.SELECT KD_DOKTER, ALAMAT FROM DOKTER WHERE NAMA ='EMI SUSANTI'
4.SELECT KD_DOKTER AS "KODE DOKTER", NAMA AS "NAMA DOKTER", ALAMAT [ALAMAT DOKTER] FROM DOKTER
5.SELECT DISTINCT Kd_dokter FROM jadwal_dokter
6.SELECT TOP 3 * FROM dokter
7.SELECT * FROM dokter ORDER BY NAMA ASC
8.SELECT * FROM dokter ORDER BY nama DESC
9.SELECT * FROM PASIEN WHERE PERIKSA BETWEEN 2 AND 4 ORDER BY PERIKSA
10.SELECT * FROM PASIEN WHERE NAMA LIKE 'R%'
11.SELECT * FROM PENYAKIT WHERE PENYAKIT LIKE '%N'
12.SELECT * FROM OBAT WHERE OBAT LIKE '%CTM%'
13.SELECT * FROM DOKTER WHERE NAMA LIKE '_U%'
14.SELECT * FROM dokter WHERE ALAMAT LIKE '%YOGYAKARTA%' OR ALAMAT LIKE '%BANDUNG%'
15.SELECT * FROM PASIEN WHERE NAMA LIKE 'R%' AND NAMA LIKE '%A'
16.SELECT * FROM PASIEN WHERE NAMA LIKE 'R%' OR NAMA LIKE '%A'
17.SELECT * FROM PASIEN WHERE ALAMAT LIKE '[JY]OG[JY]A%'
18.SELECT GETDATE()
19.SELECT UPPER(NAMA) FROM DOKTER
20.SELECT LOWER(NAMA) FROM DOKTER
21.SELECT COUNT(KD_DOKTER) FROM DOKTER
22.SELECT SUM(PERIKSA) [JUMLAH] FROM PASIEN
23.SELECT AVG (PERIKSA) [RATA RATA] FROM PASIEN
24.SELECT COUNT(*), ALAMAT FROM DOKTER GROUP BY ALAMAT
25 SELECT LEFT(NAMA,2) FROM DOKTER
26.SELECT RIGHT(NAMA,1) FROM DOKTER
27.SELECT PENYAKIT, LEN(PENYAKIT) [PANJANG KARAKTER] FROM PENYAKIT
28.SELECT KD_OBAT, OBAT, KD_OBAT + OBAT [GABUNGAN] FROM OBAT
29.SELECT LEFT(NAMA,5) [NAMA PANGGILAN] FROM DOKTER
30.SELECT MIN(periksa) [MINIMAL] FROM pasien
31.SELECT MAX(periksa) [MAXIMAL] FROM pasien
32.SELECT DATEPART(yyyy,GETDATE()) [Tahun Sekarang]
33.SELECT DATENAME(MM, GETDATE()) [BULAN SEKARANG]
34.SELECT DATEPART(DD, GETDATE()) [TANGGAL SEKARANG]
35.SELECT DATEPART(HH, GETDATE()) [JAM SEKARANG DI KOMPUTER SAYA]
36.SELECT DATEPART(MI, GETDATE()) [MENIT SEKARANG DI KOMPUTER SEKARANG]
37.SELECT DATEPART(SS, GETDATE()) [DETIK SEKARANG DI KOMPUTER SEKARANG]
38.SELECT NAMA,SUBSTRING(NAMA,3,1) [HURUF KE 3] FROM pasien
39.SELECT TANGGAL_LAHIR, DATEDIFF(DD,TANGGAL_LAHIR,GETDATE()) [USIA]FROM PASIEN
40.select a.kd_dokter, b.nama, a.hari from jadwal_dokter a join dokter b on a.kd_dokter=b.kd_dokter
41.select a.nama, b.shift from dokter a inner join jadwal_dokter b on a.kd_dokter=b.kd_dokter where b.shift='pagi'
42.select a.nama, a.gender, b.hari from dokter a inner join jadwal_dokter b on a.kd_dokter=b.kd_dokter where a.gender='L' and b.hari='senin'
43.select a.kd_penyakit, b.penyakit from resep a join penyakit b on a.kd_penyakit=b.kd_penyakit
44.select distinct a.kd_pasien, b.nama from resep a join pasien b on a.kd_pasien=b.kd_Pasien
45.select a.kd_obat, b.obat from resep a join obat b on a.kd_obat=b.kd_obat
46.select * from obat where kd_obat not in (select kd_obat from resep)
 

FAFA ALMIGHTY [I'm Shawol, Exotic, Blac Jack, VIP ] Template by Ipietoon Blogger Template | Gift Idea