The totality of CSE

Brief History of Open Source Software

2011-10-17T18:45:00.002+05:30

Free Software VS Proprietary Software

It could be said that in the beginning, there was only free (libre) software. Later on, proprietary software was born, and it quickly dominated the software landscape, to the point that it is today considered as the only possible model by many people. Only recently has the software industry considered free software as an option again.

When IBM and others sold the first large-scale commercial computers, in the 1960s, they came with some software which was free , in the sense that it could be freely shared among users, it came with source code, and it could be improved and modified. In the late 1960s, the situation changed after the "unbundling" of IBM software, and in mid-1970s it was usual to find
proprietary software, in the sense that users were not allowed to redistribute it, that source code was not available, and that users could not modify the programs.

Inception of Open Source Software Movement

In late 1970s and early 1980s, two different groups were establishing the roots of the current
open source software movement:

• On the US East coast, Richard Stallman, formerly a programmer at the MIT AI Lab, resigned, and launched the GNU Project and the Free Software Foundation. The ultimate goal of the GNU Project was to build a free operating system, and Richard started by coding some programming tools (a compiler, an editor, etc.). As a legal tool, the GNU General Public License (GPL) was designed not only to ensure that the
software produced by GNU will remain free, but to promote the production of more and more free software. On the philosophical side, Richard Stallman also wrote the GNU Manifesto, "stating that availability of source code and freedom to redistribute and modify software are fundamental rights.”

• On the US West coast, the Computer Science Research Group (CSRG) of the University of California at Berkeley was improving the Unix system, and building lots of applications which quickly become ”BSD Unix''. These efforts were funded mainly by DARPA contracts, and a dense network of Unix hackers around the world helped to debug, maintain and improve the system. During many time that software was not
redistributed outside the community of holders of a Unix AT&T licence. But in the late 1980s, it was finally distributed under the “BSD licence'', one of the first open source licences. Unfortunately, at that time every user of BSD Unix also needed an AT&T Unix licence, since some parts of the kernel and several important utilities, which were needed for a usable system, were still proprietary. Early 1990s During the 1980s and early 1990s, open source software continued its development, initially in several relatively isolated groups. USENET and the Internet helped to coordinate transnational
efforts, and to build up strong user communities. During 1991-1992, the whole landscape of open source software and of software development in general, was ready to change. Two very exciting events were taking place, although in different communities:

• In California, Bill Jolitz was implementing the missing portions to complete the Net/2 distribution, until it was ready to run on i386-class machines. Bill called his work 386BSD, and it quickly became appreciated within the BSD and Unix communities. It included not only a kernel, but also many utilities, making a complete operating system.

• In Finland, Linus Torvalds, a student of computer science, unhappy with Tanenbaum's Minix, was implementing the first versions of the Linux kernel. Soon, many people were collaborating to make that kernel more and more usable, and adding many utilities to complete GNU/Linux, a real operating system. The Linux kernel, and the GNU applications used on top of it are covered by GPL.

1990s – The Golden Period

In 1993, both GNU/Linux and 386BSD were reasonably stable platforms. Since then, 386BSD has evolved into a family of BSD based operating systems (NetBSD, FreeBSD, and OpenBSD), while the Linux kernel is healthy evolving and being used in many GNU/Linux distributions Slackware, Debian, Red Hat, Suse, Mandrake, and many more).

During the 1990s, many open source projects have produced a good quantity of useful (and usually high-quality) software. Some of them are Apache (widely used as a WWW server), Perl(an interpreted language with lots of libraries), XFree86 (the most widely used X11
implementation for PC-based machines), GNOME and KDE (both providing a consistent set of libraries and applications to present the casual user with an easy to use and friendly desktop environment), Mozilla (the free software project funded by Netscape to build a WWW browser), etc. Of all these projects, GNOME and KDE are especially important, because they address usability by non-technical people.

The late 1990s are very exciting times with respect to open source software. Open source systems based on GNU/Linux or *BSD are gaining public acceptance, and have become a real alternative to proprietary systems, competing head to head with the market leaders (like Windows NT in servers). In many niches, the best choice is already open source (an outstanding case is Apache as Web server, with a market share consistently over 50%).

Intoduction to Open Source Software

2011-10-17T18:30:00.000+05:30

OPEN SOURCE

Open source is a development method for software that harnesses the power of distributed peer review and transparency of process. The promise of open source is better quality, higher reliability, more flexibility, lower cost, and an end to predatory vendor lock-in.

THE OPEN SOURCE DEFINITION

The definition of Open Source according to the OSI (Open Source Initiative) is as follows:

Open source doesn't just mean access to the source code. The distribution terms of open-source software must comply with the following criteria:

1. Free Redistribution

The license shall not restrict any party from selling or giving away the software as a component of an aggregate software distribution containing programs from several different sources. The license shall not require a royalty or other fee for such sale.

2. Source Code

The program must include source code, and must allow distribution in source code as well as compiled form. Where some form of a product is not distributed with source code, there must be a well-publicized means of obtaining the source code for no more than a reasonable reproduction cost preferably, downloading via the Internet without charge. The source code must be the preferred form in which a programmer would modify the program. Deliberately obfuscated source code is not allowed. Intermediate forms such as the output of a preprocessor or translator are not allowed.

3. Derived Works

The license must allow modifications and derived works, and must allow them to be distributed under the same terms as the license of the original software.

4. Integrity of the Author's Source Code

The license may restrict source-code from being distributed in modified form only if the license allows the distribution of "patch files" with the source code for the purpose of modifying the program at build time. The license must explicitly permit distribution of software built from modified source code. The license may require derived works to carry a different name or version number from the original software.

5. No Discrimination against Persons or Groups

The license must not discriminate against any person or group of persons.

6. No Discrimination against Fields of Endeavor

The license must not restrict anyone from making use of the program in a specific field of endeavor. For example, it may not restrict the program from being used in a business, or from being used for genetic research.

7. Distribution of License

The rights attached to the program must apply to all to whom the program is redistributed without the need for execution of an additional license by those parties.

8. License Must Not Be Specific to a Product

The rights attached to the program must not depend on the program's being part of a particular software distribution. If the program is extracted from that distribution and used or distributed within the terms of the program's license, all parties to whom the program is redistributed should have the same rights as those that are granted in conjunction with the original software distribution.

9. License Must Not Restrict Other Software

The license must not place restrictions on other software that is distributed along with the licensed software. For example, the license must not insist that all other programs distributed on the same medium must be open-source software.

10. License Must Be Technology-Neutral

No provision of the license may be predicated on any individual technology or style of interface.

Installing Samba and Sharing files with windows

2011-10-01T09:35:00.000+05:30

AIM

To install SAMBA(Server Message Block) in the linux system and share the files to windows OS.

INTRODUCTION

Samba allows file and print sharing between computers running Windows and computers running Unix. It is an implementation of dozens of services and a dozen protocols. Samba sets up network shares for chosen Unix directories (including all contained subdirectories). These appear to Microsoft Windows users as normal Windows folders accessible via the network. Integrating Fedora Linux into a Windows network is reasonable and easy as long as we use the SAMBA utilities.

First, we must allow the Linux server full rights and access to the Windows workgroup and local domain. That means that either in our Active Server environment we need to reserve an IP address for the Linux server, or we simply need to ensure a hard coded IP address is given to the Linux server. The server must have a reserved IP address whether we deliver it via DHCP or statically assign it in the DNS. This also means that we need to ALLOW SMB DAEMON to operate. We can ensure our system security does this by editing our Firewall setup or using system-config-securitylevel.

Second, we must ensure that SAMBA (SAMBA tools and the SMB protocol) is installed and running on the Linux server. Most versions of Fedora come with the necessary packages. We should also be sure to update our SAMBA security levels properly if we are having trouble accessing a shared directory. This is found under Samba Server Configuration tool, main menu Properties, option Server Settings, and then the tab: Security.

Now we are ready to configure our Fedora Linux/SAMBA machine (SAMBA Server).

PROCEDURE

1. SMB(Server Message Block) is a protocol used by Microsoft family of OS for file and print sharing.

2. Open the window terminal in linux and check whether SAMBA package is installed or not.

$rpm –qa|grepsamba

It will display the SAMBA packages installed in linux machine.

3. Switch to supervisor$su(root) mode give the password.

4. Now check whether SAMBA service is started or not. By default it is running,else we have to start SAMBA services.

#service smb status

It displays SAMBA is stopped.

#service smb start

It will start the SAMBA service.

5. Similarly check for NMB.

#service nmb status

#service nmb start

6. Stop the IP table services.

#service ip tables stop

Similarly stop the IP version 6 table.

#service ip6tables stop

7. Type getenforce (disabled)

Type setenforce 0 set enforce: SE Linux is disabled.

8. Now add,smbusername and password.

To add username Type

#useradd winuser

To give password, Type

#smbpasswd –a winuser

New SMB password: admin

Retype new SMB password: admin

Added user winuser.

9. After adding SAMBA user, we have to restart the SAMBA service.

10. Access the SAMBA server from windows. You are now ready to use the SAMBA server for your work.

11. On the windows PC, click start menu and choose host name of SAMBA server and give the IP address of SAMBA server.

12. If it works well, you can see a server login windows give the SAMBA username and password created in the precious steps.

13. Now you can access the shared folders in the windows machine.

(Sample Screenshots)

Installing Common Unix Printing System (CUPS)

2011-10-01T09:21:00.000+05:30

AIM

To install the Common Unix Printing system into the local system.

INTRODUCTION

CUPS is the standards-based, open source printing system developed by Apple Inc. for Mac OS® X and other UNIX®-like operating systems. A computer running CUPS is a host that can accept print jobs from client computers, process them, and send them to the appropriate printer.

CUPS consists of a print spooler and scheduler, a filter system that converts the print data to a format that the printer will understand, and a backend system that sends this data to the print device. CUPS uses the Internet Printing Protocol (IPP) as the basis for managing print jobs and queues.

CUPS can be downloaded from the internet link http://www.cups.org/software.php

(In this post an example for adding HP printer is given)

PROCEDURE

1. Open the terminal window in linux and check whether the CUPS installed or not.

$rpm –qa|grep cups

to display the list of CUPS packages installed in your system.

2. Check whether the CUPS services is enabled or not, we need root permission.
$su

3. Give the password as admin123

#service cups status

4. Goto browser and type
http://localhost:631/ displays the CUPS 1.4.4 HOMEPAGE

5. Under CUPS for admin click adding printer and classes link.

6. Under printer click and printer type username and password.
Username: root password: your_password

7. Select the local printer option button and select ‘Hp printer(HPLIP)’ and click continue.

8. To display connection urls and click continue.
In connection type http://localhost:631/

9. Now type name, description, location of the printer.
Eg: Hp1010 des:Hp1010laserjet printer location:lab1 and click contine.

10. Next select Make from the list as ‘HP’. Click continue.

11. Select model as list Hp1010 select Hplaserjet 1010,hpcups 3010.6(en) click add printer.

12. Now it displays set default options of Hp1010 window.

13. In the general listing you can change the print mode, media size etc. Click set default options.

14. It displays printer Hp1010 default option have been set successfully, now click the Hp10101 link and maintenance is sample paper print.

(Sample Screenshot)

Running PHP Programs

2011-09-21T07:04:00.000+05:30

PHP + MySQL Program

Question - To create simple applications like login forms after setting up a LAMP Stack.

Here however we are designing a PHP application that obtains the information from a student and stores it in the MySQL database.

(This post assumes that you have created a LAMP Stack. If not Click Here to refer to my previous post)

Steps Involved

1. Go to the terminal and login as root.

2. Move to the /var/www/html folder by entering the following command:

[root@fosslab fosslab]# cd /var/www/html

3. Create a filenamed ‘phpdata.php’ using vi editor.

[root@fosslab html]# vi phpdata.php

Now inside enter the following code

phpdata.php

<html>

<head>

                <title>Student Registration!</title>

</head>

<body bgcolor="lightgreen">

<b><center>    <h2>Student Registration Form</h2>

                    <form action="handle_register.php" method="post">

                    <table cellpadding="10" cellspacing="10">

                    <tr>

                    <td><label for="lbl_name">Name</td>

                    <td><input type="text" name="name" ></td>

                    </tr>

                    <tr>

                    <td><label for="lbl_email">Email Id</td>

                    <td><input type="text" name="email"></td>

                    </tr>

                    <tr>

                    <td><label for="lbl_mobile">Mobile Number</td>

                    <td><input type="text" name="mobile"></td>

                    </tr>

                    <tr>

                    <td><label for="lbl_college">College</td>

                    <td><input type="text" name="college"></td>

                    </tr>

                    <tr>

                    <td><label for="lbl_degree">Degree</td>

                    <td><input type="text" name="degree"></td>

                    </tr>

                    <tr>

                    <td><label for="lbl_branch">Branch</td>

                    <td><input type="text" name="branch"></td>

                    </tr>

                    <tr>

                    <td><label for="lbl_year">Year</td>

                    <td><input type="text" name="year"></td>

                    </tr>

                    <tr>

                    </table>

                    <input type="submit" value="Register" name="Submit">

                                    </form></center></b>

</body>

</html>

4. Now save the file and create another one named ‘handle_register.php’.

[root@fosslab html]# vi handle_register.php

Now enter the following code:

handle_register.php

<?php

if($_POST['name']=="" || $_POST['email']=="" || $_POST['mobile']=="" || $_POST['college']=="" || $_POST['degree']=="" || $_POST['branch']=="" || $_POST['year']=="")

{

echo "<h3>Please go back and fill in all the details.</h1>";

die();

}

else

{

$name = $_POST['name'];

$email = $_POST['email'];

$mobile = $_POST['mobile'];

$college = $_POST['college'];

$degree = $_POST['degree'];

$branch = $_POST['branch'];

$year = $_POST['year'];

$connect = mysql_connect("localhost","root","admin123") or die( "Unable to select database");

mysql_select_db("register");

$query = "SELECT * from students where Email='$email'";

$results = mysql_query($query);

$query = "INSERT INTO students (Name,Email,Mobile,College,Degree,Branch,Year) VALUES ('$name','$email','$mobile','$college','$degree','$branch','$year')";

$results = mysql_query($query);

echo "<h2>Thank you " . $name . " for registering.</h2>";

echo "<br><br>List of Students Enrolled:<br><br>";

echo "<table border='2' cellpadding='3'><tr><td>Name</td><td>Email</td><td>Mobile</td><td>College</td><td>Degree</td><td>Branch</td><td>Year</td></tr>";

$query = "SELECT * from students";

$results = mysql_query($query);

while($info = mysql_fetch_array($results))

{

echo "<tr><td>".$info['Name']."</td><td>".$info['Email']."</td><td>".$info['Mobile']."</td><td>".$info['College']."</td><td>".$info['Degree']."</td><td>".$info['Branch']."</td><td>".$info['Year']."</td></tr>";

}

echo "</table>";

}

mysql_close();

?>

Now you have completed your coding part. Next step is to create database in MySQL. We use PhpMyAdmin for it.

Steps for creating database in PhpMyAdmin

1. In your browser type http://localhost/phpmyadmin.

2. Click the Databases tab. In the Create New Databse textbox type register and click create.

3. Next in the create new table frame enter name as ‘students’ and number of fields as ‘7’. Click Go. Now fill in the following

Field	Type
Name	Text
Email	Text
Mobile	Text
College	Text
Degree	Text
Branch	Text
Year	Text

Now finally click Save button below.

5. Now that’s it!! You have created the database.

Executing the Program

1. Go to the browser and type http://localhost/phpdata.php.

2. Fill in the details (all details) and click Register.

3. Now in the next page a Thank you message and list of entries in database will come indicating the success of the program.

Download the Source Code

Setting up a LAMP Stack in Fedora 14

2011-08-20T22:21:00.000+05:30

In this post let us see how to setup a LAMP Stack. LAMP is an acronym for a solution stack of free, open source software, originally coined from the first letters of Linux (operating system), Apache HTTP Server, MySQL (database software) and Perl/PHP/Python, principal components to build a viable general purpose web server.

Setting up this LAMP stack is essential for you to design websites and test it in your local computer.

1. Installing MySQL 5

To install MySQL type the following command in the Terminal:

yum install mysql mysql-server

In order to make MySQL start automatically whenever the system boots, type

chkconfig --levels 235 mysqld on

To Start the MySQL server

/etc/init.d/mysqld start

To set password for MySQL enter,

mysql_secure_installation

The intial password for 'root' is nothing.. So just press enter..It will prompt if you want to change it. Then press 'Y', current password "blank(press enter)" and enter the new password what you want..

2. Installing Apache 2

To install Apache 2 enter the following command

yum install httpd

Now configure your system to start Apache at boot time...

chkconfig --levels 235 httpd on

To start Apache

/etc/init.d/httpd start

To check if it has been installed,

Go to the browser and enter http://localhost

You must see a Fedora Test Page.

3. Installing PHP 5

Enter the following command

yum install php

Then restart apache,

/etc/init.d/httpd restart

The default directory for all PHP files is /var/www/html.

So place any .php file there and then test it as http://localhost/YourFileName.php.

4. Installing MySQL (to be used with PHP)

Enter the following command

yum install php-mysql

Restart the apache as mentioned in the previous step.

5. Installing PhpMyAdmin

phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.

To install PhpMyAdmin enter the following:

yum install phpmyadmin

Restart Apache.

Thats it!!! Its done. Now you are ready to use LAMP...:)

Cyborgs 2k11

2011-07-25T19:40:00.010+05:30

Cyborgs 2k11 (Brain over Brawn)

Cyborgs 2k11 is a National Level Technical Symposium conducted by the Department of Computer Science and Engineering at Valliammai Engineering College,Chennai, on 11th and 12th of August, 2011.

Following the grand success of Cyborgs 09, the CS Adroits association is back with yet another mega event of the year, CYBORGS 2K11.

CYBORGS 2K11 will be a showcase of the skills of some of the best Brains in the country. On the floor, is a plethora of challenging events testing your technical and non-technical skills that spans over two days. We are very proud to welcome you to this Brain Stimulating event and have absolute fun and frolic with our CS Adroits Family. Participate, Enjoy, Succeed, Shine. Its time to prove the might of Brain over Brawn.

Prizes Worth Rs.1,00,000 to be won!!!

List of Events in Cyborgs 2k11

Thesis Cast (Paper Presentation)
Bug Busters (Debugging)
Top Coders (Programming)
Tech Trivia (Quiz)
Ad-Zap
Show Bruta (Dumb C)
Picturesque (Bingo!)
Battle of the Gamers
Picaso on Picasa (Digital Art)
Puzzle Tuzzle

Our Website - http://cyborgs2k11.com/

Our Chief Guest - Mr.Kiruba Shankar

Our Media Partner

Virtualisation Environment

2011-06-01T22:53:00.000+05:30

Task / Aim

Virtualisation environment (e.g., xen, kqemu or lguest) to test an applications, new kernels and isolate applications. It could also be used to expose students to other alternate OSs like *BSD

Procedure

What is Virtualisation?

Virtualisation, in computing, is the creation of a virtual (rather than actual) version of something, such as a hardware platform, operating system, a storage device or network resources.

So what we are going to do is to install another operating system say 'Ubuntu' within our host operating system 'Fedora'. Now the 'Ubuntu' contained within the virtual machine is called as the guest Operating System. The software that we are going to use to perform this is the open source software called 'Qemu'

Installing Ubuntu within Fedora using QEMU

The first step involved here is to download the QEMU source code (if it is not already present). You can perform this download by clicking the following link Download QEMU Source code
Next task is to build the emulator from the source code. Go the folder where you have downloaded the source code in the terminal and enter the following two commands:
$ tar -zxvf qemu-0.14.0.tar.gz $ cd qemu-0.14.0
Next we are going to configure the qemu script such that it is built for i386 architecture. However it supports various other architectures like ARM, PPC, SPARC etc. Enter the following command:
$ ./configure --target-list=i386-softmmu
(Before doing this make sure you have installed Header files and libraries for zlib development. If you haven't then go to 'Add/Remove software' app in Fedora and do it and then configure your script)
Once you are done with configuring now you have to install it. For doing so, you must login as root in your terminal using the 'su' command. After that use the 'make' command to install it.
$ su Password: (This is not a command, but will come when you enter su) # make install
Now you have installed qemu. Next step is to create the virtual machine. The first step in that is to create a Virtual Hard disk image for that. For our Ubuntu OS let us a create an Hard disk of size 10 GB. To create that go to a folder where you want to create the hard disk image and enter the following:
$ qemu-img create ubuntu.img 10G $ ls -lh ubuntu.img (To check)
So you have created the hard disk. What next??? Yes..To install Ubuntu into it. You have to download ubuntu and place its .iso image in the current working directory.
Then execute the following commands
qemu -hda ubuntu.img --boot d -cdrom ./ubuntu-10.10-desktop-i386.iso -m 512
In the above command, '-hda' option specifies the disk image file, '-cdrom' is the CD-ROM or iso image to be used and '-m' option specifies the memory to be allocated for the guest OS. In this case it is 512 MB of RAM.

Now our Virtual machine is ready. Just got to install ubuntu in it. The screenshot is given below:

** Here we have build the software from the source. If you find it complicated you can always use fedora's "yum".... Just install using the command 'yum install qemu' and after that see 5th and 6th points given here.

*** This may be revised in future. Stay tuned for updates. If you find any problem or have any suggestions for improvements, you can always mail me.

By G.Vivek Venkatesh

Implementation of AVL Tree

2011-05-29T22:59:00.001+05:30

In this post I will give the C program for the implementation of AVL tree.

AVL TREE

In computer science, an AVL tree is a self-balancing binary search tree, and it was the first such data structure to be invented.In an AVL tree, the heights of the two child subtrees of any node differ by at most one. Lookup, insertion, and deletion all take O(log n) time in both the average and worst cases, where n is the number of nodes in the tree prior to the operation. Insertions and deletions may require the tree to be rebalanced by one or more tree rotations.

ALGORITHM

Program written based on the algorithm given in the book "Data Structures and Algorithm Analysis in C " written by Mark Allen Weiss.

PROGRAM



#include<stdio.h>

#include<conio.h>

#include<malloc.h>

struct avlnode;

typedef struct avlnode *position;

typedef struct avlnode *avltree;

struct avlnode

{

  int element;

  avltree left;

  avltree right;

  int height;

};



avltree makeempty(avltree T)

{

  if(T!=NULL)

  {

    makeempty(T->left);

    makeempty(T->right);

    free(T);

  }

  return NULL;

}



position find(int X,avltree T)

{

  if(T==NULL)

    return NULL;

  if(X<T->element)

    return find(X,T->left);

  else if(X>T->element)

    return find(X,T->right);

  else

    return T;

}



static int height(position p)

{

  if(p==NULL)

    return -1;

  else

    return p->height;

}



static int max(int lhs,int rhs)

{

  return lhs>rhs ? lhs : rhs;

}



static position singlerotatewithleft(position k2)

{

  position k1;

  k1=k2->left;

  k2->left = k1->right;

  k1->right = k2;

  k2->height = max(height(k2->left),height(k2->right))+1;

  k1->height = max(height(k1->left),k2->height)+1;

  return k1;

}



static position singlerotatewithright(position k1)

{

  position k2;

  k2=k1->right;

  k1->right = k2->left;

  k2->left = k1;

  k1->height = max(height(k1->left),height(k1->right))+1;

  k2->height = max(height(k2->right),k1->height)+1;

  return k2;

}



static position doublerotatewithleft(position k3)

{

  k3->left = singlerotatewithright(k3->left);

  return singlerotatewithleft(k3);

}



static position doublerotatewithright(position k1)

{

  k1->right = singlerotatewithleft(k1->right);

  return singlerotatewithright(k1);

}



//////Insert routine



avltree insert(int X,avltree T)

{

  if(T==NULL)

  {

    T=(avlnode*)malloc(sizeof(struct avlnode));

    if(T==NULL)

      return NULL;

    else

    {

      T->element=X;

      T->height=0;

      T->left=T->right=NULL;

    }

  }

  else if(X<T->element)

  {

    T->left = insert(X,T->left);

    if(height(T->left)-height(T->right)==2)

    {

      if(X<T->left->element)

T = singlerotatewithleft(T);

      else

T = doublerotatewithleft(T);

    }

  }

  else if(X>T->element)

  {

    T->right=insert(X,T->right);

    if(height(T->right)-height(T->left)==2)

    {

      if(X>T->right->element)

T= singlerotatewithright(T);

      else

T=doublerotatewithright(T);

    }

  }

  T->height = max(height(T->left),height(T->right))+1;

  return T;

}



inorder(avltree ptr)

{

  if(ptr!=NULL)

  {

     inorder(ptr->left);

     printf("%d ",ptr->element);

     inorder(ptr->right);

  }

}



display(avltree ptr,int level)

{

  int i;

  if(ptr!=NULL)

  {

    display(ptr->right,level+1);

    printf("\n");

    for(i=0;i<level;i++)

      printf(" ");

    printf("%d",ptr->element);

    display(ptr->left,level+1);

  }

}



void main()

{

  clrscr();

  int choice=0,data;

  avltree T;

  position p;

  T=makeempty(NULL);

  while(1)

  {

    printf("\n\n 1.Insert");

    printf("\n\n 2.Display");

    printf("\n\n 3.Exit\n");

    printf("\n\n Enter your choice:");

    scanf("%d",&choice);

    if(choice==3)

      break;

    switch(choice)

    {

      case 1:

printf("\n\n Enter the value to be inserted:");

scanf("%d",&data);

if(find(data,T)==NULL)

    T=insert(data,T);

else

  printf("\n\n Duplicate value ignored\n");

break;

      case 2:

if(T==NULL)

{

  printf("\n Empty tree...");

  continue;

}

printf("\n\n");

display(T,1);

printf("\n\n Inorder traversal of Tree is:");

inorder(T);

break;

      default:

printf("\n wrong choice...");

break;

    }

  }

  getch();

}

OUTPUT

1.Insert
2.Display
3.Exit

Enter your choice:1

Enter the value to be inserted:23

1.Insert
2.Display
3.Exit

Enter your choice:1

Enter the value to be inserted:16

1.Insert
2.Display
3.Exit

Enter your choice:1

Enter the value to be inserted:35

1.Insert
2.Display
3.Exit

Enter your choice:1

Enter the value to be inserted:12

1.Insert
2.Display
3.Exit

Enter your choice:1

Enter the value to be inserted:24

1.Insert
2.Display
3.Exit

Enter your choice:2

35
   24
23
  16
   12

Inorder traversal of Tree is:12 16 23 24 35

1.Insert
2.Display
3.Exit

Enter your choice:3

Ubuntu 11.04 Screenshots

2011-05-01T20:36:00.006+05:30

I downloaded Ubuntu 11.04 on its release date (28th of April) and found it really good...Hmmm where to begin??? First the ubuntu's attempt to shift the focus from gnome to its Unity interface...It may be looking odd in the beginning but I am sure we will be used to it as the time progresses...Given below are some screenshots of my computer loaded with ubuntu 11.04..

The new looking Desktop

Ubuntu now comes with a preloaded Banshee Meida Player

When you play those media files you will find it getting added to the panel in the 'audio' control side.

A new looking Application Browser

The Desktop Switcher

This version is considered to be the perfect replacement for Windows..;)

Sentinella: A cool app for Linux

2011-04-14T10:27:00.000+05:30

Sentinella is a free desktop application that monitors your system activity and, when a condition is met, takes the action that you've chosen. This simple application written in Qt helps you a lot actually. You can even use this as your automatic shutdown tool.

If you are using Ubuntu then you can install this software from Ubuntu Software center.

(A Screenshot of it running in my computer).

Official Website - http://sentinella.sourceforge.net/

Book Bank Management System UML Diagrams

2011-04-05T10:18:00.000+05:30

UML Diagrams for Book Bank Management System

Usecase Diagram

Class Diagram

Activity Diagram

State Chart Diagram

Registration

Authentication

Search Books

Get Books

Sequence Diagram

Registration

Authentication

Search Books

Get Books

Membership Status

Collaboration Diagram

Registration

Authentication

Search Books

Get Books

Membership Status

Yes we won it!!

2011-04-03T00:02:00.000+05:30

Tonight, the world witnessed one Legend Sachin Tendulkar being the part of the World cup winning team (the only thing that kept eluding him)...And another Legend in the making in the name of Mahendra Singh Dhoni (all cups into his Hall of fame)...

Congratulations to Team India for putting efforts to win this world cup. You provided us a great entertainment.

CHAMPIONS!!!! And you deserve it.

A special wishes to Sachin Tendulkar and Mutiah Muralidharan who are playing their last world cup and last ODI repsectively.

Muralidharan (Smiling Assasin) has been an inspiration to many. You rock!!

Was surprised to see our Superstar in the stadium. Rajini with Gajini. :P

Finally ICC World cup 2011 came to happy ending. Just enjoy have a great weekend.

On cloud nine,
G.Vivek Venkatesh

Rise of Youth in Indian Politics

2011-04-01T16:59:00.000+05:30

Tired of Gerontocracy persisting in our "world's Largest democracy" for quite a long time? Looking for that one person who emulates the character done by Surya in Ayudha Ezhuthu movie? Desperately waiting for that major shift in the paradigm of Indian Politics? Are you an youth and have that burning question in you 'Why it is that youth are neglected from governance" ?

Then I am happy to tell you that one great Gentleman has arisen to satisfy your feelings. Yes I am speaking none other than 'Foodking Sarathbabu Elumalai'. He is a BITS Pilani and IIM Ahmedabad graduate and now a owner of a catering company called "Foodking" based in Mumbai. He is well known for his rags-to-riches story, google his name and you will find it.

Coming to the important point he is standing from Velachery constituency in Tamil Nadu assembly polls 2011. He is working very hard and vigarously to win this election. Hope youth and educated people understand the value of his candidature and support him.

His main motto "Lets win one constituency without bribing a single rupee and show how youth can bring a revolution in Indian Politics". Hope he wins this time.

Important Links:

His Facebook Profile - http://www.facebook.com/profile.php?id=1616992183

His Election Symbol - SLATE

Videos

His PROMO for this election

Wishing for a Change
G.Vivek Venkatesh

Travel Agent and Airline service using JSP and Databases

2011-03-25T16:06:00.000+05:30

Question - Consider a case where we have two web Services- an airline service and a travel agent and the travel agent is searching for an airline. Implement this scenario using Web Services and Data base.

Coding

Database used: MS Access

index.jsp

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<html>
   <head>
   <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
   <title>Travel Agency</title>
   </head>
   <body>
   <center><h1>Travel Easy</h1>
   <h3> - A Smarter way to travel</h3>
   <br><br>
   <b> Enter your Details</b>
   <form name="index" action="AirlineList.jsp" method="post">
   <br>
   <table cellpadding="6" cellspacing="6">
   <tr>
   <td><b>From</b></td>
   <td><input type="text" name="txt_from"</td>
   </tr>
   <tr>
   <td><b>To</b></td>
   <td><input type="text" name="txt_to"</td>
   </tr>
   <tr>
   <td><b>Date of Journey</b></td>
   <td><input type="text" name="txt_depart"</td>
   </tr>
   <tr>
   <td><b>Number of Passengers</b></td>
   <td><input type="text" name="txt_no"</td>
   </tr>
   <tr>
   <td><b>Type of Flight</b></td>
   <td><input type="Radio" name="group1" value="domestic">Domestic Flights</td
   </tr>
   <tr>
   <td></td>
   <td><input type="Radio" name="group1" value="international">International Flights</td>
   </tr>
   <tr>
   <td><b>Select desired Airlines</b></td>
   <td>
   <select name="airline">
   <option>Kingfisher</option>
   <option>SpiceJet</option>
   </select>
   </td>
   </tr>
   </table>
   <br><br>
   <input type="Submit" name="Submit" value="Find Flights">
   </form>

   </center>
   </body>
</html>

airlinelist.jsp

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<html>
   <head>
   <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
   <title>Domestic Flights</title>
   </head>
   <body>
   <center><h1>Travel Easy</h1>
   <h3> - A Smarter way to travel</h3>
   </center>
   <br><br>
   <%@ page language="java" %>
   <%@ page import ="java.sql.*" %>
   <%@ page import = "java.util.Date,java.text.SimpleDateFormat,java.text.ParseException"%>
   <%
   String type = request.getParameter("group1");
   String from= request.getParameter("txt_from");
   String to = request.getParameter("txt_to");
   String depart= request.getParameter("txt_depart");
   String ret = request.getParameter("txt_return");
   String no = request.getParameter("txt_no");
   String airline = request.getParameter("airline");
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   String sTable = type;
   String sSql = "SELECT * FROM " sTable " WHERE From='" from "' and TO='" to "' and DepartDate='" depart "' and SeatCapacity>=" no "";
   String sDBQ = "d:/" airline ".mdb";

   String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=" sDBQ ";DriverID=22;READONLY=true";
   Connection cn = null;
   Statement st = null;
   ResultSet rs = null;
   try {
   cn = DriverManager.getConnection( database ,"","");
   st = cn.createStatement();
   rs = st.executeQuery( sSql );
   ResultSetMetaData rsmd = rs.getMetaData();
   String s1,s2,s3,s4,s5,s6,s7,s8;
   int i=1;
   String flight_no[] = new String[100];
   //out.println("<form name='AirlLine' action='' method='post'><b>" i " . " rs.getString(1) "</b><br><br>");
   out.println("<h3><b>" airline " Flights</b></h3><br>");
   out.println("<table cellspacing=20 cellpaddinng=15>");
   out.println("<tr><th>Flight No</th><th>From</th><th>To</th><th>Departure Date</th><th>Arrival Date</th><th>Start Time</th>");
   out.println("<th>Reach Time</th><th>Seats Remaining</th></tr>");
   while(rs.next())
   {
   s1 = rs.getString(1);
   flight_no[i] = s1;
   s2 = rs.getString(2);
   s3 = rs.getString(3);
   s4 = rs.getString(4);
   s5 = rs.getString(5);
   s6 = rs.getString(6);
   s7 = rs.getString(7);
   s8 = rs.getString(8);
   out.println("<tr><td>" s1 "</td>");
   out.println("<td>" s2 "</td>");
   out.println("<td>" s3 "</td>");
   out.println("<td>" s4 "</td>");
   out.println("<td>" s5 "</td>");
   out.println("<td>" s6 "</td>");
   out.println("<td>" s7 "</td>");
   out.println("<td>" s8 "</td></tr>");
   i ;
   }
   out.println("</table>");
   if(i==1)
   {
   out.println("<br><center><b>Sorry!! No flights scheudle available</b></center><br>");
   }
   else
   {
   out.println("<form name='AirlineList' action='" airline ".jsp' method='post'>");
   out.println("<br><table><tr><td>Select Flight</td><td>");
   out.println("<select name='flight_no'>");
   for(int temp=1;temp<i;temp )
   {
   out.println("<option>" flight_no[temp] "</option>");
   }
   out.println("</select></td></tr><tr></tr>");
   out.println("<tr><td><input type='hidden' name='no' value='" no "'</td>");
   out.println("<td><input type='hidden' name='air_type' value='" type "'</td></tr>");
   for(int j=1;j<=Integer.parseInt(no);j )
   {
   out.println("<tr><th>Passenger " j " details</th></tr>");
   out.println("<tr></tr>");
   out.println("<tr><td>Name</td><td><input type='text' name='pas" j "_name'</td></tr>");
   out.println("<tr><td>Age</td><td><input type='text' name='pas" j "_age'</td></tr>");
   out.println("<tr><td>Sex</td><td><input type='text' name='pas" j "_sex'</td></tr>");
   out.println("<tr></tr>");
   }
   out.println("</table><br><br><input type='Submit' name='Submit' value='Book Now'/></form>");
   }
   //out.println("<input name ='submit' value='Submit' type='submit'/>");
   }
   finally {
   try { if( null != rs ) rs.close(); } catch( Exception ex ) {}
   try { if( null != st ) st.close(); } catch( Exception ex ) {}
   try { if( null != cn ) cn.close(); } catch( Exception ex ) {}
   }

   %>
   </body>
</html>

Kingfisher.jsp

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<html>
   <head>
   <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
   <title>Kingfisher Airlines</title>
   </head>
   <body>
   <%@ page language="java" %>
   <%@ page import ="java.sql.*" %>
   <%
   String s = request.getParameter("no");
   out.println("<h1><center>Kingfisher Airlines</h1><br><h3>- Have a nice trip!!!</h3></center><br>");
   out.println("<br><br>Your Booking Details");
   out.println("<br><br><table cellspacing=10 cellpaddin=10>");
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   String sTable = request.getParameter("air_type");
   String sSql = "SELECT * FROM " sTable " WHERE FlightNo='" request.getParameter("flight_no") "'";
   String sDBQ = "d:/kingfisher.mdb";

   String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=" sDBQ ";DriverID=22;READONLY=true";
   Connection cn = null;
   Statement st = null;
   ResultSet rs = null;
   String name,age,sex,flightno,from,to,departure,arrival,starttime,reachtime,seat;
   out.println("<tr><th>Name</th><th>Age</th><th>Sex</th><th>Flight No</th><th>From</th><th>To</th><th>Departure Date</th><th>Arrival Date</th><th>Start Time</th><th>Reach Time</th><th>Seat No</th></tr>");
   try
   {
   cn = DriverManager.getConnection( database ,"","");
   st = cn.createStatement();
   rs = st.executeQuery( sSql );
   ResultSetMetaData rsmd = rs.getMetaData();
   int seat1=1;
   while(rs.next())
   {
   flightno = rs.getString(1);
   from = rs.getString(2);
   to = rs.getString(3);
   departure = rs.getString(4);
   arrival = rs.getString(5);
   starttime = rs.getString(6);
   reachtime = rs.getString(7);
   seat = rs.getString(8);
   seat1 = Integer.parseInt(seat);
   for(int i=1;i<=Integer.parseInt(s);i )
   {
   name= request.getParameter("pas" i "_name");
   age = request.getParameter("pas" i "_age");
   sex = request.getParameter("pas" i "_sex");
   flightno = request.getParameter("flight_no");

   out.println("<tr><td>" name "</td><td>" age "</td><td>" sex "</td>");
   out.println("<td>" flightno "</td><td>" from "</td><td>" to "</td><td>" departure "</td>");

   out.println("<td>" arrival "</td><td>" starttime "</td><td>" reachtime "</td><td>" seat1 "</td>");
   seat1--;
   }

   }
   Connection cn1 = null;
   Statement st1 = null;
   ResultSet rs1 = null;
   try
   {
   sSql = "update " sTable " set SeatCapacity=" seat1 " WHERE FlightNo='" request.getParameter("flight_no") "'";
   rs1 = st.executeQuery( sSql );
   }
   catch(Exception e)
   {
   }

   }
   finally {
   try { if( null != rs ) rs.close(); } catch( Exception ex ) {}
   try { if( null != st ) st.close(); } catch( Exception ex ) {}
   try { if( null != cn ) cn.close(); } catch( Exception ex ) {}
   }
   %>
   </body>
</html>

SpiceJet.jsp

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<html>
   <head>
   <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
   <title>SpiceJet Airlines</title>
   </head>
   <body>
   <%@ page language="java" %>
   <%@ page import ="java.sql.*" %>
   <%
   String s = request.getParameter("no");
   out.println("<h1><center>SpiceJet Airlines</h1><br><h3>- Have a nice trip!!!</h3></center><br>");
   out.println("<br><br>Your Booking Details");
   out.println("<br><br><table cellspacing=10 cellpaddin=10>");
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
   String sTable = request.getParameter("air_type");
   String sSql = "SELECT * FROM " sTable " WHERE FlightNo='" request.getParameter("flight_no") "'";
   String sDBQ = "d:/SpiceJet.mdb";

   String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=" sDBQ ";DriverID=22;READONLY=true";
   Connection cn = null;
   Statement st = null;
   ResultSet rs = null;
   String name,age,sex,flightno,from,to,departure,arrival,starttime,reachtime,seat;
   out.println("<tr><th>Name</th><th>Age</th><th>Sex</th><th>Flight No</th><th>From</th><th>To</th><th>Departure Date</th><th>Arrival Date</th><th>Start Time</th><th>Reach Time</th><th>Seat No</th></tr>");
   try
   {
   cn = DriverManager.getConnection( database ,"","");
   st = cn.createStatement();
   rs = st.executeQuery( sSql );
   ResultSetMetaData rsmd = rs.getMetaData();
   int seat1=1;
   while(rs.next())
   {
   flightno = rs.getString(1);
   from = rs.getString(2);
   to = rs.getString(3);
   departure = rs.getString(4);
   arrival = rs.getString(5);
   starttime = rs.getString(6);
   reachtime = rs.getString(7);
   seat = rs.getString(8);
   seat1 = Integer.parseInt(seat);
   for(int i=1;i<=Integer.parseInt(s);i )
   {
   name= request.getParameter("pas" i "_name");
   age = request.getParameter("pas" i "_age");
   sex = request.getParameter("pas" i "_sex");
   flightno = request.getParameter("flight_no");

   out.println("<tr><td>" name "</td><td>" age "</td><td>" sex "</td>");
   out.println("<td>" flightno "</td><td>" from "</td><td>" to "</td><td>" departure "</td>");

   out.println("<td>" arrival "</td><td>" starttime "</td><td>" reachtime "</td><td>" seat1 "</td>");
   seat1--;
   }

   }
   Connection cn1 = null;
   Statement st1 = null;
   ResultSet rs1 = null;
   try
   {
   sSql = "update " sTable " set SeatCapacity=" seat1 " WHERE FlightNo='" request.getParameter("flight_no") "'";
   rs1 = st.executeQuery( sSql );
   }
   catch(Exception e)
   {
   }

   }
   finally {
   try { if( null != rs ) rs.close(); } catch( Exception ex ) {}
   try { if( null != st ) st.close(); } catch( Exception ex ) {}
   try { if( null != cn ) cn.close(); } catch( Exception ex ) {}
   }
   %>
   </body>
</html>

Screenshots

Database

(similarly add for SpiceJet.mdb)

Output

index.jsp

airlinelist.jsp

Kingfisher.jsp

Joli OS is Cool

2011-03-14T20:48:00.000+05:30

Just now installed Joli OS 1.2 in my Dell Laptop and it is pretty cool. It has a very aesthetic user interface and it can be considered as a perfect OS for Netbooks, or if you have any 10 year old computers or so means this OS can be extremely useful for you.

It is an 'Ubuntu' based operating system and its makes the best use of Cloud Computing. You need to create an account in http://www.jolicloud.com/ and you can use it to store your files, install apps, share your apps and make friends. So obviously it can be used in other computers too. Just access it from the cloud..:P Ain't it great???

The coolest thing if you aren't a geek or something is that Wifi and Bluetooth installation is very easy in this. You can easily connect within a matter of minutes.

The OS itself looks like a Social networking site...:)

Pros : Its interface, its ease to use, very less boot time, makes efficient use of you hardware, "Desktop portability", Aesthetic Design that gives you the feel of a social networking site..

Cons : Most of the apps here are web apps (although you have native apps), so internet connection becomes a constraint. But again this won't be a much of concern...

Given below are some screenshots,

You can download the OS from the following link,

http://www.jolicloud.com/download

References

http://en.wikipedia.org/wiki/Joli_OS

http://www.jolicloud.com/blog/

Have fun Joliclouding!!!

G.Vivek Venkatesh

Recruitment System VB Project

2011-03-12T11:02:00.000+05:30

In this post I am explaining how to create a simple mini project for Recruitment System using Visual Basic.

I am using VB 6.0 because many colleges still use that and are yet to update to Visual Studio 2010.

Disclaimer - You can use this code for your project, but must not use as it is. Make some changes and then use it.

Download the Project in VB 6.0

Project Details

Front End : Visual Basic
Back End - MS Access (You can use Oracle however)

Steps Involved

1. Creating the database

In Visual Basic 6.0 open Add-Ins -> Visual Data Manger.
Select File -> New -> Microsoft Access ->Version 7.0 mdb.
Name it as 'record'
Create a table named 'record' with following fields

Name - Text
Age - Text
DOB - Date
Phno - Text
Qualification - Text
Percentage - Text
Id - Integer
Status - Text with size as 250.

Now Select 'Build the table'. Your table gets created.

2. Creating the 'Home form'

Before starting with the project go to Project->References and add Microsoft ActiveX Data Objects 2.0 Library and click ok. This is important.

Design the form as shown below,

The basic idea here is that if a person is an applicant he can select wither 'Register' or 'Status' button. However if he is an HR then a login panel has given to them to differentiate them from applicants. Only after proper username and password they can enter into Admin Panel. If he provides a wrong password the Recruitment System will display an error.

The components in this form are,

(The text within brackets refers to the 'Name' property of the corresponding control.)

Command Buttons

Register (Command2)
Know Status (Command1)
Login (Command4)

Textboxes

Username (hr_username)
Password (hr_password0

Images

Exit (Image2)

Code for this form

Private Sub Command1_Click()
Status.Show
End Sub

Private Sub Command2_Click()
Register.Show
End Sub

Private Sub Command4_Click()
If hr_username = "admin" And hr_password = "admin" Then
hr_username = ""
hr_password = ""
Hr.Show
Else
MsgBox "Invalid Username / Password", vbCritical, "Recruitment System"
End If
End Sub

Private Sub Image2_Click()
Unload Me
End Sub

3. Creating the 'Register' form

Design the form as below,

Here the user can enter his personal information and when they click submit button their information is added to the database.

The components in this form are,

Textboxes

Name (Text1)
Age (Text2)
D.O.B (Text3)
Phone No (Text4)
Qualification (Text5)
Percentage (Text6)

Command Buttons

Submit (Command1)

A timer control (Timer1) to display the current time.

Code for this form

This contains the code for connecting Visual Basic 6.0 with MS Access.

Dim c As Integer

Private Sub Command2_Click()
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path + "\record.mdb;Persist Security Info=False"
rs.Open "record", cn, adOpenKeyset, adLockPessimistic, adCmdTable
c = c + 1
rs.AddNew
rs("Name") = Text1
rs("Age") = Text2
rs("DOB") = Text3
rs("Phno") = Text4
rs("Qualification") = Text5
rs("Percentage") = Text6
rs("Id") = c
rs("Status") = "Yet to be processed. Waiting for the response from HR. Stay Tuned for updates"
MsgBox "Registration Successful...Your Application id is " & c & "", vbInformation, "Recruitment System"
rs.Update
rs.Close
cn.Close
Unload Me
End Sub

Private Sub Form_Load()
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path + "\record.mdb;Persist Security Info=False"
rs.Open "select * from record", cn, adOpenKeyset, adLockOptimistic
c = rs.RecordCount
End Sub

Private Sub Timer1_Timer()
Label8.Caption = Now
End Sub
After the user enters the information the following dialog with 'Applicant Id' will be displayed

This applicant id will used by the applicant to check their application status.

4. Creating the Status Form

Design the form as below,

The components in this form are,

Textboxes

Id (Text1)
Name (Text2)
Response text (Text3)

Command Button

Get Response (Command1)

Code for this form

Private Sub Command1_Click()
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path + "\record.mdb;Persist Security Info=False"
rs.Open "select * from record where Id=" & Text1.Text & "", cn, adOpenKeyset, adLockOptimistic
If (rs(0).Value = Text2.Text) Then
Text3.Text = rs(7).Value
Else
MsgBox "Please verify the details you have given", vbCritical, "Recruitment System"
End If
End Sub

4. Creating the HR Admin form

The HR user will enter after entering the correct username and password in the 'Home' form.

Design the Admin Panel form as follows,

Components in this form,

DataGrid

To display the list of applications. To add this go to Project-> Components and in the dialog box that appears select Microsoft DataGrid control 6.0 (OLEDB).

Textboxes

Enter Applicant Id (Text1)
Enter response message (Text2).

Command Button

Delete Applicant Id (Command2)

Code for this form

Private Sub Command1_Click()
On Error Resume Next
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path + "\record.mdb;Persist Security Info=False"
rs.Open "update record set status='" + Text2.Text + "' where Id=" + Text1.Text + "", cn, adOpenKeyset, adLockOptimistic
MsgBox "Response sent successfully..", vbInformation, "Recruitment System"
Unload Me
Me.Show
End Sub

Private Sub Command2_Click()
On Error Resume Next
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path + "\record.mdb;Persist Security Info=False"
rs.Open "delete from record where Id=" & Text1.Text & "", cn, adOpenKeyset, adLockOptimistic
MsgBox "Delete successfully..", vbInformation, "Recruitment System"
Unload Me
Me.Show
End Sub

Private Sub Form_Load()
On Error Resume Next
Dim oconn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim strSQL As String
strSQL = "select * from record"
Set oconn = New ADODB.Connection
oconn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + App.Path + "\record.mdb;Persist Security Info=False"
rs.CursorType = adOpenStatic
rs.CursorLocation = adUseClient
rs.LockType = adLockOptimistic
rs.Open strSQL, oconn, adOpenKeyset, adLockOptimistic
Set DataGrid1.DataSource = rs
End Sub

Finally after this if the applicant checks his status, it will be displayed as follows,

Thats it!!! Your Project is completed in 5 Steps...:)

Hope You all liked it....If you like this I can post other projects that I did.

(The project has been put only under partial testing. There may be some slight errors in it. In case you find any please modify it or mail me.)

G.Vivek Venkatesh

Recruitment System UML Diagrams, SRS

2011-03-12T09:51:00.000+05:30

Hi guys, in this post I have added the UML Diagrams for Recruitment system and a download link for problem statement and SRS.

Download Recruitment System Problem Statement and SRS

Download Recruitment System UML Diagrams

Use case diagram

Class Diagram

Sequence Diagram for 'Register'

Sequence Diagram for 'Status'

Sequence Diagram for 'Admin Panel'

Collaboration Diagram for 'Register'

Collaboraion Diagram for 'Status'

Collaboration Diagram for 'Admin Panel'

Activity Diagram

Open Source Lab Anna University

2011-03-10T19:10:00.001+05:30

One of the best labs of CSE...What do you say????

