📄 wcheck.jsp

📁 网上服装店能让用户在该网站上对物品进行上传购买等操作。该设计为原版

💻 JSP

字号:

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<% request.setCharacterEncoding("gb2312"); %>
<%@ page import="com.bwm.db.Condb"%>
<%@ page import="java.util.Date"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>

<body>
<%
	Date date=new Date();
	Condb con=new Condb();
	String path="images/";
	String str=request.getParameter("str");
	String warename=request.getParameter("warename");
	String wareprice=request.getParameter("wareprice");
	String waretype=request.getParameter("waretype");
	String wareintro=request.getParameter("wareintro");
	String image=path+request.getParameter("image");
	String sq="select * from tb_Ware where Warename='"+warename+"'";
	ResultSet rs=con.executeQuery(sq);
	if(rs.next()){
		out.println("<script language='javaScript'>alert('此商品已经添加请不要重复录入');history.back();</script>");
	}else{
		String sql="";
		if(str!=null){
			sql="insert into tb_Ware(Warename,Wareprice,Waretype,Wareintro,Wareimage,Wareif,Dattime)values('"+warename+"','"+Integer.parseInt(wareprice)+"','"+waretype+"','"+wareintro+"','"+image+"','"+1+"','"+date.toLocaleString()+"')";
		}else{
			sql="insert into tb_Ware(Warename,Wareprice,Waretype,Wareintro,Wareimage,Wareif,Dattime)values('"+warename+"','"+Integer.parseInt(wareprice)+"','"+waretype+"','"+wareintro+"','"+image+"','"+0+"','"+date.toLocaleString()+"')";
		}
		int temp=con.executeUpdate(sql);
		if(temp>0){
			out.println("<script language='javascript'>alert('添加成功');history.back();</script>");
		}else{
			out.println("<script language='javascript'>alert('数据错误');history.back();</script>");
		}
	}
	con.close();
%>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -