farhad002

package postgreSQL;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;

/**
 *
 * @author Science Fidelity
 */
public class PostGreConnection {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {

    Update update = new Update();
    Delete remove = new Delete();
    Insert insert = new Insert();

    String dbURL = "jdbc:postgresql://localhost:5432/postgres";
    String dbUser ="postgres";
    String dbPass ="1234";

    String insertId;
    String insertName;
    String UpdateId;
    String UpdateName;
    String DeleteId;
    Scanner sc = new Scanner(System.in);
    System.out.println("Enter a ID (Insert)");
    insertId = sc.nextLine();
    System.out.println("Enter a Name (Insert)");
    insertName = sc.nextLine();
    System.out.println("Enter a ID (Update)");
    UpdateId = sc.nextLine();
    System.out.println("Enter a Name (Update)");
    UpdateName = sc.nextLine();
    System.out.println("Enter a Id (Delete)");
    DeleteId = sc.nextLine();

    insert.InsertTeacher(dbURL,dbUser,dbPass,insertName,insertId);
    update.updateTeacher(dbURL,dbUser,dbPass,UpdateName,UpdateId);
    remove.DeleteTeacher(dbURL,dbUser,dbPass,DeleteId);




     }
}