ylrz_saas_pharmacy/java/scripts/TestSelectVisible.java

public class TestSelectVisible {
  public static void main(String[] a) throws Exception {
    Class.forName("com.mysql.cj.jdbc.Driver");
    java.sql.Connection c = java.sql.DriverManager.getConnection(
      "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/ylrz_saas_tenant_1?allowMultiQueries=true","root","Ylrz_1q2w3e4r5t6y");
    java.sql.Statement s = c.createStatement();
    java.sql.ResultSet r = s.executeQuery("select id, company_id, visible_company_ids from company_workflow_lobster limit 1");
    System.out.println(r.next() ? "OK row id="+r.getLong(1) : "OK empty table");
    c.close();
  }
}