Nitin Belaram

Ranch Hand

+ Follow

news 67 Posts 20 Threads

since Mar 24, 2009

Merit badge: grant badges

For More

Cows and Likes

Cows

Total received

In last 30 days

Forums and Threads

Recent posts by Nitin Belaram

PDF repot for struts

Where does PDf report file is view, Does the output display in PDF file.

What to do if resultset reurturn more then one row.,Then how to dispaly them in table

15 years ago

Struts

PDF repot for struts

Hi,

Please explain

1: How you are getting values for various report in dao from query resultset
2: How you are getting values in various heading
3: And from dao it is send to Action class.
4: Does your values are display in table

15 years ago

Struts

Report in PDF

Maneesh Godbole wrote:Check out Jasper Reports and BIRT.
Moving to a more appropriate forum.

I want PDf by using itext only

15 years ago

Other Open Source Projects

PDF repot for struts

Hi,

Can anyone please suggest how to generate itext PDf report for struts application.
Any source code example will be great.

Thanks

15 years ago

Struts

Report in PDF

Hi,

Can anyone please suggest how to generate pDf report for java application.
Any source code example will be great.

Thanks

15 years ago

Other Open Source Projects

getting started with struts

Hi,

Please suggest how to start working with struts,

Any tutorial or project explanation willl be great.

thanks:

15 years ago

Struts

struts

Hi,

Please suggest how to start work using struts. I am new to struts technology.

Any document or projrct for help will be great ..

Thanks

15 years ago

Struts

struts

Hi,

Please suggest how to start work using struts. I am new to struts technology.

Any document or projrct for help will be great ..

Thanks

15 years ago

Servlets

how to get value in drop down while doing update

I am updating record ,i am getting value in textfield by request.getAttribute (), but when i am using this in dropdown it is giving error

JSP code

<%@ page language="java"%>
<HTML>
<%@ page import="java.util.*"%>
<HEAD>
<Title>NEW USER</Title>
<script language="java script" type="text/javascript">
</script>
<script type="text/javascript">
<!--
function CallDisplay()
{
document.location.href ="DisplayServlet" ;
}
function CallUpdate()
{
document.location.href ="UserUpdate";
}
</script>
<%
Vector dept_Vect = (Vector)request.getAttribute("dept_Vect" );
if(dept_Vect == null) {
System.out.println("List of Departments are empty");
}
//Vector dept_Vect = (Vector)request.getAttribute("dept_Vect");
// Vector dept_Vect = new Vector();
Vector desg_Vect = (Vector)request.getAttribute("desg_Vect" );
if(desg_Vect == null) {
System.out.println("List of Designation are empty");
}
// Vector desg_Vect = new Vector();
%>
</HEAD>
<BODY BGCOLOR="LIGHTGREY">
<form Name="new_user" Method="POST" action="RegisterServlet1">
<Table border="1" cellspacing="10" width="75%">
<TR Valign="TOP">
<TD>EMP F NAME :     <INPUT type="text" size="20"
maxlength="15" name="empfname" value="<%=request.getAttribute("att")==null?"":request.getAttribute("att") %>"></TD>
<TD>EMP L NAME
:           <INPUT
type="text" size="20" maxlength="15" name="emplname" value="<%=request.getAttribute("att1")==null?"":request.getAttribute("att1") %>"></TD>
</TR>
<TR>
<TD>DEPARTMENT :   <SELECT NAME="department"
tabindex="3">
<Option value="select">Select Department --</Option>
<% if(dept_Vect != null)
for(int i =0 ;i < dept_Vect.size(); i++)
{%>
<option value="<%=dept_Vect.elementAt(i) %>"><%=(String)dept_Vect.elementAt(i) %>
</option>
<%}%>
</SELECT></TD>
<TD>DESIGNATION :       <Select
Name="designation">
<option value="select">Select Designation --</option>
<%if(desg_Vect != null)
for(int i = 0;i< desg_Vect.size();i++)
{ %>
<option value="<%= desg_Vect.elementAt(i) %>"><%=(String)desg_Vect.elementAt(i) %></option>
<%} %>
</Select></TD>
</TR>
<TR>
<TD>EMAIL-ID :
           <INPUT
