AI助手Copilot辅助Go+Flutter打造全栈式在线教育系统|果fx

mkdir online-education-system
cd online-education-system
go mod init online-education-system

go get -u github.com/gin-gonic/gin
go get -u github.com/jackc/pgx/v4

package main

import (
    "github.com/gin-gonic/gin"
    "github.com/jackc/pgx/v4"
    "context"
    "log"
)

func main() {
    r := gin.Default()
    
    // 数据库连接
    conn, err := pgx.Connect(context.Background(), "postgres://username:password@localhost:5432/yourdbname")
    if err != nil {
        log.Fatalf("Unable to connect to database: %v\n", err)
    }
    defer conn.Close(context.Background())

    // 定义路由
    r.GET("/api/courses", func(c *gin.Context) {
        // 查询课程逻辑
        c.JSON(200, gin.H{
            "message": "获取课程列表",
        })
    })

    r.Run() // 启动服务器
}

CREATE DATABASE yourdbname;

\c yourdbname;

CREATE TABLE courses (
    id SERIAL PRIMARY KEY,
    title VARCHAR(100),
    description TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

flutter create online_education_app
cd online_education_app

dependencies:
  flutter:
    sdk: flutter
  http: ^0.14.0

flutter pub get

import 'package:flutter/material.dart';
import 'package:http/http.dart' as http;
import 'dart:convert';

void main() => runApp(MyApp());

class MyApp extends StatelessWidget {
  @override
  Widget build(BuildContext context) {
    return MaterialApp(
      title: '在线教育系统',
      home: CourseList(),
    );
  }
}

class CourseList extends StatefulWidget {
  @override
  _CourseListState createState() => _CourseListState();
}

class _CourseListState extends State<CourseList> {
  List<dynamic> courses = [];

  @override
  void initState() {
    super.initState();
    fetchCourses();
  }

  Future<void> fetchCourses() async {
    final response = await http.get(Uri.parse('http://localhost:8080/api/courses'));

    if (response.statusCode == 200) {
      setState(() {
        courses = json.decode(response.body)['courses'];
      });
    } else {
      throw Exception('Failed to load courses');
    }
  }

  @override
  Widget build(BuildContext context) {
    return Scaffold(
      appBar: AppBar(
        title: Text('课程列表'),
      ),
      body: ListView.builder(
        itemCount: courses.length,
        itemBuilder: (context, index) {
          return ListTile(
            title: Text(courses[index]['title']),
            subtitle: Text(courses[index]['description']),
          );
        },
      ),
    );
  }
}

go run main.go

flutter run