API tools faq
paste
Advertisement
Guest User

zad3

a guest
Jun 21st, 2017
116
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 26.58 KB | None | 0 0
raw download clone embed print report
  1. <html>
  2. <head>
  3. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  4. <title>JSP Page</title>
  5. </head>
  6. <body>
  7. <form name="forma" action="Obrada">
  8. <table>
  9. <tr>
  10. <td>Korisnicko ime:</td><td><input type="text" name="ime"></td>
  11. </tr>
  12. <tr>
  13. <td>Lozinka:</td><td><input type="password" name="lozinka"></td>
  14. </tr>
  15. <tr>
  16. <td><input type="submit" value="Posalji"></td>
  17. </tr>
  18. </table>
  19. </form>
  20. </body>
  21. </html>
  22. package obrada;
  23. import java.io.IOException;
  24. import java.io.PrintWriter;
  25. import javax.servlet.ServletException;
  26. import javax.servlet.annotation.WebServlet;
  27. import javax.servlet.http.HttpServlet;
  28. import javax.servlet.http.HttpServletRequest;
  29. import javax.servlet.http.HttpServletResponse;
  30. import java.sql.*;
  31. @WebServlet(name="Obrada", urlPatterns={"/Obrada"})
  32. public class Obrada extends HttpServlet {
  33. protected void processRequest(HttpServletRequest request, HttpServletResponse response)
  34. throws ServletException, IOException {
  35. response.setContentType("text/html;charset=UTF-8");
  36. PrintWriter out = response.getWriter();
  37. String ime = request.getParameter("ime");
  38. String lozinka = request.getParameter("lozinka");
  39. try
  40. {
  41. Class.forName("org.apache.derby.jdbc.ClientDriver");
  42. }
  43. catch(ClassNotFoundException e){ System.out.println(e); }
  44. try
  45. {
  46. Connection con = DriverManager.getConnection("jdbc:derby://localhost:1527/Vozaci",
  47. "root", "rootroot");
  48. Statement stmt = con.createStatement();
  49. Statement stmt1 = con.createStatement();
  50. ResultSet rs1 = stmt1.executeQuery("select tip from app.Vozac where username='"+ime+"' and
  51. password='"+lozinka+"'");
  52. if(rs1.next())
  53. {
  54. int kilometraza=0;
  55. String tip = rs1.getString("tip");
  56. if(tip.equals("G")) tip="GSP";
  57. else tip="Taksi";
  58. //prvi nacin:
  59. //ResultSet rs = stmt.executeQuery("select broj_kilometara from app."+tip+" where
  60. usernameVozac='"+ime+"'");
  61. //while(rs.next()) kilometraza+=rs.getInt("broj_kilometara");
  62. //drugi nacin:
  63. ResultSet rs = stmt.executeQuery("select SUM(broj_kilometara) from app."+tip+" where
  64. usernameVozac='"+ime+"'");
  65. if(rs.next()) kilometraza = rs.getInt(1);
  66. out.println("Ukupna nedeljna kilometraza za vozaca "+ ime +" iznosi: "+kilometraza+"
  67. kilometara");
  68. }
  69. }
  70. catch(SQLException e){ System.err.println(e); }
  71. finally {
  72. out.close();
  73. }
  74. }
  75.  
  76. ------------------------------------------------------------------------------------------
  77. ------------------------------------------------------------------------------------------
  78. ------------------------------------------------------------------------------------------
  79. ------------------------------------------------------------------------------------------
  80. ------------------------------------------------------------------------------------------
  81.  
  82.  
  83. <%@page contentType="text/html" pageEncoding="UTF-8"%>
  84. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
  85. "http://www.w3.org/TR/html4/loose.dtd">
  86.  
  87. <html>
  88. <head>
  89. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  90. <title>JSP Page</title>
  91. </head>
  92. <body>
  93. <form method="post" action="Logovanje">
  94. <input type="text" name="brIndex">
  95. <input type="password" name="sifra">
  96. <input type="submit">
  97. </form>
  98. </body>
  99. </html>
  100.  
  101. --------------------------------------------
  102. import java.io.IOException;
  103. import java.io.PrintWriter;
  104. import javax.servlet.ServletException;
  105. import javax.servlet.annotation.WebServlet;
  106. import javax.servlet.http.HttpServlet;
  107. import javax.servlet.http.HttpServletRequest;
  108. import javax.servlet.http.HttpServletResponse;
  109. import java.sql.*;
  110. /**
  111. *
  112. * @author Drazen
  113. */
  114. @WebServlet(name="Logovanje", urlPatterns={"/Logovanje"})
  115. public class Logovanje extends HttpServlet {
  116.  
  117. protected void processRequest(HttpServletRequest request, HttpServletResponse response)
  118. throws ServletException, IOException {
  119. response.setContentType("text/html;charset=UTF-8");
  120. PrintWriter out = response.getWriter();
  121. String index=request.getParameter("brIndex");
  122. String pass=request.getParameter("sifra");
  123.  
  124. try {
  125. Class.forName("org.apache.derby.jdbc.ClientDriver");
  126. Connection con = DriverManager.getConnection("jdbc:derby://localhost:1527/Korisnik","nova","nova");
  127. Statement stm= con.createStatement();
  128.  
  129. ResultSet rs= stm.executeQuery("SELECT * FROM APP.STUDENT WHERE INDEKS='"+index+"' AND PASSWORD='"+pass+"'");
  130.  
  131. int brojac=0;
  132. int zbirOcena=0;
  133. if (rs.next()) {
  134. String indeks = rs.getString("INDEKS");
  135. Statement stm1= con.createStatement();
  136. ResultSet rsOcena= stm1.executeQuery("SELECT * FROM APP.OCENA WHERE INDEKS='"+indeks+"'");
  137. ResultSet rsPredmeta;
  138.  
  139. out.println("<html>");
  140. out.println("<head>");
  141. out.println("<title>Servlet Logovanje</title>");
  142. out.println("</head>");
  143. out.println("<body>");
  144.  
  145. while(rsOcena.next())
  146. {
  147. String predmet = rsOcena.getString("SIFRAPREDMETA");
  148. Statement stm2= con.createStatement();
  149. rsPredmeta=stm2.executeQuery("SELECT * FROM APP.PREDMET WHERE SIFRAPREDMETA='"+predmet+"'");
  150. //out.println("<h2>Predmet: </h2>");
  151. while(rsPredmeta.next()){
  152. out.println("<h3>"+rsPredmeta.getString("NAZIV")+" "+ rsPredmeta.getString("PREDAVAC") +rsOcena.getString("OCENA")+"</h3>");
  153. brojac++;
  154. zbirOcena+= Integer.parseInt(rsOcena.getString("OCENA"));
  155. }
  156. }
  157. out.println("<h1>Stranica kada si ulogovan</h1>");
  158. double ukOcena=zbirOcena/brojac;
  159. out.println("<h1>Prosecna ocena je: "+ukOcena+"</h1>");
  160. out.println("</body>");
  161. out.println("</html>");
  162. }else {
  163. out.println("<html>");
  164. out.println("<head>");
  165. out.println("<title>Servlet Logovanje</title>");
  166. out.println("</head>");
  167. out.println("<body>");
  168. out.println("<h1>Servlet Logovanje nije uspelo molim vas pokusajte ponovo </h1>");
  169. out.println("</body>");
  170. out.println("</html>");
  171. }
  172.  
  173. }catch (Exception e){}
  174. finally {
  175. out.close();
  176. }
  177. }
  178.  
  179.  
  180. ------------------------------------------------------------------------------------------
  181. ------------------------------------------------------------------------------------------
  182. ------------------------------------------------------------------------------------------
  183. ------------------------------------------------------------------------------------------
  184. ------------------------------------------------------------------------------------------
  185.  
  186.  
  187. <%@page import="java.sql.ResultSet"%>
  188. <%@page import="java.sql.Statement"%>
  189. <%@page import="java.sql.DriverManager"%>
  190. <%@page import="java.sql.Connection"%>
  191. <%@page contentType="text/html" pageEncoding="UTF-8"%>
  192. <!DOCTYPE html>
  193. <html>
  194. <head>
  195. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  196. <title>Januar 2013 - ispit</title>
  197. </head>
  198. <body>
  199. <h1>Radnik u fabrici:</h1>
  200. <a href="dodaj.jsp">Dodaj novi deo</a>
  201. <br/>
  202. <a href="obrisi.jsp">Obrisi deo</a>
  203.  
  204. <h1>Radnik u servisu:</h1>
  205. Trenutno nema opcija.
  206.  
  207. <%
  208. Class.forName("com.mysql.jdbc.Driver");
  209. Connection konekcija = DriverManager.getConnection("jdbc:mysql://localhost:3306/automobili","root","");
  210. Statement iskaz = konekcija.createStatement();
  211. ResultSet rez = iskaz.executeQuery("SELECT idDeo, naziv, proizvodjac, kategorija, cena FROM autodelovi WHERE brprimeraka>0");
  212. Statement iskaz2 = konekcija.createStatement();
  213. ResultSet rez2;
  214. out.println("<table border='1'>");
  215. out.println("<th>Naziv</th><th>Proizvodjac</th><th>Kategorija</th><th>Cena</th><th>Prodato</th>");
  216. while(rez.next()){
  217. int id = rez.getInt("idDeo");
  218. String naziv = rez.getString("naziv");
  219. String proizvodjac = rez.getString("proizvodjac");
  220. String kategorija = rez.getString("kategorija");
  221. Double cena = rez.getDouble("cena");
  222. out.println("<tr>");
  223. out.println("<td>" + naziv + "</td>");
  224. out.println("<td>" + proizvodjac + "</td>");
  225. out.println("<td>" + kategorija + "</td>");
  226. out.println("<td>" + cena + "</td>");
  227. rez2 = iskaz2.executeQuery("SELECT COUNT(p.id) FROM autodelovi a, prodaja p WHERE a.idDeo = p.idDeo and a.idDeo=" + id);
  228. if(rez2.next()){
  229. int broj = rez2.getInt(1);
  230. if(broj>2) out.println("<td>" + broj + " <font color='red'>VELIKA POTRAZNJA!</font></td>");
  231. else out.println("<td>" + broj + "</td>");
  232. }
  233. out.println("</tr>");
  234. }
  235. out.println("</table>");
  236. %>
  237. </body>
  238. </html>
  239.  
  240.  
  241. ----------
  242.  
  243. <%@page contentType="text/html" pageEncoding="UTF-8"%>
  244. <!DOCTYPE html>
  245. <html>
  246. <head>
  247. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  248. <title>Dodavanje novog dela</title>
  249. </head>
  250. <body>
  251. <h1>Popunite formu:</h1>
  252.  
  253. <form name="formaunos" action="Dodavanje" method="POST">
  254. <table border="0">
  255. <tr>
  256. <td>Naziv:</td>
  257. <td><input type="text" size="20" name="naziv">
  258. </tr>
  259. <tr>
  260. <td>Proizvodjac:</td>
  261. <td><input type="text" size="20" name="proizvodjac"></td>
  262. </tr>
  263. <tr>
  264. <td>Kategorija:</td>
  265. <td><input type="text" size="20" name="kategorija"></td>
  266. </tr>
  267. <tr>
  268. <td>Broj primeraka:</td>
  269. <td><input type="text" size="5" name="brprimeraka"></td>
  270. </tr>
  271. <tr>
  272. <td>Cena:</td>
  273. <td><input type="text" size="5" name="cena"></td>
  274. </tr>
  275. <tr>
  276. <td>Zemlja porekla:</td>
  277. <td><input type="text" size="20" name="zemlja"></td>
  278. </tr>
  279. <tr>
  280. <td colspan="2">
  281. <input type="submit" name="potvrdi" value="DODAJ">
  282. <input type="reset" value="PONISTI">
  283. </td>
  284. </tr>
  285. </table>
  286. </form>
  287. </body>
  288. </html>
  289.  
  290. ------------------
  291.  
  292. <%@page import="java.sql.ResultSet"%>
  293. <%@page import="java.sql.Statement"%>
  294. <%@page import="java.sql.DriverManager"%>
  295. <%@page import="java.sql.Connection"%>
  296. <%@page contentType="text/html" pageEncoding="UTF-8"%>
  297. <!DOCTYPE html>
  298. <html>
  299. <head>
  300. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  301. <title>Brisanje postojeceg dela</title>
  302. </head>
  303. <body>
  304. <h1>Brisanje artikla</h1>
  305. <%
  306. Class.forName("com.mysql.jdbc.Driver");
  307. Connection konekcija = DriverManager.getConnection("jdbc:mysql://localhost:3306/automobili","root","");
  308. Statement iskaz = konekcija.createStatement();
  309. ResultSet rez = iskaz.executeQuery("SELECT idDeo, naziv, proizvodjac, kategorija, cena FROM autodelovi WHERE brprimeraka>0");
  310. out.println("<form name='formabrisi' action='Brisanje' method='POST'><table border='1'>");
  311. out.println("<th>Naziv</th><th>Proizvodjac</th><th>Kategorija</th><th>Cena</th><th>Brisanje</th>");
  312. while(rez.next()){
  313. int id = rez.getInt("idDeo");
  314. String naziv = rez.getString("naziv");
  315. String proizvodjac = rez.getString("proizvodjac");
  316. String kategorija = rez.getString("kategorija");
  317. Double cena = rez.getDouble("cena");
  318. out.println("<tr>");
  319. out.println("<td>" + naziv + "</td>");
  320. out.println("<td>" + proizvodjac + "</td>");
  321. out.println("<td>" + kategorija + "</td>");
  322. out.println("<td>" + cena + "</td>");
  323. out.println("<td><input type='checkbox' name='check' value="+id+"></td>");
  324. out.println("</tr>");
  325. }
  326. out.println("<tr><td colspan='5'><input type='submit' value='OBRISI'></td></tr>");
  327. out.println("</table></form>");
  328. %>
  329. </body>
  330. </html>
  331.  
  332.  
  333. -----------------
  334.  
  335. <%@page contentType="text/html" pageEncoding="UTF-8"%>
  336. <!DOCTYPE html>
  337. <html>
  338. <head>
  339. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  340. <title>JSP Page</title>
  341. </head>
  342. <body>
  343. <form name="forma" action="Jun2012zad3">
  344. <table>
  345. <tr><td>Unesi korisnicko ime:</td><td><input type="text" name="ime"></td></tr>
  346. <tr><td>Unesi lozinku:</td><td><input type="password" name="loz"></td></tr>
  347. <tr><td colspan="2"><input type="submit" value="Posalji"></td></tr>
  348. </table>
  349. </form>
  350. </body>
  351. </html>
  352.  
  353.  
  354. -----------
  355.  
  356. Konekcija.java
  357. package zad3;
  358. import java.sql.*;
  359. public class Konekcija {
  360. public static Connection konekcija() throws SQLException
  361. {
  362. try {
  363. Class.forName("com.mysql.jdbc.Driver");
  364. }
  365. catch (ClassNotFoundException e)
  366. {
  367. System.out.println("Where is your MySQL JDBC Driver?");
  368. }
  369. System.out.println("MySQL JDBC Driver Registered!");
  370. Connection conn = null;
  371. try {
  372. conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jun2012ip",
  373. "root", "");
  374. }
  375. catch (SQLException e)
  376. {
  377. System.out.println("Connection Failed! Check output console");
  378. }
  379. finally
  380. {
  381. }
  382. return conn;
  383. }
  384. }
  385.  
  386. --------------
  387.  
  388. Jun2012Zad3.java
  389. package zad3;
  390. import java.io.IOException;
  391. import java.io.PrintWriter;
  392. import javax.servlet.ServletException;
  393. import javax.servlet.annotation.WebServlet;
  394. import javax.servlet.http.HttpServlet;
  395. import javax.servlet.http.HttpServletRequest;
  396. import javax.servlet.http.HttpServletResponse;
  397. import java.sql.*;
  398. import javax.servlet.RequestDispatcher;
  399. import javax.servlet.http.HttpSession;
  400. @WebServlet(name = "Jun2012zad3", urlPatterns = {"/Jun2012zad3"})
  401. public class Jun2012zad3 extends HttpServlet {
  402. protected void processRequest(HttpServletRequest request, HttpServletResponse response)
  403. throws ServletException, IOException, SQLException {
  404. response.setContentType("text/html;charset=UTF-8");
  405. PrintWriter out = response.getWriter();
  406. String ime = request.getParameter("ime");
  407. String lozinka = request.getParameter("loz");
  408. HttpSession sesija = request.getSession(true);
  409. sesija.setAttribute("ime", ime);
  410. out.println("Trenutno ste ulogovani kao "+ime);
  411. Connection conn = (Connection) Konekcija.konekcija();
  412. Statement st = null;
  413. ResultSet rs = null;
  414. try {
  415. st = conn.createStatement();
  416. rs = st.executeQuery("select * from student where username='"+ime+"' and
  417. password='"+lozinka+"'");
  418. out.println("<br>");
  419. if(!rs.next())
  420. {
  421. RequestDispatcher rd = request.getRequestDispatcher("Greska.jsp");
  422. rd.forward(request, response);
  423. }
  424. else
  425. {
  426.  
  427.  
  428. while(rs.next())
  429. {
  430. out.println(rs.getString(1));
  431. out.println(" ");
  432. out.println(rs.getString(2));
  433. out.println(" ");
  434. out.println(rs.getString(3));
  435. out.println(" ");
  436. out.println(rs.getString(4));
  437. out.println("<br>");
  438. }
  439. out.println("<a href='slanjeporuka.jsp'>Posalji poruku</a><br>");
  440. out.println("<a href='inbox.jsp'>Pregledaj inbox</a>");
  441. }
  442. }
  443. catch (SQLException e) {
  444. System.out.println("Connection Failed! Check output console");
  445. e.printStackTrace();
  446. return;
  447. }
  448. finally {
  449. if (rs != null) rs.close();
  450. if (st != null) st.close();
  451. if (conn != null) conn.close();
  452. out.close();
  453. }
  454. }
  455.  
  456.  
  457. ----------
  458.  
  459. slanjeporuka.jsp
  460. <%@page contentType="text/html" pageEncoding="UTF-8"%>
  461. <!DOCTYPE html>
  462. <html>
  463. <head>
  464. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  465. <title>JSP Page</title>
  466. </head>
  467. <body onLoad="document.forma.poruka.focus();">
  468. <%String ime = (String)session.getAttribute("ime");%>
  469. <h1>Hello <%=ime%>!</h1>
  470. <form name="forma" action="ObradaSlanjaPoruka">
  471. U polju ispod unesi poruku:<br>
  472. <textarea cols="50" rows="10" name="poruka" maxlength=140>
  473. </textarea ><br>
  474. Unesi kome se salje poruka: <input type="text" name="primalac">
  475. <input type="hidden" value="<%=ime%>" name="posiljalac">
  476. <input type="submit" value="Posalji">
  477. </form>
  478. </body>
  479. </html>
  480.  
  481. ------------
  482.  
  483. inbox.jsp
  484. <%@page import="zad3.Konekcija"%>
  485. <%@page import="java.sql.*"%>
  486. <%@page contentType="text/html" pageEncoding="UTF-8"%>
  487. <%! Connection conn; %>
  488. <%! Statement st; %>
  489. <%! ResultSet rs; %>
  490. <%! String pom,pitanje; %>
  491. <!DOCTYPE html>
  492. <html>
  493. <head>
  494. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  495. <title>JSP Page</title>
  496. </head>
  497. <body>
  498. <%String ime = (String)session.getAttribute("ime");%>
  499. <h1>Hello <%=ime%>!</h1>
  500. <table border="1">
  501. <tr><th>Posiljalac</th><th>Primalac</th><th>Tekst poruke</th><th colspan=2>Vreme
  502. slanja</th><th>Status poruke</th></tr>
  503. <%
  504. conn = (Connection) Konekcija.konekcija();
  505. st = conn.createStatement();
  506. String upit = "select * from poruke where primalac='"+ime+"'";
  507. rs = st.executeQuery(upit);
  508. while(rs.next())
  509. {
  510. String poruka;
  511. int procitana = rs.getInt(6);
  512. if(procitana==0) poruka="neprocitana";
  513. else poruka="procitana";
  514. %>
  515. <tr>
  516. <td><%=rs.getString(2)%></td>
  517. <td><%=rs.getString(3)%></td>
  518. <td><%=rs.getString(4)%></td>
  519. <td><%=rs.getTime(5)%></td>
  520. <td><%=rs.getDate(5)%></td>
  521. <td><%=poruka%></td>
  522. </tr>
  523. <%}
  524. %>
  525. </table>
  526. <a href='index.jsp'>Vrati se na login stranicu</a>
  527. </body>
  528. </html>
  529.  
  530. --------------
  531.  
  532. ObradaSlanjaPoruka.java
  533. package zad3;
  534. import java.io.IOException;
  535. import java.io.PrintWriter;
  536. import javax.servlet.ServletException;
  537. import javax.servlet.annotation.WebServlet;
  538. import javax.servlet.http.HttpServlet;
  539. import javax.servlet.http.HttpServletRequest;
  540. import javax.servlet.http.HttpServletResponse;
  541. import java.sql.*;
  542. import java.text.SimpleDateFormat;
  543. import java.util.Calendar;
  544. @WebServlet(name = "ObradaSlanjaPoruka", urlPatterns = {"/ObradaSlanjaPoruka"})
  545. public class ObradaSlanjaPoruka extends HttpServlet {
  546. protected void processRequest(HttpServletRequest request, HttpServletResponse response)
  547. throws ServletException, IOException, SQLException {
  548. response.setContentType("text/html;charset=UTF-8");
  549. PrintWriter out = response.getWriter();
  550. String poruka = request.getParameter("poruka");
  551. String posiljalac = request.getParameter("posiljalac");
  552. String primalac = request.getParameter("primalac");
  553. if (poruka.length()>140) poruka = poruka.substring(0,140);
  554. Connection conn = (Connection) Konekcija.konekcija();
  555. Statement st = null;
  556. PreparedStatement prest = null;
  557. ResultSet rs = null;
  558. try {
  559. st = conn.createStatement();
  560. Calendar currentDate = Calendar.getInstance();
  561. SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
  562. String dateNow = formatter.format(currentDate.getTime());
  563. String upit1 = "INSERT INTO poruke (posiljalac,primalac,tekst_poruke,vreme,primljena) "
  564. + "VALUES ('"+posiljalac+"','"+primalac+"','"+poruka+"','"+dateNow+"',"+new
  565. Integer(0).intValue()+")";
  566. prest = conn.prepareStatement(upit1);
  567. prest.executeUpdate();
  568. rs = st.executeQuery("select * from poruke where primalac='"+primalac+"'");
  569. out.println("Sve poslate poruke ka korisniku "+primalac+"<br>");
  570. out.println("<table border=1>");
  571. out.println("<tr><th>Tekst poruke</th><th colspan=2>Vreme slanja</th></tr>");
  572. while(rs.next())
  573. {
  574. out.println("</td><td>");
  575. out.println(rs.getString(4));
  576. out.println("</td><td>");
  577. out.println(rs.getTime(5));
  578. out.println("</td><td>");
  579. out.println(rs.getDate(5));
  580. out.println("</td>");
  581. out.println("</tr>");
  582. }
  583. out.println("</table>");
  584. out.println("<a href='index.jsp'>Vrati se na login stranicu</a>");
  585. }
  586. finally
  587. {
  588. out.close();
  589. }
  590. }
  591.  
  592.  
  593. ------------------------------------------------------------------------------------------
  594. ------------------------------------------------------------------------------------------
  595. ------------------------------------------------------------------------------------------
  596. ------------------------------------------------------------------------------------------
  597. ------------------------------------------------------------------------------------------
  598.  
  599.  
  600. index.jsp
  601. <%@page contentType="text/html" pageEncoding="UTF-8"%>
  602. <html>
  603. <head>
  604. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  605. <title>JSP Page</title>
  606. </head>
  607. <body>
  608. <form name="forma" action="Oktobar2_2012zad3">
  609. <table>
  610. <tr><td>Unesi korisnicko ime:</td><td><input type="text"
  611. name="ime"></td></tr>
  612. <tr><td>Unesi lozinku:</td><td><input type="password"
  613. name="loz"></td></tr>
  614. <tr><td colspan="2"><input type="submit" value="Posalji"</td></tr>
  615. </table>
  616. </form>
  617. </body>
  618. </html>
  619.  
  620. ----------
  621.  
  622. Oktobar2_2012zad3.java
  623. package ipoktobar;
  624. import java.io.IOException;
  625. import java.io.PrintWriter;
  626. import javax.servlet.ServletException;
  627. import javax.servlet.annotation.WebServlet;
  628. import javax.servlet.http.HttpServlet;
  629. import javax.servlet.http.HttpServletRequest;
  630. import javax.servlet.http.HttpServletResponse;
  631. import java.sql.*;
  632. import javax.servlet.RequestDispatcher;
  633. import javax.servlet.http.HttpSession;
  634. @WebServlet(name="Oktobar2_2012zad3", urlPatterns={"/Oktobar2_2012zad3"})
  635. public class Oktobar2_2012zad3 extends HttpServlet {
  636. protected void processRequest(HttpServletRequest request, HttpServletResponse
  637. response)
  638. throws ServletException, IOException, SQLException {
  639. response.setContentType("text/html;charset=UTF-8");
  640. PrintWriter out = response.getWriter();
  641. String ime = request.getParameter("ime");
  642. String lozinka = request.getParameter("loz");
  643. HttpSession sesija = request.getSession(true);
  644. sesija.setAttribute("ime", ime);
  645. sesija.setAttribute("knjiga",null);
  646. out.println("Trenutno ste ulogovani kao "+ime);
  647. Connection conn = (Connection)Konekcija.konekcija();
  648. Statement st = null,st2=null;
  649. ResultSet rs = null;
  650. try {
  651. st = conn.createStatement();
  652. st2 = conn.createStatement();
  653. String upit = "select * from student where username='"+ime+"' and
  654. password='"+lozinka+"'";
  655. rs = st.executeQuery(upit);
  656. out.println("<br>");
  657. if(rs==null)
  658. {
  659. RequestDispatcher rd = request.getRequestDispatcher("greska.jsp");
  660. rd.forward(request, response);
  661. }
  662. else
  663. {
  664. // Ispis prijavljenog korisnika
  665. /*while(rs.next())
  666. {
  667. out.println(rs.getString(1));
  668. out.println(" ");
  669. out.println(rs.getString(2));
  670. out.println(" ");
  671. out.println(rs.getString(3));
  672. out.println(" ");
  673. }*/
  674. String upit1="select naslov from knjiga as k,rezervacija as r where "
  675. +"r.username='"+ime+"' and k.sifraknjige=r.sifraknjige group by naslov";
  676. rs = st2.executeQuery(upit1);
  677. out.println("Trenutno duzite sledece knjige: ");
  678. out.println("<br>");
  679. while(rs.next())
  680. {
  681. out.println(rs.getString(1));
  682. out.println("<br>");
  683. }
  684. out.println("<br>");
  685. out.println("<a href=\"pretraga.jsp\">Pretraga knjiga</a>");
  686. }
  687. }
  688. catch(SQLException e) {
  689. System.out.println("Konekcija nije uspela!");
  690. e.printStackTrace();
  691. return;
  692. }
  693. finally {
  694. if(rs!=null) rs.close();
  695. if(st!=null) st.close();
  696. if(conn!=null) conn.close();
  697. out.close();
  698. }
  699. }
  700.  
  701. ------
  702.  
  703. Konekcija.java
  704. package ipoktobar;
  705. import java.sql.*;
  706. public class Konekcija
  707. {
  708. public static Connection konekcija() throws SQLException
  709. {
  710. try
  711. {Class.forName("com.mysql.jdbc.Driver");
  712. }
  713. catch (ClassNotFoundException e)
  714. {
  715. System.out.println("Where is your MySQL JDBC Driver?");
  716. }
  717. System.out.println("MySQL JDBC Driver Registered!");
  718. Connection conn = null;
  719. try
  720. {
  721. conn =
  722. DriverManager.getConnection("jdbc:mysql://localhost:3306/oktobar2_2012ip","root",
  723. "");
  724. }
  725. catch (SQLException e)
  726. {
  727. System.out.println("Connection Failed! Check output console");
  728. }
  729. finally
  730. {
  731. }
  732. return conn;
  733. }}
  734.  
  735. -----------
  736.  
  737. pretraga.jsp
  738. <%@page import="java.util.ArrayList"%>
  739. <%@page contentType="text/html" pageEncoding="UTF-8"%>
  740. <!DOCTYPE html>
  741. <html>
  742. <head>
  743. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  744. <title>Pretraga</title>
  745. </head>
  746. <body>
  747. <%ArrayList knjiga = null;%>
  748. <h2>Unesite naslov knjige koju trazite</h2>
  749. <form name="forma" action="Pretraga">
  750. <input type="text" name="knjiga"></input><br>
  751. <input type="submit" value="Pretrazi"></input>
  752. </form>
  753. <%knjiga=(ArrayList)session.getAttribute("knjiga");%>
  754. <h3>Podaci o trazenoj knjizi:</h3>
  755. <%if(knjiga!=null) {%>
  756. <table border="1">
  757. <tr><td>Sifra knjige</td><td>Autor</td><td>Naslov</td></tr>
  758. <tr><%for(int i=0;i<knjiga.size();i++) {%>
  759. <td><%=knjiga.get(i)%></td><%}%></tr></table><%}%>
  760. <br><br>
  761. <a href="index.jsp">Vrati se na stranicu za prijavu</a>
  762. </body>
  763. </html>
  764.  
  765. ------------
  766.  
  767. Pretraga.java
  768. package ipoktobar;
  769. import java.io.IOException;
  770. import java.io.PrintWriter;
  771. import javax.servlet.ServletException;
  772. import javax.servlet.annotation.WebServlet;
  773. import javax.servlet.http.HttpServlet;
  774. import javax.servlet.http.HttpServletRequest;
  775. import javax.servlet.http.HttpServletResponse;
  776. import java.sql.*;
  777. import java.util.ArrayList;
  778. import javax.servlet.RequestDispatcher;
  779. import javax.servlet.http.HttpSession;
  780. @WebServlet(name = "Pretraga", urlPatterns = {"/Pretraga"})
  781. public class Pretraga extends HttpServlet {
  782. protected void processRequest(HttpServletRequest request, HttpServletResponse
  783. response)
  784. throws ServletException, IOException, SQLException {
  785. response.setContentType("text/html;charset=UTF-8");
  786. PrintWriter out = response.getWriter();
  787. String knjiga = request.getParameter("knjiga");
  788. Connection conn = (Connection)Konekcija.konekcija();
  789. Statement st = null;
  790. ResultSet rs = null;
  791. HttpSession sesija = request.getSession(true);
  792. ArrayList knjige = new ArrayList();
  793. try {
  794. st = conn.createStatement();
  795. String upit = "select * from knjiga where naslov='"+knjiga+"'";
  796. rs = st.executeQuery(upit);
  797. while(rs.next())
  798. {
  799. knjige.add(rs.getString(1));
  800. knjige.add(rs.getString(2));
  801. knjige.add(rs.getString(3));
  802. }
  803. sesija.setAttribute("knjiga", knjige);
  804. RequestDispatcher rd = request.getRequestDispatcher("pretraga.jsp");
  805. rd.forward(request, response);
  806. out.println(upit);
  807. out.println("<br>");
  808. }
  809. catch(SQLException e) {
  810. System.out.println("Konekcija nije uspela!");
  811. e.printStackTrace();
  812. return;
  813. }
  814. finally {
  815. if(rs!=null) rs.close();
  816. if(st!=null) st.close();
  817. if(conn!=null) conn.close();
  818. out.close();
  819. }
  820. }
  821.  
  822. -------------
  823.  
  824. greska.jsp
  825. <%@page contentType="text/html" pageEncoding="UTF-8"%>
  826. <html>
  827. <head>
  828. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  829. <title>Greska</title>
  830. </head>
  831. <body>
  832. <h1>Neuspesna prijava na sistem.</h1>
  833. <a href="index.jsp">Vrati se na pocetnu stranicu</a>
  834. </body>
  835. </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!