type="text" size="20" maxlength="15" name="emailid" value="<%=request.getAttribute("att4")==null?"":request.getAttribute("att4") %>"></TD>
<TD>ADDRESS
:               
<INPUT type="text" size="20" maxlength="15" name="address" value="<%=request.getAttribute("att5")==null?"":request.getAttribute("att5") %>">
</TD>
</TR>
<TR>
<TD>PROJECT
:            <INPUT
type="text" size="20" maxlength="15" name="project" value="<%=request.getAttribute("att6")==null?"":request.getAttribute("att6") %>"></TD>
<TD>MANAGER
:             
<INPUT type="text" size="20" maxlength="15" name="manager" value="<%=request.getAttribute("att7")==null?"":request.getAttribute("att7") %>"></TD>
</TR>
</Table>
<input type="submit" name="Submit" VALUE=" INSERT"
onclick="RegisterServlet1">
<input type="button" name="Submit" VALUE=" UPDATE"
onclick= "CallUpdate();">
<input type="button" name="Submit" VALUE=" SEARCH"
onclick= "CallDisplay();" >
</form>
</BODY>
</HTML>

servlet-- from where i am getting value in jsp.

package mycontroller;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.mysql.jdbc.PreparedStatement;
import mydao.ConnectSQL;
import mydao.DaoException;
import mydao.UserDetails;
import mydao.New_USER;
/**
* Servlet implementation class for Servlet: RegisterServlet
*
*/
public class UpdateServlet extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
//static final long serialVersionUID = 1L;
private static final String VIEW = "new_user.jsp" ;
private static final String Attributeform ="form";
private static final String AttributeUser = "user";
//var
private UserDetails userdetails;
/* (non-Java-doc)
* @see javax.servlet.http.HttpServlet#HttpServlet()
*/
public void init() throws ServletException
{
System.out.print("update init");
}
/* (non-Java-doc)
* @see javax.servlet.http.HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//Prepare form bean
String value1 =request.getParameter("Empid");
System.out.println(value1);
Connection conn = null;
String empfname = "";
String emplname ="";
String deptid = "";
String desgid ="";
String email ="";
String address ="";
String proj ="";
String repmgnr="";
try{
Class.forName("com.mysql.jdbc.Driver");
String url =
"jdbc:mysql://localhost:3306/employee";
conn = DriverManager.getConnection(
url,"root", "root");
}catch(Exception e){
return;
}
try{
String sql = "Select * from base_employee where empid = " + value1 +"";
System.out.println(" SQL :- " + sql);
PreparedStatement stmt = (PreparedStatement) conn.prepareStatement(sql);
ResultSet resultSet = null;
resultSet = stmt.executeQuery();
while(resultSet.next()){
empfname = resultSet.getString("empfname");
emplname = resultSet.getString("emplname");
deptid = resultSet.getString("deptid");
desgid = resultSet.getString("desgid");
email = resultSet.getString("email");
address =resultSet.getString("address");
proj=resultSet.getString("proj");
repmgnr=resultSet.getString("repmgnr");
}
}
catch (SQLException e) {
try {
throw new DaoException(e);
} catch (DaoException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
}
request.setAttribute("att", empfname);
request.setAttribute("att1", emplname);
request.setAttribute("att2", deptid);
request.setAttribute("att3", desgid);
request.setAttribute("att4", email);
request.setAttribute("att5", address);
request.setAttribute("att6", proj);
request.setAttribute("att7", repmgnr);
request.getRequestDispatcher(VIEW).forward(request, response);
return ;
}
protected void doPost(HttpServletRequest request , HttpServletResponse response) throws ServletException, IOException {
request.getRequestDispatcher(VIEW).forward(request, response);
}
}

Please suggest how to get value in dropdown for update

15 years ago

Servlets

update record for selection of id

Shail Narkhede wrote:Nitin,

Generally this type of thing is done by considering primary key of perticular table.

While calling any updation or creation method, first we have to check that primary key,
if it is empty then call creation method and
if that key is non-empty then call updation method.

that means when you are getting the data from that table in bean you should get primary key,if you update some data & click on save than due to that primary key updation method is getting called.primary key you can populate in JSP by using hidden form feild.

My empid is primary key and i am getting it value ,Please suggest how to get all row value corresponding to this empid , and how to display them in form for updation

15 years ago

Servlets

updating record

Please suggest me how to update record on basic of id in servclet and jsp

15 years ago

Servlets

update record for selection of id

I had to update the record in the database ,but i am confuse how to do this.
I am getting empid in my servlet page but then i am confuse how to display record on basic of this empid in jsp page. and from there update these record .

My servlet is : UpdateServlet.java

package mycontroller;
import java.io.IOException;
import java.sql.Connection;
import java.util.Vector;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import mydao.ConnectSQL;
import mydao.DaoException;
import mydao.UserDetails;
import mydao.New_USER;
public class UpdateServlet extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
private static final String VIEW = "new_user.jsp" ;
private static final String Attributeform ="form";
private static final String AttributeUser = "user";
//var
private UserDetails userdetails;
public void init() throws ServletException
{
System.out.print("init method of update");
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
UserUpdate userUpdate = new UserUpdate(userdetails);
request.setAttribute(Attributeform,userUpdate);
// Process request and get result.
New_USER user =userUpdate.updateNew_USER(request);
System.out.println(request);
request.setAttribute(AttributeUser,user);
}
protected void doPost(HttpServletRequest request , HttpServletResponse response) throws ServletException, IOException {
request.getRequestDispatcher("VIEW").forward(request, response);
}
}

Java page : UserUpdate.java

package mycontroller;
import java.util.List;
import mycontroller.Form;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import mycontroller.*;
import mydao.DaoException;
import mydao.New_USER;
import mydao.UserDetails;
public final class UserUpdate extends Form{
private static final String Field_EMPID = "empid";
private static final String Field_EMPFNAME ="empfname ";
private static final String Field_EMPLNAME ="emplname";
private static final String Field_Department ="department";
private static final String Field_DESIGNATION="designation";
private static final String Field_EMAILID ="emailid";
private static final String Field_ADDRESS ="address";
private static final String Field_PROJECT ="project";
private static final String Field_MANAGER ="manager";
private static final String Field_Result = "result";
// Var----
private UserDetails userdetails;
// Constructors --
/**
* Construct an User Form associated with the given UserDetails.
*/
public UserUpdate(UserDetails userdetails)
{
this.userdetails =userdetails;
}
// Form action
/**
* Returns the registered User based on the given request.
*/
public New_USER updateNew_USER(HttpServletRequest request){
New_USER user = new New_USER();
try
{
//Object val =(request.getAttribute("value"));
// System.out.println(val);
// System.out.println("Received value of empid :- "+request.getAttribute("value"));
// System.out.println("Received value of empid :- "+request.getParameter("Empid"));
processEmpid(request.getParameter("Empid"),user);
processEmpfname(request.getParameter("empfname"), user);
processEmplname(request.getParameter("emplname"), user);
processDepartment(request.getParameter("department"), user);
processDesignation(request.getParameter("designation"), user);
processEmailid (request.getParameter("emailid"), user );
processAddress(request.getParameter("address") ,user);
processProject(request.getParameter("project") , user);
processManager(request.getParameter("manager") , user);
{ System.out.println(" before try");
try {
userdetails.update( user);
System.out.println("6");
} catch (IllegalArgumentException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
} catch (DaoException e) {
setError(Field_Result,"User Creation failed ");
e.printStackTrace();
}
return user;
}
//field processor
public void processEmpid(String Empid ,New_USER user) throws DaoException
{
if(Empid == null || FormUtil.isChanged(user.getEmpid(),Empid)) {
try {
} catch (Exception e) {
setError(Field_EMPID, e.getMessage());
}
user.setEmpid();
}
}
public void processEmpfname(String empfname ,New_USER user) throws DaoException
{
//String empfname = FormUtil.getFieldValue(request, Field_EMPFNAME);
// System.out.println(empfname + "check util");
if(empfname == null || FormUtil.isChanged(user.getEmpfname(),empfname)) {
try {
validateEmpfname(empfname);
} catch (ValidatorException e) {
setError(Field_EMPFNAME, e.getMessage());
}
// System.out.println("Set user fname = "+empfname);
user.setEmpfname(empfname);
}
}
public void processEmplname(String emplname ,New_USER user) throws DaoException
{
//System.out.println(emplname);
if(emplname == null || FormUtil.isChanged(user.getEmplname(),emplname))
{
try{
validateEmplname(emplname);
}
catch(ValidatorException e ){
setError(Field_EMPLNAME,e.getMessage());
}
user.setEmplname(emplname);
}
}
public void processDepartment(String department , New_USER user)
{
// String department = FormUtil.getFieldValue(department, Field_Department);
// System.out.println(department +"2");
if(FormUtil.isChanged(user.getDepartment(),department))
{
validateDesignation(department);
// System.out.println("Set depatment name = "+department);
user.setDepartment(department);
}
}
public void processDesignation(String designation , New_USER user)
{
// String designation = FormUtil.getFieldValue(request,Field_DESIGNATION );
if(FormUtil.isChanged(user.getDesignation(),designation))
{
validateDesignation(designation);
user.setDesignation(designation);
}
}
private void validateDesignation(String designation) {
// TODO Auto-generated method stub
}
}
}

UserDetails.java

package mydao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import mydao.New_USER;
import mydao.ConnectSQL;
public final class UserDetails
{
private static final String SQL_UPDATE =
"Update base_employee set empfname =?, emplname =?, deptid =?, desgid =?, emailid =?,address =?, project =?,manager =?, ";
private static final String SQL_DEPARTMENT =
"select deptname from base_department" ;
//var
private static ConnectSQL connectsql;
UserDetails(ConnectSQL connectsql)
{
this.connectsql = connectsql;
}
// for updating record
public static void update( New_USER user) throws DaoException, ClassNotFoundException {
Object []values = { ((New_USER) user).getEmpid()};
System.out.println(values);
/* if (user.getEmpid() == 0) {
throw new IllegalArgumentException("User is not created ");
}
*/
Object[] value = {
user.getEmpid(),
user.getEmpfname(),
user.getEmplname(),
user.getDepartment(),
user.getDesignation(),
user.getEmail(),
user.getAddress(),
user.getProject(),
user.getManager()
};
Connection connection = null;
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
try
{
connection = connectsql.getConnection();
preparedStatement = DaoUtil.prepareStatement(connection, SQL_UPDATE ,true, values);
resultSet = preparedStatement.executeQuery();
}
catch (SQLException e)
{
throw new DaoException(e);
}
}
// for saving the user in database
public void save( New_USER user) throws DaoException, IllegalArgumentException, ClassNotFoundException {
if (user.getEmpid() == 0)
{
create(user);
}
else
{
update(user);
}
}
public boolean existEmailid(String emailid) {
// TODO Auto-generated method stub
return false;
}
}

