ComputerEngineeringPrograms: TE_SEM1_PL

Assignments Group A (Mandatory)

1 DBMS using connections(Client-Data sever, two tier) Oracle/MySQL (ODBC/JDBC), SQL
prompt to create data base tables insert, update data values, delete table, use table, select
queries with/without where clause. ,demonstrate use of stored procedure / function (create
procedure at the data side and make use of it on the client side)
2 DBMS using connections(Client-application server-Data sever, three tier) Oracle/MySQL
(ODBC/JDBC), SQL Joints, prompt.
3 Design and Develop SQL DDL statements which demonstrate the use of SQL objects
such as Table, View , Index using Client-Data sever(two tier)
4 Write a program in Python/C++ to read display the i-node information for a given text file,
image file.
5 Write an IPC program using pipe. Process A accepts a character string and Process B
inverses the string. Pipe is used to establish communication between A and B processes
using Python or C++.
6 Use Python for Socket Programming to connect two or more PCs to share a text file.

Assignments Group B (Any Six Assignments, All assignments to be covered in a Batch)

1 Design at least 10 SQL queries for suitable database application using SQL DML statements:
Insert, Select, Update, Delete Clauses using distinct, count, aggregation on Client-Data
sever(three tier)
2 Implement database with suitable example using MongoDB and implement all basic
operations and administration commands using two tier architecture.
3 Use MongoDB to process semi structured and unstructured data collections such as Rfid,
images, blogs use python/Java MongoDB interface.
4 Write an python/Java application using MongoDB to maintain the blog for composing the
blog consists of text columns, images and videos also calculate the hit or users visited by
drawing 2D graphs.
5 Write a program in Python/C++ to test that computer is booted with Legacy Boot ROM-
BIOS or UEFI.
6 Write a program in C++ to create a RAMDRIVE and associate an acyclic directory structure
to it. Use this RAMDRIVE to store input, out files to run a calculator program.
7 Write a program in C++ to develop a tool using GRUB2 or GRUBx64.rfi select and display
a boot partition. (use appropriate overloading)
8 Write a Python/Java/C+ program to verify the operating system name and version of Mobile
devices.
9 Write a program using MongoDB to compose a web news-letter consisting of videos,
images, text use python MongoDB interface.
10 Create a iso boot image using open source tools.
11 Write a python program for creating virtual file system on Linux environment.
12 Write a program in C++ to make USB Device Bootable by installing required system files
13 Write a program in python for USB Device File Management. Check usefulness of
command e2fsck for different file systems mounted on computer.
14 Aggregation and indexing with suitable example using Cassendra and RdfID based
employees attendance system.
15 Aggregation and indexing with suitable example using MongoDB.
16 Map reduce operation with suitable example using MongoDB.
17 Indexing and querying with MongoDB using suitable example.
18 Connectivity with MongoDB using any Java application.
19 Using MongoDB create a database of employee performance, employee attendance on the
workstation. Perform statistical analysis for the results of the products produced by
employees rated as passed ok, damaged products ( 5 samples per batch size 1000) and the
portion covered in the training and absentee of the employees during training. Use
programming language R. (or R-Python/R-Java) or equivalent assignment using R
Programming Language for BiGDATA computing.

Assignment Group C: Advance Technology Assignments (Any One, all three to be

covered in a Batch)

1 BIG DATA applications using Hadoop
2 BIG DATA applications using Blogs
3 Big Data Predictive Machine Learning
4 Create and test functioning of Windows-8 ReFS (Resilient File System)

===============================

Practical: A1 Two tier client server mysql

===============================

===============================

Practical: A2 Three tier Mysql

===============================

//PROGRAM:-

import java.lang.*;

import java.sql.*;

import java.io.*;

public class Javasql1

{

public static void main(String[] args)

{

int ch;

String q;

BufferedReader input = new BufferedReader(new InputStreamReader(System.in));

String url = "jdbc:mysql://localhost/";

String driver = "com.mysql.jdbc.Driver";

String dbName = "studinfo";

String userName = "root";

String password="gescoe";

try{

Connection conn = DriverManager.getConnection(url+dbName,userName,password);

Statement st = conn.createStatement();

ResultSet res;

{

System.out.println("\n---------MENU---------");

System.out.println("\n1.Create Tables");

System.out.println("\n2.Insert Records");

System.out.println("\n3.Joins");

System.out.println("\n4.Exit");

System.out.println("\n\nEnter your choice:");

ch=Integer.parseInt(input.readLine());

switch(ch)

{

case 1:

System.out.println("\nCreating two table:student and marks");

q="CREATE TABLE students(Roll_No int,Name VARCHAR(10),Department varchar(10));";

st.executeUpdate(q);

q="CREATE TABLE marks(Roll_No int,Name varchar(10),Internal_Marks int,External_Marks int);";

st.executeUpdate(q);

System.out.println("\n'students' and 'marks'table Successfully created\n");

break;

case 2:

q = "INSERT INTO students VALUES(101,'Shubha','IT');";

st.executeUpdate(q);

q = "INSERT INTO students VALUES(112,'Rohini','Civil');";

st.executeUpdate(q);

q = "INSERT INTO students VALUES(103,'Nishi','Computer');";

st.executeUpdate(q);

q = "INSERT INTO students VALUES(174, 'Anushka','Computer');";

st.executeUpdate(q);

q = "INSERT INTO students VALUES(115,'Anuja','IT');";

st.executeUpdate(q);

q = "INSERT INTO marks VALUES(103,'Nishi',38,43);";

st.executeUpdate(q);

q = "INSERT INTO marks VALUES(133,'Raj',35,39);";

st.executeUpdate(q);

q = "INSERT INTO marks VALUES(174,'Anushka',43,45);";

st.executeUpdate(q);

q = "INSERT INTO marks VALUES(111,'Sham',40,41);";

st.executeUpdate(q);

q = "INSERT INTO marks VALUES(115,'Anuja',30,34);";

st.executeUpdate(q);

System.out.println("\nInserted records into the tables 'students' and 'marks' successfully...\n");

break;

case 3:

do{

System.out.println("\n\n-------Joins-------\n");

System.out.println("\n1.INNER JOIN");

System.out.println("\n2.LEFT OUTER JOIN");

System.out.println("\n3.RIGHT OUTER JOIN");

System.out.println("\n4.FULL OUTER JOIN");

System.out.println("\n5.Exit");

System.out.println("\n\nEnter your choice:");

ch=Integer.parseInt(input.readLine());

switch(ch)

{

case 1: q="SELECT students.Roll_No,students.Name, students.Department FROM students INNER JOIN marks ON students.Roll_No=marks.Roll_No;";

res=st.executeQuery(q);

System.out.println("\n\t-------------------------------------

---------------------------------");

System.out.println("\n\t\t\t\tRECORDS");

System.out.println("\n\t------------------------------------

-------------------------------\n");

while (res.next())

{

int rollno = res.getInt("Roll_No");

String name = res.getString("Name");

String department = res.getString("Department");

System.out.println("\n\tRoll No:"+rollno+"\t Name:"+name+"\tDepartment:"+department+"\n");

}

System.out.println("\n\t----------------------------------

-----------------------------\n");

break;

case 2:

q="SELECT students.Roll_No,students.Name,

marks.Internal_Marks FROM students LEFT OUTER JOIN marks ON students.Roll_No=marks.Roll_No;";

res=st.executeQuery(q);

System.out.println("\n\t----------------------------

---------------------------------------");

System.out.println("\n\t\t\t\tRECORDS");

System.out.println("\n\t--------------------------------

-----------------------------------\n");

while (res.next())

{

int rollno = res.getInt("Roll_No");

String name = res.getString("Name");

int Imarks = res.getInt("Internal_Marks");

System.out.println("\n\tRoll No:"+rollno+"\t Name:"+name+"\tInternal_Marks:"+Imarks+"\n");

}

System.out.println("\n\t-----------------------------------

--------------------------------\n");

break;

case 3:

q="SELECT students.department,marks.Roll_No,marks, External_Marks FROM students RIGHT OUTER JOIN marks ON students.Name=marks.Name;";

res=st.executeQuery(q);

System.out.println("\n\t--------------------------------

-----------------------------------");

System.out.println("\n\t\t\t\tRECORDS");

System.out.println("\n\t--------------------------------------

-----------------------------\n");

while (res.next())

{

String department = res.getString("Department");

int rollno = res.getInt("Roll_No");

int Emarks = res.getInt("External_Marks");

System.out.println("\n\tDepartment:"+

department +"Roll No:"+rollno+

"\tExternal Marks:"+Emarks+"\n");

}

System.out.println("\n\t-------------------------------------

------------------------------\n");

break;

case 4:

q="SELECT * FROM students LEFT OUTER JOIN marks ON students.Roll_No=marks.Roll_No UNION SELECT * FROM students RIGHT OUTER JOIN marks ON

students.Roll_No=marks.Roll_No;";

res=st.executeQuery(q);

System.out.println("\n\t---------------------------------

----------------------------------");

System.out.println("\n\t\t\t\tRECORDS"); System.out.println("\n\t------------------------------------

-------------------------------\n");

while (res.next())

{

int rollno = res.getInt("Roll_No");

String name = res.getString("Name");

int Imarks = res.getInt("Internal_Marks");

int Emarks = res.getInt("External_Marks");

System.out.println("\n\tRoll No:"+rollno+ "\tName:"+name+"\tInt_marks:"

+Imarks+"\tEx_marks:"+Emarks+"\n");

}

System.out.println("\n\t-----------------------------------

--------------------------------\n");

break;

case 5: break;

}

}while(ch!=5);

break;

case 4: System.exit(0);

}

}while(ch!=4);

}

catch(SQLException se)

{

System.out.print("\nCreated error is:\n"+se+"\n");

}

catch (Exception e)

{

System.out.print("\nCreated error is:\n"+e+"\n");

}

/*------------------------------------------------------------------------------------------------------

OUTPUT

In mysql -Server ;-

mysql> create database studinfo;

Query OK, 1 row affected (0.00 sec)

On Terminal-client:-

gescoe@gescoe:~/Desktop$ export CLASSPATH=$CLASSPATH:/usr/share/java/mysql-connector-java.jar

gescoe@gescoe:~/Desktop$ javac Javasql1.java

gescoe@gescoe:~/Desktop$ java Javasql1

---------MENU---------

1.Create Tables

2.Insert Records

3.Joins

4.Exit

Enter your choice:

Creating two table:student and marks

'students' and 'marks'table Successfully created

---------MENU---------

1.Create Tables

2.Insert Records

3.Joins

4.Exit

Enter your choice:

Inserted records into the tables 'students' and 'marks' successfully...

---------MENU---------

1.Create Tables

2.Insert Records

3.Joins

4.Exit

Enter your choice:

-------Joins-------

1.INNER JOIN

2.LEFT OUTER JOIN

3.RIGHT OUTER JOIN

4.FULL OUTER JOIN

5.Exit

Enter your choice:

------------------------------------------------------------------------------------

RECORDS

------------------------------------------------------------------------------------

Roll No:103 Name:Nishi Department:Computer

Roll No:174 Name:Anushka Department:Computer

Roll No:115 Name:Anuja Department:IT

------------------------------------------------------------------------------------

-------Joins-------

1.INNER JOIN

2.LEFT OUTER JOIN

3.RIGHT OUTER JOIN

4.FULL OUTER JOIN

5.Exit

Enter your choice:

-------------------------------------------------------------------------------

RECORDS

-------------------------------------------------------------------------------

Roll No:103 Name:Nishi Internal_Marks:38

Roll No:174 Name:Anushka Internal_Marks:43

Roll No:115 Name:Anuja Internal_Marks:30

Roll No:101 Name:Shubha Internal_Marks:0

Roll No:112 Name:Rohini Internal_Marks:0

-------------------------------------------------------------------------------

-------Joins-------

1.INNER JOIN

2.LEFT OUTER JOIN

3.RIGHT OUTER JOIN

4.FULL OUTER JOIN

5.Exit

Enter your choice:

------------------------------------------------------------------------------------------------

RECORDS

------------------------------------------------------------------------------------------------

Department:Computer Roll No:103 External Marks:43

Department:Computer Roll No:174 External Marks:45

Department:IT Roll No:115 External Marks:34

Department:null Roll No:133 External Marks:39

Department:null Roll No:111 External Marks:41

------------------------------------------------------------------------------------------------

-------Joins-------

1.INNER JOIN

2.LEFT OUTER JOIN

3.RIGHT OUTER JOIN

4.FULL OUTER JOIN

5.Exit

Enter your choice:

--------------------------------------------------------------------------------------------------

RECORDS

--------------------------------------------------------------------------------------------------

Roll No:103 Name:Nishi Int_marks:38 Ex_marks:43

Roll No:174 Name:Anushka Int_marks:43 Ex_marks:45

Roll No:115 Name:Anuja Int_marks:30 Ex_marks:34

Roll No:101 Name:Shubha Int_marks:0 Ex_marks:0

Roll No:112 Name:Rohini Int_marks:0 Ex_marks:0

Roll No:0 Name:null Int_marks:35 Ex_marks:39

Roll No:0 Name:null Int_marks:40 Ex_marks:41

---------------------------------------------------------------------------------------------------

-------Joins-------

1.INNER JOIN

2.LEFT OUTER JOIN

3.RIGHT OUTER JOIN

4.FULL OUTER JOIN

5.Exit

Enter your choice:

---------MENU---------

1.Create Tables

2.Insert Records

3.Joins

4.Exit

Enter your choice:

gescoe@gescoe:~/Desktop$ */

===============================

Practical: A3 Two tier client server mysql

===============================

/************ ON SERVER PC ****************/

gescoe@gescoe:~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 38
Server version: 5.5.38-0ubuntu0.14.04.1 (Ubuntu)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| DMSA               |
| T4                 |
| TE4                |
| Te40               |
| mysql              |
| performance_schema |
+--------------------+
7 rows in set (0.03 sec)

mysql> use TE4
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

mysql> show tables;
+---------------+
| Tables_in_TE4 |
+---------------+
| PLI           |
| Student       |
| cdept         |
| compdept      |
| stud          |
+---------------+
5 rows in set (0.00 sec)

mysql> select * from Student;
+--------+--------+------------+---------+
| Rollno | Name   | Branch     | Percent |
+--------+--------+------------+---------+
|      2 | ANUSHA | IT         |      75 |
|      3 | Veena | Mechanical |      60 |
|      4 | ANUSHA | Computer   |      60 |
|      5 | Sahil | Civil      |      60 |
+--------+--------+------------+---------+
4 rows in set (0.00 sec)

mysql> create view cd1 as select Rollno,Name,Percent from Student where Branch='Computer';    //create view "cd1"
Query OK, 0 rows affected (0.04 sec)

mysql> select * from cd1;       //display entries
+--------+--------+---------+
| Rollno | Name   | Percent |
+--------+--------+---------+
|      4 | ANUSHA |      60 |
+--------+--------+---------+
1 row in set (0.00 sec)

mysql> select * from cd1;   //display table cd1 after performing various operations by client pc
Empty set (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| DMSA               |
| T4                 |
| TE4                |
| Te40               |
| mysql              |
| performance_schema |
+--------------------+
7 rows in set (0.03 sec)

mysql> use TE4;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

mysql> show tables;
+---------------+
| Tables_in_TE4 |
+---------------+
| PLI           |
| REGISTRATION |
| Student       |
| cd            |
| cd1           |
| cdept         |
| compdept      |
| stud          |
+---------------+
8 rows in set (0.00 sec)

mysql> create index cdindx on Student (Name);       //create INDEX on coloumn 'Name'
Query OK, 0 rows affected (0.18 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql>

/************** CLIENT **************************/

gescoe@gescoe:~$ mysql -u userall -h 192.168.2.223
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 40
Server version: 5.5.38-0ubuntu0.14.04.1 (Ubuntu)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| DMSA               |
| T4                 |
| TE4                |
| Te40               |
| mysql              |
| performance_schema |
+--------------------+
7 rows in set (0.00 sec)

mysql> use TE4
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

mysql> show tables;
+---------------+
| Tables_in_TE4 |
+---------------+
| PLI           |
| Student       |
| cd            |
| cd1           |
| cdept         |
| compdept      |
| stud          |
+---------------+
7 rows in set (0.00 sec)

mysql> select * from cd1;
+--------+--------+---------+
| Rollno | Name   | Percent |
+--------+--------+---------+
|      4 | ANUSHA |      60 |
+--------+--------+---------+
1 row in set (0.00 sec)

mysql> update cd1 set Name='Navin' where Name='Anusha'; //UPDATE
Query OK, 1 row affected (0.04 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select * from cd1;
+--------+-------+---------+
| Rollno | Name | Percent |
+--------+-------+---------+
|      4 | Navin |      60 |
+--------+-------+---------+
1 row in set (0.00 sec)

mysql> delete from cd1 where Rollno=4; //DELETE
Query OK, 1 row affected (0.05 sec)

mysql> select * from cd1;
Empty set (0.00 sec)

===============================

Practical: A4 i-node

===============================

/*-------------------------------------------------------------------------------
Assigment no. :04
Group :A
Title :Write a program in Python/C++ to read display the i-node information for a given text file,
    image file.
Roll No. :
Batch :
------------------------------------------------------------------------------- */

#include<iostream>
#include<fstream>
#include<sys/stat.h>
using namespace std;
class osd1
{
    private:
        char filename[20];
        struct stat buf;
    public:

        void get_filename()
        {
            cout<<"\n\t Enter the name of file : ";
            cin>>filename;
        }

        void create_file()
        {
            ofstream write(filename);
            if(write.is_open())
            {
                cout<<"\n\n\t File "<<filename<<" has been created successfully..\n\n";
                write.close();
            }
            else
            {
                cout<<"\n\n\t File "<<filename<<" has been not created..\n\n";
            }
        }

        void display_data()
        {
            cout<<"\n\t--------------------------";
            cout<<"\n\t     FILE DETAILS....";
            cout<<"\n\t--------------------------";
            cout<<"\n\n\t Name : "<<filename;
            stat(filename,&buf);
            cout<<"\n\t Inode : "<<buf.st_ino;
            cout<<"\n\t Size : "<<buf.st_size<<"\n\n";
        }
};
int main()
{
    osd1 o;
    o.get_filename();
    o.create_file();
    o.display_data();
    return 0;
}

/*
-----------------------------------------
       OUTPUT
-----------------------------------------

administrator@administrator-Vostro-230:~$ cd Desktop/TE_73/
administrator@administrator-Vostro-230:~/Desktop/TE_73$ g++ osd1.cpp -o osd1
administrator@administrator-Vostro-230:~/Desktop/TE_73$ ./osd1

    Enter the name of file : navin

    File navin has been created successfully..

    --------------------------
         FILE DETAILS....
    --------------------------

    Name : navin
    Inode : 18612477
    Size : 0

administrator@administrator-Vostro-230:~/Desktop/TE_73$ stat navin
File: `navin'
Size: 0             Blocks: 0          IO Block: 4096   regular empty file
Device: 801h/2049d    Inode: 18612477    Links: 1
Access: (0664/-rw-rw-r--) Uid: ( 1000/administrator)   Gid: ( 1000/administrator)
Access: 2014-07-01 11:18:12.956589503 +0530
Modify: 2014-07-01 11:18:11.840589506 +0530
Change: 2014-07-01 11:18:11.840589506 +0530
Birth: -
administrator@administrator-Vostro-230:~/Desktop/TE_73$

*/

===============================

Practical: A5 IPC Program using pipe

===============================

-------------------------------------------------------------------------------
Assigment no. :05
Group :A
Title :Write an IPC program using pipe. Process A accepts a character string and Process B
    inverses the string. Pipe is used to establish communication between A and B processes
    using Python or C++
Roll No. :
Batch :
-------------------------------------------------------------------------------

**** processA.py ******

import os
wfpath="./p1"
rfpath="./p1"
wp=open(wfpath,'w')
wp.write("hello")
wp.close
rp=open(rfpath,'r')
response=rp.read()
print"Reverse of string from process B : %s"%response

***** processB.py *****

import os
rfpath="./p1"
wfpath="./p2"
try:
    os.mkfifo(wfpath)
    os.mkfifo(rfpath)
except OSError:
    pass
rp=open(rfpath,'r')
response=rp.read()
print"String recieved from Process A : %s"%response
s=response
s=s[::-1]
print"Reverse is :%s"%s
rp.close()
wp=open(wfpath,'w')
wp.write(s)
wp.close()
rp.close()

****input : p1.txt ****

hello

----------------------------------------------------
        OUTPUT
----------------------------------------------------

navin@Navin:~/Desktop$ python processA.py
Reverse of string from process B :
navin@Navin:~/Desktop$ python processB.py
String recieved from Process A : hello
Reverse is :olleh

===============================

Practical: A6

===============================

server

# Server program
from socket import *

# Set the socket parameters

host = "192.168.1.72"
port = 8080
buf = 1024
addr = (host,port)
# Create socket and bind to address

UDPSock = socket(AF_INET,SOCK_DGRAM)
UDPSock.bind(addr)
# Receive messages

while 1:
   data,addr = UDPSock.recvfrom(buf)
   if not data:
       print "Client has exited!"
       break
   else:
       print "Received message '", data,"'"
# Close socket

UDPSock.close()

client

# Client program
from socket import *

# Set the socket parameters

host = "localhost"
port = 21567
buf = 1024
addr = (host,port)
# Create socket

UDPSock = socket(AF_INET,SOCK_DGRAM)
def_msg = "===Enter message to send to server===";

print "",def_msg
# Send messages

while (1):
    data = raw_input('>> ')
    if not data:
        break
    else:
        if(UDPSock.sendto(data,addr)):
            print "Sending message '",data,"'....."
# Close socket

UDPSock.close()

===============================

Practical: b1 Three tier mysql

===============================

//PROGRAM:

import java.lang.*;

import java.sql.*;

import java.io.*;

public class Javasql

{

public static void main(String[] args)

{

int ch;

String q;

BufferedReader input = new BufferedReader(new InputStreamReader(System.in));

String url = "jdbc:mysql://localhost/";

String driver = "com.mysql.jdbc.Driver";

String dbName = "company";

String userName = "root";

String password="gescoe";

try{

Connection conn = DriverManager.getConnection(url+dbName,userName,password);

Statement st = conn.createStatement();

{

System.out.println("\n---------MENU---------");

System.out.println("\n1.Create Table");

System.out.println("\n2.Insert Records");

System.out.println("\n3.Select Table");

System.out.println("\n4.Update record");

System.out.println("\n5.Aggregation Function for Table");

System.out.println("\n6.Delete records");

System.out.println("\n7.Drop Table");

System.out.println("\n8.Exit");

System.out.println("\n\nEnter your choice:");

ch=Integer.parseInt(input.readLine());

switch(ch)

{

case 1:

q="CREATE TABLE products(productID INT PRIMARY KEY, Name VARCHAR(15),Quantity INT,Price DECIMAL(7,2))";

st.executeUpdate(q);

System.out.println("\n'products' table Successfully created\n");

break;

case 2:

q = "INSERT INTO products"+" VALUES(1351,'Monitor',2000,10000)";

st.executeUpdate(q);

q = "INSERT INTO products"+" VALUES(1352,'Keyboard',2000,3000);";

st.executeUpdate(q);

q = "INSERT INTO products "+"VALUES(1353,'CPU',5600,8000);";

st.executeUpdate(q);

q = "INSERT INTO products "+"VALUES(1354,'Harddisk',500,3000);";

st.executeUpdate(q);

q = "INSERT INTO products "+"VALUES(1355,'USB',1500,500);";

st.executeUpdate(q);

System.out.println("\nRecords inserted into the table 'products'...\n");

break;

case 3:

ResultSet res = st.executeQuery("SELECT * FROM products");

System.out.println("\n\nTable:product\n");

System.out.println("\n\t-----------------------------------------------------------");

System.out.println("\n\t\t\t\tRECORDS");

System.out.println("\n\t---------------------------------------------------------\n");

while (res.next()) {

int id = res.getInt("productID");

String name = res.getString("Name");

int quan = res.getInt("Quantity");

int price = res.getInt("Price");

System.out.println("\n\tProductID:"+id+"\t\tName:"+name+ "\tQuantity:"+quan+"\tPrice:"+price+"\n");

}

System.out.println("\n\t--------------------------------------------------------\n");

break;

case 4:

q ="UPDATE products SET Price=10000 where Name='CPU'; ";

st.executeUpdate(q);

System.out.println("\nRecord is updated where Name='CPU'");

break;

case 5:

do{

System.out.println("\n\n------Aggregation Functions------\n");

System.out.println("\n1.count()");

System.out.println("\n2.sum()");

System.out.println("\n3.max()");

System.out.println("\n4.min()");

System.out.println("\n5.avg()");

System.out.println("\n6.Exit");

System.out.println("\n\nEnter your choice:");

ch=Integer.parseInt(input.readLine());

switch(ch)

{

case 1:

q="SELECT count(Name) as 'Total products' FROM products;";

res=st.executeQuery(q);

while (res.next())

{

int total = res.getInt("Total Products");

System.out.println("\n\tTotal products is:"+total+"\n");

}

break;

case 2:

q="SELECT sum(Quantity)as 'Total Quantity' FROM products;";

res=st.executeQuery(q);

while (res.next())

{

int total = res.getInt("Total Quantity");

System.out.println("\n\tTotal products Quantity:" +total+"\n");

}

break;

case 3:

q="SELECT * FROM products WHERE Quantity= (SELECT max(Quantity) FROM products);";

res=st.executeQuery(q);

System.out.println("\n\t---------------------------------------------------");

System.out.println("\n\t\t\t\tRECORDS");

System.out.println("\n\t------------------------------------------------\n");

while (res.next())

{

int id = res.getInt("productID");

String name = res.getString("Name");

int quan = res.getInt("Quantity");

int price = res.getInt("Price");

System.out.println("\n\tProductID:"+id+"\t\tName:" +name+"\tQuantity:"+quan+"\tPrice:"+price+"\n");

}

System.out.println("\n\t-------------------------------------------------\n");

break;

case 4:

q="SELECT * FROM products WHERE Price=(SELECT min(Price) FROM products);";

res=st.executeQuery(q);

System.out.println("\n\t--------------------------------------------------");

System.out.println("\n\t\t\t\tRECORDS");

System.out.println("\n\t-------------------------------------------------\n");

while (res.next())

{

int id = res.getInt("productID");

String name = res.getString("Name");

int quan = res.getInt("Quantity");

int price = res.getInt("Price");

System.out.println("\n\tProductID:"+id+"\t\tName:"+name+ "\tQuantity:"+quan+"\tPrice:"+price+"\n");

}

System.out.println("\n\t-------------------------------------------------\n");

break;

case 5:

q="SELECT DISTINCT Name FROM products WHERE Price>(SELECT AVG(Price) FROM products);";

res=st.executeQuery(q);

System.out.println("\n\t---------------------------------------------------");

System.out.println("\n\t\t\t\tRECORDS");

System.out.println("\n\t-------------------------------------------------\n");

while (res.next())

{

String name = res.getString("Name");

System.out.println("\n\tName:"+name+"\n");

}

System.out.println("\n\t-------------------------------------------------\n");

break;

case 6: break;

}

}while(ch!=6);

break;

case 6:

q="DELETE FROM products;";

st.executeUpdate(q);

System.out.println("\n'products' table is empty...\n");

break;

case 7:

q="DROP TABLE products;";

st.executeUpdate(q);

System.out.println("\n 'products' table are deleted successfully...\n");

break;

case 8: System.exit(0);

}

}while(ch!=8);

}

catch(SQLException se)

{

System.out.print("\nCreated error is:\n"+se+"\n");

}

catch (Exception e)

{

System.out.print("\nCreated error is:\n"+e+"\n");

}

/*--------------------------------------------------------------------------------------------------------------

OUTPUT:

gescoe@gescoe:~/Desktop$ export CLASSPATH=$CLASSPATH:/usr/share/java/mysql-connector-java.jar

gescoe@gescoe:~/Desktop$ javac Javasql.java

gescoe@gescoe:~/Desktop$ java Javasql

---------MENU---------

1.Create Table

2.Insert Records

3.Select Table

4.Update record

5.Aggregation Function for Table

6.Delete records

7.Drop Table

8.Exit

Enter your choice:

'products' table Successfully created

---------MENU---------

1.Create Table

2.Insert Records

3.Select Table

4.Update record

5.Aggregation Function for Table

6.Delete records

7.Drop Table

8.Exit

Enter your choice:

Records inserted into the table 'products'...

---------MENU---------

1.Create Table

2.Insert Records

3.Select Table

4.Update record

5.Aggregation Function for Table

6.Delete records

7.Drop Table

8.Exit

Enter your choice:

Table:product

----------------------------------------------------------------------------------------------------------

RECORDS

---------------------------------------------------------------------------------------------------------

Product ID:1351 Name:Monitor Quantity:2000 Price:10000

Product ID:1352 Name:Keyboard Quantity:2000 Price:3000

Product ID:1353 Name:CPU Quantity:5600 Price:8000

Product ID:1354 Name:Harddisk Quantity:500 Price:3000

Product ID:1355 Name:USB Quantity:1500 Price:500

---------------------------------------------------------------------------------------------------------

---------MENU---------

1.Create Table

2.Insert Records

3.Select Table

4.Update record

5.Aggregation Function for Table

6.Delete records

7.Drop Table

8.Exit

Enter your choice:

Record is updated where Name='CPU'

---------MENU---------

1.Create Table

2.Insert Records

3.Select Table

4.Update record

5.Aggregation Function for Table

6.Delete records

7.Drop Table

8.Exit

Enter your choice:

------Aggregation Functions------

1.count()

2.sum()

3.max()

4.min()

5.avg()

6.Exit

Enter your choice:

Total products is:5

------Aggregation Functions------

1.count()

2.sum()

3.max()

4.min()

5.avg()

6.Exit

Enter your choice:

Total products Quantity:11600

------Aggregation Functions------

1.count()

2.sum()

3.max()

4.min()

5.avg()

6.Exit

Enter your choice:

------------------------------------------------------------------------------------------

RECORDS

------------------------------------------------------------------------------------------

Product ID:1353 Name:CPU Quantity:5600 Price:10000

------------------------------------------------------------------------------------------

------Aggregation Functions------

1.count()

2.sum()

3.max()

4.min()

5.avg()

6.Exit

Enter your choice:

--------------------------------------------------------------------------------------

RECORDS

--------------------------------------------------------------------------------------

Product ID:1355 Name:USB Quantity:1500 Price:500

--------------------------------------------------------------------------------------

------Aggregation Functions------

1.count()

2.sum()

3.max()

4.min()

5.avg()

6.Exit

Enter your choice:

-------------------------------------------------------------------

RECORDS

-------------------------------------------------------------------

Name:Monitor

Name:CPU

-------------------------------------------------------------------

------Aggregation Functions------

1.count()

2.sum()

3.max()

4.min()

5.avg()

6.Exit

Enter your choice:

---------MENU---------

1.Create Table

2.Insert Records

3.Select Table

4.Update record

5.Aggregation Function for Table

6.Delete records

7.Drop Table

8.Exit

Enter your choice:

'products' table is empty...

---------MENU---------

1.Create Table

2.Insert Records

3.Select Table

4.Update record

5.Aggregation Function for Table

6.Delete records

7.Drop Table

8.Exit

Enter your choice:

'products' table are deleted successfully...

---------MENU---------

1.Create Table

2.Insert Records

3.Select Table

4.Update record

5.Aggregation Function for Table

6.Delete records

7.Drop Table

8.Exit

Enter your choice:

gescoe@gescoe:~/Desktop$

===============================

Practical: B2 mongodb basics

===============================

gescoe@gescoe:~$ mongo
MongoDB shell version: 2.6.4
connecting to: test

> show dbs                        //Show database
TE     0.078GB
admin (empty)
local 0.078GB
test   0.078GB

> use PN                        //create/use databases
switched to db PN

> db                            //to check working database
PN

------------------------------------------------------------------------------

> db.movie.insert({"name":"Pranav"})            //create collection while inserting data
WriteResult({ "nInserted" : 1 })

> show dbs
PN     0.078GB
TE     0.078GB
admin (empty)
local 0.078GB
test   0.078GB

> db.createCollection("PRNV")                //create collection
{ "ok" : 1 }

> show collections                    //display collections
PRNV
movie
system.indexes

------------------------------------------------------------------------------

> db.movie.drop()                    //drop collections
true

> show collections                    //display collections
PRNV
system.indexes

------------------------------------------------------------------------------

> db.PRNV.insert({Name: 'NAVIN WAGHWANI',Rno:73,Branch:'Computer' })    //insert entries in collection
WriteResult({ "nInserted" : 1 })

> db.PRNV.insert({Name: 'PRANAV LAWATE',Rno:40,Branch:'IT' })
WriteResult({ "nInserted" : 1 })

> db.PRNV.insert({Name: 'ANUSHA PINGALE',Rno:60,Branch:'MECH' })
WriteResult({ "nInserted" : 1 })

------------------------------------------------------------------------------

> db.PRNV.find()                    //display all records
{ "_id" : ObjectId("541419673a244ede65d8482c"), "Name" : "NAVIN WAGHWANI", "Rno" : 73, "Branch" : "Computer" }
{ "_id" : ObjectId("541419873a244ede65d8482d"), "Name" : "PRANAV LAWATE", "Rno" : 40, "Branch" : "IT" }
{ "_id" : ObjectId("541419aa3a244ede65d8482e"), "Name" : "ANUSHA PINGALE", "Rno" : 60, "Branch" : "MECH" }

------------------------------------------------------------------------------

> db.PRNV.update({'Branch':'IT'},{$set:{'Branch':'Computer'}})        //Update using same fields
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })

> db.PRNV.find()
{ "_id" : ObjectId("541419673a244ede65d8482c"), "Name" : "NAVIN WAGHWANI", "Rno" : 73, "Branch" : "Computer" }
{ "_id" : ObjectId("541419873a244ede65d8482d"), "Name" : "PRANAV LAWATE", "Rno" : 40, "Branch" : "Computer" }
{ "_id" : ObjectId("541419aa3a244ede65d8482e"), "Name" : "ANUSHA PINGALE", "Rno" : 60, "Branch" : "MECH" }

> db.PRNV.update({'Name':'NAVIN WAGHWANI'},{$set:{'Branch':'Mechanical'}})        //Update using different fileds
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })

> db.PRNV.find()
{ "_id" : ObjectId("541419673a244ede65d8482c"), "Name" : "NAVIN WAGHWANI", "Rno" : 73, "Branch" : "Mechanical" }
{ "_id" : ObjectId("541419873a244ede65d8482d"), "Name" : "PRANAV LAWATE", "Rno" : 40, "Branch" : "Computer" }
{ "_id" : ObjectId("541419aa3a244ede65d8482e"), "Name" : "ANUSHA PINGALE", "Rno" : 60, "Branch" : "MECH" }

------------------------------------------------------------------------------

> db.PRNV.remove({'Rno':60})                        //Remove entry
WriteResult({ "nRemoved" : 1 })

> db.PRNV.find()
{ "_id" : ObjectId("541419673a244ede65d8482c"), "Name" : "NAVIN WAGHWANI", "Rno" : 73, "Branch" : "Computer" }
{ "_id" : ObjectId("541419873a244ede65d8482d"), "Name" : "PRANAV LAWATE", "Rno" : 40, "Branch" : "Computer" }

> db.PRNV.find().pretty()
{
    "_id" : ObjectId("541419673a244ede65d8482c"),
    "Name" : "NAVIN WAGHWANI",
    "Rno" : 73,
    "Branch" : "Computer"
}
{
    "_id" : ObjectId("541419873a244ede65d8482d"),
    "Name" : "PRANAV LAWATE",
    "Rno" : 40,
    "Branch" : "Computer"
}

===============================

Practical: B5 BIOS

===============================

-------------------------------------------------------------------------------
Assigment no. :05
Group :B
Title :Write a program in Python/C++ to test that computer is booted with Legacy Boot ROM-
    BIOS or UEFI.
Roll No. :
Batch :
-------------------------------------------------------------------------------

#include <iostream>
#include <stdlib.h>
#include <sys/stat.h>

using namespace std;

int main()
{
    cout<<"\n\nHARDWARE BOOTED FROM...\n\n";
    system("[ -d /sys/firmware/efi ] && echo UEFI || echo BIOS");
    return 0;
}

/***** OUTPUT *****

root@administrator-Vostro-230:/home/administrator/Desktop# g++ bios.cpp -o bios.o
root@administrator-Vostro-230:/home/administrator/Desktop# ./bios.o

HARDWARE BOOTED FROM...

BIOS

*/

===============================

Practical: B6 RAMDRIVE

===============================

-------------------------------------------------------------------------------
Assigment no. :06
Group :B
Title :Write a program in C++ to create a RAMDRIVE and associate an acyclic directory structure
to it. Use this RAMDRIVE to store input, out files to run a calculator program.
Roll No. :
Batch :
-------------------------------------------------------------------------------

** calc.cpp *

#include<iostream>
using namespace std;
int main()
{
    float no1,no2,res;
    int ch;
    cout<<"\n-----------------------------------------------------------";
    cout<<"\n\n\t\t ***** CALCULATOR *****";
    cout<<"\n-----------------------------------------------------------";
    cout<<"\n\n\t Enter first number : ";
    cin>>no1;
    cout<<"\n\n\t Enter second number : ";
    cin>>no2;
    do
    {
        cout<<"\n\n\t\t ***** MENU *****";
        cout<<"\n\n\t 1]. Addition";
        cout<<"\n\t 2]. Subtraction";
        cout<<"\n\t 3]. Multilication";
        cout<<"\n\t 4]. Division";
        cout<<"\n\t 5]. Mod";
        cout<<"\n\t 6]. Exit";
        cout<<"\n\n\t\t Enter your choice : ";
        cin>>ch;
        switch(ch)
        {
            case 1: res=no1+no2;
                cout<<"\n\t Addition of two numbers is : "<<res;
                break;
            case 2: res=no1-no2;
                cout<<"\n\t Subtraction of two numbers is : "<<res;
                break;
            case 3: res=no1*no2;
                cout<<"\n\t Multiplication of two numbers is : "<<res;
                break;
            case 4: res=no1/no2;
                cout<<"\n\t Division of two numbers is : "<<res;
                break;
            case 5: res=no1%no2;
                cout<<"\n\t Modulus of two numbers is : "<<res;
                break;
            case 6:return 1;
                break;
        }
    }while(ch!=6);
    return 0;
}

navin.cpp

#include <iostream>
#include <stdlib.h>
using namespace std;
int main()
{
    system("sudo mkdir -p /media/rdcal123");
    system("sudo mount -t tmpfs -o size=512M tmpfs /media/rdcal123");
    system("sudo cp /home/administrator/Desktop/calc.cpp /media/rdcal123/");
    system("sudo g++ calc.cpp -o a.o");
    system("./a.o");
return 0;
}

/*========= OUTPUT ==========

root@administrator-Vostro-230:/home/administrator/Desktop# g++ navin.cpp -o navin.o
root@administrator-Vostro-230:/home/administrator/Desktop# ./navin.o
calc.cpp: In function ‘int main()’:
calc.cpp:39:20: error: invalid operands of types ‘float’ and ‘float’ to binary ‘operator%’

-----------------------------------------------------------

        ***** CALCULATOR *****
-----------------------------------------------------------

    Enter first number : 5

    Enter second number : 2

        ***** MENU *****

    1]. Addition
    2]. Subtraction
    3]. Multilication
    4]. Division
    5]. Mod
    6]. Exit

        Enter your choice : 1

    Addition of two numbers is : 7

        ***** MENU *****

    1]. Addition
    2]. Subtraction
    3]. Multilication
    4]. Division
    5]. Mod
    6]. Exit

        Enter your choice : 2

    Subtraction of two numbers is : 3

        ***** MENU *****

    1]. Addition
    2]. Subtraction
    3]. Multilication
    4]. Division
    5]. Mod
    6]. Exit

        Enter your choice : 3

    Multiplication of two numbers is : 10

        ***** MENU *****

    1]. Addition
    2]. Subtraction
    3]. Multilication
    4]. Division
    5]. Mod
    6]. Exit

        Enter your choice : 4

    Division of two numbers is : 2.5

        ***** MENU *****

    1]. Addition
    2]. Subtraction
    3]. Multilication
    4]. Division
    5]. Mod
    6]. Exit

        Enter your choice : 5

        ***** MENU *****

    1]. Addition
    2]. Subtraction
    3]. Multilication
    4]. Division
    5]. Mod
    6]. Exit

        Enter your choice : 6
root@administrator-Vostro-230:/home/administrator/Desktop#

*/

===============================

Practical: B12 USB Device bootable

===============================

-------------------------------------------------------------------------------

Assigment no. :12

Group :B

Title :Write a program in C++ to make USB Device Bootable by installing required system files.

Roll No. :

Batch :

-------------------------------------------------------------------------------

#include <iostream>

#include <stdlib.h>

#include <sys/stat.h>

using namespace std;

int main()

{

char Ans;

int N;

re: cout<<"\n\nPlease Insert The Pendrive Now...";

cout<<"\n\nHave You Inserted The Pendrive ? [Y/N]";

cin>>Ans;

if(Ans=='y' || Ans=='Y')

{

system("sudo lsusb");

cout<<"\n\nIs The Pendrive Visible ? [Y/N]";

cin>>Ans;

if(Ans=='y' || Ans=='Y')

{

cout<<"\n\nEntering Root Mode...\n\n";

cout<<"\n\nCopying System Files...\n\n";

system("sudo dd if=/home/gescoe/Documents/ubuntu.iso of=/dev/sdb && sync");

}

else

{

cout<<"\n\nPlease re-attach the pendrive and try again...\n\n";

goto re;

}

cout<<"\n\nAll Done! Ready To Boot...\n\n";

}

else

{

goto re;

}

return 0;

}

/***************** OUtput **************

root@gescoe:/home/gescoe/Desktop/pd_navin# g++ btpd.cpp -o btpd

root@gescoe:/home/gescoe/Desktop/pd_navin# ./btpd

Please Insert The Pendrive Now...

Have You Inserted The Pendrive ? [Y/N]y

Bus 002 Device 004: ID 0461:4e22 Primax Electronics, Ltd

Bus 002 Device 003: ID 413c:2107 Dell Computer Corp.

Bus 002 Device 006: ID 8644:800b

Bus 002 Device 002: ID 8087:0024 Intel Corp. Integrated Rate Matching Hub

Bus 002 Device 001: ID 1d6b:0002 Linux Foundation 2.0 root hub

Bus 001 Device 002: ID 8087:0024 Intel Corp. Integrated Rate Matching Hub

Bus 001 Device 001: ID 1d6b:0002 Linux Foundation 2.0 root hub

Is The Pendrive Visible ? [Y/N]y

Entering Root Mode...

Copying System Files...

2009088+0 records in

2009088+0 records out

1028653056 bytes (1.0 GB) copied, 4.31832 s, 238 MB/s

All Done! Ready To Boot...

root@gescoe:/home/gescoe/Desktop/pd_navin#

===============================

Practical: B mongodbaggregation

===============================

gescoe@gescoe:~$ mongo
MongoDB shell version: 2.6.4
connecting to: test
> show dbs;
admin     (empty)
computer 0.078GB
mymdb     0.078GB
t4        0.078GB
> use myddb
switched to db myddb
_____________________________________________________________________
CREATE COLLECTION:
____________________________________________________________________
CMD:db.createCollection("student");
{ "ok" : 1 }
CMD:
   db.student.insert({Rollno:1,name:'Navin ',subject:'DMSA',marks:78});
   WriteResult({ "nInserted" : 1 })
   db.student.insert({Rollno:2,name:'anusha',subject:'OSD',marks:75});
   WriteResult({ "nInserted" : 1 })
   db.student.insert({Rollno:3,name:'ravi',subject:'TOC',marks:69});
   WriteResult({ "nInserted" : 1 })
   db.student.insert({Rollno:4,name:'veena',subject:'TOC',marks:70});
   WriteResult({ "nInserted" : 1 })
_____________________________________________________________________
DISPALY RECORD:
_____________________________________________________________________
CMD: db.student.find();

{ "_id" : ObjectId("541bffb74ebca325353a6529"), "Rollno" : 1, "name" : "Navin", "subject" : "DMSA", "marks" : 78 }
{ "_id" : ObjectId("541bffd34ebca325353a652a"), "Rollno" : 2, "name" : "anusha", "subject" : "OSD", "marks" : 75 }
{ "_id" : ObjectId("541c00134ebca325353a652b"), "Rollno" : 3, "name" : "ravi", "subject" : "TOC", "marks" : 69 }
{ "_id" : ObjectId("541c00134ebca325353a652b"), "Rollno" : 4, "name" : "veena", "subject" : "TOC", "marks" : 70 }

CMD:db.student.find().pretty();
{
   "_id" : ObjectId("541bffb74ebca325353a6529"),
   "Rollno" : 1,
   "name" : "Navin",
   "subject" : "DMSA",
   "marks" : 78
}
{
   "_id" : ObjectId("541bffd34ebca325353a652a"),
   "Rollno" : 2,
   "name" : "anusha",
   "subject" : "OSD",
   "marks" : 75
}
{
   "_id" : ObjectId("541c00134ebca325353a652b"),
   "Rollno" : 3,
   "name" : "ravi",
   "subject" : "TOC",
   "marks" : 69
}
{
   "_id" : ObjectId("541e00134ebca325353a652b"),
   "Rollno" : 4,
   "name" : "veena",
   "subject" : "TOC",
   "marks" : 70
}
_______________________________________________________________________________
AGGREGATE FUNCTIONS:
__________________________________________________________________________________
MIN():
CMD: db.student.aggregate([{$group : {_id : "$subject", marks : {$min : "$marks"}}}]);

{ "_id" : "TOC", "marks" : 70 }
{ "_id" : "OSD", "marks" : 75 }
{ "_id" : "DMSA", "marks" : 78 }
_________________________________________________________________________________
MAX():
CMD:db.student.aggregate([{$group : {_id : "$subject", marks : {$max : "$marks"}}}]);

{ "_id" : "TOC", "marks" : 69 }
{ "_id" : "OSD", "marks" : 75 }
{ "_id" : "DMSA", "marks" : 78 }
_________________________________________________________________________________
SUM():
CMD:db.student.aggregate([{$group : {_id : "$subject", marks : {$sum : "$marks"}}}]);
{ "_id" : "TOC", "marks" : 139 }
{ "_id" : "OSD", "marks" : 75 }
{ "_id" : "DMSA", "marks" : 78 }
__________________________________________________________________________________
AVG():
CMD:db.student.aggregate([{$group : {_id : "$subject", marks : {$avg : "$marks"}}}]);
{ "_id" : "TOC", "marks" : 69.5 }
{ "_id" : "OSD", "marks" : 75 }
{ "_id" : "DMSA", "marks" : 78 }
___________________________________________________________________________________
FIRST():
CMD:db.student.aggregate([{$group : {_id : "$subject", marks : {$first : "$marks"}}}]);
{ "_id" : "TOC", "marks : 69 }
{ "_id" : "OSD", "marks" : 75 }
{ "_id" : "DMSA", "marks" : 78 }
___________________________________"______________________________________________
LAST():
CMD:db.student.aggregate([{$group : {_id : "$subject", marks : {$last : "$marks"}}}]);
{ "_id" : "TOC", "marks" : 70 }
{ "_id" : "OSD", "marks" : 75 }
{ "_id" : "DMSA", "marks" : 78 }
___________________________________________________________________________________

===============================

Practical: B mongodb indexing

===============================

gescoe@gescoe:~$ mongo
MongoDB shell version: 2.6.4
connecting to: test
> show dbs
TE        0.078GB
admin     (empty)
computer 0.078GB
gj        0.078GB
local     0.078GB
mydb      0.078GB
mymdb     0.078GB
t4        0.078GB
> use mydb
switched to db mydb

//CREATE COLLECTION:
> db.createCollection("student");
{ "ok" : 1 }
> db.student.insert({Rollno:1,name:'nikita',subject:'DMSA',marks:78});
WriteResult({ "nInserted" : 1 })
> db.student.insert({Rollno:2,name:'kiran',subject:'OSD',marks:75});
WriteResult({ "nInserted" : 1 })
> db.student.insert({Rollno:3,name:'komal',subject:'TOC',marks:69});
WriteResult({ "nInserted" : 1 })
> db.student.insert({Rollno:4,name:'snehal',subject:'TOC',marks:81});
WriteResult({ "nInserted" : 1 })
> db.student.insert({Rollno:5,name:'saurabh',subject:'TOC',marks:78});
WriteResult({ "nInserted" : 1 })

//DISPLAY COLLECTION:
> db.student.find();
{ "_id" : ObjectId("541bffb74ebca325353a6529"), "Rollno" : 1, "name" : "nikita", "subject" : "DMSA", "marks" : 78 }
{ "_id" : ObjectId("541bffd34ebca325353a652a"), "Rollno" : 2, "name" : "kiran", "subject" : "OSD", "marks" : 75 }
{ "_id" : ObjectId("541c00134ebca325353a652b"), "Rollno" : 3, "name" : "komal", "subject" : "TOC", "marks" : 69 }
{ "_id" : ObjectId("541c00274ebca325353a652c"), "Rollno" : 4, "name" : "snehal", "subject" : "TOC", "marks" : 81 }
{ "_id" : ObjectId("541c007c4ebca325353a652d"), "Rollno" : 5, "name" : "saurabh", "subject" : "TOC", "marks" : 78 }

> db.student.find().pretty();
{
    "_id" : ObjectId("541bffb74ebca325353a6529"),
    "Rollno" : 1,
    "name" : "nikita",
    "subject" : "DMSA",
    "marks" : 78
}
{
    "_id" : ObjectId("541bffd34ebca325353a652a"),
    "Rollno" : 2,
    "name" : "kiran",
    "subject" : "OSD",
    "marks" : 75
}
{
    "_id" : ObjectId("541c00134ebca325353a652b"),
    "Rollno" : 3,
    "name" : "komal",
    "subject" : "TOC",
    "marks" : 69
}

{
    "_id" : ObjectId("541c0e05a8dc3dd4fa9f859e"),
    "Rollno" : 4,
    "name" : "snehal",
    "subject" : "TOC",
    "marks" : 81
}
{
    "_id" : ObjectId("541c0e2ca8dc3dd4fa9f85a1"),
    "Rollno" : 5,
    "name" : "saurabh",
    "subject" : "TOC",
    "marks" : 78
}

//USING ENSURE INDEX
> db.student.ensureIndex({Rollno:1});
{ "numIndexesBefore" : 3, "note" : "all indexes already exist", "ok" : 1 }

//USING GET INDEX:
> db.student.getIndexes();
[
    {
        "v" : 1,
        "key" : {
            "_id" : 1
        },
        "name" : "_id_",
        "ns" : "mydb.student"
    },
    {
        "v" : 1,
        "key" : {
            "marks" : 1
        },
        "name" : "marks_1",
        "ns" : "mydb.student"
    },
    {
        "v" : 1,
        "key" : {
            "Rollno" : 1
        },
        "name" : "Rollno_1",
        "ns" : "mydb.student"
    }

// USING MINIMUM INDEX:
> db.student.find().min({Rollno:4});
{ "_id" : ObjectId("541c0e05a8dc3dd4fa9f859e"), "Rollno" : 4, "name" : "snehal", "subject" : "TOC", "marks" : 81 }
{ "_id" : ObjectId("541c0e05a8dc3dd4fa9f859f"), "Rollno" : 5, "name" : "saurabh", "subject" : "TOC", "marks" : 78 }

//USING MAXIMUM INDEX:
> db.student.find().max({Rollno:2});
{ "_id" : ObjectId("541c0cf4a8dc3dd4fa9f859b"), "Rollno" : 1, "name" : "nikita", "subject" : "DMSA", "marks" : 78 }

//USING MINIMUM INDEX:
> db.student.find().max({Rollno:3});
{ "_id" : ObjectId("541c0cf4a8dc3dd4fa9f859b"), "Rollno" : 1, "name" : "nikita", "subject" : "DMSA", "marks" : 78 }
{ "_id" : ObjectId("541c0d92a8dc3dd4fa9f859c"), "Rollno" : 2, "name" : "kiran", "subject" : "OSD", "marks" : 75 }

//USING MINIMUM INDEX:
> db.student.find().min({Rollno:2});
{ "_id" : ObjectId("541c0d92a8dc3dd4fa9f859c"), "Rollno" : 2, "name" : "kiran", "subject" : "OSD", "marks" : 75 }
{ "_id" : ObjectId("541c0ddca8dc3dd4fa9f859d"), "Rollno" : 3, "name" : "komal", "subject" : "TOC", "marks" : 69 }
{ "_id" : ObjectId("541c0e05a8dc3dd4fa9f859e"), "Rollno" : 4, "name" : "snehal", "subject" : "TOC", "marks" : 81 }
{ "_id" : ObjectId("541c0e05a8dc3dd4fa9f859f"), "Rollno" : 5, "name" : "saurabh", "subject" : "TOC", "marks" : 78 }

//SORT INDEX IN ASCENDING
> db.student.find().sort({Rollno:1}).pretty();
{
    "_id" : ObjectId("541c0cf4a8dc3dd4fa9f859b"),
    "Rollno" : 1,
    "name" : "nikita",
    "subject" : "DMSA",
    "marks" : 78
}
{
    "_id" : ObjectId("541c0d92a8dc3dd4fa9f859c"),
    "Rollno" : 2,
    "name" : "kiran",
    "subject" : "OSD",
    "marks" : 75
}
{
    "_id" : ObjectId("541c0ddca8dc3dd4fa9f859d"),
    "Rollno" : 3,
    "name" : "komal",
    "subject" : "TOC",
    "marks" : 69
}
{
    "_id" : ObjectId("541c0e05a8dc3dd4fa9f859e"),
    "Rollno" : 4,
    "name" : "snehal",
    "subject" : "TOC",
    "marks" : 81
}

{
    "_id" : ObjectId("541c0e2ca8dc3dd4fa9f85a1"),
    "Rollno" : 5,
    "name" : "saurabh",
    "subject" : "TOC",
    "marks" : 78
}

//SORTING IN DESCENDING
> db.student.find().sort({Rollno:-1}).pretty();

{
    "_id" : ObjectId("541c0e05a8dc3dd4fa9f859f"),
    "Rollno" : 5,
    "name" : "saurabh",
    "subject" : "TOC",
    "marks" : 78
}
{
    "_id" : ObjectId("541c0e2ca8dc3dd4fa9f85a0"),
    "Rollno" : 4,
    "name" : "snehal",
    "subject" : "TOC",
    "marks" : 81
}
{
    "_id" : ObjectId("541c0ddca8dc3dd4fa9f859d"),
    "Rollno" : 3,
    "name" : "komal",
    "subject" : "TOC",
    "marks" : 69
}
{
    "_id" : ObjectId("541c0d92a8dc3dd4fa9f859c"),
    "Rollno" : 2,
    "name" : "kiran",
    "subject" : "OSD",
    "marks" : 75
}
{
    "_id" : ObjectId("541c0cf4a8dc3dd4fa9f859b"),
    "Rollno" : 1,
    "name" : "nikita",
    "subject" : "DMSA",
    "marks" : 78
}
//ENSURE INDEX:
> db.student.ensureIndex({Rollno:-1});
{
    "createdCollectionAutomatically" : false,
    "numIndexesBefore" : 3,
    "numIndexesAfter" : 4,
    "ok" : 1
}
> db.student.ensureIndex({Rollno:1});
{ "numIndexesBefore" : 4, "note" : "all indexes already exist", "ok" : 1 }

//GET SIZE OF INDEX:
> db.student.stats();
{
    "ns" : "mydb.student",
    "count" : 7,
    "size" : 784,
    "avgObjSize" : 112,
    "storageSize" : 8192,
    "numExtents" : 1,
    "nindexes" : 4,
    "lastExtentSize" : 8192,
    "paddingFactor" : 1,
    "systemFlags" : 1,
    "userFlags" : 1,
    "totalIndexSize" : 32704,
    "indexSizes" : {
        "_id_" : 8176,
        "marks_1" : 8176,
        "Rollno_1" : 8176,
        "Rollno_-1" : 8176
    },
    "ok" : 1
}

//EXPLAIN:
> db.student.find().explain();
{
    "cursor" : "BasicCursor",
    "isMultiKey" : false,
    "n" : 7,
    "nscannedObjects" : 7,
    "nscanned" : 7,
    "nscannedObjectsAllPlans" : 7,
    "nscannedAllPlans" : 7,
    "scanAndOrder" : false,
    "indexOnly" : false,
    "nYields" : 0,
    "nChunkSkips" : 0,
    "millis" : 0,
    "server" : "gescoe:27017",
    "filterSet" : false
}

//DROP INDEX:
> db.student.dropIndex({Rollno:1});
{ "nIndexesWas" : 4, "ok" : 1 }

===============================

Practical: B mongodbjava

===============================

#===========================================================================================
ASSIGNMENT NO:
TITLE:Connectivity with MongoDB using any Java application.
ROLL NO:73
BATCH:T4
#===========================================================================================
import com.mongodb.MongoClient;
import com.mongodb.MongoException;
import com.mongodb.WriteConcern;
import com.mongodb.DB;
import com.mongodb.DBCollection;
import com.mongodb.BasicDBObject;
import com.mongodb.DBObject;
import com.mongodb.DBCursor;
import com.mongodb.ServerAddress;
import java.util.Arrays;

public class pr3{
   public static void main( String args[] ){
      try{
    // To connect to mongodb server
         MongoClient mongoClient = new MongoClient( "localhost" , 27017 );
         // Now connect to your databases
         DB db = mongoClient.getDB( "test" );
    System.out.println("Connect to database successfully");

    DBCollection coll = db.getCollection("TE");
         System.out.println("Collection TE selected successfully");
         BasicDBObject doc = new BasicDBObject("Name", "Navin").
            append("Subject", "database").
            append("Marks", 100).
            append("by", "Computer dept");
         coll.insert(doc);
         System.out.println("Document inserted successfully");
      }catch(Exception e){
         System.err.println( e.getClass().getName() + ": " + e.getMessage() );
    }
   }
}
_________________________________________________________________________
OUTPUT
_________________________________________________________________________
root@gescoe:/home/gescoe/Desktop/tecomp20# javac pr3.java
root@gescoe:/home/gescoe/Desktop/tecomp20# java pr3
Connect to database successfully
Collection TE selected successfully
Document inserted successfully
root@gescoe:/home/gescoe/Desktop/tecomp20# mongo
MongoDB shell version: 2.6.4
connecting to: test
> use test
switched to db test
> show collections
TE
records
system.indexes
> db.TE.find().pretty()
{
    "_id" : ObjectId("54226147e4b05ff6093bdf03"),
    "Name" : "Navin",
    "Subject" : "Waghwani",
    "Marks" : 100,
    "by" : "tutorials point"
}
> exit
bye
_______________________________________________________________________

Followers

Thursday, 3 July 2014

TE_SEM1_PL_01

Assignments Group A (Mandatory)

Assignments Group B (Any Six Assignments, All assignments to be covered in a Batch)

Assignment Group C: Advance Technology Assignments (Any One, all three to be

covered in a Batch)

===============================

Practical: A1 Two tier client server mysql

===============================

===============================

Practical: A2 Three tier Mysql

===============================

===============================

Practical: A3 Two tier client server mysql

===============================

===============================

Practical: A4 i-node

===============================

===============================

Practical: A5 IPC Program using pipe

===============================

===============================

Practical: A6

===============================

**** server ****

**** client ****

===============================

Practical: b1 Three tier mysql

===============================

===============================

Practical: B2 mongodb basics

===============================

===============================

Practical: B5 BIOS

===============================

===============================

Practical: B6 RAMDRIVE

===============================

****** calc.cpp *****

**** navin.cpp ****

===============================

Practical: B12 USB Device bootable

===============================

===============================

Practical: B mongodbaggregation

===============================

===============================

Practical: B mongodb indexing

===============================

===============================

Practical: B mongodbjava

===============================

No comments:

server

client

** calc.cpp *

navin.cpp