글

라벨이 AES인 게시물 표시

mysql 샘플 테이블 + 쿼리 연습 문제

http://java-school.net/jdbc/SQL-SELECT-Statement CREATE TABLE DEPT (     DEPTNO DECIMAL ( 2 ),     DNAME VARCHAR ( 14 ),     LOC VARCHAR ( 13 ),     CONSTRAINT PK_DEPT PRIMARY KEY ( DEPTNO ) ); CREATE TABLE EMP (     EMPNO DECIMAL ( 4 ),     ENAME VARCHAR ( 10 ),     JOB VARCHAR ( 9 ),     MGR DECIMAL ( 4 ),     HIREDATE DATE ,     SAL DECIMAL ( 7 , 2 ),     COMM DECIMAL ( 7 , 2 ),     DEPTNO DECIMAL ( 2 ),     CONSTRAINT PK_EMP PRIMARY KEY ( EMPNO ),     CONSTRAINT FK_DEPTNO FOREIGN KEY ( DEPTNO ) REFERENCES DEPT ( DEPTNO ) ); CREATE TABLE SALGRADE (     GRADE TINYINT ,     LOSAL SMALLINT ,     HISAL SMALLINT ); INSE...

[암호화] AES 인코딩, 디코딩 (AES/CBC/PKCS5PADDING/Hex) - Kotlin

  /* 인코딩, 디코딩 */ CryptoConverter.kt import org.springframework.boot.context.properties. ConfigurationProperties import org.springframework.stereotype. Component import java.util.* import javax.crypto. Cipher import javax.crypto.spec. IvParameterSpec import javax.crypto.spec. SecretKeySpec import javax.persistence. AttributeConverter import javax.persistence. Convert @Convert class CryptoConverter ( private val aes256Config : AES256Config ) : AttributeConverter < String , String > { private val key = aes256Config . key private val iv = aes256Config . iv private val secretKeySpec = SecretKeySpec( key !!. toByteArray (), "AES" ) private val ivParameterSpec = IvParameterSpec( iv !!. toByteArray ())     // 인코딩 override fun convertToDatabaseColumn (payload: String ): String ? { val cipher = Cipher .getInstance( "AES/CBC/PKCS5PADDING" ) cipher .init( Cipher . ENCRYPT_MODE , secretKeySpec , ivParameterSpec ) val encrypt...