How to make Cursor in SQL Server

Hello in this chapter I will explain about how to make cursor in stored procedure. Cursor is programming language used to access any existing row separately with other record.Cursor is very suitable to solve a difficult problem. In this article I will demonstrate how to make cursor.
1. Create database
create database dbDatabaseExample

2. Create table
create table tbStudent(
NRP varchar(100) primary key not null, Name varchar(100),Address varchar(100)
)

3. Fill data
insert into tbStudent values('0001','Hendry Apryanto','Griya Persada Street')
insert into tbStudent values('0002','Yohan Andreas','Babakan Jeruk Street')
insert into tbStudent values('0003','Tana El San','Semarang Indah Permai Street')
insert into tbStudent values('0004','Tommy Gunawan','Britania Street')

4. Create Procedure

CREATE PROCEDURE SP_SHOWSTUDENTCURSOR
AS 
BEGIN
 --CURSOR DECLARATION
 DECLARE StudentCSR CURSOR
 FOR SELECT * FROM tbStudent 

 --OPEN CURSOR
 OPEN StudentCSR

 --CURSOR VARIABEL
 Declare @NO varchar(100)
 Declare @Name varchar(100)
 Declare @Address varchar(100)
 
 FETCH NEXT FROM StudentCSR into @NO,@Name,@Address
 While @@FETCH_STATUS=0
 BEGIN
  PRINT '--------------------'
  PRINT 'NO      '+@NO
  PRINT 'NAME    '+@Name
  PRINT 'ADDRESS '+@Address
  PRINT '--------------------'
 FETCH NEXT FROM StudentCSR into @NO,@Name,@Address
 END

 --CLOSE CURSOR
 CLOSE StudentCSR

 --ALLOCATE CURSOR
 DEALLOCATE StudentCSR
END

Note:
Use 'exec [STOREDPROCEDURE_NAME](exec SO_SHOWSTUDENTCURSOR)' if you want to execute.
Result :


Okay that's is it and congratulation you have made Cursor in sql server. I hope this tutorial can help you.Thank you..Have a nice day all..^^

Read More......

Stored Procedure in SQL Server 2005

Okay in this chapter I will explain about store procedure in sql server. Please followng step at bellow:
1. Create database at sql server (In this case I will create dbDatabaseExample)
create database dbDatabaseExample

2. Create table at database (Table Name:tbSTudent)
create table tbStudent(
NO varchar(100) primary key not null, Name varchar(100)
)

3. Fill table data
insert into tbStudent values('0001','Hendry Apryanto')
insert into tbStudent values('0002','Yohan Andreas')
insert into tbStudent values('0003','Tana El San')

4. Create Stored Procedure
A. Stored Procedure without parameter
create procedure SP_SHOWSTUDENT
AS
BEGIN
SELECT * FROM tbStudent
END
Note:
To execute stored procedure use 'exec [STOREPROCEDURE_NAME](EXEC SP_SHOWSTUDENT)'

B. Stored Procedure with parameter
create procedure SP_SHOWSTUDENTPARAMETER
@VARCARI VARCHAR(100)
AS
BEGIN
SELECT * FROM tbStudent WHERE NO=@VARCARI
END
Note:
To execute stored procedure use 'exec [STOREPROCEDURE_NAME][PARAMETER_VALUE](EXEC SP_SHOWSTUDENT('0001'))'

Okay that's is it and congratulation you have make stored procedure in sql server. I hope this tutorial can help you..Thank you...^^GBU

Read More......

Data Type SQL Server

In this chapter I will show you data type in sql server.
1. Bit
->Integer with value 1 or 0.
2. Int
-> Integer value between -2^31(-2.147.483.648) until 2^31-1(+2.147.384.647).
3. Decimal or Numeric
-> value between -10^38-1 until 10^38-1.
4. Money
-> currency from -2^63( -922.377.203.685.477,5808) until 2^63-1(922.377.203.685.477,5807).

5. Float
-> -214.748,3648 until 1.79E+308.
6. Real
-> -3.40E+308 until 3.40E+38.
7. DateTime
-> 1 January 1973 until 31 December 9999.
8. SmallDateTime
-> 1 January 1900 until 6 Juny 2079, with precision until 1 minute.
9. Char
-> Number of permanent character with maximum size 8000.
10. Varchar
-> Number of variabel character with maximum size 8000.
11. Text
-> Number of variabel character with maximum size 2.147.483.647 .
12. NChar
-> Number of permanent character with maximum size 4000.
13. NVarchar
-> Number of variabel character with maximum size 4000.
14. NText
-> Number of variabel chaacter with maximum size 1.073.741.823 .
15. Binary
-> Number of permanent binary with maximum size 8000.
16. Varbinary
-> Number of variabel binary with maximum size 8000.
17. Image
-> Number of variabel character with maximum size 2.147.483.647.

Okay that's is it. I hope with some knowledge about data type in sql server I can help yout. Thank you for see this tutorial..^^

Read More......

Step by Step Learn Oracle Stored Procedure

Hello everyone, how about your day, in this chapter we will discuss about how to make stored procedure in oracle.First open your IDE for oracle in this case i will use PL/SQL and please following step at bellow:(Log in with system).
1. Create user :
Create user [USER_NAME] identified by [PASSWORD];
grant connect, resources to [USER_NAME] (give permission to access database).

Example:
Create user dbDataService identified by data12345;
grant connect, resource to dbDataService;

Note:
Press F8 to execute query
2. Log in with dbDataService (at this case)-> Create table.
Create table[TABLE_NAME]([PROPERTY_NAME][VARIABEL_TYPE])

Example:
Create table Student (NO varchar2(100) primary key not null, Name varchar2(100));

3. Fill data at Student table
Insert into Student values('1','Hendry');
Insert into Student values('2','Marco');

4. Open SQL WINDOW. After that please copy following code at bellow to make stored procedure.(at this case i will use curosr to read all row).
CREATE OR REPLACE PROCEDURE[STOREDPROCEDURE_NAME]
AS
BEGIN
END;

Example:
CREATE OR REPLACE PROCEDURE SP_SHOWSTUDENT
AS
CUROSR STUDENTCURSOR IS
SELECT NO,NAMA FROM STUDENT;
BEGIN
FOR D IN STUDENTCURSOR LOOP
DBMS_OUTPUT.PUT_LINE('NO'||D.NO);
DBMS_OUTPUT.PUT_LINE('NO'||D.NAMA);
END LOOP;
COMMIT;
END;

5.Execute stored procedure.
BEGIN
[STOREDPROCEDURE_NAME];
END;

Example:
BEGIN
SP_SHOWSTUDENT;
END;

Okay that's is it and finnaly congratulation you have made STORED PROCEDURE in oracle. Thank you for see this tutorial i hope this tutorial can help you..Have a nice day..^^

Read More......

User Interface at Flex Part 2

Okay I will continue the last article. In this article I will introduce :
1. CheckBox
Example:

 
     import mx.controls.Alert;
   private function clickHandler():void{ 
    if(data1.selected) { 
     Alert.show("Data 1 is clicked","Warning");
     data1.selected=false;
    }else if(data2.selected) { 
     Alert.show("Data 2 is clicked","Warning");
     data2.selected=false;
    }else if(data3.selected) { 
     Alert.show("Data 3 is clicked","Warning");
     data3.selected=false;
    }else if(data4.selected) { 
     Alert.show("Data 4 is clicked","Warning");
     data4.selected=false;
    }
   }
  ]]>
 
 
 
 
 

Result:


2. Radio Button
Example:

Result:

3.Label
Example

Result:

4.Button
Example:

Result:

Read More......

User Interface at Flex Part 1

In this chapter I will show you some example and how use component:
1. Alert
->This component use to display message at monitor.
Example:

 
     import mx.events.CloseEvent;
   import mx.controls.Alert;
   private function init():void{ 
    Alert.show("Simple Alert","Warning");
   }
   private function initUser(event:Event):void{ 
    Alert.show("Choose yes or no ?","Warning",3,this,clickHandler);
   }
   private function clickHandler(event:CloseEvent):void{ 
    if(event.detail==Alert.YES) { 
     Alert.show("User choose YES","Warning");
    }else{ 
     Alert.show("User choose NO","Warning");
    }
   }
  ]]>
 
 
 

Result:
User Interface User Alert Button:


User Interface Simple Alert Button:


2. ComboBox
Example of combo box:

   import mx.controls.Alert;
  import mx.events.MenuEvent;
  private function clickHandler():void { 
   Alert.show(_comboBox.selectedLabel.toString(),"Warning");
  }
 ]]>



 
  
   
   
   
  
 

Result:


3.List
->Display data list in one component.(In this application click at data do you want display a message alert).
Example:

 
     import mx.controls.Alert;
   private function clickHandler() :void{ 
    Alert.show(_list.selectedItem.toString(),"Warning");
   }
  ]]>
 
 
 
  
   Data 1
   Data 2
   Data 3
   Data 4
  
 

Result:


4. Tab Bar
Example:

Result:


Source Code:
Visual Component.rar

That's is it and for another component I will publish at next article. Thank you for see this tutorial I hope this tutorial can help you...Have a nice day all...^^

Read More......

How to make Chat in Flex

In this chapter we will make simple chat in flex.Flex have 2 component. First is Producer, Producer have a utility to send a message to every client. Second is Consumer, consumer have function to accept every message when sent by producer. At bellow is a sample chat with flex:

   import mx.controls.Alert;
  import mx.messaging.events.MessageEvent;
  import mx.messaging.events.MessageFaultEvent;
  import mx.messaging.messages.AsyncMessage;
   
  public function onLoad():void{ 
   _consumer.subscribe();
  }
  public function sendMessage():void { 
   var message:AsyncMessage=new AsyncMessage();
   message.body=_txtInputUser.text+" : "+_txtInputMessage.text;
   _producer.send(message);
  }
  public function messageHandler(event:MessageEvent):void { 
     _txtArea.text+=event.message.body.toString() +"\n";
     _txtInputMessage.text=""; 
  }
  public function faultHandler(event:MessageFaultEvent):void { 
   _txtArea.text=event.faultString;
  }
 ]]>

 
 
 
  
   
    
   
   
    
   
  
  
   
    
   
   
    
   
  
  
   
   
   
    
   
  
 
 

Note:
1. At Line 2- 25, Make Script and method.
2. At Line 26, Producer component (ID=”_producer”).
3. At Line 27, Consumer component (ID=”_consumer”)
4. At Line 28-54, Declaration User Interface in flex.

Explanation:
1. At method sendMessage it use to send message using procedure component and it will fire when Button is pressed . Message will be retrieved from textInput (with ID =_txtInputUser and _txtInputMessage) and will be stored at SyncMessage.
2. At method messageHandler have a utility to accept every asnycmessage.

After you paste code at above there a have a little setting. Go to LCDS Folder on your computer after that find remotig-config.xml copy the code bellow at xml file (before ""):

         
         
             true
             8
         

after copt that save a change. go to at messaging-service.xml and copt code at bellow:

Result:


Source Code:
SimpleChat.mxml

Okay that's it and congratulation you have made simple chat using flex. I hope this tutorial can help you..Have a nice day...^^

Read More......

How use Data Grid in Flex

Data grid is a essential part in application so we must know how to use it. First open your IDE in this case i will use Eclipse Europa with flex builder plug in.
Please copy code bellow in your flex project:

 
  
   <_number>123456
   <_name>Haruki Takumi
   <_address>Kyoto Nippon Street
  
  
   <_number>654321
   <_name>Ichigo Kurosaki
   <_address>Tokyo Street
  
  
   <_number>654123
   <_name>Uzumaki Naruto
   <_address>Leaf Village
  
 
 
 
  
   
    
    
    
   
  
 

In the example above there a have 2 part, the part number 1 is XMLList it place to put data and the part 2 is DataGrid. So after we have a data in XMLLIST we can bind it to datagrid using data provider. This is a screen shoot after the code run:


Okay finnaly congaratulation you have know about how to use data grid and i hope this tutorial can help you...Thank you...^^

Read More......

How to use Menu Bar in Flex

In this chapter we will discuss about flex programming language. I will show you how to make menu bar and access menu. In flex programming language there have a hierarchy(MenuBar->XMListCollection->XMLList->MenuItem). First open your IDE in this case i will use eclipse europa with flex builder plug in. Please copy code bellow in your flex project.

At code above is example to make menu bar in flex but at menu not have a action to do something so we must add some script. In this case I will click menu 1-1 and will display with message error "Menu 1-1".Please copy code bellow:

 
     import mx.controls.Alert;
   import mx.events.MenuEvent;
   private function listenerMenu(event:MenuEvent):void { 
    Alert.show(event.item.@label,"Warning");
   }
  ]]>
 
 
  
   
    
     
     
     
     
    
    
     
     
     
     
    
    
     
     
     
     
    
   
  
 

Result


Okat that's is it and finnaly congratulation you have make one component in flex.Thank you for see this tutorial i hope with this tutorial can help you.^^

Read More......

How Insert, Update and Delete in Java (Oracle Database)

After we know about select in database the next chapter is how to insert,update and delete data at oracle database using java programming language. First open your IDE for this case i will use Netbeans 6.8.Please attention in code bellow:

ConnectionDatabase.java

import java.sql.*;
public class ConnectionDatabase {
Connection conn=null;

public Connection getConnection() {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@127.0.0.1:1521:ORCL";
String _user="dbContact";
String _pass="contact12345";
conn=DriverManager.getConnection(url,_user,_pass);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch ( SQLException e) {
e.printStackTrace();
}
return conn;
}
public static void main (String[] args) {
new ConnectionDatabase().getConnection();

}
}

InsertDatabase.java

import java.util.Scanner;
import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;

public class InsertDatabase {

public ConnectionDatabase conn = new ConnectionDatabase();
public Connection conx = null;
public int _success = 0;

public InsertDatabase() {
    String _id = "", _name = "", _address = "";
    Scanner sc = new Scanner(System.in);
    System.out.println("Insert Data");
    System.out.println("------------------------");
    System.out.print("ID\t: ");
    _id = sc.next();
    System.out.print("Name\t: ");
    _name = sc.next();
    System.out.print("Address\t: ");
    _address = sc.next();
    insertData(_id, _name, _address);
}

public void insertData(String _id, String _name, String _address) {
    //Query syntax
    try {
        String sql = "Insert into Contact values(?,?,?)";
        conx = conn.getConnection();
        PreparedStatement stat = conx.prepareCall(sql);
        stat.setString(1, _id);
        stat.setString(2, _name);
        stat.setString(3, _address);
        _success = stat.executeUpdate();
        if (_success == 1) {
            System.out.println("Data successfully insert");
        }
    } catch (SQLException ex) {
        Logger.getLogger(InsertDatabase.class.getName()).log(Level.SEVERE, null, ex);
    }
}

public static void main(String[] args) {
    new InsertDatabase();
}
}

Note: Don't use space in insert data.

Result:


UpdateDatabase.java

import java.sql.*;
import java.util.Scanner;
import java.util.logging.Level;
import java.util.logging.Logger;

public class UpdateDatabase {

public ConnectionDatabase conn = new ConnectionDatabase();
public Connection conx = null;
public int _success = 0;

public UpdateDatabase() {
    String _id = "", _name = "", _address = "";
    Scanner sc = new Scanner(System.in);
    System.out.println("Update Data");
    System.out.println("------------------------");
    System.out.print("Update ID[Enter ID you want delete]\t: ");
    _id = sc.next();
    System.out.print("Name\t: ");
    _name = sc.next();
    System.out.print("Address\t: ");
    _address = sc.next();
    updateData(_id, _name, _address);
}

public void updateData(String _id, String _name, String _address) {
    //Query syntax
    try {
        String sql = "Update Contact set Name=?,Address=? where ID=?";
        conx = conn.getConnection();
        PreparedStatement stat = conx.prepareCall(sql);
        stat.setString(1, _name);
        stat.setString(2, _address);
        stat.setString(3, _id);
        _success = stat.executeUpdate();
        if (_success == 1) {
            System.out.println("Data successfully update");
        } else {
            System.out.println("Data failed update");
        }
    } catch (SQLException ex) {
        Logger.getLogger(UpdateDatabase.class.getName()).log(Level.SEVERE, null, ex);
    }
}
public static void main(String[] args) {
    new UpdateDatabase();
}
}

Note: Don't use space in insert data.

Result:(Update name and adress in id 2(Before:Tommy Oxford. After Tana Captain))


Before Update

After Update


DeleteDatabase.java

import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;

public class DeleteDatabase {

    public ConnectionDatabase conn = new ConnectionDatabase();
    public Connection conx = null;
    public int _success = 0;

    public DeleteDatabase() {
        String _id = "";
        Scanner sc = new Scanner(System.in);
        System.out.println("Delete Data");
        System.out.println("------------------------");
        System.out.print("Delete ID: ");
        _id = sc.next();
        deleteData(_id);
    }

    public void deleteData(String _id) {
        //Query syntax
        try {
            String sql = "Delete from Contact where ID=?";
            conx = conn.getConnection();
            PreparedStatement stat = conx.prepareCall(sql);
            stat.setString(1, _id);
            _success = stat.executeUpdate();
            if (_success == 1) {
                System.out.println("Data successfully delete");
            } else {
                System.out.println("Data failed deleted");
            }
        } catch (SQLException ex) {
            Logger.getLogger(UpdateDatabase.class.getName()).log(Level.SEVERE, null, ex);
        }
    }

    public static void main(String[] args) {
        new DeleteDatabase();
    }
}

Result:

Okay that's is it and finally congratulation you have know how to insert,update,and delete data in java. I hope with this tutorial can help you...Thank You...^^

Read More......

Select data from Oracle Database using Java

Okay in this chapter we will make connection between java and oracle database. First we will make user in Oracle.Copy code bellow in your oracle:

Query to create user in oracle database (Note log in with system)
create user dbContact identified by contact12345
grant connect,resource to dbContact

Query to make table in oracle (Note:Log in with dbContact)
create table Contact(
ID varchar2(100) primary key not null, Name varchar2(100), Address varchar2(100)
)

Query insert data to table Contact
insert into Contact values('1','Yohan Andreas','Babakan Jeruk I')
insert into Contact values('2','Hendry Apryanto','Kampung Hutan Tua')
insert into Contact values('3','Tana El San','Surya Sumantri')

Class in Java
ConnectionDatabase.java

import java.sql.*;
public class ConnectionDatabase {
    Connection conn=null;

 public Connection getConnection() {
  try {
   Class.forName("oracle.jdbc.driver.OracleDriver");
   String url="jdbc:oracle:thin:@127.0.0.1:1521:ORCL";
   String _user="dbContact";
   String _pass="contact12345";
   conn=DriverManager.getConnection(url,_user,_pass);
  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch ( SQLException e) {
   e.printStackTrace();
  }
  return conn;
 }
 public static void main (String[] args) {
  new ConnectionDatabase().getConnection();
 }
}

SelectDatabase.java

import java.sql.*;
import java.util.logging.Level;
import java.util.logging.Logger;

public class SelectDatabase {

    public ConnectionDatabase conn = new ConnectionDatabase();
    public Connection conx = null;
    public ResultSet set=null;

    public SelectDatabase() {
        String sql = "Select * from Contact";
        conx = conn.getConnection();
        try {
           Statement stat = conx.createStatement();
            set = stat.executeQuery(sql);
            while (set.next()) {
                System.out.println("ID Contact :" + set.getString("ID"));
                System.out.println("Name Contact :" + set.getString("NAME"));
                System.out.println("Address :" + set.getString("ADDRESS"));
                System.out.print("\n");
            }
        } catch (SQLException ex) {
            Logger.getLogger(SelectDatabase.class.getName()).log(Level.SEVERE, null, ex);
        }
    }
    public static void main(String[] args) {
        new SelectDatabase();
    }
}

Result:



Okay that's is it and congratulation you have made connection between java and oracle and you can display data. I hope this tutorial can help you..Thank you...^^

Read More......

Function in SQL Server 2005

This chapter we will discuss about function in sql server so let's check it out:

String Function
1. 'ASCII('[Word]')' -> Return ASCII Code.
Example:ASCII('A')->Result:65

2. 'Char([Word])' -> Return Character.
Example:Char(65)->Result:A

3. 'CharIndex('[Word]','[Sentence]')' ->Return position number word in sentence.
Example:CharIndex('E','HELLO') ->Result:2

4. 'Left([Word],[Number])' ->Taking the word as much a number at left.
Example:Left('HELLO',3)->Result:HEL

5. 'Ltrim([Sentence])' ->Clear space in left at sentence.
Example:Ltrim(' Hello')->Result:Hello

6. 'Right([Word],[Number])' ->Taking the word as much a number at right.
Example:Right('HELLO',3)->Result:LLO

7. 'Rtrim([Sentence])' ->Clear space in right at sentence.
Example:Rtrim('HELLO ')->Result:HELLO

8. 'Len([Sentence])' -> Calculate number of sentence.
Example:Len('HELLO')->Result:5

9. 'Lower([Sentence])' -> Change capital word to lowercase.
Example:Lower('HELLO')->Result:hello

10. 'Reverse(['Sentence'])'->Reverse the Sentence.
Example:Reverse('HELLO')->Result OLLEH

11. 'Upper([Sentence])'->Change lowercase to capital word.
Example:Upper('Hello')->Result:HELLO

12. 'Substring([Sentence],[Start Number],[Number of word])'-> Taking word from start number to number of word.
Example:Substring('Hello Word',2,2)->Result:ll

Date Function
1. 'Getdate()'->Return Complete date.
2. 'datepart(dd,getDate())'->Take a date and month.
3. 'datename(dw,'1980-06-11')'->Return day name at 11 Juny 1980.
4. 'dateadd(yy,2,getdate())'->Add 2 years from system today.
5. 'datediff(dd,'1980-06-11',getdate())'->Calculate the different between day.

Mathematics Function
1. 'abs(-25)'->Return absolute value.
2. 'sin(pi()/2)'->Calculate degree of sinus at 90 desgress.
3. 'exp(1)'->Calculate e power 1.
4. 'radians(180)'->Conversion 180 degress to radian.
5. 'power(2,4)'->Conversion 2 power 4.
6. 'rand(90)'->Rteurn random number under 90.


okay that's is it and finally congratulation you have learn about function in sql server. Thank you for see this tutorial I hope with this tutorial can help you...^^

Read More......

Relation Operator in SQL Server

In this chapter we will learn about relation operator. Realtion Operator have a utility to make some condition in query syntax. At bellow is a little relation operator:
1. '=' -> Equal
2. '<>' -> Not Equal
3. '<' -> Less
4. '<=' -> Less than or equal to
5. '>' -> Bigger
6. '>=' -> Bigger than or equal to
7. 'Like' -> Usually use symbol '%'
8. 'IN' ->Search by parameter more than 1
9. 'Between' -> Search for 2 condition
10. 'Not Between' -> Not between 2 condition.
11. 'Null' -> Empty Value
12. 'Not Null' -> Not Empty Value

Example
Create database dbStudent

Create table dataStudent(
NRP varchar(100) primary key not null, Name varchar(100), Grade int
)

Insert into dataStudent value('0772186','Hendry Apryanto',40)
Insert into dataStudent value('0772097','Yohan Andreas',60)
Insert into dataStudent value('0772232','Tommy Gunawan',90)
Insert into dataStudent value('0772185','Junius',40)
Insert into dataStudent value('0772111','Tana El San',50)

1. Using Equal Symbol ('=')
Select * from dataStudent where NRP='0772186'
Result:
NRP = 0772186
Name = Hendry Apryanto
Grade = 40

2.Using Not Equal Symbol ('<>')
Select * from dataStudent where NRP <> '0772186'
Result :
NRP = 0772097
Name = Yohan Andreas
Grade = 60

NRP = 0772185
Name = Tommy Gunawan
Grade = 90

NRP = 0772185
Name = Junius
Grade = 40

NRP = 0772111
Name = Tana El San
Grade = 50

3. Using Less and Less Than or Equal to('<' and '<=')
Select * from dataStudent where Grade < 50
Result:
NRP = 0772186
Name = Hendry Apryanto
Grade = 40

NRP = 0772185
Name = Junius
Grade = 40

Select * from dataStudent where Grade <= 50
Result:
NRP = 0772186
Name = Hendry Apryanto
Grade = 40

NRP = 0772185
Name = Junius
Grade = 40

NRP = 0772111
Name = Tana El San
Grade = 50

4.Using Bigger and Bigger than or equal to ('>' and '>=')
Select * from dataStudent where Grade > 60
Result :
NRP = 0772185
Name = Tommy Gunawan
Grade = 90

Select * from dataStudent where Grade >= 60
Result :
NRP = 0772097
Name = Yohan Andreas
Grade = 60

NRP = 0772185
Name = Tommy Gunawan
Grade = 90

5. Using Like
Select * from dataStudent where Name LIKE '%h%' (Check at column name containt 'h' word)
Result:
NRP = 0772186
Name = Hendry Apryanto
Grade = 40

NRP = 0772097
Name = Yohan Andreas
Grade = 60

6. Using IN
Select * from dataStudent where Name IN ('Yohan Andreas','Hendry Apryanto')
Result:
NRP = 0772186
Name = Hendry Apryanto
Grade = 40

NRP = 0772097
Name = Yohan Andreas
Grade = 60

7. Using Between
Select * from dataStudent where Grade between 50 and 80
Result:
NRP = 0772097
Name = Yohan Andreas
Grade = 60

NRP = 0772111
Name = Tana El San
Grade = 50

8. Using Not Between
select * from dataStudent where Grade not between 40 and 70
Result:
NRP = 0772185
Name = Tommy Gunawan
Grade = 90

9. Using Null and Not Null
Select * from dataStudent where Name is null
Result:
(No data)

Select * from dataStudent where Name is not null
Result:
NRP = 0772186
Name = Hendry Apryanto
Grade = 40

NRP = 0772097
Name = Yohan Andreas
Grade = 60

NRP = 0772185
Name = Tommy Gunawan
Grade = 90

NRP = 0772185
Name = Junius
Grade = 40

NRP = 0772111
Name = Tana El San
Grade = 50

Okay that's is it and finally congratulation you know a little relation operator in sql server. Thank you for see this tutorial, I hope with this tutorial can help you..^^

Read More......

How to Change Table Sructure Using Sql Command

Okay in this chapter we will discuss how to change table structure using sql command. fisrt open your SQL Sever. In this case I will use sql server 2005, Choose root of database->Choose Tools menu and click at new query. after that query analyzer will display. Query Analyzer is place to write sql command.
For Example I will create some table:

Create table dataStudent(
NRP varchar(100), Name varchar(100)
)

Create table dataSubject() {
Number varchar(10) primary key not null, Name_Subject varchar(100), NRP varchar(100)
}

How to Add Column at Table(I will add column Address at dataStudent)
Format:Alter table [Table Name] add [Add Column] [Data Type]
Example: Alter table dataStudent add Address char(100)

How to change column data type at table (I will change data type column Address at dataStudent)
Format:Alter table [Table Name] alter column [Add Column] [Data Type]
Example:Alter table dataStudent alter column Adress varchar(100)

How to delete column at table (I will delete column Adress at dataStudent)
Format:Alter table [Table Name] drop column [Column Name]
Example:Alter table dataStudent drop column Address

How to add constraint primary key (I will add primary key to NRP column)
1. If you want make column as primary key you must add not null at column.
Example :Alter table dataStudent alter column NRP varchar(100) not null
2. Add Constraint to column
Format: Alter table [Table Name] add contraint [Name Primary Key] primary key [Column Name]
Example:Alter table dataStudent add contraint pk_Student primary key(NRP)

How to add contraint foreign key at column in Table(I will make foreign key between table dataSubject->dataStudent(Primary Key))
Format:Alter table[table candidate foreign key] add constraint [Contraint Name]([Column Name]) reference [table primary key](Column Name)
Example:Alter table dataSubject add contraint fk_Subject_ref_Student foreign key (NRP) reference dataStudent(NRP)

How to delete constraint (I will delete fk_subject_ref_Student)
Format:Alter table [Table Name] drop contraint [Constraint Name]
Example:Alter table dataSubject drop contraint fk_subject_ref_Student

How to drop table (I will drop table dataSubject)
Format:Drop table [Table Name]
Example:Drop table dataSubject

Okay that's is it. Congratulation you have learn a little sql command. I hope this tutorial can help you. Thank a lot..^^

Read More......

Introduction SQL Server

SQL Server is database management product. Released by Microsoft and name with Micorosft SQL Server Management Studio for this case I will use SQL Server 2005.
SQL Server have a utility to make table, view, trigger, store procedure, and many object the other.

This is step to make database:
1. Right click at part database and choose new database.
2. Fill at database menu for example dbStudent, at default it will make 2 file(dbStudent.mdf and dbStudent.log).
3. We can configuration like file type, initial type, autogrowth, path, or you can use a default setting.
4. Press ok and database will make by system.

The other way you can write a query syntax
"Create database [Name Database]"
For Example:
"Create database dbStudent"

This is step to make column in database:
1. At object explorer, choose tables folder and right click adn then choose new table.
2. Fill field and type of properties (for example varchar, date, double).
3. Choose save or you can press a shortcut CTRL+S and give a name of column.

The other way to create column
"Create table [Name of table]([Name Variables][Data type])"
For Example:
"Create table _studentData (No varchar(100) primary key not null,Name varchar(100))"

This is step to insert data at column:
1. Choose table you want insert data
2. After that right click and choose Open table
3. Fill data (it will save automatic if you change a row)

The other way to insert data
"Insert into [Name Table] values ([Data])"
For Example:
Insert into dbStudent values('1234','Hendry Yeah')


This is step to update data at column:
1. Choose table you want update data
2. After that right click and choose Open table
3. Fill data with new one (it will save automatic if you change a row)

The other way to update data
"Update [Name Table] set [Property]=[Data]"
For Example:
Update dbStudent set No='123', Nama='Hendry Apryanto' where No='1234'

This is step to delete data at column:
1. Choose table you want delete data
2. After that right click and choose Open table
3. Delete data (it will save automatic if you change a row)

The other way to DELETE data
"Delete from dbStudent where [Property]=[Data you want deleted]"
For Example:
Delete from dbStudent where No='123'

okay that's all friend. I hope this tutorial can help you and finnaly Congratulation you have make process data in database...^^

Read More......

Make Pyramid in Console Application (Java)

In this chapter we will make a pyramid using console application in java. Okay first, open your IDE. I use netbeans 6.8 with jdk1.6.0_18. After that, make a new project and new class (Class Name : "pyramid").



Source Code

import java.util.Scanner;

public class Pyramid {

    public static void main(String[] args) {
        int _heightpiramid = 1;
        Scanner sc = new Scanner(System.in);
        System.out.println("Tutorial make pyramid in Java");
        System.out.println("-----------------------------");
        System.out.print("Entry height of pyramid : ");
        _heightpiramid = sc.nextInt();
        System.out.println("Result                       : ");
        for (int x = 0; x < _heightpiramid; x++) {
            for (int z = (_heightpiramid - 1) - x; z > 0; z--) {
                System.out.print(" ");
            }
            for (int y = 0; y <= x; y++) {
                System.out.print("*");
            }
            for (int y = 1; y <= x; y++) {
                System.out.print("*");
            }

            System.out.print("\n");
        }

    }
}

Note :
1. Enter a number of height pyramid

I hope this tutorial can help you..^^

Read More......

How make class in Java

Java programming language have utility to make a object. By creating object we can easy to access data, error handling, and the tidy code. okay no talk anymore let's make a one example.First open your IDE->Make a new project, there is have 2 class so i will describe one an one.

Student.java

public class Student {
    private String _number,_name,_adress,_telpno;

    public Student() {
    }

    public Student(String _number, String _name, String _adress, String _telpno) {
        this._number = _number;
        this._name = _name;
        this._adress = _adress;
        this._telpno = _telpno;
    }

    public String getAdress() {
        return _adress;
    }

    public void setAdress(String _adress) {
        this._adress = _adress;
    }

    public String getName() {
        return _name;
    }

    public void setName(String _name) {
        this._name = _name;
    }

    public String getTelpno() {
        return _telpno;
    }

    public void setTelpno(String _telpno) {
        this._telpno = _telpno;
    }

    public String getNumber() {
        return _number;
    }

    public void setNumber(String _number) {
        this._number = _number;
    }
}

AccessClass.java

public class AccessClass {

    public AccessClass() {
        //make a new object Student and assign with name _student
        Student _student = new Student();

        // Set data from class _student
        _student.setNumber("1234");
        _student.setName("Hendry Apryanto");
        _student.setTelpno("09090090");
        _student.setAdress("California Street");

        //Access data from class _student
        System.out.println("Number :" + _student.getNumber());
        System.out.println("Name :" + _student.getName());
        System.out.println("Number Telphone :" + _student.getTelpno());
        System.out.println("Address :" + _student.getAdress());
    }

    public static void main(String[] args) {
        new AccessClass();
    }
}

In student class I am desribe all property (Number,Name,Address,Number telphone) and method(Get and set for each property). Class student have a utility like a temporary data storage and we can set one on one property using method get and set. okay in AccessClass class I made object student so all property is assign to _student.At line 8-11 is using to assign data. At line 14-17 is using to get data.

okay and finnaly congurtulation you have made class and can access it. Thank you for see this tutorial...^^

Read More......

How to Make Menu Bar in Java using Swing Libary

Menu bar is an essential part of application,because menu bar is give general features. okay let's make menu bar, first open your IDE->make a new project->make a new class (for instance:Class Name:MenuBarExercise.java)


Copy the code bellow:

import javax.swing.*;

public class MenuBarExercise {

    private JFrame _frame = new JFrame("Exercise Menu Bar");
    private JMenuBar _menubar = new JMenuBar();
    private JMenu File = new JMenu("File");
    private JMenu Data_Master = new JMenu("Master Data");
    private JMenu Transaction = new JMenu("Transaction");
    private JMenu About = new JMenu("About");
    private JMenuItem Exit = new JMenuItem("Exit");
    private JMenuItem Account = new JMenuItem("Account");
    private JMenuItem Transfer = new JMenuItem("Transfer");
    private JMenuItem Save = new JMenuItem("Save Money");
    private JMenuItem Take = new JMenuItem("Take Money");

    public MenuBarExercise() {
        //Set property of JFrame component
        _frame.setVisible(true);
        _frame.setTitle("Exercise User Interface");
        _frame.setExtendedState(_frame.MAXIMIZED_BOTH);
        _frame.setDefaultCloseOperation(_frame.EXIT_ON_CLOSE);

        //Add Menu Bar into JFrame
        _frame.setJMenuBar(_menubar);

        // Set Menu to Menu Bar
        _menubar.add(File);
        _menubar.add(Data_Master);
        _menubar.add(Transaction);
        _menubar.add(About);

        // Set Menu Item to Menu (File Menu)
        File.add(Exit);
        Transaction.add(Transfer);
        Transaction.add(Save);
        Transaction.add(Take);
        Data_Master.add(Account);
    }

    public static void main(String[] args) {
        new MenuBarExercise();
    }
}

if the code is executed correctly it will display like this:


Congratulation you have made MenuBar in your java application. I hope this tutorial can help...Thank you..^^

Read More......

How to add Action Listener in Java

Action Listener have a utility to listen every action performed on a particular component.
For Example (Purpose: Result=Operator1+Operator2):

Result of source code:




Source Code

import java.util.Scanner;

public class Pyramid {

    public static void main(String[] args) {
        int _heightpiramid = 1;
        Scanner sc = new Scanner(System.in);
        System.out.println("Tutorial make pyramid in Java");
        System.out.println("-----------------------------");
        System.out.print("Entry height of pyramid : ");
        _heightpiramid = sc.nextInt();
        System.out.println("Result                       : ");
        for (int x = 0; x < _heightpiramid; x++) {
            for (int z = (_heightpiramid - 1) - x; z > 0; z--) {
                System.out.print(" ");
            }
            for (int y = 0; y <= x; y++) {
                System.out.print("*");
            }
            for (int y = 1; y <= x; y++) {
                System.out.print("*");
            }

            System.out.print("\n");
        }

    }
}

Note :
1. Entry a Operator 1 and Operator 2 Field

I hope this tutorial can help you..^^

Read More......

How to make JInternalFrame in Java

In this chapter we will make user interface in java with JInternalFrame component. JInternalFrame is a part from library java (import javax.swing.*). All component in java is using JFrame component to display to user, so we will make JFrame first. This is the hierarchy to using JInternalFrame in java.


1. Make the class with name "ExerciseUI.java".
2. Please follow source code bellow:

import javax.swing.*;

public class ExerciseUI {

    private JFrame _frame = new JFrame();
    private JInternalFrame _internalframe=new JInternalFrame();
    private JDesktopPane _pane=new JDesktopPane();

    public ExerciseUI() {
        //Set property of JFrame component
        _frame.setVisible(true);
        _frame.setTitle("Exercise User Interface");
        _frame.setExtendedState(_frame.MAXIMIZED_BOTH);
        _frame.setDefaultCloseOperation(_frame.EXIT_ON_CLOSE);

        //Set property of JIntenalFrame component
        _internalframe.setTitle("I'm in Frame Bro!!! Hahahaha");
        _internalframe.setSize(500,500);
        _internalframe.setVisible(true);

        //Add JInternalFrame component to JDesktopPane component
        _pane.add(_internalframe);

        //Add JDesktopPane component to JFrame component
        _frame.add(_pane);
    }
    public static void main(String[] args) {
        new ExerciseUI();
    }
}

Note :
1. At line 3 is library user interface that provided by java .
2. At line 7 is make object JFrame with name "_frame".
3. At line 8 is make object JInternalFrame with name "_internalframe".
4. At line 9 is make object JDesktopPane with name "_pane".
5. At line 13-16 is set property of JFrame.
6. At line 19-21 is set property of JInternal Frame.
7. At line 24 is add JInternalFrame to JDesktopPane.
8. At line 27 is add JDesktopPane to JFrame.
9. At line 29-31 is use to running the class.

Congratulation you have successfully created JInternalFrame component in java. Thank for see this blog if there is have mistake please revision from you..^^

Read More......

Component in Java

In this chapter we will discuss about component in java. At bellow is component in swing libarary:
1. JLabel
->Have a utility to display a message, display tittle of component, and show picture.
Example :
Declaration-> JLabel _label=new JLabel("Hello Word");
or
JLabel _label=new JLabel();
_label.setText("Hello Word");

2. JButton
->Have a utility to handle event after click.
Example :
Declaration -> JButton _button=new JButton("Click Me");
or
JButton _button=new JButton();
_button.setText("Click Me");

3. JFrame
->Have a utility to display a form.
Example :
Declaration-> JFrame _frame=new JFrame();
//Set property in Java Frame
_frame.setVisible(true); (Display frame)
_frame.setTitle("Exercise User Interface"); (Tittle of frame)
_frame.setExtendedState(_frame.MAXIMIZED_BOTH); (Maximize frame)
_frame.setDefaultCloseOperation(_frame.EXIT_ON_CLOSE); (Close Event)

Add Component in Frame -> JFrame _frame=new JFrame();

//Set property in Java Frame
_frame.setVisible(true); (Display frame)
_frame.setTitle("Exercise User Interface"); (Tittle of frame)
_frame.setExtendedState(_frame.MAXIMIZED_BOTH); (Maximize frame)
_frame.setDefaultCloseOperation(_frame.EXIT_ON_CLOSE); (Close Event)

//Component
JPanel _panel= new JPanel();

//Add Panel to Frame
_frame.add(_panel);

4. JPanel
->A place to collect all component so all component can display together in monitor.
Example :
Declaration -> JPanel _panel=new JPanel();

Add Component to Panel -> JPanel _panel=new JPanel();

//Component
JLabel _label=new JLabel("Hello Word");

//Add Label to Panel
_panel.add(_label);

5. JRadioButton
-> Have a utility to make group radio button.
Example :
Declaration -> JRadioButton _radio=new JRadioButton("Chili");
Add Group RadioButton -> ButtonGroup _group=new ButtonGroup();

//Component Radio Button
JRadioButton _radioCar=new JRadioButton("Car");
JRadioButton _radioMotor=new JRadioButton("MotorCycle");
JRadioButton _radioJet=new JRadioButton("Jet");

//Add RadioButton to Button Group
_group.add(_radioCar);
_group.add(_radioMotor);
_group.add(_radioJet);

6. JBorder
->Add border decoration at form.Border in swing:
1. Line Border
2. Empty Border
3. Bevel Border
4. Compound Border
5. Etched Border
6. Lowered Bevel Border
7. Matte Border
8. Raised Bevel Border
Example:
Declaration -> JPanel _panel=new JPanel();
Border take = BorderFactory.createEtchedBorder();
take = BorderFactory.createTitledBorder("Transaction - Save Money");
_frame.setBorder(take);

7. JTextArea
->Use to entry data in application.
Example:
Declaration -> JTextArea _txtArea=new JTextArea();

8. JScroll Bar
Example:
Declaration -> JTable _table=new JTable();
JScrollPane _pane;
_pane=new JScrollPane(_table,ScrollPaneConstants.VERTICAL_SCROLLBAR_ALWAYS, ScrollPaneConstants.HORIZONTAL_SCROLLBAR_ALWAYS);

9. JCheckBox
Example :
Declaration -> JCheckBox _box=new JCheckBox("Test");

Okay that's is is and finnaly congratulation you have know about a little component in java. Thank you for see this tutorial i hope with this tutorial can help you...^^

Read More......

Java Connection To Oracle Database

In this chapter we will connect between Java and Oracle. Open your IDE to run java extension in this case I will use Netbeans 6.8.
1. Create a new java project (Click File -> New Project-> Java Application -> Project Name (For Instance:ConnectionDatabase)->Finish).



2. Create class ConnectionDatabase.java (At Source Package->Right Click->New->Java Class).



3. This is the source code to connect between Java and oracle (Note:Please input ojdbc14.jar in library of project). The oracle database is "ORCL" with user name "dbPercakapan" and Password "percakapan12345".

import java.sql.*;
public class ConnectionDatabase {
    Connection conn=null;

 public Connection getConnection() {
  try {
   Class.forName("oracle.jdbc.driver.OracleDriver");
   String url="jdbc:oracle:thin:@127.0.0.1:1521:ORCL";
   String _user="dbPercakapan";
   String _pass="percakapan12345";
   conn=DriverManager.getConnection(url,_user,_pass);
  } catch (ClassNotFoundException e) {
   e.printStackTrace();
  } catch ( SQLException e) {
   e.printStackTrace();
  }
  return conn;
 }
 public static void main (String[] args) {
  new ConnectionDatabase().getConnection();

 }
}

Note :
1. At Line 6 statement is use to call driver name of oracle.
2. At Line 7 -10 is use to open connection in oracle.

If in the console display "Connection Successfully" you have made it connect it. ^^

Read More......

Introduction Java Programming Language

Structure Java Program
Java is object oriented programming language. In java have a different way to write programming than the others. Source program in java is consist of classes. In classes is consists of attributes and method. Attributes is use to initializes data type while method is use to initializes procedure or function that will execute letter.
In java program have some class so there have 1 class will be main classes while other classes is complement.

This is a structure class in java:

public class [Class Name] { 
  [Variabel Definition]
  ...
  [Constructor] 
  ...
  [Methods] 
  ...
  Public static void main(String[] args) { 
    ...
  }
}

Variabel
Variabel is a place to store data temporarily. If want to use variabel you must declare data type and name of variabel. In declaration variabel there have a rule, starting with letter and not containt special character like space, &, #, .,and other.

Data Type
1. Boolean = Return true or false.
2. Byte = Return between 1 byte (8 bit).
3. Char = Character or letter.
4. Double = Ranges value between (-1.7 x 10308) to +1.7E308 (+1.7 x 10308).
5. Float = Range value between -3.4E38 (-3.4 x 1038) to +3.4E38 (+3.4 x 1038).
6. Int = Integer.
7. Long = Long Integer.
8. Short = Short Integer.

Operators
Operators is sepecial command in java to modification process or selection with certain criteria to produce a new information or a new condition.
1. Aritmethic Operators
->This operator is used to calculate and aritmethic process. Aritmethics operators is usually used by programmer to produce number output.
- + -> Plus
- - -> Minus
- * -> Times
- / -> Divide
- % -> Modulo
- + -> Plus 1
- - -> Minus 1
2. Logical Operators
- & ->AND
- || -> OR
- ! -> NOT
3. Relational Operator
- == -> Equal than
- != -> Not Equal
- > -> Bigger
- < -> Less
- >= - >Bigger than
- <= -> Less than

Okay that's is it. Thank you for see this tutorial I hope this tutorial can help you..^^

Read More......