IP notes for SQL and JAVA

some java forms for practice IP Practicle

Dear students

i am posting some forms for practical practice in JAVA to prepare for practical exam.

1.       Design the following GUI Form in Net beans as per the instructions given :

 Write the code for the Clear button and Exit Button.      

2.       It takes input as Emp.No., Name, and Basic Pay.

3.       Write code on the Calculate button to calculate :

For Allowances :

Category                                              Allowances

                                PGT                                                        40% of BP

                                TGT                                                        30% of BP

                                Pry.Tr.                                                   20% of BP

For Deduction :  12% of BP

For Net Pay = Basic Pay + Allowance - Deduction and

4.       If served for more than 10 years Rs.5000 is added to Allowance.

Display Message in a message box “Dear ”+ name+”, Your salary is processed.”

-------------------------form 2------------------------------------

Design the following GUI Form in Netbeans as per the instructions given :

1.       Write the code for the Clear button and Exit Button.              

2.       It takes input as Bill. No., Customer Name and Qty.

3.       Write code on the Calculate button to calculate :

VAT is 14% of Total Amt.

Net Amt. Payable = total Amt  + VAT

on the basis of the following criteria :

Food Item                                           Rate

                                Burger                                                  Rs.90

                                Pizza                                                      Rs. 150

                                Sandwich                                             Rs.75

4.       If ordered during Happy Hours get a discount of 10% on Total Amt.

5.       Display Message in a message box “Thank you.”+customer name



---------------------------form 3---------------------------------
    Design the following GUI Form in Netbeans as per the instructions given :

1.       Write the code for the Clear button and Exit Button.              

2.       It takes input as stuent Name, percentage and stream.

3.       Write code on the Calculate button to calculate

a.       If the student has NCC certificate will get 2% added to his percentage and

b.      if has National Level certificate will get 3% added to his percentage.

4.       As per the given criteria display message in textfield “Eligible for Scholarship” else “Sorry you are not Eligible”

Stream                                 Eligible net percentage

                                Science                                                 90%

                                Commerce                                          80%

                                Humanities                                         70%

assignment for conversion of loop from while to for and do while

dear students please convert the following looping statement into for loop and do while loop

Assignment – IP (class XI)
Convert the following looping statements using for loop, while loop or do.. while loop accordingly.

1.       //to display multiples  of 7

int n=7, ctr=1;

while (ctr<=10)

{

                jTextArea1.setText(jTextArea1.getText()+” “+n*ctr);

                ctr++;

}

2.       //to display even and odd numbers in separate jTextArea controls

//from 1 to the limit given. Also count the number of even and odd numbers  

int max=0, ctr=1, odd_ctr=0, even_ctr=0;

max = Integer.parseInt(jTextField1.getText());

while (ctr<=max)

{

                If(ctr%2==0)

{

jTextArea1.setText(jTextArea1.getText()+” “+ctr);

                                even_ctr++;

                }

                else

{

jTextArea2.setText(jTextArea2.getText()+” “+ctr);

                                odd_ctr++;

                }

                ctr++;

}

3.       //to display skip counting  

int n=0, ctr=1, max=0;

max = Integer.parseInt(jTextField1.getText());

while (ctr<=max)

{

                jTextArea1.setText(jTextArea1.getText()+” “+  ++ctr);

                ctr+=3;

} 

IT APPLICATIONS CHAPTER 11 class XI (IP)

dear students
kindly learn these notes for IT Applications

IT APPLICATIONS

CHAPTER 11

LEARNING OBJECTIVES:

After studying this lesson the students will be able to:

Differentiate between front-end and back-end of an application.

Identify various components of the front-end of an application.

Design and develop simple IT applications.

List the impacts of ICT on society

IT- APPLICATIONS

1.e-Governance

e-Governance involves applications which are used by government agencies/organizations to provide better governance.

Benefits

To reach the citizens in an effective and transparent manner ICT enabled counters have

been setup by government where several services like

• Birth/Death certificate registration
• Railway enquiry and ticket booking,
• submission of RTI application etc. .

e-Governance websites and their salient features and societal impacts

india.gov.in ( The National Portal of India) This portal not only gives the

information about Government of India, but also allows the users to apply online for

various services provided by the government.

goidirectory.nic.in ( Government of India Web Directory) - Through this portal one

can access various government web sites. These sites include sites of various states

and union territories, and sites of central government departments etc. All these

sites are examples of e-Governance applications of IT. Some of these sites are:

a) mcchandigarh.gov.in:

Portal of Municipal Corporation of Chandigarh

b) Jammukashnir.nic.in:

Portal of Municipal Government of Jammu and Kashmir

c) National Informatics Centre (NIC) is a premiere Science & Technology

institution of the Government of India for providing e-Government / e- Governance Solutions adopting best practices, integrated services and global solutions in Government Sector.

