Guest User

Untitled

a guest
Sep 4th, 2018
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.89 KB | None | 0 0
  1. Class.forName("com.mysql.jdbc.Driver");
  2. Connection con=DriverManager.getConnection("jdbc:mysql://localhost/price_list","root","root");
  3. PreparedStatement ps=con.prepareStatement(""+query+"");
  4. ResultSet rs=ps.executeQuery();
  5.  
  6. <thead>
  7. <tr>
  8. <th data-field="Month">Month</th>
  9. <th data-field="CAR">CAR</th>
  10. <th data-field="Type">Type</th>
  11. <th data-field="Model">Model</th>
  12. <th data-field="GST EXSHOWROOM CHARGES">GST EXSHOWROOM CHARGES</th>
  13. <th data-field="TCS 1%">TCS 1%</th>
  14. <th data-field="Handeling">Handeling</th>
  15. <th data-field="INSURANCE 0% DEp">INSURANCE 0% DEP</th>
  16. <th data-field="RTO TAX (INDV)">RTO TAX (INDV)</th>
  17. <th data-field="TOTAL ON ROAD">TOTAL ON ROAD</th>
  18. <th data-field="M.TAX">M.TAX</th>
  19. <th data-field="TOTAL ON ROAD M TAX">TOTAL ON ROAD M TAX</th>
  20. <th data-field="Extended Warranty / 100000 KM">Extended Warranty / 100000 KM</th>
  21. <th data-field="TOTAL ON ROAD EX WARRANTY">TOTAL ON ROAD EX WARRANTY</th>
  22. <th data-field="AUDI Genuine ACCESSORIES">AUDI Genuine ACCESSORIES</th>
  23. <th data-field="REGISTRATION CHARGES">REGISTRATION CHARGES</th>
  24. <th data-field="TOTAL ON ROAD ABAD">TOTAL ON ROAD ABAD</th>
  25. <th data-field="TOTAL AS PER PRICE LIST">TOTAL AS PER PRICE LIST</th>
  26. <th data-field="DIFFERENCE">DIFFERENCE</th>
  27. <th data-field="Gst plus cess">Gst plus cess</th>
  28. </tr>
  29.  
  30. </thead>
  31.  
  32. <tbody>
  33. <%
  34. while(rs.next()){
  35. out.println("<tr>");
  36. out.print("<td>"+rs.getString(1)+"</td>");
  37. out.print("<td>"+rs.getString(2)+"</td>");
  38. out.print("<td>"+rs.getString(3)+"</td>");
  39. out.print("<td>"+rs.getString(4)+"</td>");
  40. out.print("<td>"+rs.getString(5)+"</td>");
  41. out.print("<td>"+rs.getString(6)+"</td>");
  42. out.print("<td>"+rs.getString(7)+"</td>");
  43. out.print("<td>"+rs.getString(8)+"</td>");
  44. out.print("<td>"+rs.getString(9)+"</td>");
  45. out.print("<td>"+rs.getString(10)+"</td>");
  46. out.print("<td>"+rs.getString(11)+"</td>");
  47. out.print("<td>"+rs.getString(12)+"</td>");
  48. out.print("<td>"+rs.getString(13)+"</td>");
  49. out.print("<td>"+rs.getString(14)+"</td>");
  50. out.print("<td>"+rs.getString(15)+"</td>");
  51. out.print("<td>"+rs.getString(16)+"</td>");
  52. out.print("<td>"+rs.getString(17)+"</td>");
  53. out.print("<td>"+rs.getString(18)+"</td>");
  54. out.print("<td>"+rs.getString(19)+"</td>");
  55. out.print("<td>"+rs.getString(20)+"</td>");
  56.  
  57. out.println("</tr>");
  58. }
  59.  
  60. %>
  61.  
  62. </tbody>
  63. </table>
Add Comment
Please, Sign In to add comment