PROCEDURE

SAMSUNG PC@SAMSUNG c:\xampp
# mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 25
Server version: 5.5.27 MySQL Community Server (GPL)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create procedure nambah (xNBM  varchar(5),xnama_guru varchar(50),xalamat varchar(50),xjenis_kelamin varchar(15),xagama varchar(10),xno_hp varchar(15)) insert into guru values (xNBM,xnama_guru,xalamat,xjenis_kelamin,xagama,xno_hp);
Query OK, 0 rows affected (0.03 sec)

mysql> create procedure hapus_guru(xNBM  varchar(5),xnama_guru varchar(50),xalamat varchar(50),xjenis_kelamin varchar(15),xagama varchar(10),xno_hp varchar(15)) delete from guru where kondisi;
Query OK, 0 rows affected (0.01 sec)

create procedure ubah_guru (xNBM  varchar(5),xnama_guru varchar(50),xalamat varchar(50),xjenis_kelamin varchar(15),xagama varchar(10),xno_hp varchar(15)) xupdate guru set NBM=u_id_NBM,nama_guru=u_nmgr,alamat=u_almt,jenis_kelamin=u_jekel,agama=u_agama,xno_hp=u_nhp);
Query OK, 0 rows affected (0.01 sec)


mysql> create procedure nambah_kehadiran (xnis varchar(8),xnama_siswa varchar(50),xjenis_kelamin varchar(15),xkelas varchar(15),xketerangan varchar(15),xNBM varchar(15),xnama_guru varchar(50),xmapel varchar(25),xsemester varchar(15)) insert into kehadiran values (xnis,xnama_siswa,xjenis_kelamin,xkel
as,xketerangan,xNBM,xnama_guru,xmapel,xsemester);
Query OK, 0 rows affected (0.00 sec)

mysql> create procedure hapus_kehadiran (xnis varchar(8),xnama_siswa varchar(50),xjenis_kelamin varchar(15),xkelas varchar(15),xketerangan varchar(15),xNBM varchar(15),xnama_guru varchar(50),xmapel varchar(25),xsemester varchar(15)) delete from kehadiran where kondisi;
Query OK, 0 rows affected (0.00 sec)

create procedure ubah_kehadiran (xnis varchar(8),xnama_siswa varchar(50),xjenis_kelamin varchar(15),xkelas varchar(15),xketerangan varchar(15),xNBM varchar(15),xnama_guru varchar(50),xmapel varchar(25),xsemester varchar(15)) xupdate kehadiran set nis=u_nis,nama_siswa=u_nm_siswa,jenis_kelamin=u_jekel,keterangan=u_ket,NBM=u_NBM,nama_guru=nmgr,mapel=u_mpl,semester=u_smstr);
Query OK, 0 rows affected (0.01 sec)


mysql> create procedure nambah_mapel(xid_mapel varchar(10),xmapel varchar(25),xNBM varchar(15),xnama_guru varchar(50))insert into mapel values (xid_mapel,xmapel,xNBM,xnama_guru);
Query OK, 0 rows affected (0.01 sec)

mysql> create procedure hapus_mapel(xid_mapel varchar(10),xmapel varchar(25),xNBM varchar(15),xnama_guru varchar(50))delete from mapel where kondisi;
Query OK, 0 rows affected (0.00 sec)

create procedure ubah_mapel (xid_mapel varchar(10),xmapel varchar(25),xNBM varchar(15),xnama_guru varchar(50)) xupdate mapel set id_mapel=u_id_mpl,mapel=u_mpl,NBM=u_NBM,nama_guru=u_nmgr);
Query OK, 0 rows affected (0.01 sec)


mysql> create procedure nambah_semester(xid_semester varchar(10),xsemester varchar(10),xtahun_semester varchar(10))insert into semester values (xid_semester,xsemester,xtahun_semester);
Query OK, 0 rows affected (0.00 sec)

mysql> create procedure hapus_semester(xid_semester varchar(10),xsemester varchar(10),xtahun_semester varchar(10))delete from semester where kondisi;
Query OK, 0 rows affected (0.00 sec)

create procedure ubah_semester(xid_semester varchar(10),xsemester varchar(10),xtahun_semester varchar(10)) xupdate semester set id_semester=u_id_smstr,semester=u_smstr,tahun_semester=u_thn_semester);
Query OK, 0 rows affected (0.03 sec)


mysql> create procedure nambah_siswa(xnis varchar(8),xnama varchar(50),xalamat varchar(50),xjenis_kelamin varchar(15),xagama varchar(10),xno_hp varchar(15)) insert into siswa values(xnis,xnama,xalamat,xjenis_kelamin,xagama,xno_hp);
Query OK, 0 rows affected (0.00 sec)

mysql> create procedure hapus_siswa(xnis varchar(8),xnama varchar(50),xalamat varchar(50),xjenis_kelamin varchar(15),xagama varchar(10),xno_hp varchar(15)) delete from siswa where kondisi;
Query OK, 0 rows affected (0.00 sec)

create procedure ubah_siswa(xnis varchar(8),xnama varchar(50),xalamat varchar(50),xjenis_kelamin varchar(15),xagama varchar(10),xno_hp varchar(15))  xupdate siswa set nis=u_nis,nama=u_nama,alamat=u_alamat,jenis_kelamin=u_jekel,agama=u_agama,no_hp=u_hp);
Query OK, 0 rows affected (0.01 sec)


mysql> create procedure nambah_user(xid varchar(4),xusername varchar(20),xfullname varchar(30),xpassword varchar(35),xemail varchar(50),xmember_data varchar(11),xlastup varchar(11),xstatus varchar(11),xlevel varchar(20)) insert into user values (xid,xusername,xfullname,xpassword,xemail,xmember_data,
xstatus,xlevel);
Query OK, 0 rows affected (0.00 sec)

mysql> create procedure hapus_user(xid varchar(4),xusername varchar(20),xfullname varchar(30),xpassword varchar(35),xemail varchar(50),xmember_data varchar(11),xlastup varchar(11),xstatus varchar(11),xlevel varchar(20)) delete from user where kondisi;
Query OK, 0 rows affected (0.00 sec)

create procedure ubah_user (xid varchar(4),xusername varchar(20),xfullname varchar(30),xpassword varchar(35),xemail varchar(50),xmember_data varchar(11),xlastup varchar(11),xstatus varchar(11),xlevel varchar(20))  xupdate user set id=u_id,username=u_usernme,fullname=u_fullnme,password=u_pass,email=u_mail,member_data=u_memberdata,lastup=u_lastup,status=u_stts,level=u_lvl);
Query OK, 0 rows affected (0.02 sec)


mysql> create procedure nambah_kelas(xkelas varchar(8),xjurusan varchar(25),xjumlah_siswa varchar(3),xwali_kelas varchar(50)) insert into kelas values (xkelas,xjurusan,xjumlah_siswa,xwali_kelas);
Query OK, 0 rows affected (0.00 sec)

mysql> create procedure hapus_kelas(xkelas varchar(8),xjurusan varchar(25),xjumlah_siswa varchar(3),xwali_kelas varchar(50)) delete from kelas where kondisi;
Query OK, 0 rows affected (0.00 sec)

create procedure ubah_kelas(xkelas varchar(8),xjurusan varchar(25),xjumlah_siswa varchar(3),xwali_kelas varchar(50)) update kelas set kelas=u_kls,jurusan=u_jrusan,jumlah_siswa=u_jml_siswa,wali_kelas=u_walikelas);
Query OK, 0 rows affected (0.00 sec)