WebRoot/admin/ziyouchewei/ziyoucheweiAdd_Post.jsp

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%

String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%
request.setCharacterEncoding("UTF-8"); 
%>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="connDbBean" scope="page" class="db.db"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'adminyanzheng.jsp' starting page</title>
    

  </head>
  
  <body>
  <%
  ResultSet RS_result1=connDbBean.executeQuery("select * from cheweishu where leixing ='自由车位' and shuliang =(select COUNT(*) from ziyouchewei)");
if(RS_result1.next())
{
out.print("<script>alert('自由车位数已到限制!');window.history.go(-1);</script>");
return;
}
String Name=request.getParameter("Name");
String sql="";
ResultSet RS_result=connDbBean.executeQuery("select * from  ziyouchewei where Name='"+Name+"'");

if(RS_result.next())
{
out.print("<script>alert('自由车位号已经存在，不能重复添加!');window.history.go(-1);</script>");
	}
else
{
    sql="Insert into ziyouchewei(Name)values('"+Name+"')";

  	  	connDbBean.executeUpdate(sql);
  	  	out.print("<script>alert('添加成功!!');location.href='ziyoucheweiAdd.jsp';</script>");

}
 %>
  </body>
</html>