update.jsp

来自「课程设计中的在线书店源码」· JSP 代码 · 共 36 行

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<%@ include file="check.jsp"%>
<jsp:useBean id="conn" class="dbBean.DBBean" scope="session"/>
<%
	String name="不详";
	String star="";
	String size="0.0";
	String type="";
	String platform="不详";
	String profile="不详";
	String filename="";
	String editid="0";
	request.setCharacterEncoding("gb2312");
	if(request.getParameter("editid")!=null)
		editid=request.getParameter("editid");
if(request.getParameter("name")!=null&&!request.getParameter("name").equals(""))
		name=request.getParameter("name");
	if(request.getParameter("star")!=null)
		star=request.getParameter("star");
	if(request.getParameter("size")!=null&&!request.getParameter("size").equals(""))
		size=request.getParameter("size");
	if(request.getParameter("type")!=null)
		type=request.getParameter("type");
	if(request.getParameter("platform")!=null&&!request.getParameter("platform").equals(""))
		platform=request.getParameter("platform");
	if(request.getParameter("profile")!=null&&!request.getParameter("profile").equals(""))
		profile=request.getParameter("profile");
	if(request.getParameter("filename")!=null)
		filename=request.getParameter("filename");

	String sql="update sinfo set name='"+name+"',star='"+star+"',size="+size+",type='"+type+"',platform='"+platform+"',profile='"+profile+"',filename='"+filename+"' where id="+editid;
	conn.executeUpdate(sql);
	conn.close();
	response.sendRedirect("manage.jsp");
%>