向Mysql数据库插入数据.
<%
String id=new String(request.getParameter("TxtUserID").trim().getBytes("ISO-8859-1"));
String pass=new String(request.getParameter("TxtPassword").trim().getBytes("ISO-8859-1"));
String card_type=new String(request.getParameter("DDLQuestion").trim().getBytes("ISO-8859-1"));
String card_id=new String(request.getParameter("TxtNumber").trim().getBytes("ISO-8859-1"));
String address=new String(request.getParameter("TxtStreet").trim().getBytes("ISO-8859-1"));
String phone=new String(request.getParameter("PhoneNumber").trim().getBytes("ISO-8859-1"));
String name=new String(request.getParameter("TxtName").trim().getBytes("ISO-8859-1"));
String gender=new String(request.getParameter("DDLGender").trim().getBytes("ISO-8859-1"));
String email=new String(request.getParameter("TxtEmail").trim().getBytes("ISO-8859-1"));
petUtil.connect();//连接数据库
String sql1="insert into user values('123','222','123','123','123','123','123','123')";
String sql2="insert into user values('"+id+"','"+card_id+"','"+pass+"','"+address+"','"+phone+"','"+name+"','"+gender+"','"+email+"')";
petUtil.update(sql1);//插入数据库
petUtil.update(sql2);
%>
本人刚学JSP,哪位高手可以告诉我为什么在上述代码中.语句sql1可以成功插入数据库,而sql2却不能插入呢?