📄 modifymaterialconform.jsp

📁 jsp做的购物网站

💻 JSP

字号:

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<jsp:useBean id="user" scope="session" class="jspD.User"/>
<jsp:useBean id="DBLink" class="jspD.DBLink" />
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>修改确定</title>
</head>

<body>
<center>
<%@ include file="../Main.jsp"%>

<%  String sql;
	String oldName=user.getName();
	sql="UPDATE users SET name='"+request.getParameter("name")+"',pwd='"+request.getParameter("pwd")+"',email='"+request.getParameter("email")+"' WHERE ID="+request.getParameter("ID");
	
	if(!DBLink.executeUpdate(sql))
		out.print("<h4 align=center>数据库连接错误!<a href='business.jsp'>返回</a></h4>");
	else{
		user.setName(request.getParameter("name"));
		user.setPwd(request.getParameter("pwd"));
		user.setEmail(request.getParameter("email"));
		sql="UPDATE product SET producer='"+request.getParameter("name")+"' WHERE producer='"+oldName+"'";
		
		if(!DBLink.executeUpdate(sql)){
			out.print("<h4 align=center>更新产品数据库失败！</h4>");
		}
		out.print("<p><b>用户信息修改成功!</b> </p> ");
		out.print("<p><a href='releaseProduct.jsp'>继续发布新产品</a></p> ");
		out.print("<p><a href='browseMyProduct.jsp'>返回浏览界面</a></p>");
		out.print("<a href='business.jsp'>返回管理界面</a>");
	}
%>
</center>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -