Advertisement
Guest User

Untitled

a guest
Aug 2nd, 2017
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.82 KB | None | 0 0
  1. `jdbc.driverClassName = com.mysql.jdbc.Driver
  2. jdbc.url =jdbc:mysql://localhost:3306/icdb?useUnicode=true&characterEncoding=UTF-8&connectionCollation=utf8_general_ci&characterSetResults=utf8 jdbc.username = root
  3. jdbc.password =password
  4. hibernate.dialect = org.hibernate.dialect.MySQLDialect
  5. hibernate.show_sql = true
  6. hibernate.format_sql = true`
  7.  
  8. @Override
  9. public void onStartup(ServletContext servletContext) throws ServletException {
  10. super.onStartup(servletContext);
  11. FilterRegistration.Dynamic encodingFilter = servletContext.addFilter("encoding-filter", new CharacterEncodingFilter());
  12. encodingFilter.setInitParameter("encoding", "UTF-8");
  13. encodingFilter.setInitParameter("forceEncoding", "true");
  14. encodingFilter.addMappingForUrlPatterns(null, false, "/*");
  15. }
  16.  
  17. @RequestMapping(value = "/saveNewOrder", produces = {"application/json; charset=UTF-8"}, method = RequestMethod.POST)
  18. public String saveNewOrder(HttpServletRequest request, @Valid CatMenuSelection catMenuSelection, CatMenuSelectionExtra catMenuSelectionExtra, Model m, BindingResult result,
  19.  
  20. String sql = "INSERT INTO cat_menu_selection (customer_name, address, total_guest, distribution_type, ocassion_date, ocassion_time, ocassion_place, ocassion, guest_price, total_driver, driver_price, phone_no, advance_deposit, main_remarks, gross_total_amnt, further_paid_amount, discount,user_name)"
  21. + " VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?, ?, ?, ?, ?,?)";
  22.  
  23. <%@page contentType="text/html" pageEncoding="UTF-8"%>
  24. <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge">
  25. <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
  26.  
  27.  
  28. <form:form action="saveNewOrder" method="post" modelAttribute="catMenuSelection" acceptCharset="UTF-8">
  29. <table class="table">
  30. <form:hidden name="iddd" path="id"/>
  31. <div class="col-lg-12">
  32. <div class="form-group row">
  33. <div class="col-lg-1"><label><fmt:message key="catering.lalel.people" /></label></div>
  34. <div class="col-lg-3">
  35. <form:input path="totalGuest" id="popleId" class="col-lg-2 form-control " style="width: 76px; height: 32px" required="true"/>
  36. <!-- <div class="col-lg-1">
  37. <%--<form:errors path="totalGuest" cssclass="error"></form:errors>--%>
  38. </div>-->
  39. <div class="col-lg-1">
  40.  
  41. <select id="typeId" style="width: 76px; height: 25px" name="distributionType" required="true">
  42. <option value="V.I.P"><fmt:message key="catering.lalel.vip" /></option>
  43. <option value="Packet"><fmt:message key="catering.lalel.packet" /></option>
  44. <option value="Public"><fmt:message key="catering.lalel.public" /></option>
  45. </select>
  46. </div>
  47. </div>
  48. <!-- <div class="col-lg-1">
  49. <%--<form:errors path="distributionType" cssclass="error"></form:errors>--%>
  50. </div>-->
  51. <!--</div>-->
  52. <div class="col-lg-1"><label><fmt:message key="catering.lalel.date" /></label></div>
  53. <div class="col-lg-3">
  54. <form:input path="occassionDate" class="datepicker form-control" style="width: 170px" required="true"/>
  55. </div>
  56. <!-- <div class="col-lg-1">
  57. <%--<form:errors path="occassionDate" cssclass="error"></form:errors>--%>
  58. </div>-->
  59. <div class="col-lg-1"><label><fmt:message key="catering.lalel.time" /></label></div>
  60. <div class="col-lg-3">
  61. <select name="occassionTime" style="width: 170px; height: 32px" required="true">
  62. <option value="Morning"><fmt:message key="catering.lalel.morning" /></option>
  63. <option value="Noon"><fmt:message key="catering.lalel.noon" /></option>
  64. <option value="Evening"><fmt:message key="catering.lalel.evening" /></option>
  65. <option value="Night"><fmt:message key="catering.lalel.night" /></option>
  66. </select>
  67. </div>
  68. <!-- <div class="col-lg-1">
  69. <%--<form:errors path="occassionTime" cssclass="error"></form:errors>--%>
  70. </div>-->
  71. </div>
  72. <div class="form-group row">
  73. <div class="col-lg-1"><label><fmt:message key="catering.lalel.event" /></label></div>
  74. <div class="col-lg-3"><form:input path="occassion" class="form-control" style="width: 170px" required="true"/></div>
  75.  
  76. <!-- <div class="col-lg-1">
  77. <%--<form:errors path="occassion" cssclass="error"></form:errors>--%>
  78. </div>-->
  79. <div class="col-lg-1"><label><fmt:message key="catering.lalel.name" /></label></div>
  80. <div class="col-lg-3"><form:input path="customerName" class="form-control" style="width: 170px" required="true" /></div>
  81. <!--cusname-->
  82. <!--<div class="col-lg-1">
  83. <%--<form:errors path="customerName" cssclass="error"></form:errors>--%>
  84. </div>-->
  85. <div class="col-lg-1"><label><fmt:message key="catering.lalel.place" /></label></div>
  86. <div class="col-lg-3"><form:input path="occassionPlace" class="form-control" style="width: 170px" required="true"/></div>
  87. <!-- <div class="col-lg-1">
  88. <%--<form:errors path="occassionPlace" cssclass="error"></form:errors>--%>
  89. </div>-->
  90.  
  91.  
  92. </div>
  93. <div class="form-group row">
  94. <div class="col-lg-1"><label><fmt:message key="catering.lalel.vipprice" /></label></div>
  95. <div class="col-lg-3"><form:input path="guestPrice" id="vipPriceId" class="form-control " style="width: 170px" required="true"/></div>
  96.  
  97. <!-- <div class="col-lg-1">
  98. <%--<form:errors path="guestPrice" cssclass="error"></form:errors>--%>
  99. </div>-->
  100. <div class="col-lg-1"><label ><fmt:message key="catering.lalel.packetprice" /></label></div>
  101. <div class="col-lg-3"><form:input path="driverPrice" id="packetPriceId" class="form-control" style="width: 170px" placeholder="Packet Price" required="true"/></div>
  102.  
  103. <!-- <div class="col-lg-1">
  104. <%--<form:errors path="driverPrice" cssclass="error"></form:errors>--%>
  105. </div>-->
  106. <div class="col-lg-1"><label><fmt:message key="catering.lalel.driver" /></label></div>
  107. <div class="col-lg-3"><form:input path="totalDriver" id="driverId" class="form-control " style="width: 170px" required="true"/></div>
  108.  
  109. <!-- <div class="col-lg-1">
  110. <%--<form:errors path="totalDriver" cssclass="error"></form:errors>--%>
  111. </div>-->
  112. </div>
  113. <div class="form-group row">
  114. <div class="col-lg-1"><label><fmt:message key="catering.lalel.grosstotal" /></label></div>
  115. <div class="col-lg-3"><form:input path="grossTotalAmnt" id="grossTotalId" class="form-control " style="width: 170px" required="true"/></div>
  116. <div class="col-lg-1"><label><fmt:message key="catering.lalel.phone" /></label></div>
  117. <div class="col-lg-3"><form:input path="phoneNo" class="form-control" style="width: 170px" required="true" /></div>
  118.  
  119. <!-- <div class="col-lg-1">
  120. <%--<form:errors path="phoneNo" cssclass="error"></form:errors>--%>
  121. </div>-->
  122. <div class="col-lg-1"><label><fmt:message key="catering.lalel.address" /></label></div>
  123. <div class="col-lg-3"><form:input path="address" class="form-control" style="width: 170px" required="true"/></div>
  124.  
  125. <!-- <div class="col-lg-1">
  126. <%--<form:errors path="address" cssclass="error"></form:errors>--%>
  127. </div>-->
  128.  
  129. </div>
  130.  
  131. <div class="form-group row">
  132.  
  133. <div class="col-lg-1"><label><fmt:message key="catering.lalel.discount" /></label></div>
  134. <div class="col-lg-3"><form:input path="discount" class="form-control" style="width: 170px" /></div>
  135. <div class="col-lg-1"><label><fmt:message key="catering.lalel.advancedpay" /></label></div>
  136. <div class="col-lg-3"><form:input path="advanceDeposit" class="form-control" style="width: 170px"/></div>
  137. <!-- <div class="col-lg-1">
  138. <%--<form:errors path="advanceDeposit" cssclass="error"></form:errors>--%>
  139. </div>-->
  140. <div class="col-lg-1"><label><fmt:message key="catering.lalel.comment" /></label></div>
  141. <div class="col-lg-3"><form:input path="mainRemarks" class="form-control" style="width: 170px"/></div>
  142. <form:errors path="mainRemarks" cssclass="error"></form:errors>
  143. </div>
  144. </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement