小菜jsp里从表单数据更新数据库总出异常,大家帮忙。
<%@ page contentType="text/html; charset=gb2312" language="java" pageEncoding="UTF-8"%>
<jsp:useBean id="db" class="db.Datebase" scope="page"/>
<%
String username = new String(request.getParameter("username").getBytes("ISO_8859_1"),"GBK");
String zhiye = new String(request.getParameter("zhiye").getBytes("ISO_8859_1"),"GBK");
String age = request.getParameter("age");
String weizhi = new String(request.getParameter("weizhi").getBytes("ISO_8859_1"),"GBK");
String aihao = new String(request.getParameter("aihao").getBytes("ISO_8859_1"),"GBK");
String biancheng = new String(request.getParameter("biancheng").getBytes("ISO_8859_1"),"GBK");
String qq = request.getParameter("qq");
String xingbie = new String(request.getParameter("xingbie").getBytes("ISO_8859_1"),"GBK");
String xingzuo = new String(request.getParameter("xingzuo").getBytes("ISO_8859_1"),"GBK");
String Msn = request.getParameter("msn");
String Email = request.getParameter("email");
String lianxifangshi = new String(request.getParameter("lianxifangshi").getBytes("ISO_8859_1"),"GBK");
String sql = "update 档案表 set 姓名 = '"+username+"',职业 = '"+zhiye+"',年龄 = '"+age+"',位置 = '"+weizhi+"',爱好 = '"+aihao+"',编程 = '"+biancheng+"',QQ = '"+qq+"',性别 = '"+xingbie+"',星座 = '"+xingzuo+"',Msn = '"+Msn+"',Email = '"+Email+"',联系方式 = '"+lianxifangshi+"' ;";
if(db.updateSql(sql)==true)
out.println("修改成功~");
db.closeConnection();
%>
小菜要更新数据库,数据库里一个表,所有字段都是默认文本。为什么这样还写不进去,总抛java.lang.NullPointerException异常。同样方法从数据库里读数据正常啊。
还有问一下,从表单接受数据更新数据库,这样写好吗?还有别的写法吗?小菜初学,各位GG多指教。
(当然表单传来的数据安全验证暂时不考虑在内)。