2. e-Business

e-Business applications use technology to effectively access and deliver business related services and perform various kinds of business transactions.

Benefits

To reach the customers and business associates in an effective and fast manner. Business houses (now a days many small shops like snacks corners and paan shops also) provide their services on the net. These ICT enabled counters are used to get orders and feedbacks from the customers and also for inter-business transactions. This helps the businesses to widen their customer base.

e-business websites and their salient features and societal impacts

1. nafed-india.com/ebusiness.asp (e-business site of NAFED) - Through this URL

NAFD (National Agricultural Cooperative Marketing Federation of India Ltd.) offers

its e-business services to various corporates and customers.

b.Amazon.com ( e-Business site of Amazon.com) - Amazon is the world's largest

online store. Through this URL Amazon does its online business

3.e-Learning :

e-Learning applications use technology to effectively deliver and monitor learning and teaching processes.

Benefits

e-Learning has multiple goals.

1. It helps the trainer to organize and manage his/her lesson plans

1. E-Learning is about giving freedom to people to learn whatever they want to learn and whenever they want to learn irrespective of age, caste, gender, economical background, or qualification of the learner

e-Learning websites and their salient features and societal impacts

1. w3schools.com ( Website Developers e-Learning site) –

At w3schools.com you will learn how to make a website. It offers free tutorials in all web development technologies

2. www.gcflearnfree.org -It is an educational part of the GCF mission

3. educationportal.mp.gov.in/public/multimedia.aspx - This government of Madhya

Pradesh portal provides multimedia tutorials on various topics of different subjects

like maths, science, social sciences etc.

4. ncert.nic.in/html/learning_basket.htm - This NCERT portal provides interactive

modules for students to learn various topics

.

Social and Economic benefits of ICT:

•  Social networking sites help people remain in touch with their nears and dears

even when they are staying on opposite sides of the globe.

Social networking sites help like minded people come together and work for

some cause.

• e-Governance sites help people save their productive time by performing

various government related jobs like getting some forms, depositing bills

online.

• ICT helps economy grow at a faster rate as it provides transparency in the

processes and helps the government to keep check on defaulters.

Due to e-Banking and use of plastic money more money is put in circulation

leading to faster growth of GDP.

• e-Learning sites make quality study material available even to the students

staying at remote places.

IP Assignment for class XI (2015-16)

Dear students,
the following assignment is for looping and switch case statements.

Assignment for Informatics Practices

Class – XI (2015-16)

1.       What will be the output of the following programs :

a.       for (int k=1; k<=10; k=k+3)          

        jTextArea1.append("\n"+k);

b.      for(int k=1;k<=10;k+=3)         

        jTextArea1.setText(jTextArea1.getText()+"\n"+k);

c.       int a=5 , sum=0;

while (a>3)

 {

sum+=a; 

 a-=2; 

                              }

d.      int w=6, sum=0;

do

{

                sum+=w;

                w-=2;

} while(w>3);

e.       for (int i=10; i<=30; i+=4)

        jTextArea1.setText(jTextArea1.getText() + ” “ + Integer.toString(i));

f.        int x=2, y=20;

while(x<=y)

{

                JOptionPane.showMessageDialog(null, “ “+x);

                x=x+3;

}

g.        int x, y;

x= Integer.parseInt(jTextField1.getText());

y= Integer.parseInt(jTextField2.getText());

if (x=y)

                jTextField3.setText(“x  and y are equal”);

else

                jTextField3.setText(“x  and y are equal”);

h.       int a=1;

do

{

                jTextArea1.setText(Integer.toString(a+2));

                a=a+2;

} while(a<=6);

i.         String name=”Akash Jaiswal”, Name;

Name=jTextField1.getText();

jTextArea1.setText(“Welcome Mr.”+name);

jTextArea2.setText(“Hello  “+Name+”\t You are a Member of Microsoft.\n\tBill Gates”);

2.       Rewrite the following code using switch case statement without affecting the output of the following codes :

a.        char a;

if (a==’b’)

                jTextField1.setText(“Blue Ray ordered”);

else if (a==’d’)

                jTextField1.setText(“DVD ordered”);

else if (a==’c’)

                jTextField1.setText(“Compact Disk ordered”);

else if (a==’p’)

                jTextField1.setText(“Printer ordered”);

else if (a==’s’)

                jTextField1.setText(“Scanner ordered”);

else

                jTextField1.setText(“Wrong Choice”);

b.      int ch=0;

ch=Integer.parseInt(jTextField1.getText()) ;

if (ch==1)

                JOptionPane.showMessageDialog(null,“It is Monday”);

else if (ch==2)

                JOptionPane.showMessageDialog(null,“It is Tuesday”);

else if (ch==3)

                JOptionPane.showMessageDialog(null,“It is Wednesday”);

