Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <tr>
- <th style="width: 30$">ID</th>
- <th style="width: 30$">Created By</th>
- <th style="width: 30$">Estimate time</th>
- <th style="width: 30$">Timesheet time</th>
- <th style="width: 30%">Updated By</th>
- </tr>
- <%
- try
- {
- Class.forName("com.mysql.jdbc.Driver").newInstance();
- Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/testraildump","roo t","root");
- String Query="SELECT id, createdby, estimatetime, executionhours, updatedby from testraildumptable inner join timesheet on testraildumptable.updatedby = timesheet.updatedby where updatedby='"+request.getParameter("search")+"'";
- Statement stm=conn.createStatement();
- ResultSet rs=stm.executeQuery(Query);
- while(rs.next())
- {
- %>
- <tr>
- <td><%=rs.getString("id")%></td>
- <td><%=rs.getString("createdby")%></td>
- <td><%=rs.getString("estimatetime")%></td>
- <td><%=rs.getString("executionhours")%></td>
- <td><%=rs.getString("updatedby")%></td>
- </tr>
- <%
- }
- }
Add Comment
Please, Sign In to add comment