JavaRanch: "JSP"

Fetching information from database in jsp

fredrick esedo — Sun, Mar 14 2010 20:02:05 MDT

Good day everyone Please i needs help.This code was used to fetch information from database.
whenever a correct id at BEANS.JSP is entered ,it will fetch every information from that row.
But the problem am having is that it will retrieve every information on that row but the Image cannot
be retrieve instead it will retrieve image link.Please how do i solve this problem using JSP only.

Thanks for help.

below is the code

-----------BEANS.JSP------------

  


    
        Database Lookup
    
 
    
    
    
         DATA RECOVERY FROM DATABASE
    
    



        
        
            PLEASE ENTER YOUR ID  HERE FOR SEARCH

-------------------BEANS.JSP--------------------------

   


<%@ page import="java.sql.*" %>
<% Class.forName("com.mysql.jdbc.Driver"); %>


    
        Fetching Data From a Database
    

    

    
        Fetching Data From a Database

    

        <% 
            Connection connection = DriverManager.getConnection(
                "jdbc:mysql://localhost:3306/money", "root", "root");

            Statement statement = connection.createStatement();

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

            ResultSet resultset = 
                statement.executeQuery("select * from login where id = '" + id + "'") ; 

            if(!resultset.next()) {
                out.println("SORRY, WE COULD NOT GET YOUR INFORMATIONS. ");
            } else {
           
        %>

        
            
               YOUR SURNAME:
               YOUR FIRSTNAME:
               YOUR image:
                          
           
                <%= resultset.getString(1) %> 
                <%= resultset.getString(2) %> 
                " width="50" height="50">


                          
       
       

       <% 
           } 
       %>


CLICK HERE TO GO BACK

YOUR SURNAME:	YOUR FIRSTNAME:	YOUR image:
<%= resultset.getString(1) %>	<%= resultset.getString(2) %>	" width="50" height="50">

Error in

rohan abes — Sun, Mar 14 2010 17:41:06 MDT

Hello friends .. i am new to jsp .. please help me out .. I am getting ." Fail" in the end .. tell me where i gone wrong.....

LOGIN.HTML

LOGIN.JSP

<%
if(useLoginBean.check()==0) {
out.println("Done");
}
else if(useLoginBean.check()==0) {
out.println("not match");
}
else {
out.println("fail");
}
%>

LOGINBEAN.JAVA

package vcs;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class LoginBean {

String urid, urpass, urlevel, urblock;

public String getUrblock() {
return urblock;
}

public void setUrblock(String urblock) {
this.urblock = urblock;
}

public String getUrid() {
return urid;
}

public void setUrid(String urid) {
this.urid = urid;
}

public String getUrlevel() {
return urlevel;
}

public void setUrlevel(String urlevel) {
this.urlevel = urlevel;
}

public String getUrpass() {
return urpass;
}

public void setUrpass(String urpass) {
this.urpass = urpass;
}

public int check() {
String pwd=null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "system", "manager");
String sql = "SELECT urpass FROM SYSTEM.USERLOG WHERE urid = '" + urid + "' AND urblock= 0";
Statement state = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
ResultSet res = state.executeQuery(sql);
while (res.next()) {
pwd = res.getString("urpass");
}
con.close();

} catch (Exception e) {
System.out.println(e);
}
if(pwd!=null) {
if ((urpass).equals(pwd)) {
return 0;
}
else
return 1;

}
return -1;
}
}

URID URPASS URLEVEL URBLOCK
rohan abc 0 0
braj xyz 1 0
anoop abc 2 0
ashwin xyz 3 0

Dir Structure messed up??

Mimi Tam — Sun, Mar 14 2010 14:40:12 MDT

I could not get my home.html to show up.

<%@include file="include.jsp"%>
<% Redirected because we can't set the welcome page to a virtual URL. %>

<%@ page session="false"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jstl/core"%>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>

Here's my project dir structure (1st picture) and what shows up at startup (Run in Server).

Any idea will be greatly appreciated.

tag file parameters

Jim Largent — Sun, Mar 14 2010 14:17:02 MDT

I created a tagfile and I want to have an either/or required parameter. In other words, you must specific 1 of 2 parameters. Any suggestions on how best to approach this? Right now I've just made them all optional and rely on myself to know that I need to specify one or the other.
Thanks

what is the equivalent in JSP - of PHP: send in body of email file.php

Leonidas Savvides — Sun, Mar 14 2010 04:11:34 MDT

PHP CODE:

  ob_start();
include ('../confirmBookingPlacedNowEmail.php');  //  in many  initialized IN parent file(container file)
$message_place_booking = ob_get_clean();

mail($to,$subject,$message_place_booking,$headers);

what is the equivalent in JSP?
IF OUR FILE FULL OF PARAM IS confirmBookingPlacedNowEmail.jsp? like <%= %>, we suppose that script called this file[confirmBookingPlacedNowEmail.php] like in php, has all param initialized IN so the jsp takes them?

mail website

ankur garha — Sat, Mar 13 2010 13:14:34 MST

do you know how to develop a simple mail website.
for eg.
im having a domain www.example.com
and every visitor to my site can create his own email address as example@example.com
is this thing possible with the help of jsp???

checkboxes and radiobuttons as options

anuj thite — Sat, Mar 13 2010 07:52:20 MST

Hello all members,

I am creating an assesment application where i have to display some questions with radiobuttons as options for selecting only one option
& in some cases, checkboxes as options for selecting multiple options.

How i can implement the above in jsp?

Can I have to add a column in database for detecting button type?????

Please help.

Thanks in advance.

JSP EL and Javascript?

Anuradha Prasanna — Sat, Mar 13 2010 00:22:03 MST

What is the difference between JSP EL and JavaScript? Are they both same?

They both are used to "put dynamic content into the static html pages"?

Dynamically Allocate Array lists to options in a dropdown for struts JSP

Vertika Solanki — Fri, Mar 12 2010 22:10:19 MST

The situtation is ...
When user selects a value from Dropdown 1. Then depending on the value selected another dropdown should be populated from 1 of 2 diffrent Araaylist in struts form.

I'm absloutely naive at AJAX. I don't know how AJAX will work here.

The deciding dropdpwn is

The one that needs to be set is

