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);
}
}
}
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:
Post a Comment