Wednesday, July 15, 2009

In this article, I will write about Simple Shoutbox Application with JQuery. With Ajax (Asynchronous JavaScript and XML) , we can send a form submission and get response back without refreshing current page. jQuery is a fast and concise JavaScript Library that simplifies HTML document traversing, event handling, animating, and Ajax interactions for rapid web development.

Javascript Code :

 $(function() {
$(".submit").click(function() {
var name = $("#name").val();
var comment = $("#comment").val();
var dataString = 'name='+ name + '&comment=' + comment;

if(name=='' || comment=='')
{
 alert('Please Give Valide Details');
} else {
 $("#flash").show();
 $("#flash").fadeIn(400).html('<img src="img/ajax-loader.gif" align="absmiddle"> <span class="loading">Loading Comment...</span>');
 $.ajax({
   type: "POST",
   url: "ajaxshoutbox.jsp",
   data: dataString,
   cache: false,
   success: function(html){
   $("ol#update").append(html);
   $("ol#update li:last").fadeIn("slow");
   $("#name").val('');
   $("#comment").val(''); 
   $("#name").focus();
   $("#flash").hide();
   }
 });
 return false;
 }
});
});


Explanation :

$.ajax({}) is JQuery event to call ajax request, it’s has an object of key/value pairs , that are used to initialize and handle the request.
  1. type : The type of request to make ("POST" or "GET"), default is "GET"
  2. url: The url to request
  3. data: Data to be sent to the server
  4. chace : if set to false it will force the pages that you request to not be cached by the browser
  5. success : A function to be called if the request succeeds
Soutbox.jsp
<form action="#" method="post">
<label><input type="text" name="name" id="name"/>
<span class="titles">Name</span><span class="star">*</span>
</label><br />
<label>
 <textarea name="comment" id="comment"></textarea>
 <span class="titles">Comment</span>
</label><br />
<input type="submit" class="submit" value=" Submit Comment " />    </form>
ajaxshoutbox.jsp
><li class="box">
<span style="  font-weight:bold">Name :</span>
<span style="font-size:16px; color:#663399;"><%= request.getParameter("name") %></span> <br />
<span style="  font-weight:bold">Comment :</span> <%= request.getParameter("comment") %>
</li>

Download Sourcecode : http://simpleshoutboxajax.googlecode.com/files/SimpleShoutboxAjax-JQuery.zip

Simple Shoutbox Ajax with JQuery & JSP

Read More

Tuesday, June 23, 2009

In my previous project, I will be required to call Stored Procedure in SQL Server with Spring & Hibernate. Using HibernateTemplate class extends from HibernateDaoSupport, you can call the stored procedure in SQL Server.

The Stored Procedure:
USE [sample];
GO
SET ANSI_NULLS ON;
GO
SET QUOTED_IDENTIFIER ON;
GO
ALTER PROCEDURE [SP_Sample]
(@Param1 nvarchar(50), @Param2 nvarchar(50))
AS
declare @Concatenation nvarchar(150)

set @Concatenation = @Param1 + ' and ' + @Param2

select @Param1,@Param2,@Concatenation
GO
SampleDao Source:
public class SampleDao extends HibernateDaoSupport {

@SuppressWarnings("unchecked")
public String callSP(String param1, String Param2) {
  // create session from active session
Session ses = getSession(true);

// create query for call the stored procedure
SQLQuery q = ses.createSQLQuery("exec SP_Sample :param1, :param2");
q.setString("param1", param1);
q.setString("param2", param2);
  
  //execute stored procedure and get list result
List l = q.list();
StringBuilder result = new StringBuilder();

if (l.size()>0){    
 for(Iterator it=l.iterator();it.hasNext();){
  Object[] row = (Object[]) it.next();
  result.append("Param 1 : " + row[0] + ", Param 2 : " + row[1] + ", Concatenation : " + row[2]);
 }
}

return result.toString();
}

Accessing SQL Server Stored Procedure With Hibernate

Read More

Tuesday, November 4, 2008

waktu makan di warteg deket kantor, yang notabennya tempat makan karyawan-karyawan deket kantorku. gak sengaja ngeliat keluar ada orang yang nanya ke pengemis sembari bawa duit 50 ribuan. Secara gak sengaja letak pengemis dan orang yang mau nukarin uang tadi pas di belakangku. nah iniliah transaksi kedua orang tu


ternyata, pengemis jakarta penghasilannya juga lumayan ya...

Bisa tuker uang 50 ribuan euy ke pengemis...

Read More

Tuesday, August 26, 2008

Pendahuluan:
Komponen Digester merupakan komponen yang di keluarkan oleh Apache Commons yang digunakan untuk memproses/parsing file XML. Disamping itu fungsinya digunakan untuk mapping XML menjadi object pada java.

Komponen Pendukung:
  1. BeanUtils component
  2. Collections component
  3. Logging component
  4. Digester component
Contoh Penggunaan:
Skenario : Anda akan menampilkan data siswa yang menghadiri beberapa kursus pada balai kursus. Dimana data-data tersebut berasal dari file XML, dan informasi detil dari masing-masing siswa akan di simpan pada instance dari class student yang telah Anda buat. Setelah itu akan di tampilkan dan di jadikan satu ke dalam class java.util.Vector untuk proses selanjutnya.

Class yang digunakan:
student.java : merupakan class yang berisi setter dan getter untuk properti siswa.
DigestStudents.java : merupakan class untuk memproses data siswa yang tersimpan pada file XML kemudian memprosesnya menjadi Vector
students.xml : berisi data-data siswa

Download Project File:
http://digesterxmlparser.googlecode.com/files/XML2Object.zip

Hasil:
Students Vector [Name=Yogi Course=JSP, Name=Eka Course=EJB]

XML Parser dengan Digester

Read More