Go-Server

1
package main
2

3
import (
4
	"database/sql"
5
	_ "github.com/go-sql-driver/mysql"
6
)
7

8
func isExistUser(name string) bool {
9
	db, err := sql.Open("mysql", "root:Hox3taBev@/MusicMan")
10
	if err != nil {
11
		panic(err)
12
	}
13
	defer db.Close()
14

15
	rows, err := db.Query("select * from MusicMan.users where name = ?", name)
16
	if err != nil {
17
		panic(err)
18
	}
19
	return rows.Next()
20
}
21

22
func addNewUser(name string, password string) (int64, bool) {
23
	db, err := sql.Open("mysql", "root:Hox3taBev@/MusicMan")
24
	if err != nil {
25
		panic(err)
26
		return -1, true
27
	}
28
	defer db.Close()
29
	sqlScript := "INSERT INTO MusicMan.users(name, password) VALUES (?, ?)"
30
	res, err := db.Exec(sqlScript, name, password)
31
	if err != nil {
32
		panic(err)
33
		return -1, true
34
	}
35
	lastId, _ := res.LastInsertId()
36
	return lastId, false
37
}
38