diff options
author | Vitaly Takmazov | 2016-12-12 14:28:34 +0300 |
---|---|---|
committer | Vitaly Takmazov | 2016-12-12 14:28:34 +0300 |
commit | 5146e43ab81143a4fab59b43d4a71fd3de0f6ac9 (patch) | |
tree | a9e43de057ace3bfe3d0451659befe4da02a2f38 /juick-server/src/main/java/com/juick/service/EmailServiceImpl.java | |
parent | b4e5f39e6d4eed566abf7fa5933ff5928dd67e2f (diff) |
juick-spring-www: settings templates and other WIP
Diffstat (limited to 'juick-server/src/main/java/com/juick/service/EmailServiceImpl.java')
-rw-r--r-- | juick-server/src/main/java/com/juick/service/EmailServiceImpl.java | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/juick-server/src/main/java/com/juick/service/EmailServiceImpl.java b/juick-server/src/main/java/com/juick/service/EmailServiceImpl.java index bdd78609..b0bf9e20 100644 --- a/juick-server/src/main/java/com/juick/service/EmailServiceImpl.java +++ b/juick-server/src/main/java/com/juick/service/EmailServiceImpl.java @@ -1,5 +1,6 @@ package com.juick.service; +import org.apache.commons.lang3.StringUtils; import org.springframework.dao.EmptyResultDataAccessException; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.stereotype.Repository; @@ -30,4 +31,22 @@ public class EmailServiceImpl extends BaseJdbcService implements EmailService { } return true; } + + @Override + public boolean addVerificationCode(Integer userId, String account, String code) { + return getJdbcTemplate().update("INSERT INTO auth(user_id,protocol,account,authcode) VALUES (?,'email',?,?)", + userId, account, code) > 0; + } + + @Override + public boolean deleteEmail(Integer userId, String account) { + return getJdbcTemplate().update("DELETE FROM emails WHERE user_id=? AND email=?", userId, account) > 0; + } + + @Override + public boolean setSubscriptionHour(Integer userId, String account, String hour) { + getJdbcTemplate().update("UPDATE emails SET subscr_hour=NULL WHERE user_id=?", userId); + return StringUtils.isNotEmpty(account) && getJdbcTemplate().update( + "UPDATE emails SET subscr_hour=? WHERE user_id=? AND email=?", hour, userId, account) > 0; + } } |