Seach

jdbc console program to demonstrate insertion,deletion,selection,updation

import java.sql.*;
import java.io.*;
public class c
{
public static void main(String arg[])
{
System.out.println("\n1:INSERT\n2:DELETE\n3:SELECT\n4:UPDATE\n5:EXIT");
int n;
try

{
    BufferedReader bx=new BufferedReader(new InputStreamReader(System.in));
    Connection con =null;
    String URL="jdbc:mysql://localhost/hithin";
    Class.forName("com.mysql.jdbc.Driver");
    con=DriverManager.getConnection(URL,"root","");
    do
    {
    System.out.println("\n1:INSERT\n2:DELETE\n3:SELECT\n4:UPDATE\n5:EXIT");
    System.out.println("\nENTER YOUR CHOICE");
    n=Integer.parseInt(bx.readLine());
    if(n==1)
    {System.out.println("Insertion option is selected");
        System.out.println("Enter the values you want to insert");
        int a=Integer.parseInt(bx.readLine());
        int b=Integer.parseInt(bx.readLine());
        int c=Integer.parseInt(bx.readLine());
        try{
            Statement stmt=con.createStatement();
            String createString = "insert into orderdetails1(ono,bid,qty) values("+a+","+b+","+c+")";
            stmt.executeUpdate(createString);
            ResultSet rs=stmt.executeQuery("select * from orderdetails1");    
                       System.out.println("MySQL JDBC driver loaded ok.");
            System.out.println("\n\t***************");   
            System.out.println("\t  ORDERDETAILS");
            System.out.println("\t***************");
            System.out.println("\n\tORDER NO    BOOK ID   QUANTITY");
                        while(rs.next())
                          {    System.out.println("\n");
                System.out.println("\t");
                                System.out.print("\t"+rs.getString(1));
                System.out.print("\t\t");
                                System.out.print(rs.getString(2));
                System.out.print("\t");
                System.out.print(rs.getString(3));
                           }
                    
        }catch (Exception e)
        {
                   
        System.out.println("Exception: "+e);

        }
    }
    else if(n==2)
    {
System.out.println("Deletion option is selected");
        try
        { int s;
System.out.println("enter the id to delete:");
s=Integer.parseInt(bx.readLine());

            Statement stmt=con.createStatement();
            String createString = "delete from orderdetails1 where ono="+s+" ";
            stmt.executeUpdate(createString);
            ResultSet rs=stmt.executeQuery("select * from orderdetails1");    
                       System.out.println("Records Deleted.");
       
        }
        catch(Exception e)
        {
System.out.println("occured error is:"+e);
}
    }
    else if(n==3)
    {
System.out.println("Update option is selected:");
        try
        {
            Statement stmt=con.createStatement();
            //String createString = "insert into orderdetails1(ono,bid,qty) values("+a+","+b+","+c+")";
            //stmt.executeUpdate(createString);
                      ResultSet rs=stmt.executeQuery("select * from orderdetails1");    
                       System.out.println("MySQL JDBC driver loaded ok.");
            System.out.println("\n\t***************");   
            System.out.println("\t  ORDERDETAILS");
            System.out.println("\t***************");
                        while(rs.next())
                          {    System.out.println("\n");
                System.out.println("\t");
                                System.out.print("\t"+rs.getString(1));
                System.out.print("\t");
                                System.out.print(rs.getString(2));
                System.out.print("\t");
                System.out.print(rs.getString(3));
                           }                       
       
        }
        catch(Exception e)
        {}
    }
    else if(n==4)
    {
        try
        {
            System.out.println("Enter the book id of the record you want to update(bid integer value)");
            int x=Integer.parseInt(bx.readLine());
            System.out.println("Enter the field you want to update:order no or quantity");
            String s=bx.readLine();
            System.out.println("enter the value to be updated");
            int y=Integer.parseInt(bx.readLine());
            String s1=new String("order no");
            Statement stmt;
            String createString;
            if(s=="orderno")
            {   
                stmt=con.createStatement();           
                createString ="update orderdetails1 set ono="+y+" where bid="+x+"";
stmt.executeUpdate(createString);
            }
            else
            {
                stmt=con.createStatement();
                createString ="update orderdetails1 set qty="+y+" where bid="+x+"";
stmt.executeUpdate(createString);
            }
            stmt.executeUpdate(createString);
            ResultSet rs=stmt.executeQuery("select * from orderdetails1");    
                       System.out.println("MySQL JDBC driver loaded ok.");
            System.out.println("\n\t***************");   
            System.out.println("\t  ORDERDETAILS");
            System.out.println("\t***************");
                        while(rs.next())
                          {    System.out.println("\n");
                System.out.println("\t");
                                System.out.print("\t"+rs.getString(1));
                System.out.print("\t");
                                System.out.print(rs.getString(2));
                System.out.print("\t");
                System.out.print(rs.getString(3));
                           }
        }
        catch(Exception e)
        {}
    }
    else if(n==5)
    {
    break;
    }
    }
    while(n!=5);               
    }
catch(Exception e)
{
System.out.println("occured exception:"+e);
}

}
}


No comments: