API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 5th, 2016
98
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 21.91 KB | None | 0 0
raw download clone embed print report
  1. /**
  2. * Created by admin on 04.04.16.
  3. */
  4. public class Dannie {
  5. private int usId; // 1
  6. private String usName; // 2
  7. private String usFam; // 3
  8. private String usLogin;// 4
  9. private String usPass; // 5
  10. private String usPost; // 6
  11. private int usAges; // 7
  12.  
  13. public int getUsId() {
  14. return usId;
  15. }
  16.  
  17. public void setUsId(int usId) {
  18. this.usId = usId;
  19. }
  20.  
  21. public String getUsName() {
  22. return usName;
  23. }
  24.  
  25. public void setUsName(String usName) {
  26. this.usName = usName;
  27. }
  28.  
  29. public String getUsFam() {
  30. return usFam;
  31. }
  32.  
  33. public void setUsFam(String usFam) {
  34. this.usFam = usFam;
  35. }
  36.  
  37. public String getUsLogin() {
  38. return usLogin;
  39. }
  40.  
  41. public void setUsLogin(String usLogin) {
  42. this.usLogin = usLogin;
  43. }
  44.  
  45. public String getUsPass() {
  46. return usPass;
  47. }
  48.  
  49. public void setUsPass(String usPass) {
  50. this.usPass = usPass;
  51. }
  52.  
  53. public String getUsPost() {
  54. return usPost;
  55. }
  56.  
  57. public void setUsPost(String usPost) {
  58. this.usPost = usPost;
  59. }
  60.  
  61. public int getUsAges() {
  62. return usAges;
  63. }
  64.  
  65. public void setUsAges(int usAges) {
  66. this.usAges = usAges;
  67. }
  68. }
  69.  
  70. import ...
  71.  
  72. /**
  73. * Created by admin on 04.04.16.
  74. */
  75.  
  76. public class UserKlass {
  77.  
  78. private static final String userDB = "devdbuser";
  79. private static final String userDBPass = "postgres";
  80. private static final String Driver_NAME = "org.postgresql.Driver";
  81. private static final String DB_URL = "jdbc:postgresql://localhost:5432/devdb";
  82.  
  83. public Dannie getDannie(int numb) {
  84. Dannie dann = null;
  85. Connection connect = null;
  86. Statement stment = null;
  87.  
  88. try {
  89. Class.forName(Driver_NAME);
  90. connect = DriverManager.getConnection(DB_URL, userDB, userDBPass);
  91. stment = connect.createStatement();
  92. String zapros = "SELECT * FROM users WHERE usId =" + numb + ";";
  93. ResultSet result = stment.executeQuery(zapros);
  94. while (result.next()) {
  95. dann = new Dannie();
  96. dann.setUsId(result.getInt(1));
  97. dann.setUsName(result.getString(2));
  98. dann.setUsFam(result.getString(3));
  99. dann.setUsLogin(result.getString(4));
  100. dann.setUsPass(result.getString(5));
  101. dann.setUsPost(result.getString(6));
  102. dann.setUsAges(result.getInt(7));
  103.  
  104. }
  105.  
  106. } catch (ClassNotFoundException e) {
  107. System.out.println("Driver is not exist");
  108. e.printStackTrace();
  109. } catch (SQLException e) {
  110.  
  111. System.out.println("Failed connect to DB");
  112. e.printStackTrace();
  113. } finally {
  114. try {
  115. if (connect != null) {
  116.  
  117. connect.close();
  118.  
  119. }
  120. if (stment != null) {
  121. stment.close();
  122. }
  123.  
  124.  
  125. } catch (SQLException e) {
  126. System.out.println("Disconect is ignored");
  127. e.printStackTrace();
  128.  
  129.  
  130. }
  131. }
  132.  
  133. return dann;
  134. }
  135.  
  136. public List<Dannie> getDannix() {
  137. List<Dannie> dannieList = new ArrayList<>();
  138. Connection conn = null;
  139. Statement stment = null;
  140. try {
  141. Class.forName(Driver_NAME);
  142. conn = DriverManager.getConnection(Driver_NAME, userDB, userDBPass);
  143. stment = conn.createStatement();
  144. String zapros = "SELECT * FROM users ORDER BY usId";
  145. ResultSet result = stment.executeQuery(zapros);
  146. while (result.next()) {
  147. Dannie dann = new Dannie();
  148. dann.setUsId(result.getInt(1));
  149. dann.setUsName(result.getString(2));
  150. dann.setUsFam(result.getString(3));
  151. dann.setUsLogin(result.getString(4));
  152. dann.setUsPass(result.getString(5));
  153. dann.setUsPost(result.getString(6));
  154. dann.setUsAges(result.getInt(7));
  155. dannieList.add(dann);
  156.  
  157. }
  158.  
  159. } catch (SQLException e) {
  160. System.out.println("Driver is not exist");
  161. e.printStackTrace();
  162. } catch (SQLException e) {
  163.  
  164. System.out.println("Failed connect to DB");
  165. e.printStackTrace();
  166. } finally {
  167. try {
  168. if (conn != null) {
  169. conn.close();
  170. }
  171. if (stment != null) {
  172. stment.close();
  173. }
  174. } catch (SQLException e) {
  175. System.out.println("Disconnect is ignored");
  176. e.printStackTrace();
  177. }
  178.  
  179. }
  180.  
  181.  
  182. return dannieList;
  183. }
  184.  
  185. public void AddUser(Dannie dannie) {
  186. Connection connection = null;
  187. PreparedStatement prstment = null;
  188.  
  189. try {
  190. Class.forName(Driver_NAME);
  191. connection = DriverManager.getConnection(DB_URL, userDB, userDBPass);
  192.  
  193. /**
  194. Statement stMent = connection.createStatement();
  195. String zapros = "SELECT * FROM users";
  196.  
  197. ResultSet result = stMent.executeQuery(zapros);
  198. int i = 0;
  199.  
  200. while (result.next()) {
  201. int us_ID = result.getInt(1);
  202. i = us_ID;
  203. } */
  204.  
  205. prstment = connection.prepareStatement("INSERT INTO users(usName,usFam,usLogin,usPass,usPost,usAges) VALUES(?, ?, ?, ?, ?, ?, ?)");
  206.  
  207. // prstment.setInt(1, i + 1);
  208. prstment.setString(2, dannie.getUsName());
  209. prstment.setString(3, dannie.getUsFam());
  210. prstment.setString(4, dannie.getUsLogin());
  211. prstment.setString(5, dannie.getUsPass());
  212. prstment.setString(6, dannie.getUsPost());
  213. prstment.setInt(7, dannie.getUsAges());
  214. prstment.execute();
  215.  
  216. } catch (ClassNotFoundException e) {
  217.  
  218. System.out.println("Driver is not exist");
  219. e.printStackTrace();
  220. } catch (SQLException e) {
  221.  
  222. System.out.println("Failed connect to DB");
  223. e.printStackTrace();
  224.  
  225. } finally {
  226. try {
  227. if (connection != null) {
  228. connection.close();
  229. }
  230. if (prstment != null) {
  231. prstment.close();
  232. }
  233. } catch (SQLException e) {
  234. System.out.println("Disconnect is ignored or other query error");
  235. e.printStackTrace();
  236. }
  237. }
  238.  
  239. }
  240.  
  241. public void deleteUser(int id) {
  242. Connection connect = null;
  243. Statement stment = null;
  244. try {
  245.  
  246. Class.forName(Driver_NAME);
  247. connect = DriverManager.getConnection(DB_URL, userDB, userDBPass);
  248. stment = connect.createStatement();
  249. stment.execute("DELETE FROM users WHERE usId=" + String.valueOf(id));
  250.  
  251.  
  252. } catch (ClassNotFoundException e) {
  253. System.out.println("Driver is not exist");
  254. e.printStackTrace();
  255. } catch (SQLException e) {
  256.  
  257. System.out.println("Failed connect to DB");
  258. e.printStackTrace();
  259. }
  260.  
  261. }
  262.  
  263. public void updateUser(Dannie dann) {
  264. Connection conn = null;
  265. PreparedStatement prsment = null;
  266. try {
  267. Class.forName(Driver_NAME);
  268. conn = DriverManager.getConnection(DB_URL,userDB,userDBPass);
  269. prsment = conn.prepareStatement("UPDATE users SET userName=?, userFam=?,userLogin=?, userPass=?, userEmail=?, userAge=? WHERE userId=?");
  270. prsment.setString(2,dann.getUsName());
  271. prsment.setString(3,dann.getUsFam());
  272. prsment.setString(4,dann.getUsLogin());
  273. prsment.setString(5,dann.getUsPass());
  274. prsment.setString(6,dann.getUsPost());
  275. prsment.setInt(7, dann.getUsAges());
  276.  
  277. } catch (ClassNotFoundException e) {
  278.  
  279. System.out.println("Driver is not exist");
  280. e.printStackTrace();
  281. } catch (SQLException e) {
  282.  
  283. System.out.println("Failed connect to DB");
  284. e.printStackTrace();
  285. }
  286. finally {
  287. try{
  288. if (prsment!=null){
  289. prsment.close();
  290. }
  291. if(conn!=null){
  292. conn.close();
  293. }
  294. } catch (SQLException e) {
  295. System.out.println("Disconnect is ignored");
  296. e.printStackTrace();
  297. }
  298. }
  299.  
  300.  
  301. }
  302. }
  303.  
  304. import java.io.IOException;
  305. import java.util.List;
  306.  
  307. import javax.inject.Inject;
  308. import javax.servlet.ServletException;
  309. import javax.servlet.annotation.WebServlet;
  310. import javax.servlet.http.HttpServlet;
  311. import javax.servlet.http.HttpServletRequest;
  312. import javax.servlet.http.HttpServletResponse;
  313.  
  314. import com.force.samples.entity.Dannie;
  315. import com.force.samples.entity.UserKlass;
  316. import org.slf4j.Logger;
  317. import org.slf4j.LoggerFactory;
  318. import org.springframework.stereotype.Controller;
  319. import org.springframework.ui.Model;
  320. import org.springframework.web.bind.annotation.RequestMapping;
  321. import org.springframework.web.bind.annotation.RequestMethod;
  322. import org.springframework.web.bind.annotation.RequestParam;
  323. import org.springframework.web.multipart.MultipartFile;
  324. import org.springframework.web.servlet.ModelAndView;
  325.  
  326. import com.force.samples.dao.BookDAO;
  327. import com.force.samples.entity.Book;
  328.  
  329. @Controller
  330. public class HomeController extends HttpServlet{
  331.  
  332. private static Logger log = LoggerFactory.getLogger(HomeController.class);
  333.  
  334. @Inject
  335. private BookDAO bookDAO;
  336.  
  337. @RequestMapping(method=RequestMethod.GET, value={"/", "/home"})
  338. public String showHomePage (ModelAndView mv) {
  339. log.info("Hit controller");
  340.  
  341. return "home";
  342. }
  343.  
  344. @RequestMapping(method=RequestMethod.GET, value="/listbooks")
  345. public String listBooks (Model model) {
  346. List<Book> books = bookDAO.getAllBooks();
  347.  
  348. model.addAttribute("books", books);
  349.  
  350. return "listResults";
  351. }
  352.  
  353. @RequestMapping(method=RequestMethod.GET, value="/getbook")
  354. public String getBook (String title, Model model) {
  355. List<Book> books = bookDAO.getBooksByTitle(title);
  356.  
  357. model.addAttribute("books", books);
  358.  
  359. return "listResults";
  360. }
  361.  
  362. @RequestMapping(method=RequestMethod.POST, value="/upload")
  363. public String uploadFile(String description, @RequestParam(value="myFile")MultipartFile uploadedFile, Model model) {
  364.  
  365. Long fileSize = uploadedFile.getSize();
  366. log.info("File size received = " + fileSize);
  367. log.info("Description = " + description);
  368.  
  369. model.addAttribute("desc", description);
  370. model.addAttribute("fileSize", fileSize);
  371. return "uploadSuccess";
  372. }
  373.  
  374.  
  375. @RequestMapping(method = RequestMethod.POST, value="/registr")
  376. public String welcome(String usName, String usFam, String usMail, String usLogg, int usAge, Model model){
  377. model.addAttribute("userName",usName);
  378. model.addAttribute("userLastN",usFam);
  379. model.addAttribute("usMails",usMail);
  380. model.addAttribute("usLogins",usLogg);
  381. model.addAttribute("us_Age",usAge);
  382.  
  383.  
  384. return "regSucces";
  385. }
  386. @RequestMapping(method = RequestMethod.POST, value = "/registr")
  387. public Object processRequest(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException
  388. {
  389. Dannie dannie = new Dannie();
  390. dannie.setUsName(request.getParameter("imya"));
  391. dannie.setUsFam(request.getParameter("fam"));
  392. dannie.setUsLogin(request.getParameter("login"));
  393. dannie.setUsPass(request.getParameter("pass"));
  394. dannie.setUsPost(request.getParameter("uMail"));
  395. dannie.setUsAges(Integer.parseInt(request.getParameter("age")));
  396. UserKlass userKlass = new UserKlass();
  397. userKlass.AddUser(dannie);
  398. response.sendRedirect("home.jsp");
  399.  
  400. return "home";
  401. }
  402.  
  403.  
  404.  
  405. @RequestMapping(method=RequestMethod.POST, value = "/delete")
  406. public Object processDelete(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException
  407. {
  408. //Dannie dannie = new Dannie();
  409. int id = Integer.parseInt(request.getParameter("delId"));
  410. UserKlass userKlass = new UserKlass();
  411. userKlass.deleteUser(id);
  412. response.sendRedirect("home.jsp");
  413. //processDelete(request, response);
  414. return "home";
  415.  
  416. }
  417.  
  418. @RequestMapping(method = RequestMethod.POST, value= "/update")
  419. public Object processUpdate(HttpServletRequest request, HttpServletResponse response)throws ServletException,IOException
  420. {
  421. Dannie dannie = new Dannie();
  422. dannie.setUsName(request.getParameter("imya"));
  423. dannie.setUsFam(request.getParameter("fam"));
  424. dannie.setUsLogin(request.getParameter("login"));
  425. dannie.setUsPass(request.getParameter("pass"));
  426. dannie.setUsPost(request.getParameter("uMail"));
  427. dannie.setUsAges(Integer.parseInt(request.getParameter("age")));
  428. UserKlass userKlass = new UserKlass();
  429. userKlass.updateUser(dannie);
  430. //processUpdate(request, response);
  431. response.sendRedirect("home.jsp");
  432.  
  433. return "home";
  434. }
  435.  
  436. @Override
  437. protected void doGet(HttpServletRequest request, HttpServletResponse response)
  438. throws ServletException, IOException {
  439.  
  440. processRequest(request, response);
  441. processUpdate(request, response);
  442. processDelete(request, response);
  443.  
  444. }
  445.  
  446. @Override
  447. protected void doPost(HttpServletRequest request, HttpServletResponse response)
  448. throws ServletException, IOException {
  449.  
  450. processRequest(request, response);
  451. processUpdate(request, response);
  452. processDelete(request, response);
  453. }
  454.  
  455.  
  456. @RequestMapping(method = RequestMethod.POST, value="/authorization")
  457. public String authorize(String usName,String usLogg, String usFam, String usMail, Model model){
  458. model.addAttribute("userNam",usName);
  459. model.addAttribute("usLastNam",usFam);
  460. model.addAttribute("userLogins",usLogg);
  461. model.addAttribute("uMails",usMail);
  462.  
  463. return "userPage";
  464. }
  465. }
  466.  
  467. <%@ page import="com.force.samples.entity.UserKlass" %>
  468. <%@ page import="com.force.samples.entity.Dannie" %>
  469. <%--
  470. Created by IntelliJ IDEA.
  471. User: admin
  472. Date: 04.04.16
  473. Time: 19:25
  474. To change this template use File | Settings | File Templates.
  475. --%>
  476. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
  477. <html>
  478. <head>
  479. <title>Update Page</title>
  480. </head>
  481. <body>
  482. <%
  483. int id = Integer.parseInt(request.getParameter("updateId"));
  484. UserKlass userKlass = new UserKlass();
  485. Dannie danni = userKlass.getDannie(id);
  486. %>
  487. <div class="divForms">
  488. <form id="form" name="form" action="/update" method="post">
  489. <%--<label><input type="hidden" name="usId" id="usId" value="<%=String.valueOf(request.getParameter("usId"))%>" /> <!-- <span class="small"></span> --></label>--%>
  490. <label><input type="text" name="usName" id="usName" value="<%=request.getParameter("usName")%>" /></label>
  491. <label><input type="text" name="usFam" id="usFam" value="<%=request.getParameter("usFam")%>" /></label>
  492. <label><input type="text" name="usLogin" id="usLogin" value="<%=request.getParameter("usLogin")%>" /></label>
  493. <label><input type="text" name="usPass" id="usPass" value="<%=request.getParameter("usPass")%>" /></label>
  494. <label><input type="text" name="usPost" id="usPost" value="<%=request.getParameter("usPost")%>" /></label>
  495. <label><input type="text" name="usAges" id="usAges" value="<%=request.getParameter("usAges")%>" /></label>
  496. <button type="submit">Update User</button>
  497.  
  498. </form>
  499.  
  500.  
  501. </div>
  502.  
  503. </body>
  504. </html>
  505.  
  506. <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
  507. <%@ page import="com.force.samples.dao.userDAO" %>
  508. <%@ page import="java.util.*" %>
  509. <%@ page import="com.force.samples.entity.*" %>
  510. <%@ page import="sun.launcher.resources.launcher_it" %>
  511.  
  512. <HTML>
  513. <HEAD>
  514. <title>Home Page</title>
  515. <style type="text/css">
  516. .butt {
  517. position: relative;
  518. margin-left: 90px;
  519. margin-top: 10px;
  520.  
  521. }
  522.  
  523. .formText {
  524. color: mediumseagreen;
  525. position: relative;
  526. margin-left: 90px;
  527. margin-bottom: 20px;
  528. }
  529.  
  530. .inp {
  531. margin-bottom: 10px;
  532. margin-top: 10px;
  533. }
  534.  
  535. .tabEnter {
  536. margin-right: 50px;
  537. margin-top: 100px;
  538. width: 400px;
  539. height: 200px;
  540. }
  541.  
  542. .divBody {
  543. width: 600px;
  544. height: 600px;
  545.  
  546. }
  547.  
  548. .divLeft {
  549.  
  550. margin-left: 5px;
  551. width: 400px;
  552. height: 600px;
  553.  
  554. }
  555.  
  556. .tabData {
  557. width: 800px;
  558.  
  559. }
  560.  
  561. </style>
  562. </HEAD>
  563. <BODY>
  564. <%-- <%! DBClass dbClass = new DBClass(); %> --%>
  565.  
  566.  
  567. <h2>This is the home page</h2>
  568.  
  569. <img src="resources/images/puppy.jpg"/>
  570.  
  571. <H3>Try retrieving some data...</H3>
  572. <ul>
  573. <li><a href="listbooks">List all books</a></li>
  574. </ul>
  575.  
  576. <H3>Or upload a file...</H3>
  577.  
  578. <form action="upload" enctype="multipart/form-data" method="post">
  579. Description : <INPUT type="text" name="description"><BR>
  580. File : <INPUT type="file" name="myFile"><BR>
  581. <INPUT type="submit" value="Send"> <INPUT type="reset">
  582. </form>
  583.  
  584. <br/>
  585.  
  586. <table>
  587. <tr>
  588. <td>
  589. <div class="divLeft">
  590. <table border="0" style="color: blue">
  591.  
  592. <tr>
  593. <td><span class="formText">Forma Registraciya</span></td>
  594. </tr>
  595. <form method="post" action="/registr">
  596. <tr>
  597. <td><p>Imya: </p></td>
  598. <td><input type="text" name="imya" class="inp" maxlength="21"/></td>
  599. </tr>
  600. <tr>
  601. <td><p>Familiya: </p></td>
  602. <td><input type="text" name="fam" class="inp" maxlength="32"/></td>
  603. </tr>
  604. <tr>
  605. <td><p>Login: </p></td>
  606. <td><input type="text" name="login" class="inp" maxlength="16"/></td>
  607. </tr>
  608. <tr>
  609. <td><p>Parol:</p></td>
  610. <td><input type="password" name="pass" class="inp" maxlength="16"/></td>
  611. </tr>
  612. <tr>
  613. <td><p>Povtorite parol:</p></td>
  614. <td><input type="password" name="passConfirm" class="inp" maxlength="16"/></td>
  615. </tr>
  616. <tr>
  617. <td><p>Vozrast: </p></td>
  618. <td><input type="text" name="age" class="inp" maxlength="2"/></td>
  619. </tr>
  620. <tr>
  621. <td><p>Pochta: </p></td>
  622. <td><input type="email" name="uMail" class="inp" maxlength="36"/></td>
  623.  
  624. </tr>
  625. <tr>
  626. <td colspan="2"><input type="submit" name="register" value="Registratsiya" class="butt"/>
  627. </td>
  628. </tr>
  629. </form>
  630. </table>
  631. </div>
  632. </td>
  633.  
  634. <td>
  635. <div class="divBody">
  636.  
  637. <table class="tabEnter">
  638. <form method="POST" action="/authorization">
  639.  
  640. <tr>
  641. <td><span>Login: </span></td>
  642. <td><input type="text" name="usLogin"/></td>
  643. </tr>
  644. <tr>
  645. <td><span>Password:</span></td>
  646. <td><input type="password" name="passw"/></td>
  647. </tr>
  648. <tr>
  649. <td colspan="2"><input type="checkbox" name="save"/></td>
  650. </tr>
  651. <tr>
  652. <td colspan="2">
  653. <input class="enterButton" type="submit" name="vxodSystem" value=" Enter to System "/>
  654. </td>
  655. </tr>
  656.  
  657. </form>
  658.  
  659. </table>
  660.  
  661. </div>
  662.  
  663. </td>
  664. </tr>
  665.  
  666. <tr>
  667. <td colspan="2">
  668. <table class="tabData">
  669. <tr>
  670. <td>Nomer ID</td>
  671. <td>Login</td>
  672. <td>Imya</td>
  673. <td>Familiya</td>
  674. <td>Pochta</td>
  675. <td>Vozrast</td>
  676. <td>Parol</td>
  677.  
  678. </tr>
  679.  
  680. <% UserKlass userKlass = new UserKlass();
  681. List<Dannie> dannieList = userKlass.getDannix();
  682. for (Dannie dan : dannieList) { // I sushestvuyushie to je ne otobrajayutsya,mojet oshibka s svyazi v Klassax, ili s bazoy?
  683.  
  684. %>
  685.  
  686.  
  687. <tr>
  688. <td><%=dan.getUsId()%>
  689. </td>
  690.  
  691. <td><%=dan.getUsName()%>
  692. </td
  693.  
  694. <td><%=dan.getUsFam()%>
  695. </td
  696.  
  697. <td><%=dan.getUsLogin()%>
  698. </td>
  699.  
  700.  
  701. <td><%=dan.getUsPass()%>
  702. </td
  703. <td><%=dan.getUsPost()%>
  704. </td>
  705. <td><%=dan.getUsAges()%>
  706. </td>
  707. <td><form method="post" action="/delete">
  708. <input type="hidden" name="delId" id="delId" value="<%=String.valueOf(dan.getUsId())%>" />
  709. <input type="submit" value="Delete" />
  710. </form>
  711.  
  712. </td>
  713. <td><form method="post" action="/update">
  714.  
  715. <input type="hidden" name="update" />
  716. </form>
  717.  
  718. </td>
  719. </tr>
  720. <% } %>
  721.  
  722. </table>
  723.  
  724. </td>
  725. </tr>
  726. </table>
  727.  
  728.  
  729. </BODY>
  730. </HTML>
  731.  
  732. <bean id="userKlass" class="com.force.samples.entity.UserKlass" />
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!