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(); } }