ylrz_saas_pharmacy/java/scripts/Q.java

import java.sql.*;
public class Q {
  public static void main(String[] a) throws Exception {
    Connection c = DriverManager.getConnection("jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/fs_tenant_cs1?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8","root","Ylrz_1q2w3e4r5t6y");
    Statement st = c.createStatement();
    ResultSet rs = st.executeQuery("SELECT prompt_key, LEFT(prompt_content,200) c FROM lobster_system_prompt WHERE prompt_content LIKE '%确认一下%' OR prompt_content LIKE '%稍等哈%' LIMIT 20");
    while(rs.next()) System.out.println(rs.getString(1)+" | "+rs.getString(2));
    rs = st.executeQuery("SELECT workflow_id, node_code, message_template FROM company_workflow_lobster_node WHERE message_template LIKE '%旅行\u987gu问%' OR message_template LIKE '%小美%' LIMIT 10");
    System.out.println("--- travel nodes ---");
    while(rs.next()) System.out.printf("wf=%s %s %s%n", rs.getString(1), rs.getString(2), rs.getString(3));
    c.close();
  }
}