Feby Fadillah

Haii haii ..

Seminggu rasanya cepet banget berlalu ya ..

kayak baru kemarin nge-blog ,, sekarang udah mulai ngeblog lagi ..

Ok , untuk minggu ini saya akan membahas tentang CRUD pada 'CIMANDE 2 DAO SERVICE'..

Cimande 2 ??? Apa bedanya dengan cimande 1 ???

Baik ,, kita akan bahas disini ..

Perbedaan mereka adalah :

• Dari segi konfigurasi database,, pada cimande 1 dilakukan pada 3 file yaitu : cimande.properties , hibernate.cfg.xml ,dan db.properties... sedangkan pada cimande 2 hanya dilakukan pada 2 file saja , yaitu : cimande.properties dan db.properties.
• Dari segi mapping class,, cimande 1 melakukan mapping pada 2 class yaitu : hibernate.cfg.xml dan applicationContext-hibernate.xml..... sedangkan pada cimande 2 hanya di lakukan pada file hibernate.cfg.xml saja.
• Kalau di cimande 2, memakai file ClassService dan ClassServiceImplement

Ok, sekarang ayo kita mulai buat CRUD-nya ..

Tapi, CRUD itu singkatan dari Create, Read, Update and Delete.. dimana ,,

Tapi , saat ini saya mau bahas yang create dulu yah ...

OK , pertama-tama buat entity dulu. Untuk entity, syntax tidak berbeda dengan cimande 1 ..

Identitas Sekolah.java

import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.Inheritance; import javax.persistence.InheritanceType; import javax.persistence.Table; import org.blueoxygen.cimande.commons.DefaultPersistence; @Entity @Table(name = "app_identitasSekolah") @Inheritance(strategy = InheritanceType.SINGLE_TABLE) public class IdentitasSekolah extends DefaultPersistence { private String nama_sekolah; private String alamat; private String nama_kepala_sekolah; private String ketua_panitia_psb; private String telepon; private String fax; @Column public String getNama_sekolah() { return nama_sekolah; } public void setNama_sekolah(String namaSekolah) { nama_sekolah = namaSekolah; } @Column public String getAlamat() { return alamat; } public void setAlamat(String alamat) { this.alamat = alamat; } @Column public String getNama_kepala_sekolah() { return nama_kepala_sekolah; } public void setNama_kepala_sekolah(String namaKepalaSekolah) { nama_kepala_sekolah = namaKepalaSekolah; } @Column public String getKetua_panitia_psb() { return ketua_panitia_psb; } public void setKetua_panitia_psb(String ketuaPanitiaPsb) { ketua_panitia_psb = ketuaPanitiaPsb; } @Column public String getTelepon() { return telepon; } public void setTelepon(String telepon) { this.telepon = telepon; } @Column public String getFax() { return fax; } public void setFax(String fax) { this.fax = fax; } }

Kemudian buat class Service dan ServiceImplement..

IdentitasSekolahService.java

import java.util.List; import org.blueoxygen.psbOnline.entity.IdentitasSekolah; public interface IdentitasSekolahService { void save(IdentitasSekolah identitas) ; void delete(IdentitasSekolah identitas); IdentitasSekolah getidentitasById(String id); List<IdentitasSekolah> getAllidentitsas(); List<IdentitasSekolah> findidentitass(String nama_sekolah, String alamat, String nama_kepala_sekolah, String ketua_panitia_psb, String telepon, String fax, String orderby, int maxResults, int firstResult); List<IdentitasSekolah> findidentitassByField(String field, String value); int getRowCountByCriteria(String nama_sekolah, String alamat, String nama_kepala_sekolah, String ketua_panitia_psb, String telepon, String fax); }

IdentitasSekolahServiceImpl.java

