Advertisement
dyanamustafah

AddFeed,java

May 25th, 2016
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.67 KB | None | 0 0
  1. package NewsAlertServ;
  2.  
  3. import java.io.*;
  4. import java.util.*;
  5. import javax.servlet.*;
  6. import javax.servlet.http.*;
  7. import java.sql.*;
  8.  
  9. public class AddFeed extends HttpServlet
  10. {
  11.  
  12. public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException
  13. {
  14. response.setContentType("text/html");
  15.  
  16. PrintWriter out = response.getWriter();
  17.  
  18. String NamaFeed = request.getParameter("NamaFeed");
  19. String URLFeed = request.getParameter("URLFeed");
  20. String NamaPengguna = request.getParameter("NamaPengguna");
  21.  
  22.  
  23. try
  24. {
  25. Class.forName("com.mysql.jdbc.Driver");
  26.  
  27. Connection connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/rssfeeds","root", "admin");
  28. Statement statement = connection.createStatement();
  29.  
  30. String query1 = "Insert into penggunafeeds values('" + NamaFeed + "','" + URLFeed +"','"+NamaPengguna+"')";
  31. String query2 = "Insert into feeds values(feeds_seq.nextval,'" + NamaFeed + "','" + URLFeed +"')";
  32.  
  33. // ResultSet resultSet = statement.executeQuery(query);
  34.  
  35. int iupdate1 = statement.executeUpdate(query1);
  36. int iupdate2 = statement.executeUpdate(query2);
  37.  
  38. if(iupdate1>0)
  39. {
  40. response.sendRedirect("feedsuccess.jsp");
  41. out.println("Feed Data Inserted Sucessfully");
  42. }
  43. else
  44. {
  45. response.sendRedirect("feedunsuccess.jsp");
  46. out.println("Feed Data Insert Un-Sucessfull");
  47. }
  48.  
  49.  
  50. }
  51. catch (Exception e)
  52. {
  53. e.printStackTrace();
  54. out.println("Data Insert Un-Sucessfull");
  55. }
  56.  
  57.  
  58.  
  59.  
  60. }
  61.  
  62. public void doPost(HttpServletRequest request, HttpServletResponse res) throws IOException, ServletException
  63. {
  64.  
  65.  
  66.  
  67.  
  68. }
  69. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement