ylrz_saas_pharmacy/java/scripts/QGepaReplay.java

import java.sql.*;
public class QGepaReplay {
  public static void main(String[] a) throws Exception {
    Class.forName("com.mysql.cj.jdbc.Driver");
    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 COUNT(*) total, SUM(quality_score>=120) high, SUM(quality_score>0 AND quality_score<120) low FROM lobster_learning_replay_buffer");
    if (rs.next()) System.out.println("replay_buffer total="+rs.getInt(1)+" high(>=120)="+rs.getInt(2)+" low(<120)="+rs.getInt(3));
    rs.close(); st.close(); c.close();
  }
}