Programming Zone | Let's Code

Saturday, 11 July 2020

J2EE UPDATE

Update.jsp

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

<!DOCTYPE html>

<html>

<head>

</head>

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

<label>Id :

</div><br>

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

</div>

</form>

</body>

</html>

UpdateView.jsp

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

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

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

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

// 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

<label>Course :

<label>Age :

<label>Address :

<label>Email :

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

</div>

</form>

</body>

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();

}

J2EE UPDATE CODE

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>

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="";
        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>

UpdateAction.java (Servlet)

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 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.executeUpdate();
               System.out.println("Student updated successfully");
           }
   catch(Exception e)
   {
       System.out.println("-------"+e);
    e.printStackTrace();
}
}
}

Wednesday, 26 August 2015

Export to PDF code

aspx page :

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<title>Export to PDF</title>

</head>

<body>

<div>

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"

DataSourceID="SqlDataSource1" DataKeyNames="Empid">

<asp:BoundField DataField="Empid" HeaderText="Empid" SortExpression="Empid" ReadOnly="True" />

<asp:BoundField DataField="Empname" HeaderText="Empname"

SortExpression="Empname" />

<asp:BoundField DataField="Empsal" HeaderText="Empsal"

SortExpression="Empsal" />

</Columns>

</asp:GridView>

<asp:SqlDataSource ID="SqlDataSource1" runat="server"

ConnectionString="<%$ ConnectionStrings:DBConnectionString %>"

SelectCommand="SELECT * FROM [Table_1]"></asp:SqlDataSource>

<asp:Button ID="Button1" runat="server" Text="Export To PDF" OnClick="Button1_Click" />

</div>

</form>

</body>

</html>

aspx.cs page :

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using iTextSharp;

using iTextSharp.text.pdf;

using iTextSharp.text.html.simpleparser;

using System.IO;

using iTextSharp.text;

using System.Data.SqlClient;

using System.Data;

public partial class Default2 : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void Button1_Click(object sender, EventArgs e)

{

ExportGridToPDF();

}

private void ExportGridToPDF()

{

Response.ContentType = "application/pdf";

Response.AddHeader("content-disposition", "attachment;filename="+GridView1.Rows[0].Cells[1].Text+".pdf");

//to write into htmlContext

StringWriter sw = new StringWriter();

HtmlTextWriter hw = new HtmlTextWriter(sw);

GridView1.RenderControl(hw);

//Write into PDFDocument

StringReader sr = new StringReader(sw.ToString());

Document pdfDoc = new Document(PageSize.A4,10f,10f,5f,50f);

HTMLWorker htmlparser = new HTMLWorker(pdfDoc);

PdfWriter.GetInstance(pdfDoc, Response.OutputStream);

pdfDoc.Open();

htmlparser.Parse(sr);

pdfDoc.Close();

Response.End();

}

public void loadGrid()

{

using (SqlConnection con = new SqlConnection("Data Source=Home- PC\\SQLEXPRESS;Initial Catalog=EMP;Integrated Security=True"))

{

con.Open();

SqlCommand cmd = new SqlCommand("select * from employee", con);

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds);

GridView1.DataSource = ds;

GridView1.DataBind();

}

public override void VerifyRenderingInServerForm(Control control)

{

//required to avoid the runtime error "

//Control 'GridView1' of type 'GridView' must be placed inside a form tag with runat=server."

}

Tuesday, 25 August 2015

Export to Excel code

aspx page :

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

</head>

<body>

<div>

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" DataKeyNames="Empid">

<asp:BoundField DataField="Empid" HeaderText="Empid" SortExpression="Empid" ReadOnly="True" />

<asp:BoundField DataField="Empname" HeaderText="Empname"

SortExpression="Empname" />

<asp:BoundField DataField="Empsal" HeaderText="Empsal"

SortExpression="Empsal" />

</Columns>

</asp:GridView>

<asp:SqlDataSource ID="SqlDataSource1" runat="server"

ConnectionString="<%$ ConnectionStrings:DBConnectionString %>"

SelectCommand="SELECT * FROM [Table_1]"></asp:SqlDataSource>

<asp:Button ID="Button1" runat="server" Text="Export To Excel" onclick="Button1_Click"/>

</div>

</form>

</body>

</html>

aspx.cs page:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using iTextSharp.text.html.simpleparser;

using System.IO;

using System.Data.SqlClient;

using System.Data;

public partial class Default2 : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

protected void Button1_Click(object sender, EventArgs e)

{

exportToExcel();

}

public void exportToExcel()

{

Response.Clear();

Response.ContentType = "application/vnd.xls";

Response.AddHeader("content-disposition", "attachment;filename=ExportData1.xls");

StringWriter StringWriter = new System.IO.StringWriter();

HtmlTextWriter HtmlTextWriter = new HtmlTextWriter(StringWriter);

GridView1.RenderControl(HtmlTextWriter);

Response.Write(StringWriter.ToString());

Response.End();

}

Saturday, 11 July 2020

J2EE UPDATE

J2EE UPDATE CODE

Wednesday, 26 August 2015

Export to PDF code

Export to PDF code

aspx page :

aspx.cs page :

Tuesday, 25 August 2015

Export to Excel code

Export to Excel code

aspx page :

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