public String newUserDetails(UserDetails ud) {
try {
rs =
stmt.executeQuery(
"select Email from Customer_Information where Email = \""
+ ud.getEmailAddress()
+ "\";");
while (rs.next()) {
if (ud.getEmailAddress().equals(rs.getString("Email"))) ;
{
return "Username already exists";
}
}
System.out.println(ud.getPassword());
PreparedStatement preparedStatement =
conn.prepareStatement(
"Insert into Customer_Information (Email,Name,Password) values (?,?,?);");
preparedStatement.setString(1, ud.getEmailAddress());
preparedStatement.setString(2, ud.getName());
preparedStatement.setString(3, ud.getPassword());
preparedStatement.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
return "Register unsuccessful";
}
return "Successfully Register";
}
