Cacher is the code snippet organizer for pro developers

    static final String vHost = "jdbc:mysql://localhost:3306";
    static final String vUser = "root";
    static final String vPass = "mypass";
    
    private List<String> userList;
    
    public void getTermUsers () throws SQLException {

        Connection conn;
        Statement stmnt;
        ResultSet rs;

        conn = DriverManager.getConnection(vHost, vUser, vPass);
        stmnt = conn.createStatement();
        rs = stmnt.executeQuery("SELECT tc.BOUserID FROM TomcatUsers tc WHERE (tc.Password LIKE '%terminated%' OR tc.Status IN ('Inactive', 'Deleted')) AND tc.BOUserID IS NOT NULL");

        userList = new ArrayList<>();
        while (rs.next()) {
            
            System.out.println(rs.getString(1));
            userList.add(rs.getString(1));
        }
        
        rs.close();
        stmnt.close();
        conn.close();
    }