개발
-
querydsl 업데이트 벌크쿼리개발/java 2016. 4. 29. 10:28
public class SnsRepositoryImpl extends QueryDslSupport implements CustomSnsRepository { public SnsRepositoryImpl() { super(Sns.class); } @PersistenceContext(unitName = "entityManagerFactory") private EntityManager em; @Override public long updateProfile(Sns sns) throws Exception { QSns qSns = QSns.sns; JPAUpdateClause updateClause = new JPAUpdateClause(em, qSns); long count = updateClause.where(..
-
-
하이버네이트 서브쿼리개발/java 2016. 4. 29. 10:24
import org.hibernate.annotations.Formula; @Formula(value = "(SELECT REPLACE(CONCAT(T.FILE_PATH,T.FILE_NM,'.',T.FILE_EXT,'|',T.SNS_FILE_ID), '\\\\', '/' ) "+ " FROM SNS_FILE T"+ " INNER JOIN SNS X ON T.SNS_ID = X.SNS_ID"+ " WHERE X.USER_ID = USER_ID"+ " AND X.SNS_TP = 'PROFILE'"+ " AND X.PROFILE_Fl = 'Y'"+ " ORDER BY T.SNS_FILE_ID DESC LIMIT 1)");
-
javax 를 이용한 gmail 서버로 메일 보내기개발/java 2016. 4. 22. 09:34
import java.util.Properties; import javax.mail.Address; import javax.mail.Authenticator; import javax.mail.Message; import javax.mail.PasswordAuthentication; import javax.mail.Session; import javax.mail.Transport; import javax.mail.internet.InternetAddress; import javax.mail.internet.MimeMessage; import mgood.domain.User; public class SMTPUtil{ private final static String ACCOUNT = mgood.common...