我们提供融合门户系统招投标所需全套资料,包括融合系统介绍PPT、融合门户系统产品解决方案、
融合门户系统产品技术参数,以及对应的标书参考文件,详请联系客服。
CREATE TABLE News ( id INT AUTO_INCREMENT PRIMARY KEY, title VARCHAR(255) NOT NULL, content TEXT, published_date DATE ); ]]>
from flask import Flask, jsonify from flask_sqlalchemy import SQLAlchemy app = Flask(__name__) app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://username:password@localhost/mydb' db = SQLAlchemy(app) class News(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(255), nullable=False) content = db.Column(db.Text, nullable=False) published_date = db.Column(db.Date, nullable=False) @app.route('/api/news', methods=['GET']) def get_news(): news_items = News.query.all() return jsonify([{'id': item.id, 'title': item.title, 'content': item.content, 'published_date': str(item.published_date)} for item in news_items]) if __name__ == '__main__': app.run(debug=True) ]]>
import React, { useState, useEffect } from 'react'; import axios from 'axios'; const NewsList = () => { const [news, setNews] = useState([]); useEffect(() => { axios.get('http://localhost:5000/api/news') .then(response => setNews(response.data)) .catch(error => console.error(error)); }, []); return ( {news.map(item => ( {item.title} {item.content} {item.published_date} ))}
);
};
export default NewsList;
]]>