import java.util.List; import org.blueoxygen.cimande.persistence.hibernate.dao.HibernatePersistenceDaoManager; import org.blueoxygen.psbOnline.entity.IdentitasSekolah; import org.hibernate.Criteria; import org.hibernate.criterion.MatchMode; import org.hibernate.criterion.Projections; import org.hibernate.criterion.Restrictions; import org.springframework.stereotype.Repository; import org.springframework.transaction.annotation.Transactional; @Repository @Transactional public class IdentitasSekolahServiceImpl extends HibernatePersistenceDaoManager<IdentitasSekolah> implements IdentitasSekolahService { @Transactional public void delete(IdentitasSekolah identitas) { // TODO Auto-generated method stub if (identitas != null && identitas.getId() != null) { identitas= getById(IdentitasSekolah.class, identitas.getId()); remove(identitas); } } @SuppressWarnings("unchecked") @Transactional public List<IdentitasSekolah> findidentitass(String namaSekolah, String alamat, String namaKepalaSekolah, String ketuaPanitiaPsb, String telepon, String fax, String orderby, int maxResults, int firstResult) { Criteria criteria = sessionFactory.getCurrentSession().createCriteria( IdentitasSekolah.class); criteria.add(Restrictions.like("nama_sekolah", namaSekolah+ "", MatchMode.ANYWHERE)); criteria.add(Restrictions.like("nama_kepala_sekolah", namaKepalaSekolah+ "", MatchMode.ANYWHERE)); criteria.setMaxResults(maxResults); criteria.setFirstResult(firstResult); return criteria.list(); } @SuppressWarnings("unchecked") @Transactional public List<IdentitasSekolah> findidentitassByField(String field, String value) { // TODO Auto-generated method stub Criteria criteria = sessionFactory.getCurrentSession().createCriteria( IdentitasSekolah.class); criteria.add(Restrictions.like(field, value)); return criteria.list(); } @Transactional public List<IdentitasSekolah> getAllidentitsas() { // TODO Auto-generated method stub return findAll(IdentitasSekolah.class); } @Transactional public int getRowCountByCriteria(String namaSekolah, String alamat, String namaKepalaSekolah, String ketuaPanitiaPsb, String telepon, String fax) { // TODO Auto-generated method stub Criteria criteria = sessionFactory.getCurrentSession().createCriteria( IdentitasSekolah.class); criteria.add(Restrictions.like("nama_sekolah", namaSekolah+ "", MatchMode.ANYWHERE)); criteria.add(Restrictions.like("nama_kepala_sekolah", namaKepalaSekolah+ "", MatchMode.ANYWHERE)); criteria.setProjection(Projections.rowCount()); return (Integer) criteria.uniqueResult(); } @Transactional public void save(IdentitasSekolah identitas) { if (identitas != null) { if (identitas.getId() == null || "".equalsIgnoreCase(identitas.getId())) { identitas.getLogInformation().setCreateBy( getCurrentUser().getId()); identitas.getLogInformation().setLastUpdateBy( getCurrentUser().getId()); identitas.getLogInformation().setCreateDate(getCurretTime()); identitas.getLogInformation().setLastUpdateDate(getCurretTime()); identitas.getLogInformation().setActiveFlag(1); persist(identitas); } else { identitas.getLogInformation().setLastUpdateBy( getCurrentUser().getId()); identitas.getLogInformation().setLastUpdateDate(getCurretTime()); merge(identitas); } } // TODO Auto-generated method stub } @Transactional public IdentitasSekolah getidentitasById(String id) { // TODO Auto-generated method stub return getById(IdentitasSekolah.class, id); } }

pada saat create,, akan menjalankan method save() pada class IdentitasSekolahService.java

Kemudian buat class action. Untuk Create , class action-nya adalah Form.java dan Save.java

FormIdentitasSekolah.java

import org.blueoxygen.cimande.commons.CimandeAction; import org.blueoxygen.psbOnline.IdentitasSekolah.service.IdentitasSekolahService; import org.blueoxygen.psbOnline.entity.IdentitasSekolah; import org.springframework.beans.factory.annotation.Autowired; public class FormIdentitasSekolah extends CimandeAction { public IdentitasSekolah identitas = new IdentitasSekolah(); private String id; private String nama_sekolah; private String alamat; private String nama_kepala_sekolah; private String ketua_panitia_psb; private String telepon; private String fax; protected @Autowired IdentitasSekolahService service; public String execute() { return SUCCESS; } public IdentitasSekolah getIdentitas() { return identitas; } public void setIdentitas(IdentitasSekolah identitas) { this.identitas = identitas; } public String getId() { return id; } public void setId(String id) { this.id = id; } public String getNama_sekolah() { return nama_sekolah; } public void setNama_sekolah(String namaSekolah) { nama_sekolah = namaSekolah; } public String getAlamat() { return alamat; } public void setAlamat(String alamat) { this.alamat = alamat; } public String getNama_kepala_sekolah() { return nama_kepala_sekolah; } public void setNama_kepala_sekolah(String namaKepalaSekolah) { nama_kepala_sekolah = namaKepalaSekolah; } public String getKetua_panitia_psb() { return ketua_panitia_psb; } public void setKetua_panitia_psb(String ketuaPanitiaPsb) { ketua_panitia_psb = ketuaPanitiaPsb; } public String getTelepon() { return telepon; } public void setTelepon(String telepon) { this.telepon = telepon; } public String getFax() { return fax; } public void setFax(String fax) { this.fax = fax; } public IdentitasSekolahService getService() { return service; } public void setService(IdentitasSekolahService service) { this.service = service; } }

SaveIdentitasSekolah.java

import org.blueoxygen.psbOnline.entity.IdentitasSekolah; import com.opensymphony.xwork2.validator.annotations.RequiredStringValidator; import com.opensymphony.xwork2.validator.annotations.Validation; import com.opensymphony.xwork2.validator.annotations.Validations; @Validation public class SaveIdentitasSekolah extends FormIdentitasSekolah{ private int maxPage, currPage, nextPage, prevPage = 0, page = 0; private int maxRowPerPage = 5; private String orderBy = "nama_sekolah"; private int resultRows; private IdentitasSekolah identitas = new IdentitasSekolah(); @Validations(requiredStrings = { @RequiredStringValidator(fieldName = "nama_sekolah", message = "Nama tidak boleh kosong") }) public String execute() { identitas.setId(null); identitas.setAlamat(getAlamat()); identitas.setFax(getFax()); identitas.setKetua_panitia_psb(getKetua_panitia_psb()); identitas.setNama_kepala_sekolah(getNama_kepala_sekolah()); identitas.setNama_sekolah(getNama_sekolah()); identitas.setTelepon(getTelepon()); service.save(getIdentitas()); return SUCCESS; } public int getMaxPage() { return maxPage; } public void setMaxPage(int maxPage) { this.maxPage = maxPage; } public int getCurrPage() { return currPage; } public void setCurrPage(int currPage) { this.currPage = currPage; } public int getNextPage() { return nextPage; } public void setNextPage(int nextPage) { this.nextPage = nextPage; } public int getPrevPage() { return prevPage; } public void setPrevPage(int prevPage) { this.prevPage = prevPage; } public int getPage() { return page; } public void setPage(int page) { this.page = page; } public int getMaxRowPerPage() { return maxRowPerPage; } public void setMaxRowPerPage(int maxRowPerPage) { this.maxRowPerPage = maxRowPerPage; } public String getOrderBy() { return orderBy; } public void setOrderBy(String orderBy) { this.orderBy = orderBy; } public int getResultRows() { return resultRows; } public void setResultRows(int resultRows) { this.resultRows = resultRows; } public IdentitasSekolah getIdentitas() { return identitas; } public void setIdentitas(IdentitasSekolah identitas) { this.identitas = identitas; } }

Kemudian, buat viewernya..

FormIdentitasSekolah.vm

SaveIdentitasSekolah.vm

<link rel="stylesheet" type="text/css" href="file:///C|/Documents and Settings/style.css" /> <link rel="stylesheet" type="text/css" href="file:///C|/Documents and Settings/jscript/src/css/jscal2.css" /> <link rel="stylesheet" type="text/css" href="file:///C|/Documents and Settings/jscript/src/css/border-radius.css" /> <link rel="stylesheet" type="text/css" href="file:///C|/Documents and Settings/jscript/src/css/gold/gold.css" /> <script type="text/javascript" src="file:///C|/Documents and Settings/jscript/src/js/jscal2.js"></script> <script type="text/javascript" src="file:///C|/Documents and Settings/jscript/src/js/lang/en.js"></script> <script type="text/javascript" src="#surl("value=/jscript/ext/adapter/jquery/jquery.js")"></script> <script src="file:///C|/Documents and Settings/jscript/js/jquery-latest.js"></script> <script type="text/javascript" src="file:///C|/Documents and Settings/jscript/js/jquery.validate.js"></script> <style type="text/css"> * { font-family: Verdana; font-size: 96%; } label { width: 10em; float: left; } label.error { float: none; color: red; padding-left: .5em; vertical-align: top; } p { clear: both; } .submit { margin-left: 12em; } em { font-weight: bold; padding-right: 1em; vertical-align: top; } .style1 { font-family: Verdana, Arial, Helvetica, sans-serif; font-weight: bold; } .style6 {color: #006B9F} .style22 { font-weight: bold; color: #006B9F; font-size: 18px; font-family: Verdana; } .style23 { font-family: Arial; font-weight: bold; font-size: 12px; } .style25 {color: #FF0000} .style26 {font-family: Arial} .style27 {color: #006B9F; font-family: Arial; } </style> <script> $(document).ready(function(){ $("#commentForm").validate(); }); </script> <script></script> <form id="commentForm" name="form1" method="post" action="file:///C|/Documents and Settings/axioo/Desktop/save.action"> <table bgcolor="#d0dcff" border="0" cellpadding="3" cellspacing="1" width="62%" align="center"> <tr bgcolor="#d0dcff"> <td height="3"></td> </tr> <tr bgcolor="#d0dcff"> <td bgcolor="#d0dcff"><table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0" bordercolor="#0000FF" bgcolor="#d0dcff"> <tr> <td width="114" rowspan="2" class="style1"><div align="center"><img src="../../images/psbOnlineImages/identitas.png" width="95" height="51" /></div></td> <td width="629" height="28" class="style22 style26">Identitas Sekolah </td> </tr> <tr> <td><span class="style23">Menu ini di gunakan untuk memasukkan data identitas sekolah </span></td> </tr> </table> <div align="center" class="style1"></div></td> </tr> <tr bgcolor="#ffffff"> <td height="3"></td> </tr> <tr bgcolor="#FFFFFF"> <td><table bgcolor="#d0dcff" height="100%" width="100%"> <tr> <td colspan="3" bordercolor="#999999" bgcolor="#FFFFFF"><div align="center" class="style26"><span class="style2 style25"><em><strong>Data telah tersimpan</strong></em></span></div></td> </tr> <tr> <td bordercolor="#999999" bgcolor="#FFFFFF"><span class="style2 style6 style26">Nama Sekolah *</span></td> <td width="27" bgcolor="#FFFFFF"><div align="center" class="style26">:</div></td> <td width="402" bordercolor="#999999" bgcolor="#FFFFFF"><span class="style27"> <label>$!nama_sekolah</label> </span></td> </tr> <tr> <td bordercolor="#999999" bgcolor="#FFFFFF"><span class="style2 style6 style26">Alamat*</span></td> <td bgcolor="#FFFFFF"><div align="center" class="style26">:</div></td> <td bordercolor="#999999" bgcolor="#FFFFFF"><span class="style27"> <label>$!alamat</label> </span></td> </tr> <tr> <td bordercolor="#999999" bgcolor="#FFFFFF"><span class="style2 style6 style26">Nama Kepala Sekolah*</span></td> <td bgcolor="#FFFFFF"><div align="center" class="style26">:</div></td> <td bordercolor="#999999" bgcolor="#FFFFFF"><span class="style27">$!nama_kepala_sekolah</span></td> </tr> <tr> <td bordercolor="#999999" bgcolor="#FFFFFF"><span class="style2 style6 style26">Ketua Panitia PSB*</span></td> <td bgcolor="#FFFFFF"><div align="center" class="style26">:</div></td> <td bordercolor="#999999" bgcolor="#FFFFFF"><span class="style27">$!ketua_panitia_psb</span></td> </tr> <tr> <td bordercolor="#999999" bgcolor="#FFFFFF"><span class="style2 style6 style26">Telepon*</span></td> <td bgcolor="#FFFFFF"><div align="center" class="style26">:</div></td> <td bordercolor="#999999" bgcolor="#FFFFFF"><span class="style27">$!telepon</span></td> </tr> <tr> <td bordercolor="#999999" bgcolor="#FFFFFF"><span class="style2 style6 style26">Fax*</span></td> <td bgcolor="#FFFFFF"><div align="center" class="style26">:</div></td> <td bordercolor="#999999" bgcolor="#FFFFFF"><span class="style27">$!fax</span></td> </tr> </table></td> </tr> <tr bgcolor="#ffffff"> <td height="3"></td> </tr> <input type="hidden" name="id2" value="$!id"/> <tr bgcolor="#d0dcff"> <td bgcolor="#d0dcff" align="center"><input name="button2" type="button" onclick="javascript:location.href='create'" value="OK" /> <input type="hidden" name="id" value="$!id"/> </td> </tr> </table> <p> <p></p> <p> <p></p> </form>

Kemudian buat file struts-nya

Struts-IdentitasSekolah.xml

<?xml version="1.0" encoding="iso-8859-1"?> <!DOCTYPE struts PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN" "http://struts.apache.org/dtds/struts-2.0.dtd"> <struts> <package name="identitasSekolah" extends="default" namespace="/module/identitasSekolah"> <action name="create" class="org.blueoxygen.psbOnline.IdentitasSekolah.actions.FormIdentitasSekolah"> <result name="success" type="velocity"> /psb/identitasSekolah/FormIdentitas </result> </action> <action name="save" class="org.blueoxygen.psbOnline.IdentitasSekolah.actions.SaveIdentitasSekolah"> <result name="success" type="velocity"> /psb/identitasSekolah/DetailSaveIdentitas </result> <result name="input" type="velocity"> /psb/identitasSekolah/FormIdentitas </result> </action> </package> </struts>

dan hasilnya

dan setelah di klik Save akan keluar detailnya

Yapzz ,, begitulah create ..

Untuk Read, Update dan Delete akan di bahas di part selanjutnya ..

Wait yah ..

Bye bye ..