为什么数据有时能添加到数据库,有时不能?
<%
String suser=new String(request.getParameter("user").getBytes("8859_1"));
String szu=new String(request.getParameter("zu").getBytes("8859_1"));
String spassword=new String(request.getParameter("password").getBytes("8859_1"));
String spassword2=new String(request.getParameter("password2").getBytes("8859_1"));
String srname=new String(request.getParameter("rname").getBytes("8859_1"));
String ssex=new String(request.getParameter("sex").getBytes("8859_1"));
String sphone=new String(request.getParameter("phone").getBytes("8859_1"));
String saddress=new String(request.getParameter("address").getBytes("8859_1"));
%>
<%
String str="insert into USER (UNAME,UCLASS,UPASSWORD,URNAME,USEX,UPHONE,UADDRESS) values('"+ suser +"','"+ szu+ "','"+ spassword +"','"+ srname +"','"+ ssex +"',"+ sphone +",'"+ saddress +"')";
AddBean.executeUpdate(str);
out.println(str);
%>
输出sql语句是正确的,真是弄不懂~