|
nbsp;
db.Query("drop database if exists tmpdb")
db.Query("create database tmpdb")
//db.Query("use tmpdb")
db.Query("create table tmpdb.tmptab(c1 int, c2 varchar(20), c3 varchar(20))")
db.Query("insert into tmpdb.tmptab values(101, '姓名1', 'address1'), (102, '姓名2', 'address2'), (103, '姓名3', 'address3'), (104, '姓名4', 'address4')")
//checkErr(err)
query, err := db.Query("select * from tmpdb.tmptab")
checkErr(err)
v := reflect.ValueOf(query)
fmt.Println(v)
fmt.Println("--增加数据测试--")
printResult(query)
db.Query("delete from tmpdb.tmptab where c1 = 101")
//checkErr(err)
query2, _ := db.Query("select * from tmpdb.tmptab")
fmt.Println("--删除数据测试--")
printResult(query2)
db.Query("update tmpdb.tmptab set c3 = 'address4' where c1 = 103")
//checkErr(err)
query3, _ := db.Query("select * from tmpdb.tmptab")
fmt.Println("--更新数据测试--")
printResult(query3)
db.Query("delete from tmpdb.tmptab")
//checkErr(err)
query4, _ := db.Query("select * from tmpdb.tmptab")
|