Except JSP, Servlet and HTML!

T2015_16

import java.sql.*;

public class T2015_16 {

    static Connection con;

    static Statement s;

    static ResultSet rs;

    public static void main(String[] args) throws Exception{

        deleteRecord();

    }

    public static void deleteRecord() throws Exception{

        Class.forName("com.mysql.jdbc.Driver");

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

        con=DriverManager.getConnection(url,"root","");

        if(con!=null){

            s=con.createStatement();

            String sql="DELETE FROM employee WHERE age>60";

            int res=s.executeUpdate(sql);

            if(res!=-1){

                rs=s.executeQuery("SELECT id,name,salary,post,age FROM employee");

                System.out.println("id    name    salary    post    age");

                while(rs.next()){

                    System.out.println(rs.getInt(1)+"  "+rs.getString(2)+"   "+rs.getInt(3)+"   "+rs.getString(4)+"   "+rs.getInt(5));

                  System.out.println("___________________________________");

                }

            }

            else{

                System.out.println("Error in deleting records");  

            }     

        }

        else{

            System.out.println("Error connecting to database!");

        }

    }

}

 

T2015_17

import java.awt.*;

import javax.swing.*;

import javax.swing.event.*;

import java.awt.event.*;

public class T2015_17 extends JFrame implements ActionListener{

    JTextField t1,t2;

    JButton b;

    public T2015_17(){

        t1=new JTextField();

        t2=new JTextField();

        t2.setEnabled(false);

        b=new JButton("Reverse");

        setLayout(new GridLayout(3,1));

        add(t1); add(t2); add(b);

        setSize(200,400);

        setVisible(true);

        b.addActionListener(this);    

    }

    public void actionPerformed(ActionEvent e){

        int n=Integer.parseInt(t1.getText());

        int sum=0;

        while(n!=0){

           int r=n%10;

           sum+=r;

           n=n/10;

        }

        t2.setText("Sum is: "+sum);

    }

    public static void main(String[] args) {

        new T2015_17();

    }

}

 

www.spastakhabar.com

T2016_2

 import java.awt.*;

import javax.swing.*;

import javax.swing.event.*;

import java.awt.event.*;

public class T2016_2 extends JFrame implements ActionListener{

    JTextField t1,t2;

    JLabel sum;

    JButton b;

    public T2016_2(){

        t1=new JTextField();

        t2=new JTextField();

        sum=new JLabel("");

        b=new JButton("Add");

        setLayout(new GridLayout(4,1));

        add(t1); add(t2); add(b); add(sum);

        setSize(200,400);

        setVisible(true);

        b.addActionListener(this);    

    }

    public void actionPerformed(ActionEvent e){

        int n1=Integer.parseInt(t1.getText());

        int n2=Integer.parseInt(t2.getText());

        int s=n1+n2;

        sum.setText("Sum is: "+s);

    }

    public static void main(String[] args) {

        new T2016_2();

    }

}

 

T2016_3

import java.applet.*;

import java.awt.*;

import java.awt.event.*;

public class T2016_3 extends Applet implements KeyListener{

    TextField t1;

    Label lab;

    public void init(){

        t1=new TextField();

        add(t1);

        lab=new Label();

        add(lab);

        setSize(300,300);

        setLayout(new GridLayout(2,1));

    }

    public void start(){

        t1.addKeyListener(this);

    }

    public void keyTyped(KeyEvent e){}

    public void keyPressed(KeyEvent e){}

    public void keyReleased(KeyEvent e){

        String a=t1.getText();

        if(a.length()==5){

            lab.setText(a+" is of length 5");

        }

        else{

            lab.setText(a+" is not of length 5");

        }

    }

}

 

T2016_6

import java.sql.*;

public class T2016_6 {

    static Connection con;

    public static void main(String[] args) throws Exception{

        connect();

    }

    public static void connect() throws Exception{

        Class.forName("com.mysql.jdbc.Driver");

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

        con=DriverManager.getConnection(url,"root","");

        if(con!=null){

            System.out.println("Successfully connected to database");      

        }

        else{

            System.out.println("Error connecting to database!");

        }

    }

}

 

T2016_7

import java.awt.*;

public class T2016_7 extends Frame{

    Label l1,l2;

    Panel p1,p2;

    TextField t1;

    CheckboxGroup cb;

    Checkbox a,b,c;

    public T2016_7() {

      l2=new Label("Gender: ");

      cb=new CheckboxGroup();

      a=new Checkbox("Male",true,cb);

      b=new Checkbox("Female",false,cb);

      c=new Checkbox("Other",false,cb);

      add(l2); add(a); add(b); add(c);

      setLayout(new FlowLayout());

      setSize(400,200);

      setVisible(true);

    }

    public static void main(String[] args) {

        new T2016_7();

    }

}

 

T2017_2

import java.sql.*;

public class T2017_2 {

    static Connection con;

    static Statement s;

    static ResultSet rs;

    public static void main(String[] args) throws Exception{

        displayRecord();

    }

    public static void displayRecord() throws Exception{

        Class.forName("com.mysql.jdbc.Driver");

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

        con=DriverManager.getConnection(url,"root","");

        if(con!=null){

            rs=s.executeQuery("SELECT id,name,post,salary FROM employee");

            System.out.println("id          |           name            |           post            |           salary");

            while(rs.next()){

                System.out.println(rs.getInt(1)+"  "+rs.getString(2)+"   "+rs.getString(3)+"   "+rs.getInt(4));

              System.out.println("____________________________________");

            }

        }   

        else{

            System.out.println("Error connecting to database!");

        }

    }

}

 

T2017_5

import java.applet.*;

import java.awt.event.*;

import java.awt.*;

public class T2017_5 extends Applet implements ActionListener{

    Panel p1,p2;

    Label l1,l2,l3;

    TextField t1,t2,t3;

    Button b1,b2;

    public void init(){

        p1=new Panel();

        p2=new Panel();

        p1.setLayout(new GridLayout(3,2));

        p2.setLayout(new FlowLayout());

        l1=new Label("Number 1");

        l2=new Label("Number 2");

        l3=new Label("Result");

        t1=new TextField();

        t2=new TextField();

        t3=new TextField();

        t3.setEditable(false);




        p1.add(l1); p1.add(t1);

        p1.add(l2); p1.add(t2);

        p1.add(l3); p1.add(t3);

        

        add(p1); add(p2);

        

        b1=new Button("+");

        b2=new Button("-");

        p2.add(b1); p2.add(b2);

    }

       

    public void start(){

        b1.addActionListener(this);

        b2.addActionListener(this);

    }

       

    public void actionPerformed(ActionEvent e){

       int a=Integer.parseInt(t1.getText());

       int b=Integer.parseInt(t2.getText());

       if(e.getSource()==b1){

        int c=a+b;

        t3.setText(" "+c);

       }

       else if(e.getSource()==b2){

        int c=a-b;

        t3.setText(" "+c);

       } 




   }

}

 

T2017_6

import javax.swing.*;

import javax.swing.event.*;

import java.awt.*;

import java.awt.event.*;

public class T2017_6 extends JFrame{

    TextField t1;

    JComboBox<String> combo;

    String[] s={"BIM","BHM","BSc. CSIT","BBM","BCA"};

    public T2017_6(){

        t1=new TextField();

        t1.setEditable(false);

        combo=new JComboBox<String>(s);

        add(combo);

        add(t1);

        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

        combo.addItemListener(new ItemListener(){

            public void itemStateChanged(ItemEvent e){

                t1.setText(""+combo.getSelectedItem());

            }

        });

        setLayout(new GridLayout(2,1));

        setSize(100,100);

        setVisible(true);

    }

    public static void main(String[] args) {

        new T2017_6();

    }

}

 

T2018_4

 import java.sql.*;

public class T2018_4 { 

    private static Connection con;

    private static Statement s;

    public static void main(String[] args) throws Exception{

       insertRecords();

    }

    public static void insertRecords() throws Exception{

        Class.forName("com.mysql.jdbc.Driver");

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

        con=DriverManager.getConnection(url,"root","");

        if(con!=null){

            s=con.createStatement();

            String sql="INSERT INTO book (id,title,author.price) VALUES "

                    + "(25,'AbcBook','AbcAuthor',2500),"

                    + "(47,'MnoBook','MnoAuthor',800),"

                    + "(33,'PqrBook','PqrAuthor',625),"

                    + "(49,'XyzBook','XyzAuthor',1200),"

                    + "(11,'StuBook','StuAuthor',1200) ";

            int res=s.executeUpdate(sql);

            if(res!=-1){

                System.out.println("Successfully inserted in table BOOK");

            }

            else{

                System.out.println("Could not insert into table");

            } 

        }

        else{

            System.out.println("Error in connectiong to database!");

        }

    }

}

 

T2018_5

import java.awt.*;

import java.applet.*;

/*

<applet code="T2018_5.class" height="300" width="500">

<param name="name" value="Laxmi" />

<param name="age" value="20" />

</applet>

*/

public class T2018_5 extends Applet 

{

String n;

String a;

public void init(){

        n=getParameter("name");

        a=getParameter("age");

}

public void paint(Graphics g){

        g.drawString("Name is: " + n, 20, 20);

        g.drawString("Age is: " + a, 20, 40);

}

}

 

T2018_6

import javax.swing.*;

import java.awt.*;

import java.awt.event.*;

public class T2018_6 extends JFrame implements ActionListener{

    JTextField t1;

    JButton b1,b2;

    public T2018_6() {

        t1=new JTextField();

        b1=new JButton("ok");

        b2=new JButton("clear");

        add(t1); t1.setEditable(false);

        t1.setPreferredSize(new Dimension(100,20));

        add(b1);

        add(b2);

        setLayout(new FlowLayout());

        setSize(50,200);

        setVisible(true);

        b1.addActionListener(this);

        b2.addActionListener(this);

    }

    public void actionPerformed(ActionEvent e){

        if(e.getSource()==b1){

            t1.setText("Welcome");

        }

        else if(e.getSource()==b2){

            t1.setText("");

        }

    }

    public static void main(String[] args) {

        new T2018_6();

    } 

}

 

Leave a Reply

Your email address will not be published. Required fields are marked *