有一字符串如:user:name%name%name%name.....%#typename为不固定长度的字符串,以%为分隔,如何将name字符串一个一个读出,并写入到数据库USER表中的user字段?求思路或原码,最好有代码.完成后正确再加分
conn为数据库连接dim arry() as string dim sql as string dim i as integerarry = split(user,"%")for i = 0 to ubound(arry) sql = "insert into user(user) values('" & arry(i) & "')" conn.execute sqlnext