string strSQL="insert into table1(username,password,sex,age,info) values('"+strName+ ","+ strPwd + "," + strSex + "," + strAge + "," + strInfo+"')";你这段sql最后会拼接成insert into table1(username,password,sex,age,info) values('xxx,xxx,xxx,xxx,xxx')这样前面是5个字段,而你values 因为单引号的原因最后拼接成一个字段的值了,前后不符合了。建议做这种拼接时用占位符的方式,那样看着会清晰,不会因为单双引号弄出...
|