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

public class myDatabase {

    public static void main(String[] args) {

        Scanner scanner = new Scanner(System.in);
        System.out.print("Would you like to create a new user account? ");
        String input = scanner.nextLine();

        if (input.equals("y")) {
            System.out.println("To continue, you must create a new user account: ");
            System.out.print("Name: ");
            String name = scanner.nextLine();
            System.out.print("Username: ");
            String username = scanner.nextLine();
            System.out.print("Password: ");
            String password = scanner.nextLine();
            System.out.print("E-mail: ");
            String email = scanner.nextLine();

            String dataSourceName = "first test";
            String dbUrl = "jdbc:odbc:" + dataSourceName;

            try {
                System.out.println("Name: " + name);
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

                Connection con = DriverManager.getConnection(dbUrl, "", "");

                Statement s = con.createStatement();

                s.execute("insert into members(name, username, password, email)values('Luke', username, password, email)");

                s.execute("select name, username, password, email from members");

                ResultSet rs = s.getResultSet();

                if (rs != null) {
                    while (rs.next()) {
                        System.out.println("Data from Grade: "
                                + rs.getString(1) + "Data from Remark: "
                                + rs.getString(2));
                    }
                }

                s.close();
                con.close();

            } catch (Exception e) {
                System.out.println(e);
            }
        }

    }
}