Advertisement
Guest User

Untitled

a guest
Dec 19th, 2018
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.31 KB | None | 0 0
  1. //Baza de date
  2. static final String JDBC_DRIVER= "com.mysql.jdbc.Driver";
  3. static final String DB_URL = "jdbc:mysql://localhost/test";
  4. static final String USER = "root";
  5. static final String PASS = "admin";
  6. static ResultSet rs;
  7.  
  8. Class.forName(JDBC_DRIVER);
  9. Connection conn = DriverManager.getConnection(DB_URL, USER, PASS);
  10. Statement stmt = conn.createStatement();
  11. String sql = "select * from instrumente";
  12. rs = stmt.executeQuery(sql);
  13.  
  14. Connection con = DriverManager.getConnection (url, "root", "admin");
  15. Statement stm = (Statement) con.createStatement();
  16. String sql = "DELETE FROM persoane " +
  17. "WHERE id = "+id;
  18. stm.executeUpdate(sql);
  19. rs = stm.executeQuery("select * from persoane");
  20.  
  21. //html
  22. <!DOCTYPE html>
  23. <html>
  24. <head>
  25. <meta charset="UTF-8">
  26. <title>Destinatii turistice</title>
  27. </head>
  28. <body>
  29. <form method='GET' action="http://localhost:8080/Destinatii/Serv">
  30. <table>
  31. <tr><td align='left'>Denumire</td>
  32. <td><input type='text' name='txtDenumire'></td>
  33. </tr>
  34. <tr><td align='left'>Data vizitei</td>
  35. <td><input type='text' name='txtZi' size='3'>
  36. <input type='text' name='txtLuna' size='3'>
  37. <input type='text' name='txtAn' size='3'></td>
  38. </tr>
  39. <tr><td><input type='submit' name=btnAdaugare value='Adaugare'></td></tr>
  40.  
  41. </table>
  42. </form>
  43. </body>
  44. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement