\u4ece\u6570\u636e\u5e93\u4e2d\u8bfb\u53d6\u6570\u636e<\/h3> \n
\u5728http:\/\/sqlitebrowser.org\/<\/a>\u4e0b\u8f7dsqlite3\u53ef\u89c6\u5316\u5de5\u5177\uff0c\u5728\u672cmain.go\u540c\u76ee\u5f55\u4e0b\u521b\u5efapersonal.db<\/code>\u6570\u636e\u5e93\uff0c\u521b\u5efa\u8868\u5982\u4e0b\uff1a
<\/p> \n package main\n\nimport (\n "database\/sql"\n "fmt"\n\n _ "github.com\/mattn\/go-sqlite3"\n)\n\/\/ \u7528struct\u7c7b\u578b\u5c06\u6765\u81eaSQL\u6570\u636e\u5e93\u7684\u6570\u636e\u6620\u5c04\u5230\u5185\u5b58\u4e2d\u7684\u5bf9\u8c61\ntype Profile struct {\n ProfileId int\n FirstName string\n LastName string\n Age int\n}\n\nfunc main() {\n db, err := sql.Open("sqlite3", ".\/personal.db")\n checkError(err)\n var profile Profile\n \/\/ Query\u53ef\u4ee5\u4f7f\u7528\u53c2\u6570\n rows, err := db.Query("select ProfileId, FirstName, LastName, Age from Profile where FirstName = ? and LastName = ?", "Tarik", "Guney")\n checkError(err)\n for rows.Next() {\n err := rows.Scan(&profile.ProfileId, &profile.FirstName, &profile.LastName, &profile.Age)\n checkError(err)\n fmt.Println(profile)\n }\n rows.Close()\n db.Close()\n}\n\nfunc checkError(err error) {\n if err != nil {\n panic(err)\n }\n}<\/code><\/pre> \n
\u5c06\u6570\u636e\u63d2\u5165\u6570\u636e\u5e93<\/h3> \n
package main\n\nimport (\n _ "github.com\/mattn\/go-sqlite3"\n "database\/sql"\n "fmt"\n)\n\ntype Profile struct{\n ProfileId int\n FirstName string\n LastName string\n Age int\n}\n\nfunc main(){\n db, err := sql.Open("sqlite3", ".\/personal.db")\n checkError(err)\n \/* \u66f4\u65b0\u6570\u636e\u5e93\u6570\u636e\n statement, err := db.Prepare("update Profile set FirstName = ? where ProfileId = ?")\n checkError(err)\n statement.Exec("Martha", 5)\n *\/\n statement, err := db.Prepare("insert into Profile (FirstName, LastName, Age) values(?,?,?)")\n checkError(err)\n statement.Exec("Jessica", "McArthur", 30)\n \/* \u5220\u9664\u6570\u636e\u5e93\u6570\u636e\n statement ,err := db.Prepare("delete from Profile where ProfileId = ?")\n checkError(err)\n statement.Exec(3)\n *\/\n var profile Profile\n rows, err := db.Query("select ProfileId, FirstName, LastName, Age from Profile")\n checkError(err)\n for rows.Next(){\n err := rows.Scan(&profile.ProfileId, &profile.FirstName, &profile.LastName, &profile.Age)\n checkError(err)\n fmt.Println(profile)\n }\n rows.Close()\n db.Close()\n}\n\nfunc checkError(err error) {\n if (err != nil) {\n panic(err)\n }\n}<\/code><\/pre> \n<\/div>","orderid":"0","title":"Go\u57fa\u7840\u7f16\u7a0b\u5b9e\u8df5\uff08\u5341\uff09\u2014\u2014 \u6570\u636e\u5e93","smalltitle":"","mid":"0","fname":"GO","special_id":"0","bak_id":"0","info":"0","hits":"102","pages":"1","comments":"0","posttime":"2019-07-13 20:10:47","list":"1563019847","username":"admin","author":"","copyfrom":"","copyfromurl":"","titlecolor":"","fonttype":"0","titleicon":"0","picurl":"https:\/\/www.cppentry.com\/upload_files\/","ispic":"0","yz":"1","yzer":"","yztime":"0","levels":"0","levelstime":"0","keywords":"\u57fa\u7840<\/A> \u7f16\u7a0b<\/A> \u5b9e\u8df5<\/A> \u6570\u636e\u5e93<\/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":"47.106.78.186","lastfid":"0","money":"0","buyuser":"","passwd":"","allowdown":"","allowview":"","editer":"","edittime":"0","begintime":"0","endtime":"0","description":"Go\u57fa\u7840\u7f16\u7a0b\u5b9e\u8df5\uff08\u5341\uff09\u2014\u2014 \u6570\u636e\u5e93","lastview":"1708210865","digg_num":"0","digg_time":"0","forbidcomment":"0","ifvote":"0","heart":"","htmlname":"","city_id":"0"},"page":"1"}