return
}
k := 【BUSINESS OBJECT】
err = json.Unmarshal(data, &k)
if err != nil {
utility.SimpleFeedBack(w, 13, "Pramaters failed!")
pillarsLog.PillarsLogger.Print("Pramaters failed!")
return
}
//方便快捷。再访问参数的时候，直接调用结构体参数就可以了。
//注意ajax调用函数的时候需要做出一些调整代码如下：
$.ajax([dist],JSON.stringify([data]),function(){},'json');//注意JSON
7.持久层
7.1 Mysql
其实不管什么语言的Mysql驱动都是从PRO*C来的，所以会PRO*C之后，啥都好说
Insert/Delete/Update
stmt, err := mysqlUtility.DBConn.Prepare("INSERT INTO credit (credit_code, user_code, credit_rank) VALUES (?, ?, ?)")
if err != nil {
pillarsLog.PillarsLogger.Print(err.Error())
return false, err
}
defer stmt.Close()
_, err = stmt.Exec(credit.CreditCode, credit.UserCode, credit.CreditRank)
if err != nil {
return false, err
} else {
return true, err
}
//还是比较方便的
Query
stmt, err := mysqlUtility.DBConn.Prepare(`SELECT commodity_code, commodity_name, description, picture,
price, storage, count, status,
insert_datetime, update_datetime FROM commodity WHERE commodity_code = ?`)
if err != nil {
return nil, err
}
defer stmt.Close()
result, err := stmt.Query(commodityCode)
if err != nil {
return nil, err
}
defer result.Close()
var commodity utility.Commodity
if result.Next() {
err = result.Scan(&(commodity.CommodityCode), &(commodity.CommodityName), &(commodity.Description),
&(commodity.Picture), &(commodity.Price), &(commodity.Storage), &(commodity.Count), &(commodity.Status),
