use random classes and code in java please with screen shots, thank you. You are

Question

use random classes and code in java please with screen shots, thank you.

You are to create a relational database of all the classes you have taken The database should contain the following: . Number of the class . Name of the class . The faculty member for the class (initials are acceptable) . The quarter and year taken (these can be separate fields) . The subject of the course (math. computer science. English. Etc.). The database should print the list of all the courses Make sure you are allowing your relational database to accept new tuples as necessary.

Explanation / Answer

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Scanner;

public class CourseDB {
   private int numberOfClass;
   private String nameOfClass;
   private String faculty;
   private int quarter;
   private int year;
   private String subject;
   static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
   static final String DB_URL = "jdbc:mysql://localhost/EMP";
    static final String USER = "username";
    static final String PASS = "password";
   public int getNumberOfClass() {
       return numberOfClass;
   }
   public String getNameOfClass() {
       return nameOfClass;
   }
   public String getFaculty() {
       return faculty;
   }
   public int getQuarter() {
       return quarter;
   }
   public int getYear() {
       return year;
   }
   public String getSubject() {
       return subject;
   }
   public void getData(){
       Scanner s=new Scanner(System.in);
       System.out.println("Enter class number: ");
       numberOfClass=s.nextInt();
       System.out.println("Enter name of the class: ");
       nameOfClass=s.next();
       System.out.println("Enter faculty name: ");
       faculty=s.next();
       System.out.println("Enter quarter: ");
       quarter=s.nextInt();
       System.out.println("Enter year: ");
       year=s.nextInt();
       System.out.println("Enter subject: ");
       subject=s.next();
       s.close();
   }
   public static void main(String[] args){
       Connection conn = null;
        Statement stmt = null;
        CourseDB c;
        Scanner s=new Scanner(System.in);
        String sql;
        ResultSet rs;
       try{
          //STEP 2: Register JDBC driver
           Class.forName("com.mysql.jdbc.Driver");
          //STEP 3: Open a connection
          System.out.println("Connecting to database...");
          conn = DriverManager.getConnection(DB_URL,USER,PASS);
          stmt = conn.createStatement();
          while(true){
              c=new CourseDB();
              c.getData();
              sql="";
              sql = "INSERT INTO COUSREDB VALUES('"+c.getNumberOfClass()+"','"+c.getNameOfClass()+"','"
              +"'"+c.getFaculty()+"','"+c.getQuarter()+"','"+c.getYear()+"','"+c.getSubject()+"');";
              stmt.executeUpdate(sql);
              System.out.println("Record inserted into database");
              System.out.println("Do you want to add another? (Y/N) ");
              String choice=s.next();
              if(choice.toUpperCase()=="N"){
                  break;
              }            
          }
          sql = "SELECT number_of_class,name_of_class,faculty,quarter,year,subject from COURSEDB";
          rs = stmt.executeQuery(sql);
          while(rs.next()){
              //Retrieve by column name
              int number_of_class = rs.getInt("number_of_class");
              int name_of_class = rs.getInt("name_of_class");
              String faculty = rs.getString("faculty");
              String year = rs.getString("year");
              String subject = rs.getString("subject");
              String quarter=rs.getString("quarter");
              //Display values
              System.out.print("Number of the class: " + number_of_class);
              System.out.print(" Name of the class: " + name_of_class);
              System.out.print("Faculty: " + faculty);
              System.out.println(" Quarter: " + quarter);
              System.out.println("Year: "+year);
              System.out.println("Subject:"+ subject);
           }
           //STEP 6: Clean-up environment
           rs.close();
           stmt.close();
       }catch(Exception e){
           e.printStackTrace();
       }
   }
}

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.