栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 面试经验 > 面试问答

使用servlet和jsp在数据库中插入5行数据

面试问答 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

使用servlet和jsp在数据库中插入5行数据

我已将您的jsp更改为不同的行使用不同的名称。并且还更改了serverlet代码以读取并构建雇员bean列表。完成这些更改后,就可以使用chrisI08
abovve提到的逻辑。timesheet.jsp。

<%@page language="java" contentType="text/html charset=UTF-8" pageEncoding="UTF-8"%><!DOCTYPE html><html>  <head>  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Timesheet Page</title>  </head>  <body><form action="TimeSheetServlet" method="post">    <fieldset >          <legend>Timesheet</legend><table>  <thead><tr><th>Employee ID</th><th>Date</th><th>Time In</th><th>Time Out</th><th>Lunch</th><th>After Lunch Time in</th><th>After Lunch Time out</th><th>Task Description</th><th>Total Hours</th><th>Overtime</th> </tr> </thead> <tbody>     <tr>         <td><input type="text" name="empid1" required="required" /></td> <td><input type="date" id="date" name="logindate1" required="required" /></td><td><input type="time"  name="logintime1" required="required" /></td><td><input type="time"  name="logouttime1" required="required" /></td>          <td><input type="time"  name="lunch1" required="required" /></td><td><input type="time"   name="afterlunchlogin1" required="required" /></td><td><input type="time"  name="afterlunchlogout1" required="required" /></td>          <td><input type="textarea" name="1" required="required" /></td>         <td><input type="time"  name="total1" /></td>         <td><input type="time"  name="overtime1" required="required" /></td>     </tr>       <tr>         <td><input type="text" name="empid2" required="required" /></td> <td><input type="date" id="date" name="logindate2" required="required" /></td><td><input type="time"  name="logintime2" required="required" /></td><td><input type="time"  name="logouttime2" required="required" /></td>          <td><input type="time"  name="lunch2" required="required" /></td><td><input type="time"   name="afterlunchlogin2" required="required" /></td><td><input type="time"  name="afterlunchlogout2" required="required" /></td>          <td><input type="textarea" name="task2" required="required" /></td>         <td><input type="time"  name="total2" /></td>         <td><input type="time"  name="overtime2" required="required" /></td>     </tr>       <tr>         <td><input type="text" name="empid3" required="required" /></td> <td><input type="date" id="date" name="logindate3" required="required" /></td><td><input type="time"  name="logintime3" required="required" /></td><td><input type="time"  name="logouttime3" required="required" /></td>          <td><input type="time"  name="lunch3" required="required" /></td><td><input type="time"   name="afterlunchlogin3" required="required" /></td><td><input type="time"  name="afterlunchlogout3" required="required" /></td>          <td><input type="textarea" name="task" required="required" /></td>         <td><input type="time"  name="total3" /></td>         <td><input type="time"  name="overtime3" required="required" /></td>     </tr>       <tr>         <td><input type="text" name="empid4" required="required" /></td> <td><input type="date" id="date" name="logindate4" required="required" /></td><td><input type="time"  name="logintime4" required="required" /></td><td><input type="time"  name="logouttime4" required="required" /></td>          <td><input type="time"  name="lunch4" required="required" /></td><td><input type="time"   name="afterlunchlogin4" required="required" /></td><td><input type="time"  name="afterlunchlogout4" required="required" /></td>          <td><input type="textarea" name="task" required="required" /></td>         <td><input type="time"  name="total4" /></td>         <td><input type="time"  name="overtime4" required="required" /></td>     </tr>       <tr>         <td><input type="text" name="empid5" required="required" /></td> <td><input type="date" id="date" name="logindate5" required="required" /></td><td><input type="time"  name="logintime5" required="required" /></td><td><input type="time"  name="logouttime5" required="required" /></td>          <td><input type="time"  name="lunch5" required="required" /></td><td><input type="time"   name="afterlunchlogin5" required="required" /></td><td><input type="time"  name="afterlunchlogout5" required="required" /></td>          <td><input type="textarea" name="task5" required="required" /></td>         <td><input type="time"  name="total5" /></td>         <td><input type="time"  name="overtime5" required="required" /></td>     </tr>   </tbody>        </table>      </fieldset><input type="submit" value="Submit"></form><a href="logout.jsp">Logout</a></body>  </html>

Servlet:

List<EmployeeBean> ebList=  ArrayList<EmployeeBean>();     SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd", Locale.US);    for(int i=1;i<=5;i++){        EmployeeBean eb = new EmployeeBean();         eb.setEmpid(Emp_id);         Date logindate = new java.sql.Date(formatter.parse(request.getParameter("logindate"+i)).getTime());          eb.setLogindate((java.sql.Date) logindate);      //String Date=request.getParameter("logindate");          String LoginTime=request.getParameter("logintime"+i);      eb.setLogintime(LoginTime);      eb.setLogouttime(request.getParameter("logouttime"+i));       eb.setLunch(request.getParameter("lunch"+i));       eb.setAfterlunchlogin(request.getParameter("afterlunchlogin"+i));       eb.setAfterlunchlogout(request.getParameter("afterlunchlogout"+i));       eb.setTask(request.getParameter("task"+i));        eb.setTotal(request.getParameter("total"+i));       eb.setOvertime(request.getParameter("overtime"+i));    }    TimeSheetDao.insert(ebList);

注意:我尚未编译此代码。您可能需要更改一些内容。



转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/635954.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号