Go语言实现简单留言板的方法

2019-11-10 09:19:20王振洲

   
        // 显示数据
        err = tpl.ExecuteTemplate(w, "list", lys)
        if err != nil {
            log.Fatal(err)
        }
    }
   
    // 留言页面 /liuyan
    requestLiuyan := func(w http.ResponseWriter, req *http.Request) {
        err := req.ParseForm()
        if err != nil{
            log.Fatal(err)
        }
   
        if "POST" == req.Method {
            if len(req.Form["name"]) < 1 {
                io.WriteString(w, "参数错误!n")
                return
            }
            if len(req.Form["content"]) < 1 {
                io.WriteString(w, "参数错误!n")
                return
            }
   
            name := template.HTMLEscapeString(req.Form.Get("name"))
            content := template.HTMLEscapeString(req.Form.Get("content"))
   
            // sql语句
            sql, err := db.Prepare("insert into liuyan(name, content, time) values(?, ?, ?)")
            if err != nil {
                log.Fatal(err)
            }
            defer sql.Close()
   
            // sql参数,并执行
            _, err = sql.Exec(name, content, time.Now().Unix())
            if err != nil {
                log.Fatal(err)