ylrz_saas_pharmacy/java/scripts/QLogin.java

import java.sql.*;

public class QLogin {
    public static void main(String[] a) throws Exception {
        Class.forName("com.mysql.cj.jdbc.Driver");
        try (Connection c = DriverManager.getConnection(
                "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/fs_tenant_cs1?useSSL=false&serverTimezone=GMT%2B8",
                "root", "Ylrz_1q2w3e4r5t6y");
             Statement st = c.createStatement()) {
            ResultSet rs = st.executeQuery(
                    "SELECT user_name, LEFT(password,30) p, status FROM company_user "
                            + "WHERE user_name IN ('admin','ceadmin') AND del_flag='0'");
            while (rs.next()) {
                System.out.println(rs.getString(1) + " status=" + rs.getString(3) + " hash=" + rs.getString(2));
            }
            rs = st.executeQuery("SELECT user_name, LEFT(password,30) p, status FROM sys_user "
                    + "WHERE user_name='admin' AND del_flag='0'");
            while (rs.next()) {
                System.out.println("sys " + rs.getString(1) + " status=" + rs.getString(3) + " hash=" + rs.getString(2));
            }
            rs = st.executeQuery("SELECT config_key, config_value FROM sys_config WHERE config_key LIKE '%captcha%'");
            while (rs.next()) {
                System.out.println(rs.getString(1) + "=" + rs.getString(2));
            }
            rs = st.executeQuery(
                    "SELECT id, template_name, industry_type FROM company_workflow_lobster "
                            + "WHERE industry_type='liquor' OR template_name LIKE '%鐧?' OR template_name LIKE '%閰?' LIMIT 10");
            while (rs.next()) {
                System.out.println("tpl " + rs.getLong(1) + " " + rs.getString(2) + " " + rs.getString(3));
            }
        }
    }
}