API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 24th, 2016
155
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.37 KB | None | 0 0
raw download clone embed print report
  1. <%@page import="java.util.ArrayList"%>
  2. <%@page import="java.sql.ResultSet"%>
  3. <%@page import="java.sql.Statement"%>
  4. <%@page import="java.sql.Connection"%>
  5. <%@page import="java.sql.DriverManager"%>
  6. <%@page import="java.sql.SQLException"%>
  7. <%@page import="com.db.DB"%>
  8. <%@page contentType="text/html" pageEncoding="UTF-8"%>
  9.  
  10.  
  11. <%
  12. if( "yes" == session.getAttribute("valid") ){
  13.  
  14. }else {
  15. response.sendRedirect("logout.jsp");
  16. }
  17. %>
  18.  
  19. <%! Connection con=null; %>
  20. <%! Statement st= null; %>
  21. <%! ResultSet rs= null; %>
  22. <%! ResultSet rssrc= null; %>
  23. <%
  24. DB db = new DB();
  25.  
  26. String vmessage = "";
  27.  
  28.  
  29. String vcarid = request.getParameter("carid");
  30. String vcarmodel = request.getParameter("carmodel");
  31. String vplatno = request.getParameter("platno");
  32. String vstate = request.getParameter("state");
  33. String vrentalprice = request.getParameter("rentalprice");
  34. String vinsuranceid = request.getParameter("insuranceid");
  35. String vavailibility = request.getParameter("availability");
  36. String vSQL=null;
  37.  
  38. if(request.getParameter("Submit") != null){
  39.  
  40. try{
  41.  
  42.  
  43. vSQL = " Insert Into tblcarmaster ";
  44. vSQL += " values( ";
  45. vSQL += " '"+ vcarid +"', ";
  46. vSQL += " '"+ vcarmodel +"', ";
  47. vSQL += " '"+ vplatno +"', ";
  48. vSQL += " '"+ vstate +"', ";
  49. vSQL += " '"+ vrentalprice +"', ";
  50. vSQL += " '"+ vinsuranceid +"', ";
  51. vSQL += " '"+ vavailibility +"') ";
  52. db.InsertRecord(vSQL);
  53.  
  54. vmessage = "Data added!";
  55.  
  56. }catch(Exception e){
  57. e.printStackTrace();
  58.  
  59. }
  60. }
  61.  
  62. if(request.getParameter("Update") != null){
  63.  
  64. try{
  65.  
  66. vSQL = " Update tblcarmaster Set ";
  67. vSQL += " carid='"+ vcarid +"', ";
  68. vSQL += " carmodel='"+ vcarmodel +"', ";
  69. vSQL += " platno='"+ vplatno +"', ";
  70. vSQL += " state='"+ vstate +"', ";
  71. vSQL += " rentalprice='"+ vrentalprice +"', ";
  72. vSQL += " insuranceid='"+ vinsuranceid +"', ";
  73. vSQL += " availability='"+ vavailibility +"' ";
  74. vSQL += " where carid='" + vcarid + "' ";
  75.  
  76. db.UpdateRecord(vSQL);
  77.  
  78. }catch(Exception e){
  79. e.printStackTrace();
  80.  
  81.  
  82. }
  83. }
  84.  
  85. if(request.getParameter("Delete") != null){
  86.  
  87. try{
  88.  
  89. vSQL = " Delete From tblcarmaster ";
  90. vSQL += " where carid='" + vcarid + "' ";
  91. db.DeleteRecord(vSQL);
  92.  
  93. }catch(Exception e){
  94. e.printStackTrace();
  95.  
  96.  
  97. }
  98. }
  99. if(request.getParameter("Delete") != null){
  100.  
  101. try{
  102.  
  103. vSQL = " Delete From tblcarmaster ";
  104. vSQL += " where carid='" + vcarid + "' ";
  105. db.DeleteRecord(vSQL);
  106.  
  107. }catch(Exception e){
  108. e.printStackTrace();
  109.  
  110.  
  111. }
  112. }
  113. String srcCarid = "";
  114. String srcModel = "";
  115. String srcPlatno = "";
  116. String srcState = "";
  117. String srcRentalprice = "";
  118. String srcInsuranceid = "";
  119. String srcAvailability = "";
  120.  
  121.  
  122. if(request.getParameter("Search") != null){
  123.  
  124. try{
  125.  
  126. vSQL = " Select * From tblcarmaster ";
  127. vSQL += " where carid='" + vcarid + "' ";
  128. rssrc = db.getResultSet(vSQL);
  129.  
  130. while(rssrc.next()){
  131. srcCarid = rssrc.getString("carid");
  132. srcModel = rssrc.getString("carmodel");
  133. srcPlatno = rssrc.getString("platno");
  134. srcState = rssrc.getString("state");
  135. srcRentalprice = rssrc.getString("carmodel");
  136. srcInsuranceid = rssrc.getString("insuranceid");
  137. srcAvailability = rssrc.getString("availability");
  138. }
  139.  
  140. }catch(Exception e){
  141. }
  142. }
  143.  
  144.  
  145. db.close();
  146.  
  147. %>
  148. <!DOCTYPE html>
  149. <html lang="en">
  150.  
  151.  
  152. <head>
  153. <title>Car Details</title>
  154. <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge">
  155. <meta name="viewport" content="width=device-width, initial-scale=1">
  156.  
  157.  
  158. <link rel="stylesheet" href="css/bootstrap.min.css">
  159.  
  160. <link rel="stylesheet" href="font-awesome-4.4.0/css/font-awesome.min.css">
  161. <style>
  162. body {
  163. position: relative;
  164. }
  165. .affix {
  166. top:0;
  167. width: 100%;
  168. z-index: 9999 !important;
  169. }
  170. .navbar {
  171. margin-bottom: 0px;
  172. }
  173.  
  174. .affix ~ .container-fluid {
  175. position: relative;
  176. top: 50px;
  177. }
  178.  
  179. </style>
  180. </head>
  181. <body data-spy="scroll" data-target=".navbar" data-offset="50">
  182.  
  183. <div class="container-fluid" style=" height:125px;background-image : url('img/h2.jpg');color:#fff;" >
  184. <div class="headline">
  185. <h1 class="text-center">WELCOME ADMIN</h1>
  186. </div>
  187. </div>
  188.  
  189. <nav class="navbar navbar-inverse" data-spy="affix" data-offset-top="197">
  190. <div class="container-fluid">
  191. <div class="navbar-header">
  192. <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-ex1-collapse">
  193. <span class="icon-bar"></span>
  194. <span class="icon-bar"></span>
  195. <span class="icon-bar"></span>
  196. </button>
  197. <a class="navbar-brand active" href="welcome.jsp">CarRental Service</a>
  198. </div>
  199. <div>
  200. <div class="collapse navbar-collapse navbar-ex1-collapse" id="myNavbar">
  201. <ul class="nav navbar-nav">
  202. <li><a href="viewdata.jsp"><i class="fa fa-users"></i>Customers Data </a></li>
  203. <li><a href="vieworder.jsp"><i class="fa fa-database"></i>Rental Record </a></li>
  204. <li class="active"><a href="pageadmin.jsp"><i class="fa fa-car"></i>Cars Details </a></li>
  205. <li><a href="insurancedetails.jsp"><i class="fa fa-bank "></i>Insurance Details </a></li>
  206. <li><a href="report.jsp"><i class="fa fa-bar-chart "></i> Reports </a></li>
  207. <li><a href="logout.jsp"><i class=""></i>Logout </a></li>
  208. </ul>
  209. </div>
  210. </div>
  211. </div>
  212. </nav>
  213.  
  214. <div class="container">
  215.  
  216. <%
  217. try
  218. {
  219. Class.forName("com.mysql.jdbc.Driver").newInstance();
  220. con = DriverManager.getConnection("jdbc:mysql://localhost:3306/dbcarrental?user=root&password=");
  221.  
  222. st = con.createStatement();
  223. rs = st.executeQuery("select * from tblcarmaster");
  224.  
  225. out.println("<br><br><table border=0 cellpadding=5 class='table table-striped table-hover'>");
  226. out.println("<tr bgcolor=#97e3f9><th> Car ID </th>");
  227. out.println("<th> Car Model </th>");
  228. out.println("<th> Plat No </th>");
  229. out.println("<th> State </th>");
  230. out.println("<th> Rental Price</th>");
  231. out.println("<th> Insurance ID </th>");
  232. out.println("<th> Availability </th></tr>");
  233.  
  234. while(rs.next()) {
  235.  
  236. out.println("<tr bgcolor=#e6f9ff>");
  237. out.println( "<td>" + rs.getString("carid") + "</td>");
  238. out.println( "<td>" + rs.getString("carmodel") + "</td>");
  239. out.println( "<td>" + rs.getString("platno") + "</td>");
  240. out.println( "<td>" + rs.getString("state") + "</td>");
  241. out.println( "<td> RM " + rs.getString("rentalprice") + ".00</td>");
  242. out.println( "<td>" + rs.getString("insuranceid") + "</td>");
  243. out.println( "<td>" + rs.getString("availability") + "</td>");
  244. out.println("</tr>");
  245.  
  246. }
  247. out.println("</table>");// end of whilee
  248. rs.close();
  249. st.close();
  250. con.close();
  251.  
  252. }catch(SQLException e)
  253. {
  254. e.printStackTrace();
  255. }
  256. %>
  257.  
  258. <center>
  259. <form method="post" action="">
  260. <table border=0 cellpadding=5 >
  261. <tr><td>Car ID <br><br></td><td><input type="text" value="<% out.print(srcCarid); %>" name="carid" class="form-control " /><br></td></tr>
  262. <tr><td>Car Model <br><br></td><td><input type="text" value="<% out.print(srcModel); %>" name="carmodel" class="form-control "/><br></td></tr>
  263. <tr><td>Plat Number <br><br></td><td><input type="text" value="<% out.print(srcPlatno); %>" name="platno" class="form-control "/><br></td></tr>
  264. <tr><td>Gear State <br><br></td><td><input type="text" value="<% out.print(srcState); %>" name="state" class="form-control "/><br></td></tr>
  265. <tr><td>Rental Price <br><br></td><td><input type="text" value="<% out.print(srcRentalprice); %>" name="rentalprice" class="form-control "/> <br></td></tr>
  266. <tr><td>Insurance Premium <br><br></td><td><input type="text" value="<% out.print(srcInsuranceid); %>" name="insuranceid" class="form-control "/><br></td></tr>
  267. <tr><td>Availability <br><br></td><td><input type="text" value="<% out.print(srcAvailability); %>" name="availability" class="form-control "/><br></td></tr>
  268. </table>
  269.  
  270. <input type="submit" value="Add" name="Submit" class="btn btn-primary "/>
  271. <input type="submit" value="Update" name="Update" class="btn btn-info "/>
  272. <input type="submit" value="Delete" name="Delete" class="btn btn-danger "/>
  273. <input type="submit" value="Search" name="Search" class="btn btn-danger "/><br><br>
  274. </form>
  275. </center>
  276.  
  277. <div id="footer">
  278. <div class="container" >
  279. <p align="center" class="muted credit">
  280.  
  281. &copy; CarRental Service </p>
  282. </div>
  283. </div>
  284. <script src="jquery/jquery.min.js"></script>
  285. <script src="js/bootstrap.min.js"></script>
  286. <script src="val2.js"></script>
  287. </body>
  288.  
  289. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!