Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package database;
- import java.util.Scanner;
- // This allows for the user of access of database and functions
- // to interact with the database. Uses other classes to
- // de-clutter.
- public class mysqlMain {
- public static void main(String[] args) throws Exception {
- @SuppressWarnings("resource")
- Scanner ms = new Scanner(System.in);
- // Display Database Info
- System.out.print("Enter Y/N to display database: ");
- String dbUs = ms.nextLine();
- if (dbUs.equalsIgnoreCase("Y")) {
- queryDatabase db = new queryDatabase();
- db.dbQuery();
- } else {
- System.out.println("Database not shown.");
- }
- System.out.println("");
- // Asks if they want to enter any new users to the database
- System.out.print("Enter amount of new users you want to enter: ");
- int input = Integer.parseInt(ms.nextLine());
- for (int i = 1; i <= input; i++) {
- newUser in = new newUser();
- in.userMaker();
- }
- System.out.println("");
- // Asks if they want to display the database
- System.out.print("Enter Y/N to display database: ");
- dbUs = ms.nextLine();
- if (dbUs.equalsIgnoreCase("Y")) {
- queryDatabase db = new queryDatabase();
- db.dbQuery();
- } else {
- System.out.println("Database not shown.");
- }
- System.out.println("");
- // Asks if they want to change any uses' info in the database
- System.out.print("Enter amount of users' info you want to change: ");
- int inputUpdate = Integer.parseInt(ms.nextLine());
- for (int i2 = 1; i2 <= inputUpdate; i2++) {
- updateUsers upUs = new updateUsers();
- upUs.upUsers();
- }
- System.out.println("");
- // Asks if they want to display the database
- System.out.print("Enter Y/N to display database: ");
- dbUs = ms.nextLine();
- if (dbUs.equalsIgnoreCase("Y")) {
- queryDatabase db = new queryDatabase();
- db.dbQuery();
- } else {
- System.out.println("Database not shown.");
- }
- System.out.println("");
- // Asks if they want to delete any users from the database
- System.out.println("Enter amount of users you want to delete: ");
- int deleteUser = Integer.parseInt(ms.nextLine());
- for (int i3 = 1; i3 <= deleteUser; i3++) {
- deleteUsers dUs = new deleteUsers();
- dUs.dUsers();
- }
- System.out.println("");
- // Asks if they want to display the database
- System.out.print("Enter Y/N to display database: ");
- dbUs = ms.nextLine();
- if (dbUs.equalsIgnoreCase("Y")) {
- queryDatabase db = new queryDatabase();
- db.dbQuery();
- } else {
- System.out.println("Database not shown. Goodbye!");
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement