Saturday, 11 July 2020

JAVA DELETE


import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.Statement;

import java.sql.SQLException;


public class delete {

        public static void main(String[] args) throws Exception 

    {

    Connection connection = null;

     try

    {

     Class.forName("com.mysql.jdbc.Driver"); 

     String url = "jdbc:mysql://localhost/pinnacle";

     String user = "root";

     String password = "admin";

     connection = DriverManager.getConnection("jdbc:mysql://localhost/pinnacle",

             "root", "admin");

     Statement stmt = connection.createStatement();

     String sq1 = "DELETE FROM pinnacle WHERE course= 'java'";

     stmt.execute(sq1); 

      }

       catch (Exception e)

        {

            e.printStackTrace();

        } 

    finally

        {

            if (connection != null)

            {

                connection.close();

            }

        }

 }

    

}
at No comments:
Labels: , , , , , ,

J2EE INSERT


  1. Insert.jsp

<%@page contentType="text/html" pageEncoding="UTF-8"%>

<!DOCTYPE html>

<html>

    <head>

        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

        <title>JSP Page</title>

    </head>

    <body>

        <h1>Hello World!</h1>

        <form action = "InsertAction">

        Id:<input type="text" name="Id"><br>    

        Name:<input type="text" name="Name"><br>

        Course:<input type="text" name="Course"><br>

        Age:<input type="text" name="Age"><br>

        Address:<input type="text" name="Address"><br>

        Email:<input type="text" name="Email"><br>

        <input type="submit">

        </form>

    </body>

</html>


  1. InsertAction.java (Servlet Page )

import java.io.IOException;

import java.io.PrintWriter;

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 java.sql.Connection;

import java.sql.DriverManager;

import java.sql.Statement;

import java.sql.SQLException;


public class InsertAction extends HttpServlet {

@Override

protected void doGet(HttpServletRequest request,

      HttpServletResponse response) throws ServletException, IOException {

    

       Connection connection = null; 

       int Id=Integer.parseInt(request.getParameter("Id"));

       String Name= request.getParameter("Name");

       String Course = request.getParameter("Course");

       int Age=Integer.parseInt(request.getParameter("Age"));

       String Address= request.getParameter("Address");

       String Email = request.getParameter("Email");

             System.out.println("-"+Id+"-"+Name+"-"+Course+"-"+Age+"-"+Address+"-"+Email);

       

    try

    {

             Class.forName("com.mysql.jdbc.Driver");

            String url = "jdbc:mysql://localhost/education";

            String user = "root";

            String password = "admin";

            connection = DriverManager.getConnection("jdbc:mysql://localhost/education", "root", "admin");

            //connection = DriverManager.getConnection(url,user,password);

             Statement stmt = connection.createStatement();

            String sql = "INSERT INTO education VALUES('"+Id+"', '"+Name+"', '"+Course+"', '"+Age+"', '"+Address+"', '"+Email+"')";

            stmt.executeUpdate(sql);

      }   

   catch(Exception e)

   {

    e.printStackTrace();

} 

}

}
at No comments:
Labels: , , , ,

J2EE SEARCH


  1. Search.jsp


<%@page contentType="text/html" pageEncoding="UTF-8"%>

<!DOCTYPE html>

<html>

    <head>

        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

        <title>JSP Page</title>

    </head>

    <form method="post" action="SearchAction">

      <table border="0" width="300" align="center" bgcolor="#e9fh">

        <tr><td colspan=2 style="font-size:12pt;" align="center">

        <h3>Search Details</h3></td></tr>

        <tr><td ><b>Student ID:</b></td>

          <td>: <input  type="text" name="Id" id="Id">

        </td></tr>      

        <tr><td colspan=2 align="center">

        <input  type="submit" value="Search" ></td></tr>

      </table>

    </form>

</html>


  1. SearchView.jsp


<%@ page import="java.util.*" %>

 <%@page contentType="text/html" pageEncoding="UTF-8"%>

<!DOCTYPE HTML>

