tianxiaqingqi/CSRC
0
1+
2 {k�i� � � � ^ RI t ^ RIt ! R R4 t]R8X d* ]! 4 t]P 4 ]P
4 R# R# )� Nc �Z a � ] tR t^t o R R ltR tR tR tR tR t R t3R t R t R4t
V tR # )
�FeedbackSearchToolc �N � Wn R V n R V n V P 4 R # )N)�db_name�conn�cursor�5connect_db)�selfr s &&�DC:\Users\hp\Documents\trae_projects\CSRC FMC feedback\search_tool.py�__init__�FeedbackSearchTool.__init__ s � � � ��� ��� � ���� c �: � \ P ! V P 4 V n V P P 4 V n \ RV P 24 R# \ d0 p\ RT 24 \ P ! ^4 Rp?R# Rp?ii ; i)u 连接数据库u 成功连接到数据库: u 连接数据库失败: N) �sqlite3�connectr r r �print� Exception�sys�exit)r6 �es & r r � FeedbackSearchTool.connect_db sp � � � ���� � �5�D�I� �)�)�*�*�,�D�K� �.�t�|�|�n�=� >��� � �+�A�3�/� 0� �H�H�Q�K�K�� �s �A A � B�+$B�Bc �� � V P P RRV R2RV R234 V P P 4 pV# \ d p\ RT 24 . u Rp?# Rp?ii ; i)u! 根据关键词搜索反馈意见z�7 SELECT id, title, link, date, category 8 FROM feedbacks 9 WHERE title LIKE ? OR content LIKE ? 10 ORDER BY date DESC11 �%� 搜索失败: N�r �execute�fetchallr r )r12 �keyword�resultsr s && r �search_by_keyword�$FeedbackSearchTool.search_by_keyword su � � � �K�K� � � !�13 �g�Y�a�.�A�g�Y�a�.�1�
3� �k�k�*�*�,�G��N��� � �N�1�#�&� '��I�� �s �AA � A)�A$� A)�$A)c �� � V P P RV34 V P P 4 pV# \ d p\ RT 24 . u Rp?# Rp?ii ; i)u 根据类别搜索反馈意见z�14 SELECT id, title, link, date, category 15 FROM feedbacks 16 WHERE category = ? 17 ORDER BY date DESC18 r Nr )r19 �categoryr r s && r �search_by_category�%FeedbackSearchTool.search_by_category$ sb � � � �K�K� � � !�20 ��
� �k�k�*�*�,�G��N��� � �N�1�#�&� '��I�� �� �8; � A �A�A �A c �� � V P P RW34 V P P 4 pV# \ d p\ RT 24 . u Rp?# Rp?ii ; i)u$ 根据日期范围搜索反馈意见z�21 SELECT id, title, link, date, category 22 FROM feedbacks 23 WHERE date >= ? AND date <= ? 24 ORDER BY date DESC25 r Nr )r26 �27start_date�end_dater r s &&& r �search_by_date_range�'FeedbackSearchTool.search_by_date_range3 sc � � � �K�K� � � !�28 �'�
)� �k�k�*�*�,�G��N��� � �N�1�#�&� '��I�� �r& c �� � V P P R4 V P P 4 pV# \ d p\ RT 24 . u Rp?# Rp?ii ; i)u 获取所有反馈意见z�29 SELECT id, title, link, date, category 30 FROM feedbacks 31 ORDER BY date DESC32 � 查询失败: Nr )r33 r r s & r �get_all_feedbacks�$FeedbackSearchTool.get_all_feedbacksB s[ � �34 � �K�K� � � !�
�35 �k�k�*�*�,�G��N��� � �N�1�#�&� '��I�� �s �69 � A �A�A �A c �^ � V' g \ R4 R# \ R\ V4 R24 \ V^4 Fo w r#\ V RV^, 24 \ RV^, 24 \ RV^, 24 \ RV^, R 8X d R36MR 24 \ R 4 Kq R# )
u 打印搜索结果u 未找到匹配的反馈意见Nu 找到 u 条匹配的反馈意见:37u38 . 标题: u 链接: u 日期: u 类别: �39securitiesu 证券类u 基金类zP--------------------------------------------------------------------------------)r �len� enumerate)r40 r �i�items && r �
print_results� FeedbackSearchTool.print_resultsP s� � �� �2� 3� �
���G� �~�%A�B�C� ��!�,�G�A� �Q�C�z�$�q�'��+� ,� �K��Q��y�)� *� �K��Q��y�)� *� �K�t�A�w�,�/F� �K� X�Y� Z� �(�O� -r c �H � \ R4 \ R4 \ R4 \ R4 \ R4 \ R4 \ R4 \ R4 pVR 8X d0 \ R414 pV P V4 pV P V4 EM`VR 8X d \ R 4 \ R
4 \ R4 \ R4 pVR 8X d V P R4 pM'VR 8X d V P R4 pM\ R4 EK V P V4 M�VR8X d: \ R4 p\ R4 pV P WV4 pV P V4 M�VR8X d# V P
4 pV P V4 MrVR8X dM V P P R4 V P P 4 ^ , p\ RV 24 M VR 8X d \ R 4 R# \ R 4 \ R 4 EK� \ d p\ RT 24 Rp?L,Rp?ii ; i) u 运行搜索工具u! 42=== 反馈意见搜索工具 ===u 1. 根据关键词搜索u 2. 根据类别搜索u 3. 根据日期范围搜索u 4. 查看所有反馈意见u 5. 查看反馈意见总数u 0. 退出u 请选择操作编号: �1u 请输入关键词: �2u 请选择类别:u 1. 证券类u 2. 基金类u 请选择类别编号: r1 �fundu 无效的选择�3u, 请输入开始日期 (格式: YYYY-MM-DD): u, 请输入结束日期 (格式: YYYY-MM-DD): �4�5z SELECT COUNT(*) FROM feedbacksu 反馈意见总数: r- N�0u 退出搜索工具u! 无效的选择，请重新输入u 按回车键继续...) r �inputr r6 r$ r* r. r r �fetchoner ) r43 �choicer r �44cat_choicer( r) �countr s & r �run�FeedbackSearchTool.run^ s� � �� �6� 7� �,� -� �)� *� �/� 0� �/� 0� �/� 0� �+� ��4�5�F���}� � 6�7�� �0�0��9���"�"�7�+��3� ��(�)��n�%��n�%� "�#<� =�45� ��$� "� 5� 5�l� C�G� �3�&� "� 5� 5�f� =�G��+�,� ��"�"�7�+��3� � "�#Q� R�46� �!O�P�� �3�3�J�I���"�"�7�+��3� � �0�0�2���"�"�7�+��3� �0��K�K�'�'�(H�I� �K�K� 0� 0� 2�1� 5�E�� 0���8�9� �3� ��*�+�� �9�:� �)� *�� !� 0��N�1�#�.�/�/��0�s �A47G> �> H!� H � H!c �x � V P ' d( V P P 4 \ R4 R# R# )u 关闭数据库连接u 数据库连接已关闭N)r �closer )r48 s &r rH �FeedbackSearchTool.close� s' � � �9�9�9� �I�I�O�O� � �,� -� r )r r r N)z feedback.db)�__name__�49__module__� __qualname__�__firstlineno__r r r r$ r* r. r6 rE rH �__static_attributes__�__classdictcell__)�
__classdict__s @r r r s8 �� � �� �
�
�
� � � 9+�v.� .r r �__main__)r r r rJ � search_toolrE rH � r r �<module>rT sE �� � 50�Y.� Y.�v �z��$�&�K��O�O������ r