{"rsdb":{"rid":"242844","subhead":"","postdate":"0","aid":"167199","fid":"78","uid":"1","topic":"1","content":"
\n

JS \u5206\u9875<\/p> \n

1>     JS\u5206\u9875\uff0c\u4e1a\u52a1\u903b\u8f91<\/p> \n

(1)     \u5206\u9875\u91c7\u7528\u7684\u662f\u4e00\u4e2a\u53ebjquery.pagination.js\u7684\u4e00\u4e2ajquery\u63d2\u4ef6<\/p> \n

(2)     \u9700\u8981jquery\u7684\u652f\u6301\uff0c\u6b64\u9879\u76ee\u4e2d\u4f7f\u7528\u5230\u7684\u662fjquery-2.1.1.min.js<\/p> \n

(3)     \u5206\u9875\u9700\u8981\u7684\u53c2\u6570\u6709:\u8bb0\u5f55\u603b\u6570\uff0c\u6bcf\u9875\u663e\u793a\u4e2a\u6570\uff0c\u9875\u7801<\/p> \n

(4)     \u6dfb\u52a0\u641c\u7d22\u7684\u6761\u4ef6\uff0c\u4f5c\u4e3a\u67e5\u8be2\u4f7f\u7528<\/p> \n

2>     \u7f16\u5199\u65b0\u7684model\uff0c\u547d\u540d\u4e3aperson.go.\u5176\u4ee3\u7801\u5982\u4e0b:<\/p> \n

   <\/p> \n

\n 
package models\n\nimport (\n\t"log"\n\t"fmt"\n db "GinLearn\/GinLearn\/database"\n)\n\/\/\u8868\u7ed3\u6784\ntype Person struct {\n   Id        int    `json:"id" form:"id"`\n   FirstName string `json:"first_name" form:"first_name"`\n   LastName  string `json:"last_name" form:"last_name"`\n}\n\n\/\/\u65b0\u589e\u8bb0\u5f55\nfunc (p *Person) AddPerson() bool {\n   rs, err := db.SqlDB.Exec("INSERT INTO person(first_name, last_name) VALUES (?, ?)", p.FirstName, p.LastName)\n   if err != nil {\n     return false\n   }\n   id, err := rs.LastInsertId()\n   fmt.Println(id)\n   if err!=nil{\n     return false\n   }else{\n     return true\n   }\n}\n\n\/\/\u4fee\u6539\u8bb0\u5f55\nfunc (p *Person) EditPerson() bool {\n  rs, err := db.SqlDB.Exec("UPDATE person set first_name=?,last_name=? where id=?", p.FirstName, p.LastName,p.Id)\n  if err != nil {\n    return false\n  }\n  id, err := rs.RowsAffected()\n  fmt.Println(id)\n  if err!=nil{\n    return false\n  }else{\n    return true\n  }\n}\n\n\/\/\u5220\u9664\u8bb0\u5f55\nfunc DeletePerson(Id int) bool {\n  rs, err := db.SqlDB.Exec("Delete From person where id=?", Id)\n  if err != nil {\n    return false\n  }\n  id, err := rs.RowsAffected()\n  fmt.Println(id)\n  if err!=nil{\n    return false\n  }else{\n    return true\n  }\n}\n\n\/\/\u5f97\u5230\u8bb0\u5f55\u5217\u8868\nfunc GetPersonList(pageno,pagesize int,search string) (persons []Person) {\n\n    fmt.Println("\u641c\u7d22\u53c2\u6570:"+search)\n    persons = make([]Person, 0)\n    \/\/SQL\u67e5\u8be2\u5206\u9875\u8bed\u53e5\n    if search!=""{\n      rows, err := db.SqlDB.Query("SELECT id, first_name, last_name FROM person where 1=1 and last_name like '%"+search+"%' or first_name like '%"+search+"%' limit ?,?",(pageno-1)*pagesize,pagesize)\n      if err != nil {\n        return nil\n       }\n       defer rows.Close()\n    \n       \/\/\u6570\u636e\u6dfb\u52a0\u5230\u6570\u636e\u96c6\u4e2d\n       for rows.Next() {\n         var person Person\n         rows.Scan(&person.Id, &person.FirstName, &person.LastName)\n         persons = append(persons, person)\n       }\n       if err = rows.Err(); err != nil {\n         return nil\n       }\n     \n    }else{\n      rows, err := db.SqlDB.Query("SELECT id, first_name, last_name FROM person where 1=1  limit ?,?",(pageno-1)*pagesize,pagesize)\n      if err != nil {\n        return nil\n      }\n      defer rows.Close()\n\n    \n     \/\/\u6570\u636e\u6dfb\u52a0\u5230\u6570\u636e\u96c6\u4e2d\n     for rows.Next() {\n       var person Person\n       rows.Scan(&person.Id, &person.FirstName, &person.LastName)\n       persons = append(persons, person)\n      }\n      if err = rows.Err(); err != nil {\n       return nil\n     }\n  }\n  return persons\n}\n\/\/\u5f97\u5230\u8bb0\u5f55\u6570\nfunc GetRecordNum(search string) int {\n   num:=0;\n\n  \/\/SQL\u67e5\u8be2\u5206\u9875\u8bed\u53e5\n  if search!=""{\n    rows, err := db.SqlDB.Query("SELECT id, first_name, last_name FROM person where 1=1 and first_name like '%?%' or last_name '%?%'",search,search)\n    if err != nil {\n      return 0\n     }\n     defer rows.Close()\n  \n     \/\/\u6570\u636e\u6dfb\u52a0\u5230\u6570\u636e\u96c6\u4e2d\n     for rows.Next() {\n       num++;\n     }\n   \n  }else{\n    rows, err := db.SqlDB.Query("SELECT id, first_name, last_name FROM person where 1=1")\n    if err != nil {\n      return 0\n    }\n    defer rows.Close()\n\n  \n   \/\/\u6570\u636e\u6dfb\u52a0\u5230\u6570\u636e\u96c6\u4e2d\n  \/\/\u6570\u636e\u6dfb\u52a0\u5230\u6570\u636e\u96c6\u4e2d\n  for rows.Next() {\n    num++;\n  }\n  \n}\nreturn num\n}\n\/\/\u5f97\u5230\u7528\u6237\u6570\u636e\nfunc  GetPersonById(Id int) (p *Person) {\n \n  var person Person\n  \/\/\u6839\u636eID\u67e5\u8be2\u5f97\u5230\u5bf9\u8c61\n  err := db.SqlDB.QueryRow("SE","orderid":"0","title":"Gin-Go\u5b66\u4e60\u7b14\u8bb0\u4e09\uff1aGin-Web\u6846\u67b6 JS\u5206\u9875(\u4e00)","smalltitle":"","mid":"0","fname":"GO","special_id":"0","bak_id":"0","info":"0","hits":"2524","pages":"6","comments":"0","posttime":"2017-12-20 12:50:15","list":"1513745415","username":"admin","author":"","copyfrom":"","copyfromurl":"","titlecolor":"","fonttype":"0","titleicon":"0","picurl":"http:\/\/images2017.cnblogs.com\/blog\/1290422\/201712\/1290422-20171220101529943-574435923.png","ispic":"1","yz":"1","yzer":"","yztime":"0","levels":"0","levelstime":"0","keywords":"Gin-Go<\/A> \u5b66\u4e60<\/A> \u7b14\u8bb0<\/A> Gin-Web<\/A> \u6846\u67b6<\/A> JS\u5206\u9875<\/A>","jumpurl":"","iframeurl":"","style":"","template":"a:3:{s:4:\"head\";s:0:\"\";s:4:\"foot\";s:0:\"\";s:8:\"bencandy\";s:0:\"\";}","target":"0","ip":"119.123.182.93","lastfid":"0","money":"0","buyuser":"","passwd":"","allowdown":"","allowview":"","editer":"","edittime":"0","begintime":"0","endtime":"0","description":"Gin-Go\u5b66\u4e60\u7b14\u8bb0\u4e09\uff1aGin-Web\u6846\u67b6 JS\u5206\u9875","lastview":"1714066941","digg_num":"0","digg_time":"0","forbidcomment":"0","ifvote":"0","heart":"","htmlname":"","city_id":"0"},"page":"1"}