海量智库第27期 | 全密态数据库，拧紧数据的“安全阀”

import java.sql.*;

import java.util.*;    

   class JDBC_TESRRSA{        

       public static void main(String[] args) {   

           Locale.setDefault(Locale.US); 

           String driver = "org.postgresql.Driver";

           String url = 

"jdbc:postgresql://172.16.55.169:8888/vastbase?enable_ce=1";

           String user = "test"; 

           String password = "xxxxxxx";

           ResultSet rs = null;

           try(Connection conn = DriverManager.getConnection(url, user, password)){                

               Class.forName(driver); 

               Statement stmt = conn.createStatement();

               stmt.execute("CREATE CLIENT MASTER KEY ImgCMK_a1 WITH ( KEY_STORE = localkms, KEY_PATH = \"key_path_value11\" , ALGORITHM = SM2)");  

               stmt.execute("CREATE COLUMN ENCRYPTION KEY ImgCEK_a1 WITH VALUES (CLIENT_MASTER_KEY = ImgCMK_a1, ALGORITHM  = SM4_SM3);");          

                stmt.execute("CREATE TABLE creditcard_info (id_number int, name varchar(50) encrypted with (column_encryption_key = ImgCEK_a1, encryption_type = DETERMINISTIC),credit_card varchar(19) encrypted with (column_encryption_key = ImgCEK_a1, encryption_type = DETERMINISTIC));");

               stmt.execute("INSERT INTO creditcard_info VALUES (1,'joe','6217986500001288393');"); 

               rs = stmt.executeQuery("select * from creditcard_info where name = 'joe';"); 

               List<String>list = new ArrayList<String>(); 

               while (rs.next()){ 

                   list.add(rs.getString(2)); 

                } 

               if (list != null && list.size()>0){  

                   String[] arr = new String[list.size()]; 

                   for (int i=0;i<list.size();i++){ arr[i]="list.get(i);" } 

                   for (String s : arr){ System.out.println(s);};

                 } 

               stmt.close(); 

           } catch(Exception exception){ 

               exception.printStackTrace();

            } 

       } 

   }