go語言操作資料庫（database/sql）

這是一個建立於 的文章，其中的資訊可能已經有所發展或是發生改變。

操作sql類，目前只有一個查詢，其他可以根據這個再去擴充

package QORMimport ("database/sql""fmt""reflect"_ "github.com/go-sql-driver/mysql")//請求結構體type QDBProto struct {DB *sql.DB}var qDBProto *QDBProto//建構函式func CreateDBProto(driver string, sqlLink string) *QDBProto {qDBProto = new(QDBProto)db, err := sql.Open(driver, sqlLink)if err == nil {qDBProto.DB = dbreturn qDBProto} else {return nil}}//查詢func (p *QDBProto) Select(destClass interface{}, sqlstr string, arg ...interface{}) ([]interface{}, int) {var rowCount int = 0var rows *sql.Rowsvar err errorif arg != nil {rows, err = p.DB.Query(sqlstr)} else {rows, err = p.DB.Query(sqlstr, arg)}if err != nil {fmt.Println(err.Error())return nil, rowCount}defer rows.Close()result := make([]interface{}, 0)for rows.Next() {scanArr := make([]interface{}, 0)scanEntity := make(map[string]interface{})destValue := reflect.ValueOf(destClass)destType := reflect.TypeOf(destClass)fieldCount := destValue.NumField()for fieldIndex := 0; fieldIndex < fieldCount; fieldIndex++ {field := destValue.Field(fieldIndex)fieldType := field.Type()newFieldValue := reflect.New(fieldType)fieldValue := newFieldValue.Interface()scanArr = append(scanArr, fieldValue)fmt.Println(destType.Field(fieldIndex).Name)scanEntity[destType.Field(fieldIndex).Name] = fieldValue}if err := rows.Scan(scanArr...); err != nil {fmt.Println(err.Error())return nil, rowCount} else {result = append(result, scanEntity)rowCount++}}return result, rowCount}

使用：

rows, rowCount := conn2.Select(automethodNew{}, "select * from automethod")