下面這段話有什么問(wèn)題，輸入已有的用戶名會(huì)執(zhí)行“該用戶名已存在”，但是輸入新的用戶名顯示注冊(cè)成功但是數(shù)據(jù)庫(kù)里沒有新的記錄，應(yīng)該是賦值語(yǔ)句有問(wèn)題，請(qǐng)問(wèn)insert語(yǔ)句哪里錯(cuò)了呢String username=request.getParameter("r_user");String password=request.getParameter("r_password");sql=conn.createStatement();rs=sql.executeQuery("select * from user where username='"+username+"'");if(!rs.next()){String updateCondition="insert into user(username,password)values('"+username+"','"+password+"')";out.print("注冊(cè)成功！");response.setHeader("refresh","2;URL=index.jsp");}else{out.print("該用戶名已存在");response.setHeader("refresh", "3;URL=reg2.jsp");}}
jsp中sql的insert語(yǔ)句問(wèn)題
DIEA
2019-04-25 18:19:57
