基于golang的学生信息管理系统

package main

import (
	"database/sql"
	"html/template"
	"log"
	"net/http"

	_ "github.com/go-sql-driver/mysql"
)

var a1 *sql.DB
var a2 error

func init() {
	a1, a2 = sql.Open("mysql", "root:123456@tcp(127.0.0.1:3306)/books")
	if a2 != nil {
		log.Fatal(a2)
	}

	a2 = a1.Ping()
	if a2 != nil {
		log.Fatal(a2)
	}
}

func main() {
	http.HandleFunc("/results", a3)
	http.HandleFunc("/register", a4)
	http.HandleFunc("/registerSubmit", a5)
	http.HandleFunc("/login", a6)
	http.HandleFunc("/searchSubmit", a7)
	http.HandleFunc("/", a8)
	http.HandleFunc("/loginSubmit", a9)
	http.HandleFunc("/search", a10)
	log.Fatal(http.ListenAndServe(":8080", nil))
}

func a8(w http.ResponseWriter, r *http.Request) {
	t := template.Must(template.ParseFiles("index.html"))
	t.Execute(w, nil)
}

func a4(w http.ResponseWriter, r *http.Request) {
	t := template.Must(template.ParseFiles("register.html"))
	t.Execute(w, nil)
}

func a5(w http.ResponseWriter, r *http.Request) {
	if r.Method == "POST" {
		name := r.FormValue("name")
		pass := r.FormValue("pass")
		_, a2 := a1.Exec("INSERT INTO users (name, pass) VALUES (?, ?)", name, pass)
		if a2 != nil {
			http.Error(w, a2.Error(), http.StatusInternalServerError)
			return
		}
		http.Redirect(w, r, "/login", http.StatusSeeOther)
	}
}

func a6(w http.ResponseWriter, r *http.Request) {
	t := template.Must(template.ParseFiles("login.html"))
	t.Execute(w, nil)
}

func a9(w http.ResponseWriter, r *http.Request) {
	if r.Method == "POST" {
		name := r.FormValue("name")
		pass := r.FormValue("pass")
		var a3 string
		a2 := a1.QueryRow("SELECT name FROM users WHERE name = ? AND pass = ?", name, pass).Scan(&a3)
		if a2 != nil {
			http.Error(w, "用户名或密码错误", http.StatusUnauthorized)
			return
		}
		http.Redirect(w, r, "/search", http.StatusSeeOther)
	}
}

func a10(w http.ResponseWriter, r *http.Request) {
	t := template.Must(template.ParseFiles("search.html"))
	t.Execute(w, nil)
}

func a7(w http.ResponseWriter, r *http.Request) {
	if r.Method == "POST" {
		query := r.FormValue("query")
		http.Redirect(w, r, "/results?q="+query, http.StatusSeeOther)
	}
}

func a3(w http.ResponseWriter, r *http.Request) {
	query := r.URL.Query().Get("q")
	rows, a2 := a1.Query("SELECT * FROM stud WHERE xuehao LIKE ? OR xingming LIKE ? OR ban LIKE ? OR banma LIKE ? OR kecheng LIKE ? OR zy LIKE ?", "%"+query+"%", "%"+query+"%", "%"+query+"%", "%"+query+"%", "%"+query+"%", "%"+query+"%")
	if a2 != nil {
		http.Error(w, a2.Error(), http.StatusInternalServerError)
		return
	}
	defer rows.Close()

	var results []map[string]interface{}
	for rows.Next() {
		var id int
		var xuehao, xingming, ban, banma, kecheng, zy string
		a2 := rows.Scan(&id, &xuehao, &xingming, &ban, &banma, &kecheng, &zy)
		if a2 != nil {
			http.Error(w, a2.Error(), http.StatusInternalServerError)
			return
		}
		result := map[string]interface{}{
			"id":       id,
			"xuehao":   xuehao,
			"xingming": xingming,
			"ban":      ban,
			"banma":    banma,
			"kecheng":  kecheng,
			"zy":       zy,
		}
		results = append(results, result)
	}

	t := template.Must(template.ParseFiles("results.html"))
	t.Execute(w, results)
}