15 years ago

Servlets

Sending checkbox value to two different servlet page

Mohamed Inayath wrote:Nitin,

Q) How can i pass value of check box from same jsp page to another servlet where i can update my record ,

Update: you to have all the values from the screen along with checkbox value to the UpdateServlet.
(Similar way you have done in Delete Servlet).

Q) How can i had two submit button on same page OR how to submit checkbox value without using submit button to servlet

Yes you can have two Submit Buttons.

Create a hidden parameter say userSelect within the form.
Set the value for userSelect when the user selects either Delete/Update.

The JSP page code is fetching the record from database and displaying them in table, from where i can either delete the record or update them on the basic of checkbox.
Delete is working fine as i had define input type submit and form action as delete servlet.

But how can i update the record, on click of a button i want to pass empid to my servlet where i can call my update method defined in controller servlet.

Q) how does hidden parameter will work

Without submit button; tell me at what user event you want to pass the values of the screen to servlet.

15 years ago

Servlets

Sending checkbox value to two different servlet page

I had a jsp page in which i had two button delete and update ,
The user select checkbox and after clicking delete button record are deleted from database for which i had defined servlet which is working fine it is getting value of check box as i had define form action to call delete servlet. the input type of delete button is submit.

Q) How can i pass value of check box from same jsp page to another servlet where i can update my record ,
Q) How can i had two submit button on same page OR how to submit checkbox value without using submit button to servlet

My JSP code

<%@page import="java.util.*"%>
<%@page import="java.lang.reflect.Array"%>
<%@page import="mydao.New_USER;"%>
<html>
<head>
<title>Insert title here</title>
<script language="java script" type="text/javascript">
</script>
<script type="text/javascript">
<!--
function CallUpdate()
{
// var ss = document.Display.Empid[].value;
// System.out.println(ss);
document.location.href ="UpdateServlet" ;
}
</script>
</head>
<body>
<form Name="Display" Method="get" action="DeleteServlet">
<%
// for(int i = 0; i <= empfname.size();i++)
//{
//for( ) // {
%>
<CENTER>
<TABLE CELLSPACING="1" CELLPADDING="4" BORDER="3">
<TR>
<TH>Select</TH><TH>EmpID</TH><TH>EmpFName</TH><TH>EmpLName</TH><TH>Department</TH><TH>Designation</TH><TH>Email</TH><TH>Address</TH><TH>Project</TH><TH>Manager</TH>
</TR>
<%
ArrayList p = new ArrayList ();
ArrayList rows = new ArrayList (p);
if (request.getAttribute("AttributeUser") != null) {
rows = (ArrayList ) request.getAttribute("AttributeUser");
for(int i=0; i< rows.size(); i++) {
New_USER user = (New_USER) rows.get(i);
%>
<tr>
<td><input type="checkbox" name="Empid" value= <%= user.getEmpid()%> ></td>
<td> <%= user.getEmpid()%> </td>
<td> <%= user.getEmpfname()%> </td>
<td> <%= user.getEmplname()%> </td>
<td> <%= user.getDepartment()%> </td>
<td> <%= user.getDesignation()%> </td>
<td> <%= user.getEmail()%> </td>
<td> <%= user.getAddress()%> </td>
<td> <%= user.getProject()%> </td>
<td> <%= user.getManager()%> </td>
</tr>
<%}}%>
</Table>
<%
ArrayList items=new ArrayList();
ArrayList items1=new ArrayList();
String[] itemselected;
String itemname;
itemselected=request.getParameterValues("Empid");
if(itemselected!=null){
for(int i=0;i<itemselected.length;i++){
// out.println(itemselected[i]);
// itemname=itemselected[i];
//out.println(itemname);
//items.add(itemname);
// items1.addAll(items);
}
Iterator iterator=items.iterator();
}
%>
<input type="submit" name="Submit" VALUE="Delete"
onclick= "DeleteServlet" >
<input type="button" name="Submit" VALUE=" Update"
onclick= "CallUpdate();" >
</CENTER></form>
</body>
</html>

15 years ago

Servlets

Tomcat error

I am using eclipse editor and tomcat , it was giving some error after which i reinstall eclipse and tomcat ,

But now i am getting this error

Target runtime Apache Tomcat v5.5 is not defined.

15 years ago

Tomcat