📄 personadd1.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"));
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=request.getParameter("room");
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="/DSN/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 + -