What is SQL

What is SQL?

Full Form : Structured Query Language

Definition : SQL is the standard language for accessing database. It is used to create manage and manipulate the database.

C++ CLASS EXAMPLE

Program to create a simple class in C++

#include<iostream.h>
class simple
{
  private:
  void you()
  {
    cout<<"Hi, i am private, you cannot access in main.";
   }
  public:
  void hello()
  {
     cout<<"Welcome to hello function.\n";
   }
   void world()
  {
    cout<<"You are now in world function.";
   }
};
void main()
{
  simple obj;  //creating object of class simple
  cout<<"Welcome to main function.\n";
  obj.hello();  //accessing the function hello using the object obj of class simple
  obj.world();
  //object.you();  //this will give error because the function is private
  getch();
}

==OUTPUT==
Welcome to main function.
Welcome to hello function.
You are now in world function.

CALL BY VALUE PROGRAM IN C

Program of Call by value for swapping two values

#include<stdio.h>
void swap(int a, int b)
{
  int temp;
  temp=a;
  a=b;
  b=temp;
 }
void main()
{
   int a=5;
   int b=10;
   /*printf("c-programcodes.blogspot.in");*/
   swap(a,b);  /*the values goes out of scope  after the function is executed*/
   printf("values are not swapped");
   printf("a=%d\n",a);
   printf("b=%d",b)
}
==OUTPUT==

values are not swapped
a=5
b=10

Java Program #2

Q) Write a Program to print STAR Pattern.
   *
   **
   ***
   ****
   *****

Sol)

class Stars {
  public static void main(String[] args) {
    int row, numberOfStars;

    for (row = 1; row <= 5; row++) {
      for(numberOfStars = 1; numberOfStars <= row; numberOfStars++) {
        System.out.print("*");
      }
      System.out.println(); // Go to next line
    }
  }
}

Java Program #1

Q) Write a Program to print " Hello World ".

Sol)

   public class HelloWorld {

    public static void main(String[] args) {
        
        System.out.println("Hello World");
        
    }

LOWER TRIANGULAR MATRIX

Write a program to print lower triangular matrix in c++

#include<iostream.h>
#include<conio.h>
void main()
{   clrscr();
 int a[10][10],b[10][10],c[10][10];
 int i, j, n, m;
 int p,q;
 cout<<"enter no of rows of matrix\n";
 cin>>m;
 cout<<"enter no of colomns of matrix\n";
 cin>>n;
 cout<<"\n\nenter the elements of matrix\n";
  for(i=0;i<m;i++)
   {
    for(j=0;j<n;j++)
     {
      cout<<"a["<<i+1<<"]["<<j+1<<"]:= ";
      cin>>a[i][j];
     }
   }
  cout<<"\n\nmatrix u have entered is"<<endl;
  for(i=0;i<m;i++)
   {
    for(j=0;j<n;j++)
     {
      cout<<"\t"<<a[i][j];
     }
    cout<<endl;
   }
 cout<<"Lower tringular matrix is"<<endl;
  for(i=0;i<m;i++)
  {
   for(j=0;j<n;j++)
    {
     if(j<=i)
     {
      cout<<"\t"<<a[i][j];
     }
     else
     {
      cout<<"\t ";
     }
    }
    cout<<endl;
  }


getch();
}

C Program to remove all characters except string

Q) Write a C program to remove the characters in String except alphabets.

Sol)
 
#include<stdio.h>

int main()
{
  char line[150];
  int i,j;  

  printf("Enter a string:") ;
  gets(line);

  for(i=0; line[i]!='\0' ; ++i)
   {
      while(!((line[i]>='a' && line[i]<='z') || (line[i]>='A' && line[i]<='Z' || line[i] == '\0')))
           {
                for(j=i; line[j]!='\0';++j)
                        {
                                  line[j] = line[j+1];
                         }
                line[j]='\0' ;
            }
   }
  printf("Output String is :  ")
  puts(line);
  return 0;
}


                                  :: OUTPUT ::  

Enter a string: G-="o";][d 
Output String is: God

STAR PATTERN2

Write a program to print the following star pattern

*****
****
***
**
*

#include<iostream.h>
#include<conio.h>
void main()
{
 clrscr();
 int i,j,n;
 cout<<"Enter number of rows"<<endl;
 cin>>n;
 for(i=n;i>=1;i--)
  {
   for(j=1;j<=i;j++)
    {
     cout<<"*";
    }
   cout<<endl;
 }
 getch();
}

==OUTPUT==

MULTIPLICATION OF TWO MATRICES

Write a program for multiplication  of two matrices
                        OR
Write a program to multiply two matrices

#include<iostream.h>
#include<conio.h>
void main()
{  
 clrscr();
 int a[10][10],b[10][10],c[10][10];
 int i, j, n, m;
 int p,q,k,x[10];
 cout<<"enter no of rows of 1st matrix\n";
 cin>>m;
 cout<<"enter no of colomns of 1st matrix\n";
 cin>>n;
  cout<<"enter no of rows of 2nd matrix\n";
 cin>>p;
 cout<<"enter no of colomn 2nd matrix\n";
 cin>>q;
 if(n==p)
 {
  cout<<"\n\nenter the elements of 1st matrix\n";
  for(i=0;i<m;i++)
   {
    for(j=0;j<n;j++)
     {
      cout<<"a["<<i+1<<"]["<<j+1<<"]:= ";
      cin>>a[i][j];
     }
   }
  cout<<"\n\nfirst matrix u have entered is:="<<endl;
  for(i=0;i<m;i++)
   {
    for(j=0;j<n;j++)
     {
      cout<<"\t"<<a[i][j];
     }
    cout<<endl;
   }
 cout<<"\n\nenter the elements of 2nd matrix\n";
 for(i=0;i<p;i++)
  {
   for(j=0;j<q;j++)
    {
     cout<<"b["<<i+1<<"]["<<j+1<<"]:= ";
     cin>>b[i][j];
    }

  }
 cout<<"\n\n2nd matrix u have entered is:="<<endl;
 for(i=0;i<p;i++)
  {
   for(j=0;j<q;j++)
    {
     cout<<"\t"<<b[i][j];
    }
    cout<<endl;
 }
 for(i=0;i<m;i++)
  {
   for(j=0;j<q;j++)
   {
   c[i][j]=0;
    {
     for(k=0;k<n;k++)
      {  
        x[k]=0;
        x[k]=a[i][k]*b[k][j];
        c[i][j]=c[i][j]+x[k];
      }
    }}
   }
  cout<<"\n\nmultiplication of two matrices is:="<<endl;
  for(i=0;i<m;i++)
   {
    for(j=0;j<q;j++)
     {
      cout<<"\t"<<c[i][j];
     }
    cout<<endl;
   }
  }
   else
    {
     cout<<"matrices cannot be multiplied";
     }

getch();
}

==OUTPUT==


enter no of rows of 1st matrix
2
enter no of column of 1st matrix
2
enter no of rows of 1st matrix
2
enter no of column of 1st matrix
2

enter the elements of 1st matrix
a[1]=1
a[2]=2
a[3]=2
a[4]=3

first matrix u have entered is:=
1 2
2 3

enter the elements of 2nd matrix
b[1]=2
b[2]=3
b[3]=2
b[4]=1

2nd matrix u have entered is
2 3
2 1

multiplication of two matrices is
6 5
8 9