I tried hiding and showing them as required .

  
function showHide(){

document.getElementById('tmsSecurityCodeType').style.display = 'none';
document.getElementById('intlSecurityCodeType').style.display = 'none';

var tradeGp = document.getElementById('tradeGroup').value;
				
if( tradeGp == "TMS" ){

document.getElementById('tmsSecurityCodeType').style.display = 'inline';
document.getElementById('intlSecurityCodeType').style.display = 'none';

}else if ( tradeGp == 'FISSMC' || tradeGp == 'FISSEU' || tradeGp == 'FISSAS' || tradeGp == 'TRANSRPT'){
						
document.getElementById('tmsSecurityCodeType').style.display = 'none';
document.getElementById('intlSecurityCodeType').style.display = 'inline';
						
}

but when the form is submitted it doesn't take the value for the secCodeTypeOptions options even when it is displayed rather it picks up the first value from the secCodeTypeOptionsIntl array

I would appreciate if someone can tell me where I'm wrong ....please help me how can I get thru ....

Writing JSP from scratch

Muhammad Imad Qureshi — Fri, Mar 12 2010 19:37:54 MST

I have been programming since last 5 years. I have maintained JSPs but not written one from scratch. What I want to know is, do people first create html pages using some html editor and then convert into a JSP or they directly create JSPs. Which editor is normally used for creating JSPs in eclipse?

JSP taglib Paggination

Ramkumar Subburaj — Fri, Mar 12 2010 09:27:54 MST

Hi,

I want to display records from the db in the form of tables using pagination.

I found display tag as a useful one but I can see a problem with that.

The tag takes the list which contains the data and records per page to display the contents and pagination.

If the user clicks page no 2, all the records needs to be loaded into the list and given as input to the name attribute which doesnt makes sense i beleive.

Is what i say correct or is there any better of doing it.

I require a pagination taglib where I input the the total number of records, records per page, uri, page param amd it should give me the paginnation.

Problem - Configuring init parameters for jsp

Anuradha Prasanna — Fri, Mar 12 2010 08:57:24 MST

I have a jsp(BasicCounter.jsp) in my C:\tomcat\tomcat-6.0.24\webapps folder,


<%@ page import="foo.*" %>




<%! 
int doubleCount(){
count=count*2;
return count;
}
%>

<%!
public void jspInit(){
ServletConfig sConfig = getServletConfig();
String emailAddr=sConfig.getInitParameter("email"); //line 1
ServletContext ctx = getServletContext();
if(emailAddr == null){
emailAddr="goodforme@yahoo.co.in";
ctx.setAttribute("mail", emailAddr);
}
}
%>

<%! int count=1; %>
The page count is:
<%= doubleCount() %>


<%= (String)getServletContext().getAttribute("mail") %>

And in my "web.xml" iam doing the following for configuring the init parameters,

MyBasicCounter

/BasicCounter.jsp

email //line 2
ikickedyou@wickedlysmart.com /line 3

When i load the jsp page as, "http://localhost:8080/BasicCounter.jsp", i get

The page count is: 2
goodforme@yahoo.co.in

Can you please tell me why my init parameter, "email" is not coming correctly in line 1, as i configured it in line2 and line 3
anyone can you correct me so i can get the value for "email" correctly?
Iam a beginner in jsp.

java.sql.SQLException: No suitable driver found

Harish Moolchandani — Fri, Mar 12 2010 07:59:14 MST

Hello friends, I'm having a problem using Oracle Type4 driver.
I had the following code:

<%@taglib prefix="sql" uri="http://java.sun.com/jsp/jstl/sql"%>
<%@page errorPage="/errorpage.jsp"%>

running this produces following error:
Unable to get connection, DataSource invalid: "java.sql.SQLException: No suitable driver found for ${database}"

I've tried these things:
1. The driver requires "ojdbc14.jar" file so I put it in both the lib(i.e in WEB-INF/lib and Tomcat/lib) but nothing solved the problem.
2. I have tried using it on both Tomcat 5.5 and Tomcat 6 but the problem still remains same.
3. I also tried to use the driver "oracle.jdbc.driver.OracleDriver" instead of "oracle.jdbc.OracleDriver" but no improvement.
4. The classpaths for ojdbc14.jar file is also set in Environment variable. One java desktop application is running fine with this driver, but I'm using it first time with JSP's JSTL.

Please help......It's been one day I'm stuck with this problem

Help with update

Jaidev Arer — Fri, Mar 12 2010 06:16:47 MST

Hi All,
I am developing an application where in i have 30 rows from the mysql database for a calender month. one of the field is read-write,so i have 30 update buttons. Now when a user updates (for ex:24th record's read-write field), i need to update the same on the database. But i am confused how to map the update to the corresponding records.
i have attached the image of the JSP.
in the attached image, requested field is read-write field. if the user updates that field for any particular date then that update has to be reflected on the database.
Please advise how to go on.
Thanks in advance.

Validate HTML field on the server

Paulo Correa Silva — Fri, Mar 12 2010 05:03:47 MST

This is my JSP file:

      
    Cadastro de Clientes  
      
      
        Cadastro de Clientes  
        

  
          
         Nome:  
              
           CPF/CNPJ:  
             
           RG:  
             
         
        Endereco:  
             
           Bairro:  
             
           Cidade:

I have the following function validation cpf (document required in Brazil)

public class ValidaCpfCnpj {  
     public static boolean valida_cpf_cnpj(final String CNPJ_CPF) {  
   
         if(CNPJ_CPF.length() == 11) { //CPF  
             int acumulador1 = 0;  
             int acumulador2 = 0;  
             int resto = 0;  
             StringBuffer resultado = new StringBuffer();  
             String digitoVerificadorCPF = CNPJ_CPF.substring((CNPJ_CPF.length() - 2),  
                                                               CNPJ_CPF.length());  
             for(int i = 1; i < (CNPJ_CPF.length() - 1); i++) {  
                 acumulador1 += (11 - i) * Integer.valueOf(CNPJ_CPF.substring((i - 1), i));  
                 acumulador2 += (12 - i) * Integer.valueOf(CNPJ_CPF.substring((i - 1), i));  
             }  
             resto = acumulador1 % 11;  
             if (resto < 2) {  
                 acumulador2 += 2;  
                 resultado.append(2);  
             }  
             else {  
                 acumulador2 += 2 * (11 - resto);  
                 resultado.append((11 - resto));  
             }  
             resto = acumulador2 % 11;  
             if (resto < 2) {  
                 resultado.append(0);  
             }  
             else {  
                 resultado.append((11 - resto));  
             }  
             return resultado.toString().equals(digitoVerificadorCPF);  
         }  
}

What I need is this: How do I fill in the field to the CPF in the HTML form it is validated by the function that is running on the server. If number entered in the field for a cpf invalid, returns a message and erases the contents, but it goes smoothly.

Synchronization issue in Jsp

Kousik Majumder — Fri, Mar 12 2010 01:09:29 MST

Hi all,

I have a jsp pagewhere I have used an useBean for instantiation of a bean in session scope.
Now the problem is that sometimes this page is giving NullPointerException when multiple user or may be first time hitting this page.
In compiled java file of this jsp there is a synchronized block(synchronized(session)) where the instantiation is occuring.

So I am confused what is happening as because the requests will wait untill instantiation ,so no question of "Null".Please help.

   
           <%
String name = "ABC";
if (!obj1.getAttribute("name").equals(name)) obj1.update(name);
%>

EL evaluation within bracket and without bracket

sakthi vadivel — Thu, Mar 11 2010 23:48:58 MST

hiiii folks

I have a doubt on EL evaluation technique. Please anybody explain me how el evaluates the expression when it's inside quotes "" and without quotes sorrounded.

for ex i saw a quiz

${"a"<"b"} returns true

${a

thanks in advance>

Why only Maps and List is supported for tags

James Tharakan — Thu, Mar 11 2010 21:50:29 MST

Why is that only Maps and List are support by the JSP tags. Why not the Sets and Queue ?

confused about the usage of JSP tags

James Tharakan — Thu, Mar 11 2010 21:14:54 MST

I am kind of confused about the usage of tags...
Like to set the property of a bean we can use

(If a bean does not exist then a bean can be created )
setProperty>

or
<c:set var=useThis scope="page" value="value" /> (bean can also be created like this)

but now sure which one is better and why....

and
To display the bean property we can use

getProperty>

or
<c: out value="${useThis.name}" default="not set" />

Is there is any kind of rule when to use one thing but not the other... I mean how is the choice made :confused:

Regarding Ajax

santhosh kumar vk — Thu, Mar 11 2010 20:28:42 MST

hi,

I am doing one project using ajax with jsp i do not know how to use ajax in jsp can you give any note or example regarding to work with jsp and ajax.

Thanking You.

Does this situation need filter?

Vikas Kapoor — Thu, Mar 11 2010 19:37:26 MST

I have menu with tabs in my web application. but those tabs are visible/accessible based on security settings. I have tab id and user id.
Right now I have created a common method at one place and calling it from various controllers and checking for the authority settings.

But is filter best choice here or the way I have implemented is ok or something else?

Using a JSP and EL to a file or ByteArrayStream?

Pat Farrell — Thu, Mar 11 2010 07:39:31 MST

I need to populate a non-HTML text stream (say an email message) with data in my POJO bean. If I want to send it out to a browser, its easy. But I want the text, processed with EL, locally to the server.

The idea would be to take a JSP page as a "template" and then populate the template with appropriate EL values. This allows a GUI designer/artist to make the JSP look
as cool as they want, using tools they know how to use, and lets me, the engineer, not care about how its made pretty.

Is this possible? Any ideas on how to start?

thanks
pat

data are not showing in a Jsp using link

Babu Singh — Thu, Mar 11 2010 05:13:25 MST

i have a Jsp page. in this Jsp page having some links. i want when i click to link of result some data should be display. but it does not displaying. please check the below code.

Indus.jsp

  


Indus Public School



Indus Public School







<%String value="";
if(value!=null && (value.equals("result")))
{%>
Indus Public School 
<%
}
%>


 please suggest.

Expression Language
MaheshS Kumbhar — Wed, Mar 10 2010 23:54:09 MST
As per the rule, anything inside [] which is not in quotes must satisfy java naming rules. Then how does following code work even though thing inside [] is not in quotes and which doesn't comply to java naming rules?

 

 String [] list = {"one", "two"};
request.setAttribute("arraylist", list);
${arraylist[1]}


 

 

Role based Authorization for Tree Structure
Deepaks Deshpande — Wed, Mar 10 2010 23:41:33 MST
I have a javascript based tree structure in my jsp, I want to perform user level authorization for each node/leaf of the tree on clicks on the corresponding node/leaf. I am using the tree structure from http://www.destroydrop.com/javascripts/tree/default.html . I am adding the id, parentId, Name, Title,and path information of the node/leaf  from the database by using JSONObject.  I have a scenario where, at present I have 2 types of users - Admin and Group Users. Admin is authorized to view the entire tree structure. Group user is assigned to a particular group and should be able to view the tree structure according to the group to which he belongs. How should I perform user level authorization for this?

A simple web-app to retrieve and display an Excel Sheet
Shantanu Rathore — Wed, Mar 10 2010 22:08:21 MST
Hi,

 

 What I am trying to do: Reading an Excel sheet from a remote location and passing it on to a JSP page.

 

 What I have managed so far: I have managed to read the Excel Sheet from the remote location. This was done using a Java class and POI.

 

 What I need help with:

 1. How to pass the Excel Sheet(retrieved in the java file) to a JSP page which will display the excel sheet. I have researched somethings but am not clear how to go about doing it.

 2. I am OK with the JSP page opening the excel sheet separately, but is it possible to display it within the JSP page itself? I was wondering about using iFrames but i think its client side basically. Is it possible to use it in a JSP?

 

 Code Snippets:-

 

 ByteArrayInputStream bais = new ByteArrayInputStream(baos.toByteArray()); 

 

 //baos is a ByteArrayOutputStrream whichread the Excel sheet from the remote location.

 

             //POI Coding to read the excel file          

             POIFSFileSystem fs = new POIFSFileSystem(bais);

             HSSFWorkbook wb = new HSSFWorkbook(fs);

 

 Application FLow:- A HTML(user enters the filename here) ==> passes filename to ==> JSP==> passes filename to ==>Java (retrieves file)

                               Java==> passes File to ==>JSP : DISPLAYS THE FILE

 

 

 Thanks in advance.

 

             

 

How can i Jsp page itself
Babu Singh — Wed, Mar 10 2010 10:09:52 MST
I have two Jsp pages named bestschool.jsp and schoolnames.jsp.

 

 I am calling schoolnames.jsp from bestschool.jsp.

 

 I want when I click the link on INDUS School. It can show all concerning link of INDUS School links like profile, result, facility etc. in the same place instead of other naming school links. 

 

 my requiremet main is i want to update the information on same Jsp page.

 

 How can I implement this with in Servlets/Jsp.

 

 Please review below JSP’s files

 

 schoolnames.jsp

  








Profile



Staff





Result

  
 






 bestschool.jsp



Best school




Best Schools in Rohtak





School list



INDUS School



Vaise School




D.G.V School



D.P.S School 

   
 
 



  

 

 Can someone please suggest me how can I make this "attribute" variable reference to null?  Really don't want to use scriplet since it will be a step back.

 

 Thanks in advance


Creating a forum
Karabo Mashiyane — Tue, Mar 9 2010 02:48:46 MST
 :confused: :confused: :confused:Hey Guys   :D. I'm currently studying java and I am busy with my Project, which entails creating a forum.

 I wnted to know ; How do i display user user topics and replies. Is it ok to use expressions to display these on my 

 Jsp.  :rolleyes:


Dual Authentication Issue
Ryan Sandow — Mon, Mar 8 2010 23:20:54 MST
Hi,

 

 At our work we are setting up a system with SSL and it will act as a web server.

 

 It is using Apache with ajp connector to connect into Tomcat. The problem occurs when a java applet which uses RMI tunneling is launched.

 

 The user follows these steps to reproduce the issue.

 

 1. using IE7 user logs in and enters standard username and password when the prompt appears

 2. navigation works correctly as long as no java applet is launched

 3. clicks on a link where java applet is launched and the user gets prompted again to enter standard username and password

 4. once the username and password has been entered the session runs smoothly with no more prompts for these credentials

 5. close IE7 and open up again, go through the same steps and it happens again

 

 The initial login prompt is an IE one. The second looks like a java one, it is titled "Authentication Required" when using Java 1.6_15. If you are using Java 1.4_2 or 1.5_15 the dialogue is titled "Password Needed - Networking".

 

 This issue happens with IE6, 7 and 8 using either Java 1.4, 1.5 or 1.6. It does not happen when using Firefox. We haven't tested any more browsers.

 

 Please also note that this issue does not occur if the web server has SSL turned off.

 

 Thanks in advance


problems in a Chat Client/Server application
Ankit Tripathi — Mon, Mar 8 2010 14:16:25 MST
Dear Freinds,

 me and my freinds are developing a Chat Client/Server application.I am core java programmer and has a good knowledge in Servlets/JSPs still we are facing many problems in our project. :confused: we want to include the functionalities of real time file sharing and creation and exchange of MIDI sequences in our project.will you please suggest me which one is the best way to implement such type of project with interactive functionalities.

 1.Core Networking

 2.JMS

 3.RMI/IIOP

 I want also to know what would be best possible architecture of my web based application.......

 there are many problems before us

 1.should there be any controller servlet or all JSPs?

 2.how would i pop up a splash screen and a swing frame from a jsp for user login details?

 3.database connectivity code should be on login page or on any other loginhandler page? 

 please help us in the best informative way and suggestive books and tutorials!!!!!!!!!thanking you all....If it is necessary i can represent my coding pages here.reply soon. :rolleyes: 


Problem with anchor tag # when trying to open pdf
vamshidhar nimbagiri — Mon, Mar 8 2010 13:09:10 MST
Hi All,

 

 I have a requirement to open a PDF document (to open an existing pdf on server not creating) with showing the appropriate section which user clicked and also need to update the count in database.

 

 In order to do this i have followed these steps:

 Ex: Lets say XYZ.pdf file which has a, b and c sections. To show section a in the URL it is some thing like ../../XYZ.pdf#a

 

 

 1. First, i called my controller class when user clicks the link (to update the count in database) and in controller i used Spring MVC redirect function to open XYZ.pdf#a. But the problem is its removing   the # from URL and showing entire XYZ.pdf opening first page instead of showing #a section. That too this is happening in IE browser not in Firefox.

 2. I have tried another way by calling a dummy jsp from controller and onload of that jsp i did location.href function to show the pdf document. It worked but the problem is with back button, if i use POST method back button displays page cannot be displayed message, if use GET method back is not working i will be in same page forever it wont allow you to go back.

 

 I hope i cleared explained my problem, Could any one please help me.

 

 Thanks in advance!

 

 - Vamshidhar Nimbagiri

 

 


JSP custom tag unable to pass dynamic value
Amit Kohli — Mon, Mar 8 2010 06:17:08 MST
I am facing problem while passing dynamic values in my custom tag.

 I have created one tag which is retrieving some data based on passed-in values. It is working fine with static values like in my jsp if I use

 	

 i.e.  in my tag I am passing 3 values and getting some results.

 

 But when I am using same tag with dynamic values like 

 

 

 

 It is showing JasperException (i.e. According to TLD or attribute directive in tag file, attribute brandCode does not accept any expressions).

 

 Following are my configurations for this project:

 

 1.	I am using struts2.0 and tomcat6.0.

 2.	In my tld(for this customized tag), I have mentioned 

 

 
 "http://java.sun.com/j2ee/dtds/web-jsptaglibrary_1_1.dtd">

 

 	1.0

 	1.1

 	DemoTags

 	http://www.abc.com

 	Demo Tags Library

 

 3.	My web.xml contains 

 http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"	id="WebApp_ID" version="2.5">

 

 Please suggest.

 



<%@ include file="schoolnames.jsp" %>


 
 
 
    

 

 please suggest.


Form is not submitting on TAB navigation
G.T. Reddy — Wed, Mar 10 2010 08:46:31 MST
Hi All, 

 I have a problem while submitting the form through tab navigation. 

 

 in a form I have browse button(created using  tag) but this is hidden by a customized browse button as shown in the following code. 

 

 
 target="logo_upload"> 

 

 
 onChange="javascript:saveImage('repLogo','datafileLogo','logo_upload');"/> 

  

  

 

 //this method is used to open the file selection window on clicking the image above Browse image. 

 this.openFileWindow = function(objectId) 

 { 

 var flvar = document.getElementById(objectId); 

 flvar.click(); 

 } 

 

 

 //this save image method is called when the user selects the image from the file window( on onChange) .Here I have to use the TAB navigation only to select and submit the selected file. 

 this.saveImage = function(imagePrefix,imageName,displayImageFrame) 

 { 

 var fileName = document.getElementById(imageName).value; 

 var fileType = fileName.substr(fileName.lastIndexOf(".")); 

 var fileSystem = new ActiveXObject("Scripting.FileSystemObject"); 

 var thefile = fileSystem.getFile(fileName); 

 var size = thefile.size; 

 

 if(((fileType == ".gif") || (fileType == ".GIF")) && (size <= 1048576)) 

 { 

 document.uploadform.imageType.value = fileType; 

 document.uploadform.imagePrefix.value = imagePrefix; 

 document.uploadform.fileOperation.value= 'saveImage'; 

 document.uploadform.target = displayImageFrame; 

 document.uploadform.imagefileName.value = imageName; 

 document.uploadform.submit(); 

 } 

 else 

 { 

 util.alert("Images must be .gif files less than 1MB is size. Click the information icon in the coverpage options section for more information."); 

 } 

 

 } 

 


May include run-time value as attribute in custom tag?
Leonidas Savvides — Wed, Mar 10 2010 07:22:31 MST
" /> 

 

 May include <%= request.getParameter("dateonly") %> as attribute value like above, in custom tags(struts)?

 

 eg...

      
/WEB-INF/tlds/datetime.tld

currentdatetime
datetime.CurrentDateTimeTag
empty

dateOnly
true
true
boolean





javabeans/ relational db
J Bo — Wed, Mar 10 2010 06:41:39 MST
When you are creating beans do you create one for each table in your database?

 

 Can you have a HTML form that has components that use more than one bean? Updating data to more than one table?

 


Retaining jsp form data when accessing a separate menu item
Melodie Rice — Tue, Mar 9 2010 12:11:26 MST
Hello,

 

 I am trying to retain all the jsp form values when a user exits the jsp and accesses another jsp from a menu item, then returns back to the original jsp.

 

 So:

    1.  User enters form information in jsp

    2.  User chooses menu item during visit or entering the jsp.  (The menu item references another jsp which is a "how to" page)

    3.  User return to original page via a javascript.history() command.

    4.  Original info on original form is empty.

 

 Thanks!

 

 I usually go through a servlet when processing jsp info but not in this case.

 

 Thanks so much!

 

 Mel...

 


JSP Bean,not able to work my first bean
Stanley Walker — Tue, Mar 9 2010 10:53:32 MST
I have created a webproject in which i have one jsp firstView.jsp captures details about the person and relays the information to the second jsp viewInformation.jsp.

 The source code is as below:

 FirstView.jsp

   
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
	pageEncoding="ISO-8859-1" import="viewBean.Person" %>
	


	




First View




Enter First Name Here :  


Enter Last Name Here :  


Enter Age Here :  







 

 

 

 viewInformation.jsp

 

 <%@ page language="java" contentType="text/html; charset=ISO-8859-1"
	pageEncoding="ISO-8859-1" import="viewBean.Person"%>




View Information






FirstName of the person is 



LastName of the person is 



Age of the person is 



 





 

 

 

 The bean i have used is under package viewBean, which I have kept under src/viewBean folder. The output folder for the class files is under the lib folder.

 The bean class is as under

 

 
package viewBean;

public class Person {

	public String getFirstName() {
		return firstName;
	}

	public void setFirstName(String firstName) {
		this.firstName = firstName;
	}

	public String getLastName() {
		return lastName;
	}

	public void setLastName(String lastName) {
		this.lastName = lastName;
	}

	public int getAge() {
		return age;
	}

	public void setAge(int age) {
		this.age = age;
	}

	public String firstName;
	public String lastName;
	public int age;

}



 

 

 However whenever i hit the firstview.jsp i get an exception:

 

 org.apache.jasper.JasperException: /pages/firstView.jsp(5,0) The value for the useBean class attribute viewBean.Person is invalid.

 	at org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:40)

 	at org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:407)

 	at org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:148)

 	at org.apache.jasper.compiler.Generator$GenerateVisitor.visit(Generator.java:1272)

 	at org.apache.jasper.compiler.Node$UseBean.accept(Node.java:1178)

 	at org.apache.jasper.compiler.Node$Nodes.visit(Node.java:2361)

 	at org.apache.jasper.compiler.Node$Visitor.visitBody(Node.java:2411)

 	at org.apache.jasper.compiler.Node$Visitor.visit(Node.java:2417)

 	at org.apache.jasper.compiler.Node$Root.accept(Node.java:495)

 	at org.apache.jasper.compiler.Node$Nodes.visit(Node.java:2361)

 	at org.apache.jasper.compiler.Generator.generate(Generator.java:3426)

 	at org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:216)

 	at org.apache.jasper.compiler.Compiler.compile(Compiler.java:332)

 	at org.apache.jasper.compiler.Compiler.compile(Compiler.java:312)

 	at org.apache.jasper.compiler.Compiler.compile(Compiler.java:299)

 	at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:586)

 	at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:317)

 	at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)

 	at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)

 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

 	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

 	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

 	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)

 	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

 	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

 	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)

 	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)

 	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)

 	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)

 	at java.lang.Thread.run(Unknown Source)

 

 

 

 Please help. I am stuck.

 is there some place else where i need to keep the bean class file. or have i used the bean correctly.

 


please help i am in big trouble, my  project  is not working, this is urgent.
j u ray — Tue, Mar 9 2010 06:50:07 MST
i am working on a project that is based on jsp. my project is NOT  working in my system  but is running  properly in another system.  both system are running netbeans  6.8 and same appache tomcat server 5.5.17.  

 

 the error is that:  when  i am trying to run it , it is saying deployment failed  and the browser is launched . In the browser it is saying "unable to connect to local host",  but it is  running properly on another system. My browser is mozilla fifefox 3.6

 

 what can be my problem. please help me.


Reading a CSV file and storing it into an array and then displaying it on a HTML screen
Shantanu Rathore — Tue, Mar 9 2010 04:50:31 MST
Hi Everyone,

 

 Requirement: TO read a CSV file and transferring the content into an array which I can display on a JSP/HTML screen.

 

 Description:-

 1. I want to read a CSV file stored in a particular location on my computer.

 2. As per my understanding, the CSV file is a comma separated file with each line representing a row in a table. The columns are separated by commas.

 3. I want to store the CSV file contents in an array in exactly the same structure as the original tabular format.

 4. Then I want to display the file on a JSP screen or a HTML screen in tabular format again.

 

 Notes:- 

 The CSV file I have is a pretty big one because it has a lot of data. The data is mostly 'string'.

 

 Since this is the first time I am trying something like this I dont have any idea about the code. Can anyone help me out with a small example explaining me how to go about doing this? 

 

 Thank you all in advance. Eagerly awaiting a response. Thanks 

 

 Shantanu


Free instances held up by c:forEach tag
Abhijith Prabhakar — Tue, Mar 9 2010 04:47:03 MST
Dear All, 

 

 Our application in production started throwing outofmemory error recently.  I used JProbe profiler to narrow down lottering objects.

 

 I found that there is an arraylist which in turn holds many DTO objects is not getting released.  I create this arraylist in view bean and loop it through in jsp using c:forEach tag.  I found from profiler that c:forEach tag is holding live references hence this object is not getting garbage collected.  I confirmed it by removing c:forEach tag and putting scriplets instead.  The instances are getting garbage collected perfectly when used with scriplets!!

 

 I tried removing the variables using c:remove tag.  But didn't help.  Please find below the piece of code.

 

   


    

		
		 :