獲取后端數(shù)據(jù) (查看全部數(shù)據(jù)) :? select? *? from uesrlist
查找的數(shù)據(jù)? ? ? :? select? *? from? userlist? where? id=${id}
搜索的數(shù)據(jù)? ? ? :? select *? from userlist? where name like %{張三}%? and? id=9
添加的數(shù)據(jù)? ? :insert? into? userlist (name...) values? (${name},...)
刪除的數(shù)據(jù)? ? :delete? from? userlist? where id =${id}
修改的數(shù)據(jù)? ? :updata userlist set name=${name} where id=${id}
例 : updata userlist set name="張三" where id=33