Develop a programme to present a set of choice for user to select a product and display the price of product.

*How to execute Programme.

    1) First Make a DataBase Name is Student.
      2)Make a Table Name is product.
    
    Create table product(id int(10),
    p_name varchar(30),
    p_price int(10));

    3)Insert Data.
  
     insert into product values(01,'Laptop',35000);
     insert into product values(02,'Desktop',30000);
     insert into product values(03,'Keyboard',700);
     insert into product values(04,'Mouse',500);

     4)FileName
     

GUIList.java : This file include all GUI of Frame and One               Listener Which is call other class for get Data from Database.

DataDB.java:  In this file First i make 2 static int variable which       is use to get id or price globally.Then i have make one getData         function with one parameter.getData(String Name) Function             Create  Connection & Pass Query & get Data From Database.                                       

 DriverClass.java : This Class file define all basic parameter of          Database Connectivity.

Code:

GUIList.java

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package Prac13;

import java.awt.BorderLayout;
import java.awt.Color;
import java.awt.FlowLayout;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;

/**
 *
 * @author Queue
 */
public class GUIList  extends JFrame implements ItemListener{ 
    
    JComboBox combo;
    
    JPanel p,p2;
    JLabel Id,IdValue,Dep,DepValue;
    
    public String names[]={" ","Laptop","Desktop","KeyBord","Mouse"};
    DataDB db=new DataDB();
    
    GUIList()
    {
        p=new JPanel();
        combo=new JComboBox(names);
        p.add(combo);
       
        p2=new JPanel();
        Id =new JLabel("ID:");
        IdValue=new JLabel("");
        Dep=new JLabel("Department:");
        DepValue=new JLabel("");
        
        p2.add(Id);
        p2.add(IdValue);
        p2.add(Dep);
        p2.add(DepValue);
        
        combo.addItemListener(this);
        add(p);  
        add(p2);
        setLayout(new FlowLayout());
        setDefaultCloseOperation(EXIT_ON_CLOSE);
        setSize(500,500);
        setVisible(true);
    }
   public static void main(String args[])
    {
        GUIList gui=new GUIList();
    }
    @Override
    public void itemStateChanged(ItemEvent e) {
        String Name=(String) combo.getItemAt(combo.getSelectedIndex());
        
        try {
            db.getData(Name);
            IdValue.setText(String.valueOf(DataDB.id));
            DepValue.setText(String.valueOf(DataDB.p_price));
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(GUIList.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(GUIList.class.getName()).log(Level.SEVERE, null, ex);
        }
        
    }

}



DataDB.Java



package Prac13;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 *
 * @author Queue
 */
public class DataDB {
    
    public static int id=0;
    public static int p_price=0;
    
    DriverClass d=new DriverClass();
    
    public void getData(String Name) throws ClassNotFoundException, SQLException
    {
        Class.forName(d.Driver);
        Connection con=DriverManager.getConnection(d.Path,d.UserName,d.password);
        System.out.println("Connection Establish");
        PreparedStatement ps=con.prepareStatement("Select * from product where p_name=? ");
        ps.setString(1, Name);
        ResultSet rs=ps.executeQuery();
        
        while(rs.next())
        {
            id=rs.getInt("id");
            p_price=rs.getInt("p_price");
       }
    }

}

DriverClass.java

package Prac13;

import p12.*;
public class DriverClass {
    
    public String Driver="com.mysql.jdbc.Driver";
    public String UserName="root";
    public String password="ujash7878";
    public String Path="jdbc:mysql://localhost:3306/student";
    

}


Download Source Code

Output:

Thanks ;)

Happy Coding

   

Develop a Graphical User Interface that perform the following SQL operation : a) insert b) Delete c)Update.

*How to execute Programme.

    1) First Make a DataBase Name is Student.
      2)Make a Table Name is st.
    
    Create table st(firstName varchar(30),
    lastName varchar(30),
    erNumber int,age int,
    gen varchar(30));

    3)FileName:
    *Main Class:Pra_12_java.java
    *insert & Update GUI: Form.java
    *DataBase Connection:DriverClass.java
    *Insert & Update: DriverDB
   *BackButton: Back_bitton,java


CODE:

*Pra_12_java.java

package p12;

import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.*;

public class Pra_12_java extends JFrame implements ActionListener {

DriverDB db=new DriverDB();
    CardLayout card;

    JButton insert, delete, update,sumbitDel,submitUp;
    JPanel p_insert, p_delete, p_update, p1,p_update_in;
    JLabel for_delete,for_update,er_update_label,Result;
    JTextField delete_no,er_update_no;
    
    public static boolean flag=false;
    public static int er=0;
    
