Guest User

Untitled

a guest
Apr 17th, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.94 KB | None | 0 0
  1. <tr>
  2. <th style="width: 30$">ID</th>
  3. <th style="width: 30$">Created By</th>
  4. <th style="width: 30$">Estimate time</th>
  5. <th style="width: 30$">Timesheet time</th>
  6. <th style="width: 30%">Updated By</th>
  7. </tr>
  8. <%
  9. try
  10. {
  11. Class.forName("com.mysql.jdbc.Driver").newInstance();
  12. Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/testraildump","roo t","root");
  13. String Query="SELECT id, createdby, estimatetime, executionhours, updatedby from testraildumptable inner join timesheet on testraildumptable.updatedby = timesheet.updatedby where updatedby='"+request.getParameter("search")+"'";
  14.  
  15.  
  16. Statement stm=conn.createStatement();
  17. ResultSet rs=stm.executeQuery(Query);
  18. while(rs.next())
  19. {
  20. %>
  21. <tr>
  22. <td><%=rs.getString("id")%></td>
  23. <td><%=rs.getString("createdby")%></td>
  24. <td><%=rs.getString("estimatetime")%></td>
  25. <td><%=rs.getString("executionhours")%></td>
  26. <td><%=rs.getString("updatedby")%></td>
  27.  
  28. </tr>
  29. <%
  30. }
  31. }
Add Comment
Please, Sign In to add comment