save.jsp

课程设计中的在线书店源码

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<%@ include file="check.jsp"%>
<jsp:useBean id="conn" class="dbBean.DBBean" scope="session"/>
<%
	request.setCharacterEncoding("gb2312");
	String name="不详";
	String star="";
	String size="0.0";
	String type="";
	String platform="不详";
	String profile="不详";
	String filename="";
	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="insert into sinfo(name,star,times,addtime,size,type,platform,profile,filename) values('"+name+"','"+star+"',0,date()+time(),"+size+",'"+type+"','"+platform+"','"+profile+"','"+filename+"')";
	conn.executeUpdate(sql);	
	conn.close();
	response.sendRedirect("manage.jsp");
%>