81,092
社区成员
发帖
与我相关
我的任务
分享
else{
PrintWriter out = response.getWriter();
response.setContentType("text/html;charset=utf-8");
response.setCharacterEncoding("utf-8");
out.println("<script language = javascript>alert('编号为空,请重新输入!')");
out.println("window.history.go(-1)</script>");
}
request.setAttribute("num","num");
request.getRequestDispatcher("跳转到的页面").forward(request,response);
num:${num}
这种情况默认在request中取参数,{}里面的是参数名称,如果不清楚可以看看EL教程。num:<%=request.getAttribute("num")%>
这样就可以取出了。public void delete(HttpServletRequest request, HttpServletResponse response)
throws ClassNotFoundException, SQLException, ServletException,
IOException {
try {
DBBean dbbean_delete = new DBBean();
String ch = request.getParameter("num");
String sql = "delete from news where num='"+ch+"'";
dbbean_delete.update(sql);
dbbean_delete.close();
response.sendRedirect("/task/mainpage.jsp");
} catch (Exception ex) {
ex.printStackTrace();
}
}
out.println("<tr>");
out.println("<td align=center>"+rs.getString("num").trim()+"</td>");
out.println("<td align=center>"+rs.getString("theme").trim()+"</td>");
out.println("<td align=center>"+rs.getString("author").trim()+"</td>");
out.println("<td align=center>"+rs.getString("date").trim()+"</td>");
out.println("<td align=center><a href='servlet/MyServlet?num="+ rs.getString("num").trim()+"'>修改</a>"+"</td>");
out.println("<td align=center><a href='servlet/MyServlet?num="+ rs.getString("num").trim()+"'>删除</a>"+"</td>");
}
out.println("</table>");
myDBbean.close();
//信息删除方法
public void delete(HttpServletRequest request, HttpServletResponse response) throws ClassNotFoundException, SQLException, ServletException, IOException{
Connection conn=null;
Statement stat=null;
conn=connect();
stat=conn.createStatement();
String id2=request.getParameter("id");
stat.execute("delete from student where id="+id2+"");
request.getRequestDispatcher("delete.jsp").forward(request, response);
}
//信息修改方法
public void update1(HttpServletRequest request, HttpServletResponse response) throws ClassNotFoundException, SQLException, ServletException, IOException{
String id4=request.getParameter("id");
request.setAttribute("result", select(id4,""));
request.getRequestDispatcher("update1.jsp").forward(request, response);
}
public void update(HttpServletRequest request, HttpServletResponse response) throws ClassNotFoundException, SQLException, ServletException, IOException{
Connection conn=null;
Statement stat=null;
String id3=request.getParameter("id");
String name3=request.getParameter("name");
String age3=request.getParameter("age");
String gender3=request.getParameter("gender");
String major3=request.getParameter("major");
conn=connect();
stat=conn.createStatement();
stat.execute("update student set id="+id3+",name='"+name3+"',age="+age3+",gender='"+gender3+"',major='"+major3+"' where id="+id3+"");
request.setAttribute("result", select(id3,""));
request.getRequestDispatcher("update.jsp").forward(request, response);
}
}
DBBean myDbBean = new DBBean();
ResultSet rs=myDbbean.query("select * from news");