else if (ch==4)

                JOptionPane.showMessageDialog(null,“It is Thursday”);

else if (ch==5)

                JOptionPane.showMessageDialog(null,“It is Friday”);

else if (ch==6)

                JOptionPane.showMessageDialog(null,“It is Saturday”);

else if (ch==7)

                JOptionPane.showMessageDialog(null,“It is Sunday”);

else

                JOptionPane.showMessageDialog(null,“Please enter number between 1 to 7”);

c.       int code=0;

code=Integer.parseInt(jTextField1.getText()) ;

if (code==1)

                JOptionPane.showMessageDialog(null,“Nokia Mobile”);

else if (code==2)

                JOptionPane.showMessageDialog(null,“Samsung  Mobile”);

else if (code==3)

                JOptionPane.showMessageDialog(null,“Sony  Mobile”);

else if (code==4)

                JOptionPane.showMessageDialog(null,“Microtech  Mobile”);

else if (code==5)

                JOptionPane.showMessageDialog(null,“Apple Mobile”);

else

                JOptionPane.showMessageDialog(null,“Ordered mobile not supported. Use code 1 to 5”);

d.      if (jComboBox1.getSelectedIndex()==0)

                JOptionPane.showMessageDialog(null,“You belong to India”);

else if (jComboBox1.getSelectedIndex()==1)

                JOptionPane.showMessageDialog(null,“You belong to Canada”);

else if (jComboBox1.getSelectedIndex()==2)

                JOptionPane.showMessageDialog(null,“You belong to Kenya”);

else if (jComboBox1.getSelectedIndex()==3)

                JOptionPane.showMessageDialog(null,“You belong to Australia”);

e.      if (jComboBox1.getSelectedIndex()==0)

                jTextField1.setText(“Science  stream”);

else if (jComboBox1.getSelectedIndex()==1)

                JOptionPane.showMessageDialog(null,“You belong to Canada”);

else if (jComboBox1.getSelectedIndex()==2)

                JOptionPane.showMessageDialog(null,“You belong to Kenya”);

else if (jComboBox1.getSelectedIndex()==3)

                JOptionPane.showMessageDialog(null,“You belong to Australia”);

IP Assignment 1( 2015-16)

Dear Students these are the following practice questions. please solve them and paste this assignment in your registers.

private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {                                        

        // TODO add your handling code here:

        String msg1="";

        int n=0;

        msg1=jTextField1.getText()+" ";

        if(jCheckBox1.isSelected())

        {

            msg1=msg1+"Passport Copy, ";

            n++;

        }

        if(jCheckBox2.isSelected())

        {

            msg1=msg1+"Driving Licence Copy, ";

            n++;

        }

        if(jCheckBox3.isSelected())

        {

            msg1=msg1+"Aadhar Card Copy ";

            n++;

        }

        if(n==0)

            jTextArea1.setText(msg1+" pl.submit any of the 3 documents\n"

                    + "to process the loan.");

        else

            jTextArea1.setText(msg1+ " submitted. your loan is processed.");

    }                                       

    private void jButton3ActionPerformed(java.awt.event.ActionEvent evt) {                                        

        // TODO add your handling code here:

        System.exit(0);

    }                                       

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {                                        

        // TODO add your handling code here:

        int  t=0, r=0;

        double dis=0, rate=0,amt=0,payamt=0,instal=0;

        amt=Double.parseDouble(jTextField2.getText());

        if(jRadioButton4.isSelected())

        {

            dis=amt*2/100;

            jTextField5.setText("2%");

        }

        else if(jRadioButton5.isSelected())

        {

            dis=0;

            jTextField5.setText("No discount");

        }

        if(jComboBox1.getSelectedIndex()==0)

        {

            rate=8;

            jTextField6.setText("8%");

        }

        else if(jComboBox1.getSelectedIndex()==1)

        {

            rate=10;

            jTextField6.setText("10%");

        }

        else if(jComboBox1.getSelectedIndex()==2)

        {

            rate=12;

            jTextField6.setText("12%");

        }

        else

            JOptionPane.showMessageDialog(null,"Please select the type of Loan");

        if(jRadioButton1.isSelected())

            t=5;

        else if(jRadioButton2.isSelected())

            t=10;

        else if(jRadioButton3.isSelected())

            t=15;

        else

            JOptionPane.showMessageDialog(null,"Please select the time");

        amt=amt-dis;

        //jTextField7.setText(""+amt);

        //payamt=amt*Math.pow(r,t);

        payamt=amt+(amt*rate*t)/100;

        jTextField3.setText(""+payamt);

        r=0;

        r=t*12;

        instal=payamt/r;

        jTextField4.setText(""+instal);

    }                                        

prep for exhibition

Hello Friends,

Lets discuss something on e-Governess i.e. using Online payment to various government sites.

dharna