   public Pra_12_java() {
        card = new CardLayout();
        p1 = new JPanel();
        
        p_insert = new JPanel();
        p_delete = new JPanel();
        p_update = new JPanel();
        p_update_in =new JPanel();
        insert = new JButton("INSERT");
        delete = new JButton("DELETE");
        update = new JButton("UPDATE");
        
        Result=new JLabel("");
        for_delete = new JLabel("Enter enroolemnt number for DELETE data");
        Font font = new Font("Times New Romen", Font.BOLD, 20);
        sumbitDel =new JButton("Submit");
        submitUp =new JButton("Submit Up");
 delete_no = new JTextField(20);
 er_update_no=new JTextField(20);
 for_update = new JLabel("Enter new values...");
 for_update.setFont(font);
 er_update_label=new JLabel("Enter er Number");
 er_update_label.setFont(font);

        setLayout(card);
        //FIRST PAGE
        
        p1.add(insert);
        p1.add(delete);
        p1.add(update);
        //INSERT CODE
        p_insert.add(new Form(card, getContentPane()));
        //DELETE COD
        p_delete.add(for_delete);
        p_delete.add(delete_no);
        p_delete.add(sumbitDel);
        p_delete.add(Result);
        p_delete.add(new Back_bitton(card, getContentPane()));
        
        p_update_in.add(er_update_label);
        p_update_in.add(er_update_no);
        p_update_in.add(submitUp);
        p_update_in.add(new Back_bitton(card, getContentPane()));
        // UPDATE CODE
        p_update.setLayout(new BorderLayout());
        p_update.add(for_update,BorderLayout.NORTH);
        p_update.add(new Form(card, getContentPane()));
        add(p1, "1");
        add(p_insert, "2");
        add(p_delete, "3");
        add(p_update_in,"4");
        add(p_update, "5");
        
        insert.addActionListener(this);
        delete.addActionListener(this);
        update.addActionListener(this);
        sumbitDel.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e)  {
           
                String re="";
                try {
                    int d=Integer.parseInt(delete_no.getText().toString());
                    re=db.Delete(d);
                    Result.setText(re);
                } catch (ClassNotFoundException ex) {
                    System.out.println(ex);
                } catch (SQLException ex) {
                    System.out.println(ex);
                }
            }
        });
        
        update.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
              flag=true;
            }
        });
           submitUp.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                card.show(getContentPane(), "5");
                er=Integer.parseInt(er_update_no.getText().toString());
            }
        });
       setDefaultCloseOperation(EXIT_ON_CLOSE);
        setSize(500, 500);
        setVisible(true);
    }

    public static void main(String[] args) {
        // TODO code application logic here
        Pra_12_java obj = new Pra_12_java();
    }

    @Override
    public void actionPerformed(ActionEvent e) {
        if (e.getSource() == insert) {
            card.show(getContentPane(), "2");
        } else if (e.getSource() == delete) {
            card.show(getContentPane(), "3");
        } else if (e.getSource() == update) {
            card.show(getContentPane(), "4");
        }
        
    }

}

*Form.java

package p12;
import java.awt.CardLayout;
import java.awt.Container;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.*;
import p12.Pra_12_java.*;

public class Form extends JPanel{
   
   public static boolean flag1=false;
    CardLayout cn;
    Container cr;
    JLabel f_name, l_name, en_no, age, dept, gender, for_delete,nothing,result;
    JTextField fname, lname, en_no_t, age_t, dept_t, gender_t, delete_no;
    JRadioButton male, female;
    ButtonGroup g;
    JButton submit;
    
  public Form(CardLayout cn, Container cr) {
       submit = new JButton("SUBMIT");
        f_name = new JLabel("First name:");
        l_name = new JLabel("Last name:");
        en_no = new JLabel("Enroll number:");
        dept = new JLabel("Departement");
        gender = new JLabel("Gender:");
        age = new JLabel("Age:");
        nothing = new JLabel(" ");
        result=new JLabel("");
        fname = new JTextField(10);
        lname = new JTextField(10);
        en_no_t = new JTextField(10);
        dept_t = new JTextField(10);
        age_t = new JTextField(10);

        male = new JRadioButton("male", true);
        female = new JRadioButton("Female");
        g = new ButtonGroup();
        g.add(male);
        g.add(female);
       
        setLayout(new GridLayout(8, 3));
        add(f_name);
        add(fname);
        add(l_name);
        add(lname);
        add(en_no);
        add(en_no_t);
        add(age);
        add(age_t);
        add(gender);
        add(male);
        add(nothing);
        add(female);
        add(submit);
        add(new Back_bitton(cn, cr));
        add(result);
        
        submit.addActionListener(new ActionListener() {
           @Override
           public void actionPerformed(ActionEvent e) {
          
               if(Pra_12_java.flag==false)
               {
                   try {
                       query();
                   } catch (ClassNotFoundException ex) {
                       Logger.getLogger(Form.class.getName()).log(Level.SEVERE, null, ex);
                   } catch (SQLException ex) {
                       Logger.getLogger(Form.class.getName()).log(Level.SEVERE, null, ex);
                   }
                }
               else
               {
                   flag1=true;
                   try {
                       query();
                   } catch (ClassNotFoundException ex) {
                       Logger.getLogger(Form.class.getName()).log(Level.SEVERE, null, ex);
                   } catch (SQLException ex) {
                       Logger.getLogger(Form.class.getName()).log(Level.SEVERE, null, ex);
                   }
               }
             
           }
       });
    }
    
    public void query() throws ClassNotFoundException, SQLException
    {
        String re="";
                   
                   DriverDB db=new DriverDB();
                   int er=Integer.parseInt(en_no_t.getText().toString());
                   int age=Integer.parseInt(age_t.getText().toString());
                   String gen="";
                   
                   if(female.isSelected()){
                       gen="female";
                   }else{
                     gen="male";
                   }
                   re=db.insertAndUpdate(fname.getText().toString(), lname.getText().toString(),er , age,gen);
                   result.setText(re);
                  }
}

*DriverClass.java

package p12;
public class DriverClass {
    
    public String Driver="com.mysql.jdbc.Driver";
    public String UserName="root";
    public String password="ujash7878";
    public String Path="jdbc:mysql://localhost:3306/student";
 }

*DriverDB.java

package p12;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.SQLException;

import java.sql.Statement;

import p12.DriverDB;

public class DriverDB     {

    DriverClass d=new DriverClass();

    

    

    public String insertAndUpdate(String firstName,String          lastName,int erNumber,int age,String gender) throws ClassNotFoundException, SQLException

    {

        

        String re="";

        Class.forName(d.Driver);

    Connection con=DriverManager.getConnection(d.Path,d.UserName,d.password);    

    

    if(Form.flag1==false)

    {

        System.out.println("you are in insert panel");

        System.out.println(Form.flag1);

        PreparedStatement ps=con.prepareStatement("insert into st               values(?,?,?,?,?)");

        

        ps.setString(1, firstName);

        ps.setString(2, lastName);

        ps.setInt(3, erNumber);

        ps.setInt(4, age);

        ps.setString(5, gender);

        

        int i=ps.executeUpdate();

        

        if(i>=0)

        {

            re="Record Inserted";

            Form.flag1=true;

        }

    }

    else

    {

         

        int oldEr=Pra_12_java.er;

        Statement s=con.createStatement();

        s.executeUpdate("set sql_safe_updates=0;");

        PreparedStatement ps=con.prepareStatement("update st set               fisrtName=?,lastName=?,erNumber=?,age=?,gen=? where               erNumber=?");

       

        ps.setString(1, firstName);

        ps.setString(2, lastName);

        ps.setInt(3, erNumber);

        ps.setInt(4, age);

        ps.setString(5, gender);

        ps.setInt(6, oldEr);

        int i=ps.executeUpdate();

        if(i>=0)

        {

            re="Record Updated";

            Form.flag1=false;

        }

    }

    return re;

    }

    

    public String Delete(int er) throws ClassNotFoundException, SQLException

    {

        String re="";

        Class.forName(d.Driver);

    Connection con=DriverManager.getConnection(d.Path,d.UserName,d.password);        

    

    PreparedStatement ps=con.prepareStatement("delete from st where erNumber=?");

    ps.setInt(1, er);

    

    int i=ps.executeUpdate();

    

    if(i>=0)

    {

        re="Record Deleted";

    }

       

    return re;

    }

}

*Back_Bitton.java

package p12;

import java.awt.CardLayout;

import java.awt.Container;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import javax.swing.JButton;

import javax.swing.JPanel;

public class Back_bitton extends JPanel{

    CardLayout c;

    Container con;

    

    JButton btn;

    public Back_bitton(CardLayout c , Container con) {

        btn = new JButton("BACK");

        this.c=c;

        this.con = con;

        btn.addActionListener(backListener);

        add(btn);

       

    }

    

    ActionListener backListener=new ActionListener() {

        @Override

        public void actionPerformed(ActionEvent e) {

           c.show(con, "1");

        }

    };

    

}

Note:I am using Mysql as Database Connection.If you do not how to Create Connection in java then follow this link:http://rctiajava.blogspot.com/2017/02/connection-of-database-with-mysql.html

Download Source Code:https://drive.google.com/drive/folders/0By7E21gumtOVWkpPSmkyVDhJRlE?usp=sharing

OutPut:

          *FirstLayout:
             

                

                *Insert Layout
                           

                *Delete Layout:

           
                *Update Layout :

Thanks ;)
Happy Coding 

Hello World in Servlet Java.

*First You need to Download Tomcat server for execute Servlet java File.

~ Tomcat 8 Download : https://tomcat.apache.org/download-80.cgi

~ After Download tomcat-8.5.11.exe file you have to install them and remember port number.

*How to start tomcat server and test them.

~ First go Tomcat 8 Folder at Program file.

~ C:\Program Files\Apache Software Foundation\Tomcat 8.5\bin

~Right Click on Tomcat 8 and run as Administrator.

~ After run. open any browser and type at url :"localhost:portnumber"

~For Ex My port Number is 8088 then i have to tpye url like:"localhost:8088".

~ If you have successfully  done then Browser Page Look likes below page.

*Let's Start Hello World in Servlet java.

~ First you are beginners then you have to use Eclipse,NetBeans.

~If you are learning for Exam perpose then you should use notpad & CMD.

Hello.java

import java.io.IOException;

import java.io.PrintWriter;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

public class Hello extends HttpServlet {

    

    public void doGet(HttpServletRequest rq,HttpServletResponse res) throws IOException

    {

        PrintWriter out=res.getWriter();

        

        out.println("Hello World form other World");

        

    }
 }

*Web.xml

<?xml version="1.0" encoding="UTF-8"?>

<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"

  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

  xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"

  version="3.1">

    <servlet>

        <servlet-name>hello</servlet-name>

        <servlet-class>Hello</servlet-class>

    </servlet>

    

    <servlet-mapping>

        <servlet-name>hello</servlet-name>

        <url-pattern>/hellow</url-pattern>

    </servlet-mapping>

</web-app>

Thanks ;)

Happy Coding

  

Connection of Database with Mysql & Oracle in java. JDBC Type 2 Connection

*Here is link to download Jar File

ForMysql:http://www.java2s.com/Code/JarDownload/mysql/mysql-connector.jar.zip

ForOracle:http://www.java2s.com/Code/JarDownload/ojdbc14/ojdbc14.jar.zip

*How to add External Jar in netbeans ans Eclipse.

Netbeans:                                               Eclipse:

>Right Click on Project.             >Right Click on project.

>Click on properties.                  >Java Build Path.

>Click on Libraries.                    >Add External Jars.

>Add/Jar Folder.

*Driver Class

Oracle: oracle:jdbc:driver:OracleDriver

Mysql: com.mysql.jdbc.Driver

*URL path

 Oracle: jdbc:oracle:thin:@localhost:1521:XE

 Mysql:jdbc:mysql://localhost:3306

*DataBase Engine Download link

Oracle:http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html

Mysql:https://dev.mysql.com/downloads/installer/

Code:

import java.sql.*;
public class msqlTest {
    
    public static void main(String args[]) throws Exception
    {
        String url="jdbc:mysql://localhost:3306";
        String userName="root";
        String password="ujash7878";
        
        Class.forName("com.mysql.jdbc.Driver");
        
        Connection con=DriverManager.getConnection(url,userName,password);
        System.out.println("Done");
        
       }
    
    

}

Practical 11 Doc File Link:https://drive.google.com/file/d/0By7E21gumtOVT0NGVF9KLU91dGM/view?usp=sharing

Practical 11 Source Code File:https://drive.google.com/file/d/0By7E21gumtOVMmpzeC1BeFhWNk0/view?usp=sharing

Thanks ;)

Happy Coding 

Practical 10: Develop a program that draws two sets of ever-decreasing rectangles one in outline form and one filled alternately in black and white.

Code:

import java.applet.Applet;
import java.awt.Color;
import java.awt.Graphics;

public class Rect extends Applet {

int x, y, h, w;

@Override
public void init() {
// TODO Auto-generated method stub
super.init();
setSize(500, 500);
x = 10;
y = 100;
h = 300;
w = 200;

}

@Override
public void paint(Graphics g) {
// TODO Auto-generated method stub
super.paint(g);
for (int i = 0; i < 20; i++) {
x = x + 5;
y = y + 5;
h = h - 10;
w = w - 10;
if (i % 2 == 0) {
g.setColor(Color.black);
g.fillRect(x, y, h, w);
} else {
g.setColor(Color.white);
g.fillRect(x, y, h, w);
}

}

}
}


Output

Coding By Sumit Bamania

Thanks ;)