Showing posts with label Servlet. Show all posts
Showing posts with label Servlet. Show all posts

Wednesday, September 10, 2014

Insert dropdown value into database. Using JSP SERVLET




Create Dynamic project: File > New > Project....> Web > Dynamic Web Project.


























Create Servlet class with name SampleTest.java(it will automatically makes entry in web.xml)
Paste the following code into doPost()
System.out.println("Selected value is : "+(String)request.getParameter("gameName"));
            String gameName = (String)request.getParameter("gameName");
            DBConnection dbConnection = new DBConnection();
            dbConnection.insertQuery(gameName);
            System.out.println("Query insert successfully");


Create DBConnection.java file


     
     


      static Connection l_objConnection;


      public static Connection getConnetion() {


            try {


                  Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
                  // Your url -jdbc:oracle:thin:@localhost:1521:DBName
                  // your username - Test
                  // your password - Test
                  l_objConnection = DriverManager.getConnection(
                              "jdbc:oracle:thin:@localhost:1521:DBName", "username",
                              "password");


            } catch (InstantiationException e) {
                  // TODO Auto-generated catch block
                  e.printStackTrace();
            } catch (IllegalAccessException e) {
                  // TODO Auto-generated catch block
                  e.printStackTrace();
            } catch (ClassNotFoundException e) {
                  // TODO Auto-generated catch block
                  e.printStackTrace();
            } catch (SQLException e) {
                  // TODO Auto-generated catch block test
                  e.printStackTrace();
            }


            return l_objConnection;
      }


      public void insertQuery(String gameName) {
            try {
                  // Replace your table name instead of TABLENAME
                  // Replace GAMENAME into colounm name.
                  PreparedStatement preStatement = l_objConnection
                              .prepareStatement("INSERT INTO TABLENAME(GAMENAME) VALUES (?)");
                  preStatement.setString(1, gameName);
                  preStatement.execute();
            } catch (SQLException e) {
                  // TODO Auto-generated catch block
                  e.printStackTrace();
            }
      }





Create index.jsp under WebContent folder.
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<SCRIPT LANGUAGE="JavaScript">
            <!--
            function button1()
            {
              var value =   document.getElementById("gameName").value;
              alert(value);
              document.SampleTest.submit()
            }   
            
            // -->
        </SCRIPT>
<body>
<FORM NAME="SampleTest" METHOD="POST" action="./SampleTest">
<select id="gameName" name="gameName">
<option>Sports</option>
     <option>Corporate</option>
     <option>Religious</option>
     <option>Music</option>
</select>
<INPUT TYPE="submit" VALUE="Save" ONCLICK="button1()">
</FORM>
</body>
</html>


Web.xml
<servlet>
    <description></description>
    <display-name>SampleTest</display-name>
    <servlet-name>SampleTest</servlet-name>
    <servlet-class>com.test.SampleTest</servlet-class>
  </servlet>
  <servlet-mapping>
    <servlet-name>SampleTest</servlet-name>
    <url-pattern>/SampleTest</url-pattern>
  </servlet-mapping>


Output:


 

Friday, January 18, 2013

Pagination test code

check.jsp
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<form action="./CSVLoginServlet" method="post">
<input type="submit" value="Submit">
</form>
</body>
</html>


result.jsp
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1" import="java.util.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
    <%
        ArrayList array = (ArrayList) session.getAttribute("array");
        String pages = (String) session.getAttribute("pages");
        int i = 0;
        while (i < array.size()) {

            out.print(array.get(i));
            i++;
        }
        int j = 1;

        while (j <= Integer.parseInt(pages) + 1) {

            out.println("<a href=result.jsp?id=" + j + ">" + j
                    + "</a>");

            j++;
        }
    %>
</body>
</html>


csvfile.java
/**
 *
 */
package doa;

import java.io.BufferedReader;
import java.io.File;
import java.io.FileReader;
import java.io.FileWriter;
import java.io.IOException;
import java.util.ArrayList;

/**
 * @author Boomiraj
 *
 */
public class CSVFile {
    public static ArrayList<String> getArrayList(ArrayList list) throws IOException{
        //FileWriter fw = new FileWriter("C:/Users/Boomiraj/Desktop/Boomiraj.csv");
       //fw.close();
       File file = new File("C:/Users/Boomiraj/Desktop/test.csv");
       FileReader fr = new FileReader(file);
       BufferedReader pr =new BufferedReader(fr);
       String dataRow = pr.readLine();
      //System.out.println(dataRow);
      // ArrayList array = new ArrayList();
       if(file.isFile()){
       System.out.println(dataRow);
       while (dataRow != null){
        String[] dataArray = dataRow.split(",");
        for (String item:dataArray) {
            //System.out.println(item);
          // pr.re(item+",");
            list.add(item);
           // System.out.println(list);
        }
       // System.out.println("test"); // Print the data line.
        dataRow = pr.readLine();
       fr.read();
     //  System.out.println(list);
       }}
       return list;
   }
    public static void main(String[] args) throws IOException {
        ArrayList list = new ArrayList();
        new CSVFile().getArrayList(list);
        /*FileWriter fw = new FileWriter("C:/Users/Boomiraj/Desktop/Boomiraj.csv");
           fw.close();*/
         /*  File file = new File("C:/Users/Boomiraj/Desktop/test.csv");
           FileReader fr = new FileReader(file);
           BufferedReader pr =new BufferedReader(fr);
           String dataRow = pr.readLine();
          // System.out.println(dataRow);
          ArrayList array = new ArrayList();
           if(file.isFile()){
           //System.out.println(dataRow);
           while (dataRow != null){
            String[] dataArray = dataRow.split(",");
            for (String item:dataArray) {
                //System.out.println(item);
              // pr.re(item+",");
                array.add(item);
               // System.out.println(array);
            }
           // System.out.println();
            //System.out.println("test"); // Print the data line.
            dataRow = pr.readLine();
           fr.read();
           System.out.println(array);
           }}*/
    }

}



csvservlet.java
package servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.util.ArrayList;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import dao.CSVBean;
import doa.CSVFile;
import doa.CSVFileReadWrite;

/**
 * Servlet implementation class CSVLoginServlet
 */
public class CSVLoginServlet extends HttpServlet {
    private static final long serialVersionUID = 1L;
      
    /**
     * @see HttpServlet#HttpServlet()
     */
    public CSVLoginServlet() {
        super();
        // TODO Auto-generated constructor stub
    }

    /**
     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        /*PrintWriter out = response.getWriter();
        CSVBean csvBean = new CSVBean();
        csvBean.setFirstName(request.getParameter("firstname"));
        csvBean.setLastName(request.getParameter("lastname"));
        csvBean.setPhoneNumber(request.getParameter("phonenumber"));
       
        CSVFileReadWrite.writeFile(csvBean);
        out.println("Write Finished");
        */
       
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        PrintWriter out = response.getWriter();
        CSVFile csv = new CSVFile();
        //csv.getArrayList();
        ArrayList array = new ArrayList();
        HttpSession session = request.getSession(true);
        String pageNo = request.getParameter("id");
        //System.out.println(csv.getArrayList(array));
        if(pageNo==null){
            pageNo="1";
        }
        final int offSet = 2;

        int pageNumber = Integer.parseInt(pageNo);
        if(pageNumber != 0){
        //System.out.println("67"+array.add(csv.getArrayList(array)));
        int numberOfData = array.size();
        //System.out.println(array);
        int totalPages = numberOfData/offSet;
        String noPages = Integer.toString(totalPages);
        System.out.println(noPages + 1);
        int nodata = offSet*pageNumber;

        int fistNo = nodata - offSet;
        //System.out.println("NO Of Data"+nodata);
        //System.out.println("From"+fistNo+"To"+nodata);

        if(nodata>array.size()){
            nodata = array.size();
        }
        ArrayList onlyData = new ArrayList();
        while (fistNo<nodata ){
            //StudentBean student = (StudentBean) arrayList.get(fistNo);
            //System.out.println(student.getName_Strudet());

            array.get(fistNo);
           
            fistNo ++;
        }
        }
        System.out.println("servlet 88"+array);
        session.setAttribute("array", array);
        session.setAttribute("pages", pageNo);
        response.sendRedirect("result.jsp");
    }

}

Tuesday, January 15, 2013

get the arraylist value from servlet to jsp

Servlet:
PrintWriter out = response.getWriter();
        out.println("test");
        BufferedReader buffer = new BufferedReader(new FileReader(new File("C:/Users/boomiraj/Desktop/Boomiraj1.csv")));
        String readline = buffer.readLine();
        ArrayList<String> array = new ArrayList<String>();
       
        while(readline != null){
            String[] read = readline.split(" ");
            //out.println(read);
        array.add(read[0]);
        array.add(read[1]);
        array.add(read[2]);
        //array.add("sekar");
        Iterator<String> i = array.iterator();
        while(i.hasNext()){
            i.next();
        }
        readline = buffer.readLine();
        }
        HttpSession session = request.getSession(true);
        session.setAttribute("test", array);
        RequestDispatcher rd;
        rd = request.getRequestDispatcher("checkout.jsp");
        rd.forward(request,response);
        //response.sendRedirect("");



JSP file checkout.jsp

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1" import="java.util.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<%
ArrayList<String> array =(ArrayList)session.getAttribute("test");
if(!array.isEmpty()){
    for(int i = 0; i<array.size(); i++){
        %>
        <td><%= array.get(i)%></td>
       
       
<%}%><br>
    <%}%>       
</body>
</html>

Thursday, December 6, 2012

Login servlet

package servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import dao.LoginBean;
import doa.UserDOA;

/**
 * Servlet implementation class LoginServlet
 */
public class LoginServlet extends HttpServlet {
    private static final long serialVersionUID = 1L;

    /**
     * Default constructor.
     */
    public LoginServlet() {
        // TODO Auto-generated constructor stub
    }

    /**
     * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stubt
       
    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        PrintWriter out = response.getWriter();
        LoginBean lbean = new LoginBean();
        String username = request.getParameter("username");
        String password = request.getParameter("password");
        lbean.setUsername(username);
        lbean.setPassword(password);
       
            
        lbean = UserDOA.login(lbean);
       
        if(lbean.isValid()){
            HttpSession session = request.getSession(true);
             session.setAttribute("currentSessionUser",lbean);
             response.sendRedirect("RegisteredUser.jsp"); //logged-in page
           }else{
            //out.println("<h1> Username and Password Not Matched </h1>");
            response.sendRedirect("InvalidUser.jsp"); //error page
        }
         
         
               
    }

}