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

使用servlet和jsp在数据库中插入5行数据,第1张

使用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);

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



欢迎分享,转载请注明来源:内存溢出

原文地址: https://outofmemory.cn/zaji/5641818.html

(0)
打赏 微信扫一扫 微信扫一扫 支付宝扫一扫 支付宝扫一扫
上一篇 2022-12-16
下一篇 2022-12-16

发表评论

登录后才能评论

评论列表(0条)

保存