مساعده فالربط

بتاريخ: 12 أكتوبر 201510 سنة

السلام عليكم ورحمه الله وبركاته
الله يسعدكم احد يقولي فين الغلط فالكود

/*

 * 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 cs;


import java.sql.*;

 


/**

 *

 * @author salwa-1995

 */

public class MAIN {

    

    

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

          Connection con=null;

          Statement stat=null;

          ResultSet rsl=null;

          String  user= "ADPROG";

          String  pass= "SOSO1995";

          try { 

      Class.forName("oracle.jdbc.driver.OracleDriver")    ;  

       con=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:xe",user,pass);

     

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

      

       stat=con.createStatement();

      

      stat.executeUpdate("NSERT INTO INST VALUES 4201234,'Ahmed Mohammed','assistant professor','[email protected]'");

      stat.executeUpdate("NSERT INTO INST VALUES 4201235,'Omer Ahmed','associate professor','[email protected]'");

     

      stat.executeUpdate("NSERT INTO STD VALUES 4331234,'Ahmed Abdullah','12/01/1995','[email protected]'");

      stat.executeUpdate("NSERT INTO STD VALUES 4331235,'Khalid Ahmad','06/06/1995','[email protected]'");

      stat.executeUpdate("NSERT INTO STD VALUES 4331236,'Abdualziz Abdullah','07/11/1994','[email protected]'");

     

      

     stat.executeUpdate("NSERT INTO C_I VALUES 4331234,1111");

     stat.executeUpdate("NSERT INTO C_I VALUES 4331234,2222");  

     stat.executeUpdate("NSERT INTO C_I VALUES 4331235,1111");

     stat.executeUpdate("NSERT INTO C_I VALUES 4331235,3333");

     stat.executeUpdate("NSERT INTO C_I VALUES 4331236,1111");

     stat.executeUpdate("NSERT INTO C_I VALUES 4331236,2222");

     stat.executeUpdate("NSERT INTO C_I VALUES 4331236,3333");

      

      

      stat.executeUpdate("NSERT INTO COURSE VALUES 4201234,1111,'Computer programming III',3 ");

      stat.executeUpdate("NSERT INTO COURSE VALUES 4201234,2222,'Database',,3");

      stat.executeUpdate("NSERT INTO COURSE VALUES 4201235,3333,'software ingineering',4");

       

     stat.executeUpdate("NSERT INTO RELA VALUES 4331234,1111,50");

     stat.executeUpdate("NSERT INTO RELA VALUES 4331234,2222,50");

     stat.executeUpdate("NSERT INTO RELA VALUES 4331234,1111,50");

     stat.executeUpdate("NSERT INTO RELA VALUES 4331234,3333,50");

     stat.executeUpdate("NSERT INTO RELA VALUES 4331236,1111,50");

     stat.executeUpdate("NSERT INTO RELA VALUES 4331236,2222,50");

     stat.executeUpdate("NSERT INTO RELA VALUES 4331236,3333,50");

      

      

      rsl=stat.executeQuery("select * from STD");

      

     System.out.println("**********************************ALL STUDENTS******************************************************\n\n");



      while(rsl.next()){

           System.out.println("ID:"+rsl.getInt(1)+",NAME:"+rsl.getString(2)+",POSITION:"+rsl.getString(3)+",EMAUL:"+rsl.getString(4)+"\n");    

      }

      System.out.println("************************************END****************************************************\n\n");



      

      

      

      rsl=stat.executeQuery("select STUDENT_ID,STUDENT_NAME from STD");

      System.out.println("**********************************IDS AND NAMES  FOR STUDENTS***************************************\n\n");



      while(rsl.next()){

           System.out.println("ID:"+rsl.getInt(1)+",NAME:"+rsl.getString(2)+"\n");    

      }

      System.out.println("************************************END****************************************************\n\n");

 

      

      

      rsl=stat.executeQuery("select * from STD where EXTRACT(YEAR FROM TO_DATE(DATE_OF_BRITH,'DD/MM/YYYY')) > 1994");

       System.out.println("**********************************STUDENTS BORN LATER THEN 1994*************************************\n\n");



      while(rsl.next()){

           System.out.println("ID:"+rsl.getInt(1)+",NAME:"+rsl.getString(2)+",DATE OF BRITH:"+rsl.getDate(3)+",EMAUL:"+rsl.getString(4)+"\n");    

      }

      System.out.println("************************************END****************************************************\n\n");



     

      

      rsl=stat.executeQuery("select i.INSTRUCTOR_ID,i.INSTRUCTOR_NAME,i.INSTRUCTOR_POSITION,i.INSTRUCTOR_EMAIL from INST i  INNER JOIN COURSE c   ON c.INSTRUCTOR_ID = i.INSTRUCTOR_ID where c.COURSE_ID=1111)");

         //rsl=stat.executeQuery("select * from INST where INSTRUCTOR_ID=(select INSTRUCTOR_ID from COURSE where COURSE_ID=1111)");

   System.out.println("**********************************INSTRUCTOR_NAME TEATHING PROGRAMMING III ******************************************************\n\n");



      while(rsl.next()){

           System.out.println("ID:"+rsl.getInt(1)+",NAME:"+rsl.getString(2)+",EMAUL:"+rsl.getString(3)+"\n");    

      }

      System.out.println("************************************END****************************************************\n\n");



     

      

       //rsl=stat.executeQuery("select STUDENT_ID,STUDENT_NAME from STD where STUDENT_ID=(select STUDENT_ID from C_I where COURSE_ID=1111)");

      rsl=stat.executeQuery("select s.STUDENT_ID,s.STUDENT_NAME from STD s NNER JOIN C_I c   ON s.STUDENT_ID=c.STUDENT_ID  where   c.COURSE_ID=1111)");

     System.out.println("**********************************STUDENTS WHO ENROLLED IN PROGRAMMING III ******************************************************\n\n");



      while(rsl.next()){

           System.out.println("ID:"+rsl.getInt(1)+",NAME:"+rsl.getString(2)+"\n");    

      }

      System.out.println("************************************END****************************************************\n\n");

          }

          

          

          

          catch(Exception e){e.printStackTrace(); System.out.println("can't connect to the database");}

          

          finally{

          if(con!=null){con.close();}

           if(stat!=null){stat.close();}

          if( rsl!=null){rsl.close();}

          }

     

        

    } 

    

}

اقتباس