📄 stafferadd_do.jsp

📁 一个超市管理系统,提供一些基本简单的操作,JSP+APACHE+ORCALE实现
💻 JSP
字号:
<script language="JavaScript">
<!--
function CheckForm()
{
   alert("错误！！！");
   return false;
}
// -->
</script>
 <%@ page language="java" contentType="text/html; charset=gb2312"
    pageEncoding="gb2312"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>职员信息数据处理</title>
</head>
<body>
<jsp:useBean id="dbcon" scope="page" class="bb.Dbcon" />
<jsp:useBean id="login" scope="session" class="bb.login" />
<%if(login.dept!=3&&login.dept!=5)
  {
%>
<jsp:forward page="index.jsp"/>
<% 
  }
%>
<%try{
  ResultSet rs=null;
  String sql=null;

  String id_card=request.getParameter("id_card");
  int salary=0,bonus=0;  
  String phone=request.getParameter("phone");    
  String sta_name=dbcon.getStr(request.getParameter("sta_name"));
  String sex=dbcon.getStr(request.getParameter("sex"));
  String job=dbcon.getStr(request.getParameter("job"));
  String address=dbcon.getStr(request.getParameter("address"));
  String email=request.getParameter("email");
  String user0=request.getParameter("user0");
  String password0=request.getParameter("password0");
  String year=request.getParameter("year");
  String month=request.getParameter("month");
  String day=request.getParameter("day");
  String birthdate=year+"-"+month+"-"+day;

  Connection con=dbcon.getConn();
  if(request.getParameter("salary")!=""&&request.getParameter("bonus")!="")
  {
	 salary=Integer.parseInt(request.getParameter("salary"));
     bonus=Integer.parseInt(request.getParameter("bonus"));
     sql="insert into tpb.staffer values (seq3.nextval,'"+sta_name+"','"+sex+"','"+id_card+"','"+birthdate+"','"+job+"',"+salary+","+bonus+",'"+phone+"','"+address+"','"+email+"','"+user0+"','"+password0+"')";
  }
  else if(request.getParameter("salary")==""&&request.getParameter("bonus")!="")
  {
	 bonus=Integer.parseInt(request.getParameter("bonus"));
	 sql="insert into tpb.staffer values (seq3.nextval,'"+sta_name+"','"+sex+"','"+id_card+"','"+birthdate+"','"+job+"',null,"+bonus+",'"+phone+"','"+address+"','"+email+"','"+user0+"','"+password0+"')";
  }
  else if(request.getParameter("salary")!=""&&request.getParameter("bonus")=="")
  {
	 salary=Integer.parseInt(request.getParameter("salary"));
	 sql="insert into tpb.staffer values (seq3.nextval,'"+sta_name+"','"+sex+"','"+id_card+"','"+birthdate+"','"+job+"',"+salary+",null,'"+phone+"','"+address+"','"+email+"','"+user0+"','"+password0+"')";
  }
  else
  {
	 sql="insert into tpb.staffer values (seq3.nextval,'"+sta_name+"','"+sex+"','"+id_card+"','"+birthdate+"','"+job+"',null,null,'"+phone+"','"+address+"','"+email+"','"+user0+"','"+password0+"')";
  }
  Statement stmt=con.createStatement();
  rs=stmt.executeQuery(sql);
  rs.close();
  stmt.close();
  dbcon.Close();
  }catch(SQLException e){
%>
	<script language="JavaScript">
	  CheckForm("填加的供应商不存在！");
	  document.location.href="stafferAdd.jsp"
	</script>
<%
}catch(Exception e){
	if(login.dept==3)
	{

%>
<script language="JavaScript">
  CheckForm();
  document.location.href="staffer.jsp"
</script>
<% 
    }else if(login.dept==5)
    {
%>
<script language="JavaScript">
  CheckForm();
  document.location.href="manager.jsp"
</script>
<%
    }
                    }
%>
<h1 align="center">添加职员成功</h1>
<a href="stafferAdd.jsp">返回</a>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -