📄 restwrite.jsp
字号:
<%@ page language="java" import="java.sql.*" %>
<%@ page contentType="text/html;charset=gb2312"%>
<html>
<head>
<title>请假的写入</title>
</head>
<body bgcolor="#ffffff" text="#000000">
<jsp:useBean id="db" scope="page" class="opendb.opendb"/>
<%
String personID=(String)session.getAttribute("personID");
String Syear=request.getParameter("Syear");
Syear=Syear.trim();
String Smonth=request.getParameter("Smonth");
Smonth=Smonth.trim();
String Sday=request.getParameter("Sday");
Sday=Sday.trim();
String Shour=request.getParameter("Shour");
Shour=Shour.trim();
String Sminute=request.getParameter("Sminute");
Sminute=Sminute.trim();
String Eyear=request.getParameter("Eyear");
Eyear=Eyear.trim();
String Emonth=request.getParameter("Emonth");
Emonth=Emonth.trim();
String Eday=request.getParameter("Eday");
Eday=Eday.trim();
String Ehour=request.getParameter("Ehour");
Ehour=Ehour.trim();
String Eminute=request.getParameter("Eminute");
Eminute=Eminute.trim();
int hours=Integer.parseInt(request.getParameter("hours"));
String cause = new String((request.getParameter("cause")).getBytes("ISO8859-1"),"gb2312");
//String Adate;
//Date usertime=new Date();
//Adate=(String)usertime.getTime();
String Sdate;
Sdate=Syear+Smonth+Sday+Shour+Sminute;
String Edate;
Edate=Eyear+Emonth+Eday+Ehour+Eminute;
String sql="";
sql=sql+"insert into wglMESSAGE ";
sql=sql+"(EMP_CODE,";
sql=sql+"M_STIME,";
sql=sql+"M_ETIME,";
sql=sql+"M_HOURS,";
sql=sql+"M_CAUSE,";
sql=sql+"M_TIME)";
sql=sql+" values(";
sql=sql+"'"+ personID +"',";
sql=sql+"'" + Sdate + "',";
sql=sql+"'"+ Edate + "',";
sql=sql+"" + hours + ",";
sql=sql+"'" + cause + "',";
sql=sql+"getdate())";
ResultSet rs=db.executeQuery(sql);
%>
<p align="center">您已经提交成功！</p>
<p align="center"><a href="userBack.jsp">返回</a></p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -