Class.forName(
                                                        "com.mysql.jdbc.Driver")
                                                        .newInstance();

                                                Connection conn = null;

                                                conn =

                                                DriverManager
                                                        .getConnection(
                                                                "jdbc:mysql://database.io1asdfrw09.us-east-1.rds.amazonaws.com:3306",
                                                                "name",
                                                                "8IG455H45HC0D3H3R3");

                                                PreparedStatement pstmt = conn
                                                        .prepareStatement("CREATE DATABASE IF NOT EXISTS name_db;");
                                                PreparedStatement pstmt2 = conn
                                                        .prepareStatement("USE name_db;");
                                                PreparedStatement pstmt3 = conn
                                                        .prepareStatement("CREATE TABLE IF NOT EXISTS db_table(id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY);");
                                                PreparedStatement pstmt4 = conn
                                                        .prepareStatement("ALTER TABLE db_table ADD(user VARCHAR(30), pass VARCHAR(30), repass VARCHAR(30), name VARCHAR(30), lname VARCHAR(30), dob VARCHAR(10), gender TEXT, addr TEXT, apt TEXT, city TEXT, zip TEXT, phone TEXT, email VARCHAR(100));");
                                                PreparedStatement pstmt5 = conn
                                                        .prepareStatement("INSERT INTO db_table(user, pass, repass, name, lname, dob, gender, addr, apt, city, zip, phone, email, id) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?;");

                                                pstmt4.setString(1, user);
                                                pstmt4.setString(2,
                                                        String.valueOf(pass));
                                                pstmt4.setString(3,
                                                        String.valueOf(repass));
                                                pstmt4.setString(4, name);
                                                pstmt4.setString(5, lname);
                                                pstmt4.setString(6, dob);
                                                pstmt4.setString(7, gender);
                                                pstmt4.setString(8, addr);
                                                pstmt4.setString(9, apt);
                                                pstmt4.setString(10, city);
                                                pstmt4.setString(11, zip);
                                                pstmt4.setString(12, phone);
                                                pstmt4.setString(13, email);
                                                pstmt4.setLong(14, id);
                                                pstmt4.execute();

                                                pstmt.executeUpdate();
                                                pstmt2.executeUpdate();
                                                pstmt3.executeUpdate();
                                                pstmt4.executeUpdate();
                                                pstmt5.executeUpdate();

                                                Statement stmt = conn
                                                        .createStatement();

                                                String qry = "SELECT * FROM db_table;";

                                                ResultSet rs = stmt
                                                        .executeQuery(qry);
                                                while (rs.next()) {
                                                    rsUser = rs.getString(1);
                                                    System.out.println(rsUser);

                                                }
                                                rs.close();

                                            } catch (SQLException ex) {
                                                // handle any errors
                                                System.out.println("StackTrace: "
                                                        + ex.getStackTrace());
                                                System.out.println("SQLState: "
                                                        + ex.getSQLState());
                                                System.out.println("VendorError: "
                                                        + ex.getErrorCode());
                                                System.out
                                                        .println("Throwable: "
                                                                + ex.getCause());
                                                System.out.println("SQL Exception: "
                                                        + ex.getMessage());

                                            } catch (InstantiationException e) {
                                                // TODO Auto-generated catch
                                                // block
                                                e.printStackTrace();
                                            } catch (IllegalAccessException e) {
                                                // TODO Auto-generated catch
                                                // block
                                                e.printStackTrace();
                                            } catch (ClassNotFoundException e) {
                                                // TODO Auto-generated catch
                                                // block
                                                e.printStackTrace();
}