Question

Database assignment SQL Assignment added to a database. Customers buy products that are in stock by placing an arder which records the amount purchased and the date Date Quantity Customer Product CustomerlD FName LName Address EmaillD PID Pname Description Price Stock Orders

Answer 1

import java.sql.*;
public class DatabaseConnectivity{
public static void main(String args[]){
   try{
      // load driver for mysql (Download and paste mysqlconnector.jar file in jre/lib/ext folder and then set classpath to this jar file )
      Class.forName("com.mysql.jdbc.Driver");
      Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/dbase","root","");
      //here dbase is database name, root is username and password is pwd
    
      // Suppose we want to get orders of customer with customer id 1;
      int oid,cid=1;
      Statement stmt=con.createStatement();
      ResultSet rs=stmt.executeQuery("select orderid from orders where customerID ="+cid+" limit 1");
      if(rs.next())
      {
         oid= rs.getInt(1);
            
    
    
         rs=stmt.executeQuery("select Pname, price, description from Product where PID in (select pid from orders where orderid ="+oid);
         System.out.println("The order details of customer "+cid+" are as ");
         while(rs.next())
         {
            System.out.println(rs.getInt(1)+" "+rs.getString(2)+" "+rs.getString(3));
         }
      }
      con.close();
   }catch(Exception e){ System.out.println(e);}
   }
}