<html>

    <head>

    </head>

    <body>

        <table width="700px" align="center"

               style="border:1px solid #000000;">

            <tr>

                <td colspan=4 align="center"

                    style="background-color:teal">

                    <b>Employee Records</b></td>

            </tr>

            <tr style="background-color:lightgrey;">

                <td><b>Id</b></td>

                <td><b>Name</b></td>

                <td><b>Course</b></td>

                <td><b>Age</b></td>

                <td><b>Address</b></td>

                <td><b>Email</b></td>

            </tr>

            <%

                int count = 0;

                String color = "#F9EBB3";

                if (request.getAttribute("pid_list") != null) {

                    ArrayList pid_list = (ArrayList) request.getAttribute("pid_list");

                    System.out.println(pid_list);

                    Iterator itr = pid_list.iterator();

                    while (itr.hasNext()) {

                        if ((count % 2) == 0) {

                            color = "#eeffee";

                        }

                        count++;

                        ArrayList al = (ArrayList) itr.next();

            %>

            <tr style="background-color:<%=color%>;">

                <td><%=al.get(0)%></td>

                <td><%=al.get(1)%></td>

                <td><%=al.get(2)%></td>

                <td><%=al.get(3)%></td>

                <td><%=al.get(4)%></td>

                <td><%=al.get(5)%></td>

            </tr>

            <%

                    }

                }

                if (count == 0) {

            %>

            <tr>

                <td colspan=4 align="center"

                    style="background-color:#eeffee"><b>No Record Found..</b></td>

            </tr>

            <%            }

            %>

        </table>

    </body>

</html>


  1. SearchAction.java (Servlet Page)


import java.io.IOException;

import java.io.PrintWriter;

import java.sql.*;

import java.util.ArrayList;

import javax.servlet.RequestDispatcher;

import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;


public class SearchAction extends HttpServlet {

    @Override

    protected void doPost(HttpServletRequest request, HttpServletResponse response)

            throws ServletException, IOException {

        response.setContentType("text/html");

        PrintWriter out = response.getWriter();

        Connection conn = null;

        String url = "jdbc:mysql://localhost:3306/";

        String dbName = "education";

        String driver = "com.mysql.jdbc.Driver";

        String userName = "root";

        String password = "admin";

        Statement st=null;

        try {

            Class.forName(driver).newInstance();

            conn = DriverManager.getConnection(url + dbName, userName, password);

            System.out.println("connected!.....");

            String eid = request.getParameter("Id");

            ArrayList al = null;

            ArrayList pid_list = new ArrayList();

            String query = "select * from education";

            if(eid!=null && !eid.equals("")){

                query = "select * from education where Id='" + eid + "' ";

            }

            System.out.println("query " + query);

            st = conn.createStatement();

            ResultSet rs = st.executeQuery(query);


            while (rs.next()) {

                al = new ArrayList();


                al.add(rs.getInt(1));

                al.add(rs.getString(2));

                al.add(rs.getString(3));

                al.add(rs.getInt(4));

                al.add(rs.getString(5));

                al.add(rs.getString(6));

                System.out.println("al :: " + al);

                pid_list.add(al);

            }


            request.setAttribute("pid_list", pid_list);

            RequestDispatcher view = request.getRequestDispatcher("view.jsp");

            view.forward(request, response);

            conn.close();

            System.out.println("Disconnected!");

        } catch (Exception e) {

            e.printStackTrace();

        }

    }


    @Override

    public String getServletInfo() {

        return "getting records from database through servlet controller";

    }// </editor-fold>

}
at No comments:
Labels: , , , ,

J2EE UPDATE


  1. Update.jsp

<%@page contentType="text/html" pageEncoding="UTF-8"%>

<!DOCTYPE html>

<html>

    <head>

        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

        <title>JSP Page</title>

    </head>

    <body bgcolor="gray">

        <form name="f1" method="Post" action="UpdateView.jsp">  

           <div id="container">

        <div class="content"><center>Edit Student</center><br>

            <div class="formElements,rightcol" align="center">

                <label>Id : 

                 <span><input type="text" id="Id" name="Id" ></span></label>

                       </div><br>

            <div class="buttons" align="center">

                <button type="submit" class="primaryAction">Edit</button>

                 <button type="reset" class="primaryAction">Clear</button>

            </div>

        </div> 

    </div>

       </form>

    </body>

</html>


  1. UpdateView.jsp

<%@page import="java.sql.PreparedStatement"%>

<%@page import="java.sql.ResultSet"%>

<%@page import="java.sql.DriverManager"%>

<%@page import="java.sql.Connection"%>



<form name="f1" class="anu" method="Post" action="UpdateAction">  

    <%  

      // String Name= request.getParameter("Name");

       //String Course = request.getParameter("Course");

      // int Age=Integer.parseInt(request.getParameter("Age"));

      // String Address= request.getParameter("Address");

      // String Email = request.getParameter("Email");    

        String Name="";

        String Course="";

        int Age=0;

        String Address="";

        String Email="";

         int Id=Integer.parseInt(request.getParameter("Id"));

try 

                {

                Class.forName("com.mysql.jdbc.Driver");

     Connection con=(Connection) DriverManager.getConnection("jdbc:mysql://localhost/education","root","admin");

String selectStoredProc = "SELECT * FROM education WHERE Id = '"+Id+"'";


                    PreparedStatement ps = con.prepareStatement(selectStoredProc);

                    ResultSet rs=ps.executeQuery();

                    while(rs.next()) {

                      Id = rs.getInt(1);


                      Name=rs.getString(2);

                      Course=rs.getString(3);

                      Age=rs.getInt(4);

                      Address=rs.getString(5);

                      Email=rs.getString(6);

                       }

                    rs.close();

                    rs = null;

                } 

                catch (Exception e) {

                    System.out.println(e.getLocalizedMessage());

                    e.printStackTrace();

                }

                finally {     

                }

    %>

                                 ID :  <input type="text"  name="Id" value="<%=Id%>"><br><br>

<label>Name

              <span><input type="text"  name="Name" value="<%=Name%>"></span></label><br>

                <label>Course :

                 <span><input type="text"  name="Course" value="<%=Course%>"></span></label><br>

            <label>Age :

                 <span><input type="text"  name="Age" value="<%=Age%>"></span></label><br>

            <label>Address :

                 <span><input type="text"  name="Address" value="<%=Address%>"></span></label><br>

            <label>Email :

                 <span><input type="text"  name="Email" value="<%=Email%>"></span></label><br>

            <div class="buttons">

                <button type="submit" class="primaryAction">Edit</button>

                <button type="reset" class="primaryAction">Clear</button>

            </div> 

</form>

  </body>


  1. UpdateAction.java


import java.io.IOException;

import java.io.PrintWriter;

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 java.sql.PreparedStatement;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.Statement;

import java.sql.SQLException;


public class UpdateAction extends HttpServlet {

protected void doPost(HttpServletRequest request,

      HttpServletResponse response) throws ServletException, IOException {

    

       

       int Id=Integer.parseInt(request.getParameter("Id"));

       String Name= request.getParameter("Name");

       String Course = request.getParameter("Course");

       int Age=Integer.parseInt(request.getParameter("Age"));

       String Address= request.getParameter("Address");

       String Email = request.getParameter("Email");

       Connection con = null; 

               System.out.println("--"+Id+"--"+Name+"--"+Course+"--"+Age+"--"+Address+"--"+Email);

           try

    {

            Class.forName("com.mysql.jdbc.Driver");

             con= DriverManager.getConnection("jdbc:mysql://localhost/education","root","admin");

            

           // String url = "jdbc:mysql://localhost/education";

           // String user = "root";

           // String password = "admin";

            //connection = DriverManager.getConnection("jdbc:mysql://localhost/education", "root", "admin");

            //connection = DriverManager.getConnection(url,user,password);

//String sql="UPDATE education SET Id=?,Name=?,Course=?,Age=?,Address=?,Email=? where Id=?";             

//PreparedStatement cstmt= con.prepareStatement(sql);

                        

String sql="UPDATE education SET Id='"+Id+"', Name='"+Name+"', Course='"+Course+"', Age='"+Age+"', Address='"+Address+"', Email='"+Email+"' where Id="+Id;

System.out.println(sql);

PreparedStatement cstmt= con.prepareStatement(sql);


                // cstmt.setInt(1,Id);

               // cstmt.setString(2,Name);

               // cstmt.setString(3,Course);

               // cstmt.setInt(4,Age);

               // cstmt.setString(5,Address);

               // cstmt.setString(6,Email);  

                cstmt.executeUpdate(); 

               System.out.println("Student updated successfully");

           }   

   catch(Exception e)

   {

       System.out.println("-------"+e);

    e.printStackTrace();

} 

}

}


at No comments:
Labels: , , , , ,
Subscribe to: Comments (Atom)

‘Java’ is not recognised as an internal or external command

For Windows 10: 1.        Right click on  My Computer           2.      Select  Properties           3.    Select  Advanced System Setting...