Example #1
0
File: user.go Project: fyx912/token
//返回map类型,如: map[account:system password:123456]
func MapSelect() {
	mysql, err := db.OpenDatabase()
	db.CheckError(err)
	rows, err := mysql.Query(" SELECT account,password FROM User ")
	db.CheckError(err)
	defer rows.Close()
	columns, _ := rows.Columns()
	scanArgs := make([]interface{}, len(columns))
	values := make([]interface{}, len(columns))
	for i := range values {
		scanArgs[i] = &values[i]
	}

	for rows.Next() {
		//将行数据保存到record字典
		err = rows.Scan(scanArgs...)
		record := make(map[string]string)
		for i, col := range values {
			if col != nil {
				record[columns[i]] = string(col.([]byte))
			}
		}
		fmt.Println(record)
	}
}
Example #2
0
File: user.go Project: fyx912/token
//说明:flag 为函数返回值;username为接收参数
func ValidationUsername(usernames string) (falg bool) {
	mysql, err := db.OpenDatabase() //连接数据函数
	db.CheckError(err)
	rows, err := mysql.Query(" SELECT account,password FROM User where 1=1 and account=? ", usernames)
	// rows, err := mysql.Query(" SELECT account,password FROM User ")
	db.CheckError(err)
	defer rows.Close()
	columns, _ := rows.Columns()
	fmt.Println("columns=", columns)
	var user User
	for rows.Next() {
		var username string
		var password string
		err := rows.Scan(&username, &password)
		db.CheckError(err)
		user.Username = username
		fmt.Println("%s ", username)
	}
	if usernames == user.Username {
		falg = true
		fmt.Println("数据验证成功!", true)
	} else {
		falg = false
		fmt.Println("数据验证失败!", false)
	}
	return falg
}
Example #3
0
File: user.go Project: fyx912/token
func ValidationLoginTest() {
	mysql, err := db.OpenDatabase()
	db.CheckError(err)
	usernames := "system"
	passwords := "123456"
	rows, err := mysql.Query(" SELECT account,password FROM User where 1=1 and account=? and password=? ", usernames, passwords)
	// rows, err := mysql.Query(" SELECT account,password FROM User ")
	db.CheckError(err)
	defer rows.Close()
	columns, _ := rows.Columns()
	fmt.Println("columns=", columns)
	var user User
	for rows.Next() {
		var username string
		var password string
		err := rows.Scan(&username, &password)
		db.CheckError(err)
		user.Username = username
		user.Password = password
		fmt.Printf("%s is %v \n", username, password)
	}
	if usernames == user.Username && passwords == user.Password {
		fmt.Println(true)
	} else {
		fmt.Println(false)
	}
}