Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package mljac.database;
- import java.io.IOException;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.SQLException;
- import javax.servlet.ServletException;
- import javax.servlet.annotation.WebServlet;
- import javax.servlet.http.HttpServlet;
- import javax.servlet.http.HttpServletRequest;
- import javax.servlet.http.HttpServletResponse;
- /**
- * Servlet implementation class DbInsert
- */
- @WebServlet("/DbInsert")
- public class DbInsert extends HttpServlet {
- private static final long serialVersionUID = 1L;
- /**
- * @see HttpServlet#HttpServlet()
- */
- public DbInsert() {
- super();
- // TODO Auto-generated constructor stub
- }
- /**
- * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
- */
- protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
- String ime, probao;
- double cijena;
- ime = request.getParameter("ime");
- probao = request.getParameter("probao");
- cijena = Double.parseDouble(request.getParameter("cijena"));
- Connection conn = null;
- PreparedStatement statement = null;
- try {
- Class.forName("org.sqlite.JDBC");
- conn = DriverManager.getConnection("jdbc:sqlite:c:\\tomcat\\db\\Mljac.db");
- String sql = "INSERT INTO Hrana (ime, cijena, probao) VALUES('"+ ime +"', '" + cijena +"','"+ probao +"')";
- statement = conn.prepareStatement(sql);
- int result = statement.executeUpdate();
- if (result == 1)
- response.sendRedirect("http://localhost:8080/FastFoodMljac/FoodList");
- else
- response.sendRedirect("http://localhost:8080/FastFoodMljac/Error");
- }catch(SQLException se) {
- System.out.println("SQL Exception:" + se.getMessage());
- }catch(Exception e) {
- System.out.println("Exception:" + e.getMessage());
- }finally {
- try {
- if(conn != null)
- conn.close();
- }catch(SQLException se) {
- System.out.println("Excpetion in closing connection " + se.getMessage());
- }
- }
- }
- /**
- * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
- */
- protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
- // TODO Auto-generated method stub
- doGet(request, response);
- }
- }
- <!DOCTYPE html>
- <html>
- <head>
- <meta charset="UTF-8">
- <title>Fast Food Mljac</title>
- </head>
- <body>
- <h1>Dodajte novo jelo</h1>
- <form action="DbInsert">
- Unesite naziv jela: <input type="text" name="ime"><br>
- Unesite cijenu jela: <input type="number" name="cijena" step="0.01"><br>
- <label>Jeste li probali jelo?</label>
- <select name="probao">
- <option value='NE'>Ne</option>
- <option value='DA'>Da</option>
- </select>
- <br><br>
- <input type="submit" value="Dodaj">
- </form>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement