import java.sql.*;

public class Q {
    static final String URL = "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/fs_tenant_cs1"
            + "?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8";

    public static void main(String[] a) throws Exception {
        try (Connection c = DriverManager.getConnection(URL, "ylrz_saas", "Ylrz_1q2w3e4r5t6y")) {
            q(c, "SELECT template_id, COUNT(*) cnt FROM company_lobster_tag_user_rel "
                    + "WHERE company_id=338 AND del_flag=0 GROUP BY template_id ORDER BY cnt DESC");
            q(c, "SELECT status, COUNT(*) cnt FROM lobster_workflow_instance "
                    + "WHERE company_id=338 GROUP BY status");
            q(c, "SELECT id, template_name, execution_mode, enable_content_personalization, "
                    + "enable_flow_personalization, strict_fixed_workflow, auto_start_instance_on_tag "
                    + "FROM company_workflow_lobster WHERE id=61");
            q(c, "SELECT id, tag_code, task_template_id, status FROM company_tag_template_binding "
                    + "WHERE company_id=338 AND del_flag=0 ORDER BY id DESC LIMIT 8");
        }
    }

    static void q(Connection c, String sql) throws SQLException {
        System.out.println("\n-- " + sql);
        try (Statement st = c.createStatement(); ResultSet rs = st.executeQuery(sql)) {
            ResultSetMetaData md = rs.getMetaData();
            while (rs.next()) {
                StringBuilder sb = new StringBuilder();
                for (int i = 1; i <= md.getColumnCount(); i++) {
                    if (i > 1) sb.append(" | ");
                    sb.append(rs.getObject(i));
                }
                System.out.println(sb);
            }
        }
    }
}