jsp 连接mysql空指针_JSP连接数据库 空指针异常怎么解决

Integer aa=(Integer)session.getAttribute("id");

Integer rest=(Integer)session.getAttribute("rest");

int tempid=aa.intValue();

int flag=0;

Connection conn=null;

PreparedStatement pstat=null;

DBConn db=new DBConn();

try{

String sql="update t_ticket set rest=? where id=?";

conn=db.getConn();

pstat=conn.prepareStatement(sql);

pstat.setInt(1,rest-1);

pstat.setInt(2,aa);

flag=pstat.executeUpdate();

if(flag!=0){

response.sendRedirect("jpd.jsp");

}else{

response.sendRedirect("error.jsp");

}

}catch(SQLException e){

System.out.println("数据库处理失败"+e.toString());

}finally{

if(pstat!=null) pstat.close();

if(conn!=null) conn.close();

}

%>

这段代码中String sql="update t_ticket set rest=? where id=?";

conn=db.getConn();

pstat=conn.prepareStatement(sql);

pstat.setInt(1,rest-1);

pstat.setInt(2,aa);

flag=pstat.executeUpdate();

是不是有问题u

展开