gz_add_sav_lxry.jsp

来自「JSP页面和oracle9i数据库的源代码」· JSP 代码 · 共 100 行

JSP
100 行
字号 
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.text.*"%>
<%@ page import="java.util.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style>
<!--
a {text-decoration: none}
.f1          { font-size: 9pt; font-family: Verdana; line-height: 15pt }
.f2          { font-size: 8pt; font-family: Verdana; line-height: 12pt }
-->
</style>
</head>
<body>
<p>
<jsp:useBean id="conn" scope="page" class="beans3.conn"/>
<%try{
   ResultSet rs=null;
   
   String bhX=conn.toChinese(request.getParameter("tmp_bh"));
   
   String bmX=conn.toChinese(request.getParameter("bm"));
     
   String xmX=conn.toChinese(request.getParameter("xm"));
     
   Float gtX=Float.valueOf(conn.toChinese(request.getParameter("gt")));
   
   Float rgzX=Float.valueOf(conn.toChinese(request.getParameter("rgz")));
   
   String jcny_year=conn.toChinese(request.getParameter("jcny_year"));
   String jcny_month=conn.toChinese(request.getParameter("jcny_month"));
   String jcny_day=conn.toChinese(request.getParameter("jcny_day"));
   String jcny_str=jcny_year+"-"+jcny_month+"-"+jcny_day;
   
   String condition="insert into BGZDH.BZGZ (bh,bm,xm,rgz,gt,jcny) values("+"'"+bhX+"','"+bmX+"','"+xmX+"',"+rgzX+","+gtX+",to_timestamp('"+jcny_str+"','yyyy-mm-dd'))";
   //out.print(condition);
   conn.executeUpdate(condition);
    
%>
  
</p>
<div align="center">
 <p class="f1">添加临时人员后的员工列表：</p>
 <p>&nbsp;  </p>
 <p>
   <span class="f1">
<%SimpleDateFormat formatter1 = new SimpleDateFormat("MM/dd/yyyy HH:mm:ss");%> 
   <% 
 int all=0;  

 condition="SELECT * FROM BGZDH.BZGZ where BH LIKE "+"'"+"L%"+"'";
rs=conn.executeQuery(condition);
 %>
   </span></p>
 <span class="f1">
 <table width="600" border="1" cellpadding="0" cellspacing="1" bordercolor="#D2A3FF">

 <tr bgcolor="#CC99FF">
   <th class="f1" scope="col">编号</th>
   <th class="f1" scope="col">部门</th>
   <th class="f1" scope="col">姓名</th>
   <th class="f1" scope="col">日工资</th>
   <th class="f1" scope="col">工天</th>
   <th class="f1" scope="col">进厂年月</th>
   </tr>
   
   <%while(rs.next())
   {all++;%>
  
   <tr>
     <td><div align="center" class="f1"><%=rs.getString("BH")%></div></td>
     <td><div align="center" class="f1"><%=rs.getString("BM")%></div></td>
     <td><div align="center" class="f1"><%=rs.getString("XM")%></div></td>
     <td><div align="center" class="f1"><%=rs.getString("RGZ")%></div></td>
     <td><div align="center" class="f1"><%=rs.getString("GT")%></div></td>
	 
	 <%java.util.Date d = formatter1.parse(rs.getString("JCNY")); 
	 SimpleDateFormat formatter2=new SimpleDateFormat("yyyy-MM-dd");
	 String mDateTime=formatter2.format(d);
	 %>
	 
     <td><div align="center" class="f1"><%=mDateTime%></div></td>
   </tr>

   <%}%>
   <%  if(all!=0){out.print("</table>");}
 else{out.print("现在没有临时工!");}  
 }catch (Exception e) {e.getMessage();}
 
 
 %>
   
 <p></p>
 <p class="f1"><a href="gz_add_lxry.jsp">继续添加</a>&nbsp; &nbsp; &nbsp; &nbsp; <a href="../index/gz_index.jsp">返回主页</a></p>
 
 <p>&nbsp;  </p>
</body>
</html>

gz_add_sav_lxry.jsp - 源码说明

本页面展示了「JSP页面和oracle9i数据库的源代码」中的 gz_add_sav_lxry.jsp 源码文件，采用 JSP 编程语言编写，共 100 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与oracle9i相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

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