Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package NewsAlertServ;
- import java.io.*;
- import java.util.*;
- import javax.servlet.*;
- import javax.servlet.http.*;
- import java.sql.*;
- public class AddFeed extends HttpServlet
- {
- public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException
- {
- response.setContentType("text/html");
- PrintWriter out = response.getWriter();
- String NamaFeed = request.getParameter("NamaFeed");
- String URLFeed = request.getParameter("URLFeed");
- String NamaPengguna = request.getParameter("NamaPengguna");
- try
- {
- Class.forName("com.mysql.jdbc.Driver");
- Connection connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/rssfeeds","root", "admin");
- Statement statement = connection.createStatement();
- String query1 = "Insert into penggunafeeds values('" + NamaFeed + "','" + URLFeed +"','"+NamaPengguna+"')";
- String query2 = "Insert into feeds values(feeds_seq.nextval,'" + NamaFeed + "','" + URLFeed +"')";
- // ResultSet resultSet = statement.executeQuery(query);
- int iupdate1 = statement.executeUpdate(query1);
- int iupdate2 = statement.executeUpdate(query2);
- if(iupdate1>0)
- {
- response.sendRedirect("feedsuccess.jsp");
- out.println("Feed Data Inserted Sucessfully");
- }
- else
- {
- response.sendRedirect("feedunsuccess.jsp");
- out.println("Feed Data Insert Un-Sucessfull");
- }
- }
- catch (Exception e)
- {
- e.printStackTrace();
- out.println("Data Insert Un-Sucessfull");
- }
- }
- public void doPost(HttpServletRequest request, HttpServletResponse res) throws IOException, ServletException
- {
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement