Photo Albums

Books

March 24, 2005

How to Use DB2 Store Prosedure in Java

In Indonesian :

yang jelas pertama" kalian bikin dulu store prosedurnya di db2.. caranya gampang soalnya udah ada wizardnya. habis bikin di ibm kemudian pengen di pakai di aplikasi java nih. gini caranya, lebih cepet kalau di kasih contoh aja ya :

/* heheh.. nama prosedurnya DB2ADMIN.PROCEDURE1

store prosedurnya isinya select semua isi dari tabel buku

CallableStatement adalah perintah yang digunakan untuk memanggil Store Prosedur*/

import java.sql.*;
import javax.sql.*;

public class TesProsedur {

public static void main( String[] args ) throws SQLException,ClassNotFoundException
{

   String url = "jdbc:db2:Project";
   String myLogin = "db2admin";
   String myPassword = "db2admin";
   Connection con;
          String strResult="";
         
         Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
  con = DriverManager.getConnection(url, myLogin, myPassword);
  { 
   CallableStatement cls = con.prepareCall( "{ ? = call DB2ADMIN.PROCEDURE1}" );
   cls.registerOutParameter(1, Types.VARCHAR);
   
   cls.execute();
   ResultSet rs = cls.executeQuery();
   while(rs.next())
   {
    strResult += rs.getString(1);
    strResult += " ";
    strResult += rs.getString(2);
    strResult += " ";
         strResult += rs.getString(3);
    strResult += " ";
    strResult += rs.getInt(4);
    strResult += " ";
    strResult += "\n";

   }
   
                                 
   System.out.println(strResult);
   cls.close();
  }
  con.close();
 
   
 
}
}

Recent Comments

March 2008

Sun Mon Tue Wed Thu Fri Sat
            1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31          
Powered by Friendster Blogs
Member since 03/2005