(You can find the programs soon in this blog, the link is http://www.csewiki.co.cc/search/label/Open%20Source%20Lab)

OBJECTIVE:

To expose students to FOSS environment and introduce them to use open source
packages

1. Kernel configuration, compilation and installation : Download / access the
latest kernel source code from kernel.org,compile the kernel and install it in the
local system.Try to view the source code of the kernel

2. Virtualisation environment (e.g., xen, kqemu or lguest) to test an applications,
new kernels and isolate applications. It could also be used to expose students to
other alternate OSs like *BSD

. Compiling from source : learn about the various build systems used like the
auto* family, cmake, ant etc. instead of just running the commands. This could
involve the full process like fetching from a cvs and also include autoconf,
automake etc.,

4. Introduction to packet management system : Given a set of RPM or DEB,
how to build and maintain, serve packages over http or ftp. and also how do you
configure client systems to access the package repository.

5. Installing various software packages
Either the package is yet to be installed or an older version is existing. The
student can practice installing the latest version. Of course, this might need
internet access. Install samba and share files to windows Install Common Unix Printing System(CUPS)

6. Write userspace drivers using fuse -- easier to debug and less dangerous to
the system (Writing full-fledged drivers is difficult at student level)

7. GUI programming : a sample programme – using Gambas since the students
have VB knowledge. However, one should try using GTK or QT.

8. Version Control System setup and usage using RCS, CVS, SVN

9. Text processing with Perl: simple programs, connecting with database e.g.,
MYSQL

10. Running PHP : simple applications like login forms after setting up a LAMP stack

11. Running Python : some simple exercise – e.g. Connecting with MySql database

12. Set up the complete network interface usinf ifconfig command liek setting
gateway, DNS, IP tables, etc.,

(Source - Anna University R 2008 Syllabus)

Happy Women's Day

2011-03-08T18:33:00.000+05:30

Hi friends, I wish all those who represent motherhood a "Happy Women's day" on this 100th Anniversary of International Women's day.

Book Bank System

2011-02-28T19:52:00.003+05:30

DOWNLOAD PROBLEM STATEMENT AND SRS

PROBLEM STATEMENT:

Book bank system is where the books can be collected every semester and must be returned at the end of semester. The system must have option for new members to enroll for membership by paying deposit. A provision for getting six or seven books per semester. Membership can be renewed by using the register number. The deposit must be refunded on termination of membership. A database must be maintained to guide the issuer to track the details of students. Search option must be provided so that the member can search for the availability of a particular book.

SOFTWARE REQUIREMENT SPECIFICATION

TABLE OF CONTENTS

1. 1 Introduction

1.1 Purpose

1.2 Product scope

1.3 Document conventions

1.4 References

2. 2 Overall Description

2.1 Product Perspective

2.2 Product Functions

2.3 Tools to be used

External Interface

3.1 Hardware Interface

3.2 Software Interface

System Features

4.1 Requesting Books

4.1.1 System Description and Priority

4.1.2 Stimulus/response Sequence

4.1.3 Functional Requirements

Other non-functional requirements

5.1 Performance Requirements

5.2 Safety Requirements

5.3 Security Requirements

1. INTRODUCTION

The book bank is a set up that lends books for all its members which they can return at the end of each semester. It has a huge collection of books and has to keep track of all its members’ details such as requests, dues and penalties and the books.

1.1 PURPOSE

The purpose of this document is to present a detailed description of the Book Bank System. It will explain the purpose and features of the system, the interfaces of the system, what the system will do, the constraints under which it must operate and how the system will react to external stimuli.

1.2 SCOPE

The book bank holds an online interface with its members for maintaining all kinds of transaction details. Each member is provided with a unique user id at the time of registering as a member.

1.3 DOCUMENT CONVENTIONS

· Director: The ultimate authority in the staff hierarchy of the book bank

· Member: Any person who registers with the book bank

· HTML-Hyper Text Markup Language used to create web page.

1.4 REFERENCES

www.reachbookbank.com

www.bookworldlibrary.com

2. OVERALL DESCRIPTION

2.1 PRODUCT PERSPECTIVE

This project is a self contained one for enabling a book bank organization to be connected with its students, through this system, the students can check for availability of books, makes requests, etc.

2.2 PRODUCT FUNCTIONS

This system functions with a database at the back end, for keeping track of its member’s dues and payments, and also its available resources. Every student who is a member needs only a web browser to connect to this system.

2.3 TOOLS TO BE USED

Visual basic and Microsoft Access

3. EXTERNAL INTERFACES

3.1 HARDWARE INTERFACES

The system should have good hardware support. The processor should have high speed and must be of high efficiency.

3.2 SOFTWARE INTERFACE

The system uses ODBC drive to connect and control the database.

4. SYSTEM FEATURES

4.1 REQUESTING BOOKS

4.1.1 SYSTEM DESCRIPTION & PRIORITY

Allows a student, who becomes a member to login using a unique id issued at the time of registering as a member, and after logging in, the member can browse through available books and make requests accordingly. The books will be issued provided there is no due, regarding returning of previous books.

4.1.2 STIMULUS/RESPONSE SEQUENCE

Whenever the student wishes to get books, he/she checks for the availability by logging in. When the request is made, the director of the book bank decides on granting the request of book(s) after checking the member details for due in returning previous books.

4.1.3 FUNCTIONAL REQUIREMENTS

The member should be authenticated by means of unique login id and password. The availability of books requested must be prompted to the user through e-mail or sms notifications.

5. OTHER NON-FUNCTIONAL REQUIREMENTS

5.1 PERFORMANCE REQUIREMENTS

The web interface should be able to support multiple users trying to log in simultaneously.

5.2 SAFETY REQUIREMENTS

The student details should be made available in the database and must be updated every time a book is issued or returned or some kind of payment takes place to prevent errors.

5.3 SECURITY REQUIREMENTS

The member can only access certain details from the database. He/she should not be able to modify the database nor has any of its information corrupted. Only the DBA must be bestowed with the privileges of handling any kind of modifications.

Online Eamination using JSP and Databases

2011-02-25T23:33:00.001+05:30

Question - Write programs in Java to create three-tier applications using JSP and Databases for conducting online examination.

Download Source code

Download Database file

index.jsp

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Welcome to Online Examination</title>
    </head>
    <body bgcolor="cyan">
        <form name="index" action="exam.jsp" method="post">
        <center><h1><span><font color="red">Welcome to Online Examination</font></span></h1>
        <br>
        <h2><u><span><font color="blue">Instructions to the Candidates</font></span></u></h2>
        <br><h3><ol><li>Fill the correct Registration number.</li>
        <br><li>Enter your name.</li>
        <br><li>Read the questions carefully.</li>
        <br><li>No negative marking.</li></ol></h3>

        <br>
        <b>Enter your Register number</b>
        <input type="text" name="txt_reg">
        <b>Enter your Name</b>
        <input type="text" name="txt_name"><br><br>
        <input name ="submit" value="Submit" type="submit"/>
        </center>
        </form>
    </body>
</html>

exam.jsp

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Examination Panel</title>
    </head>
    <body bgcolor="cyan">
        <%@ page language="java" %>
<%@ page import ="java.sql.*" %>
<%
String reg= request.getParameter("txt_reg");
String name = request.getParameter("txt_name");
out.println("<h2>Welcome"   name   "...Your Register number is "   reg   "!!</h2><br><br><br>");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String sTable = "exam";
String sSql = "SELECT * FROM "   sTable   "";
String sDBQ = "C:/Users/A/Documents/NetBeansProjects/Online Examination/exam.mdb";

String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="   sDBQ   ";DriverID=22;READONLY=true";
Connection cn = null;
Statement st = null;
ResultSet rs = null;
try {
cn = DriverManager.getConnection( database ,"","");
st = cn.createStatement();
rs = st.executeQuery( sSql );
ResultSetMetaData rsmd = rs.getMetaData();
String s1,s2,s3,s4;
int i=1;
while(rs.next())
{

out.println("<form name='exam' action='report.jsp' method='post'><b>" i " . "   rs.getString(1)   "</b><br><br>");
s1 = rs.getString(2);
s2 = rs.getString(3);
s3 = rs.getString(4);
s4 = rs.getString(5);
out.println("<input type=radio name=opt" i " value=" s1 " CHECKED>" s1 " <br><br>");
out.println("<input type=radio name=opt" i " value=" s2 ">"   s2 "<br><br>");
out.println("<input type=radio name=opt" i " value=" s3 ">"   s3 "<br><br>");
out.println("<input type=radio name=opt" i " value=" s4 ">"   s4 "<br><br>");
i ;
}
out.println("<input name ='submit' value='Submit' type='submit'/>");
/*int n = rsmd.getColumnCount();
out.println( "<table border=1 cellspacing=3><tr>" );
for( int i=1; i<=n; i   ) // Achtung: erste Spalte mit 1 statt 0
out.println( "<th>"   rsmd.getColumnName( i )   "</th>" );
while( rs.next() )
{
out.println( "</tr><tr>" );
for( int i=1; i<=n; i   ) // Achtung: erste Spalte mit 1 statt 0
out.println( "<td nowrap>"   rs.getString( i )   "</td>" );
}
out.println( "</tr></table>" );*/
}
finally {
try { if( null != rs ) rs.close(); } catch( Exception ex ) {}
try { if( null != st ) st.close(); } catch( Exception ex ) {}
try { if( null != cn ) cn.close(); } catch( Exception ex ) {}
}

%>

    </body>
</html>

report.jsp

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Exam Report</title>
    </head>
    <body bgcolor="cyan">
        <center><h1>Your Report Card</h1></center>
<%@ page language="java" %>
<%@ page import ="java.sql.*" %>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String sTable = "exam";
String sSql = "SELECT * FROM "   sTable   "";
String sDBQ = "C:/Users/A/Documents/NetBeansProjects/Online Examination/exam.mdb";

String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ="   sDBQ   ";DriverID=22;READONLY=true";
Connection cn = null;
Statement st = null;
ResultSet rs = null;
try {
cn = DriverManager.getConnection( database ,"","");
st = cn.createStatement();
rs = st.executeQuery( sSql );
ResultSetMetaData rsmd = rs.getMetaData();
String s1,s2,s3,s4;
int i=1;
int correct=0,incorrect=0,total=0;
out.println("<h2><br><br><center><table border=1 cellpadding=2 cellspacing=2><tr><th>Question</th><th>Your Answer</th><th>Correct Answer</th><th>Status</th></tr>");
while(rs.next())
{
total ;
s1 = rs.getString(1);
s2 = request.getParameter("opt" i);
s3 = rs.getString(6);
if(s2.equals(s3))
{
    s4="Correct";
    correct ;
}
else
{
    s4="Incorrect";
    incorrect ;
}
out.println("<tr><td>" s1 "</td><td>" s2 "</td><td>" s3 "</td><td>" s4 "</td></tr>");
i ;
}
out.println("</table><br><br><table><b><tr><td>Correct Answers</td><td>" correct "</td></tr>");
out.println("<tr><td>Incorrect Answers</td><td>" incorrect "</td></tr>");
out.println("<tr><td>Total Questions</td><td>" total "</td></tr></table></b></center></h2>");

}
finally {
try { if( null != rs ) rs.close(); } catch( Exception ex ) {}
try { if( null != st ) st.close(); } catch( Exception ex ) {}
try { if( null != cn ) cn.close(); } catch( Exception ex ) {}
}

%>

    </body>
</html>

Screenshots

index.jsp

exam.jsp

report.jsp

Hope u like it guys..:)

Gantt Chart for my Passport Automation System Project

2011-02-20T08:54:00.002+05:30

Hi Guys, a sample Gantt chart for Passport Automation System is given below,

Passport Automation System UML Diagrams

2011-02-09T05:31:00.000+05:30

Download All Diagrams

Use case Diagram

Class Diagram

Sequence Diagram

New Registration

Check Status

Admin Panel

Activity Diagram

New Registration

Check Status

Admin Panel

Collaboration Diagrams

New Registration

Check Status

Admin Panel

Guys, I have attached most of the UML Diagrams for Passport Automation System..

Hope you like it..

Wishing you good Luck..:)

Disclaimer - The UML diagrams given might have some mistakes..So please take care when you use it and please do comment about any mistakes you find so that we can rectify it.

Invoking servlets from HTML forms

2011-02-07T18:19:00.000+05:30

Question - "To invoke servlets from HTML forms".

To work on this program, I recommend you to download Netbeans IDE.

You can download Netbeans IDE from the following link,

http://netbeans.org/downloads/

After you download and install perform the following procedure,

Procedure to run this program on Netbeans

Start Netbeans IDE.
Now Select File->New Project.
In the New Project Dialog box that appears select Java Web(Web Application).
Now “New Web Application” Dialog box appears.
Give the Project Name as “ServletApplication”.
Click Next twice and then Finish.
Now a web application named ServletApplication is created with a default page “index.jsp”. There write the code for HTML forms.
Then right click on the WEB-INF folder and select New-> Servlet. Give the name of the servlet as “MyServlet” , click Next. In the next dialog that appears please make sure “Add information to deployment descriptor” checkbox is selected. Now click next and then finish.
Write the code for Servlet in it.
To compile the file, right click on index.jsp and then select “compile file”.
After compiling, again right click on index.jsp and select “Run file”.
Now the browser(use firefox) will open and verify the output.

Download the Source code

Code

index.jsp

<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<html>
    <head><title>HTML Forms and Servlet</title></head>
    <body>
        <%-- <jsp:useBean id="beanInstanceName" scope="session" class="beanPackage.BeanClassName" /> --%>
        <%-- <jsp:getProperty name="beanInstanceName" property="propertyName" /> --%>
        <h1>Enter your Details</h1>
        <form action = "MyServlet">
        <table>
        <tr>
        <td>Name
        <td><input type="text" name="name"><br><br>
        </tr>
        <tr>
        <td>Reg No
        <td><input type="text" name="reg"><br><br>
        </tr>
        <tr>
        <td>Sub1 Mark
        <td><input type="text" name="sub1"><br><br>
        </tr>
        <tr>
        <td>Sub2 Mark
        <td><input type="text" name="sub2"><br><br>
        </tr>
        <tr>
        <td>Sub3 Mark
        <td><input type="text" name="sub3"><br><br>
        </tr>
        <tr>
        <td>Sub4 Mark
        <td><input type="text" name="sub4"><br><br>
        </tr>
        <tr>
        <td>Sub5 Mark
        <td><input type="text" name="sub5"><br><br>
        </tr>
        <tr>
        <td>Sub6 Mark
        <td><input type="text" name="sub6"><br><br>
        </tr>
        </table>
        <input type="submit">
        </form>
    </body>
</html>

MyServlet.java

/*
* MyServlet.java
*
* Created on February 3, 2011, 9:03 PM
*/
import java.io.*;
import java.net.*;
import javax.servlet.*;
import javax.servlet.http.*;
/**
*
* @author Administrator
* @version
*/
public class MyServlet extends HttpServlet {
    /** Initializes the servlet.
     */
    public void init(ServletConfig config) throws ServletException {
        super.init(config);
    }

    /** Destroys the servlet.
     */
    public void destroy() {

    }
      public String display(int mark)
    {
        if(mark>90 && mark<=100)
    {
    return "S";
    }
    else if(mark>80 && mark<=90)
    {
    return("A");
    }
    else if(mark>70 && mark<=80)
    {
    return("B");
    }
    else if(mark>60 && mark<=70)
    {
    return("C");
    }
    else if(mark>55 && mark<=60)
    {
    return("D");
    }
    else if(mark>=50 && mark<55)
    {
    return("E");
    }
    else
    {
    return("Re Appear");
    }
    }
    /** Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
     * @param request servlet request
     * @param response servlet response
     */

    protected void processRequest(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        response.setContentType("text/html");
        PrintWriter out = response.getWriter();

        try {
            String name, reg;
            int mark,s1,s2,s3,s4,s5,s6;
name = request.getParameter("name");
reg = request.getParameter("reg");
s1 = Integer.parseInt(request.getParameter("sub1"));
s2 = Integer.parseInt(request.getParameter("sub2"));
s3 = Integer.parseInt(request.getParameter("sub3"));
s4 = Integer.parseInt(request.getParameter("sub4"));
s5 = Integer.parseInt(request.getParameter("sub5"));
s6 = Integer.parseInt(request.getParameter("sub6"));

response.setContentType("text/html");

out.println("<html>");
out.println("<head>");
out.println("<title>Mark Report Servlet<title>");
out.println("</head>");

out.println("<body>");
out.println("<center><p><h2><b>Name :" + name + "</p>");
out.println("<p><b>Reg No :" + reg + "</p>");
out.println("<p><b>Your Mark Details</p><br><br></center>");
out.println("<center><table border=2 cellpadding=5 cellspacing=5>");
out.println("<tr><th>Subjects</th><th>Mark</th><th>Grade</th></tr>");
out.println("<tr><th>Sub1</th><td>"+s1 + "</td><td>" + display(s1) + "</td></tr>");
out.println("<tr><th>Sub2</th><td>"+s2 + "</td><td>" + display(s2) + "</td></tr>");
out.println("<tr><th>Sub3</th><td>"+s3 + "</td><td>" + display(s3) + "</td></tr>");
out.println("<tr><th>Sub4</th><td>"+s4 + "</td><td>" + display(s4) + "</td></tr>");
out.println("<tr><th>Sub5</th><td>"+s5 + "</td><td>" + display(s5) + "</td></tr>");
out.println("<tr><th>Sub6</th><td>"+s6 + "</td><td>" + display(s6) + "</td></tr></table>");
out.println("</body>");
out.println("</html>");
        } finally {
            out.close();
        }

    }

    /** Handles the HTTP <code>GET</code> method.
     * @param request servlet request
     * @param response servlet response
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    }
    /** Handles the HTTP <code>POST</code> method.
     * @param request servlet request
     * @param response servlet response
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
        processRequest(request, response);
    }
    /** Returns a short description of the servlet.
     */
    public String getServletInfo() {
        return "Short description";
    }

Note

Some parts of the code will be automatically generated by Netbeans itself. So you need not worry.

Screenshots