quot;
sql = sql & SqlStr(email) & ", "
sql = sql & SqlStr(password) & ", "
sql = sql & SqlStr(name) & ", "
sql = sql & SqlStr(school) & ", "
sql = sql & SqlStr(department) & ", "
sql = sql & SqlStr(sex) & ", "
sql = sql & SqlStr(phone) & ")"
conn.Execute sql
调用一个SQL的Insert语句把数据插入到数据库中。其实这一查询也可以做成存贮查询放在数据库中,我偷了点懒:-)不过对比之下也可以看到存贮查询的好处,运行时查询写起来实在是太麻烦了。
sql = sql & SqlStr(email) & ", "
sql = sql & SqlStr(password) & ", "
sql = sql & SqlStr(name) & ", "
sql = sql & SqlStr(school) & ", "
sql = sql & SqlStr(department) & ", "
sql = sql & SqlStr(sex) & ", "
sql = sql & SqlStr(phone) & ")"
conn.Execute sql
调用一个SQL的Insert语句把数据插入到数据库中。其实这一查询也可以做成存贮查询放在数据库中,我偷了点懒:-)不过对比之下也可以看到存贮查询的好处,运行时查询写起来实在是太麻烦了。
| 对此文章发表了评论 |
