Dim Tmp as string SELECT MAX(id) as AID from YourTable AID=AID+1
(1):dim sql as string sql="select * from T1" set rs=cn.Execute(sql) if rs.eof then cn.Execute("Insert into T1(id)value('gz001')") end if(2):可用字符串截取,截取后三位,然后+1了之后再和'gz'连接起来形成你想要的字符串 最后插入数据库即可
SELECT MAX(id) as AID from YourTable AID=AID+1
set rs=cn.Execute(sql)
if rs.eof then
cn.Execute("Insert into T1(id)value('gz001')")
end if(2):可用字符串截取,截取后三位,然后+1了之后再和'gz'连接起来形成你想要的字符串
最后插入数据库即可