📄 personadd1.jsp

📁 公司人员管理系统源代码,公司人员管理系统源代码,公司人员管理系统源代码

💻 JSP

字号:

<%@ page language="java" import="java.sql.*" %>
<%@ page contentType="text/html;charset=gb2312"%>
<html>
<head>
<title>personAdd1</title>
</head>
<jsp:useBean id="db" scope="page" class="opendb.opendb"/>
<%
 String personID = new String((request.getParameter("personID")).getBytes("ISO8859-1"),"gb2312");
 String personname=new String((request.getParameter("personname")).getBytes("ISO8859-1"),"gb2312");
 String ID=request.getParameter("ID");
 int sex=Integer.parseInt(request.getParameter("sex"));
 String Syear=request.getParameter("Syear");
 String Smonth=request.getParameter("Smonth");
 String Sday=request.getParameter("Sday");
String Eyear=request.getParameter("Eyear");
 String  Emonth=request.getParameter("Emonth");
String Eday=request.getParameter("Eday");
String Byear=request.getParameter("Byear");
 String  Bmonth=request.getParameter("Bmonth");
String Bday=request.getParameter("Bday");
 int   web=Integer.parseInt(request.getParameter("web"));
 int marries=Integer.parseInt(request.getParameter("marries"));
 String school=new String((request.getParameter("school")).getBytes("ISO8859-1"),"gb2312");
 String	level = new String((request.getParameter("level")).getBytes("ISO8859-1"),"gb2312");
 String	telephone=request.getParameter("telephone");
 String mtel=request.getParameter("mtel");
String room=new String((request.getParameter("room")).getBytes("ISO8859-1"),"gb2312");
String password = request.getParameter("password");
String username=request.getParameter("username");
	        String Sdate;
			Sdate=Syear+Smonth+Sday;
			String Edate;
			Edate=Eyear+Emonth+Eday;
			String Bdate;
			Bdate=Byear+Bmonth+Bday;
			String sql="insert into wglPERSON(EMP_CODE,EMP_NAME,EMP_DEPT,EMP_SEX,EMP_WEB,EMP_MARRY,EMP_BIRTHDAY,EMP_INDATE,EMP_SCHOOL,EMP_RADUATION,EMP_EDUATION,EMP_ADRESS,EMP_TEL,EMP_HANDTEL,EMP_USERNAME,EMP_PASSWORD) values('"+personID+"','"+personname+"','"+ID+"',"+sex+","+web+","+marries+",'"+Bdate+"','"+Sdate+"','"+school+"','"+Edate+"','"+level+"','"+room+"','"+telephone+"','"+mtel+"','"+username+"','"+password+"')";
ResultSet rs=db.executeQuery(sql);
%>
<body background="b.files/bj.gif">
<p align="center">您已经插入成功！</p>
<p align="center"><a href="adminBack.jsp">返回</a></p>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -