Forum:

Help in using bean inside JSP

Greenhorn

Posts: 24

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

java file: try1.java

package jdbc;
import java.sql.*;
public class try1 {
private String username;
private String userage;
private String userquali;
	public void setUsername() throws ClassNotFoundException, SQLException
	{
		Class.forName("oracle.jdbc.driver.OracleDriver");
		Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@Agnit-PC:1521:devdb","system","bababobby");
		Statement st=conn.createStatement();
		ResultSet rs=st.executeQuery("select name from a where name=username");
		String a="";
		rs.next();
		username=rs.getString(1);
											
		}
	public String getUsername()
	{
		return username;
	}

public void getUserage() throws ClassNotFoundException, SQLException
	{
		Class.forName("oracle.jdbc.driver.OracleDriver");
		Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@Agnit-PC:1521:devdb","system","bababobby");
		Statement st=conn.createStatement();
		ResultSet rs=st.executeQuery("select age from a where name=username");
		String userage="";
		rs.next();
		userage=(rs.getString(2));

}

public String setUserage()
{
	return userage;
}
public void getUserquali() throws ClassNotFoundException, SQLException
	{
		Class.forName("oracle.jdbc.driver.OracleDriver");
		Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@Agnit-PC:1521:devdb","system","bababobby");
		Statement st=conn.createStatement();
		ResultSet rs=st.executeQuery("select quali from a where name=username");
		String userquali="";
		
		rs.next();		
		userquali=(rs.getString(3));
		
}

public String setUserquali()
{
	return userquali;
}
}

1st JSP file

<%@ page import="java.sql.*" %>
<%@ page import="java.lang.*" %>
<%@ page import="java.exception.*" %>
<%@ page import="jdbc.try1" %>

<jsp:useBean id="try1" scope="application"
class="jdbc.try1" />
<jsp:setProperty name="try1" property="*" />
<html>
<head><title>Welcome to Qualification Section of TheTehnicalIllusion</title></head>
<body bgcolor="white" background="background.gif">
<%@ include file="dukebanner.html" %>
<table border="0" width="700">
<tr>
<td width="150">   </td>
<td width="550">
<h1>Welcome to Qualification Section of TheTehnicalIllusion</h1>
</td>
</tr>
<tr>
<td width="150"   </td>
<td width="550">
<form method="get">
Enter your name:<input type="text" name="username" size="25">
<br>
<jsp:setProperty name="try1" property= "userquali" />!
<jsp:setProperty name="try1" property= "userage" />!

2nd JSP file

I keep on getting some error or the other..........could you please help me.......where am I mistaking! Please help

Bear Bibeault

Sheriff

Posts: 67753

173

I like...

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Step 1: Move the Java code out of the JSP and into a Java class. Do it now. Java code in a JSP has been discredited for almost 10 years now and its use is irresponsible.

Step 2: Once you've done that, if you still get errors, please be sure to post the nature of the errors.

[Asking smart questions] [About Bear] [Books by Bear]

HTML 5 (verified skill)
Skill verified by Jeanne Boyarsky

CSS 3 (verified skill)
Skill verified by Jeanne Boyarsky

JavaScript (verified skill)
Skill verified by Jeanne Boyarsky

Agnit Chatterjee

Greenhorn

Posts: 24

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

But I have kept here 2 JSP files and a Java file separately

Bear Bibeault

Sheriff

Posts: 67753

173

I like...

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Please read this article for information on properly structuring web applications.

Java has no place inside a JSP. That is an extremely poor practice that went out of favor in 2002.

[Asking smart questions] [About Bear] [Books by Bear]

Agnit Chatterjee

Greenhorn

Posts: 24

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Please help me out.......I can't figure out where the problem is............please help

Jeanne Boyarsky

author & internet detective

Posts: 42109

935

I like...

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I've added code tags to make your post readable. I can't find where you say what the error is. Can you call attention to that so people can help you?

[OCP 21 book] | [OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2

Java 8 (verified skill)
Skill verified by Jeanne Boyarsky

JUnit 5 (verified skill)
Skill verified by Jeanne Boyarsky

Agnit Chatterjee

Greenhorn

Posts: 24

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Here is the details of the error I am getting:

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: /myfirst.jsp(4,0) The value for the useBean class attribute jdbc.try1 is invalid.
org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:41)
org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:407)
org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:148)
org.apache.jasper.compiler.Generator$GenerateVisitor.visit(Generator.java:1221)
org.apache.jasper.compiler.Node$UseBean.accept(Node.java:1182)
org.apache.jasper.compiler.Node$Nodes.visit(Node.java:2376)
org.apache.jasper.compiler.Node$Visitor.visitBody(Node.java:2428)
org.apache.jasper.compiler.Node$Visitor.visit(Node.java:2434)
org.apache.jasper.compiler.Node$Root.accept(Node.java:475)
org.apache.jasper.compiler.Node$Nodes.visit(Node.java:2376)
org.apache.jasper.compiler.Generator.generate(Generator.java:3458)
org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:249)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:365)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:345)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:332)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:594)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:342)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:391)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.8 logs.

Agnit Chatterjee

Greenhorn

Posts: 24

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

They are giving the error:

Name was not previously introduced as per JSP.5.3

Where is the problem???

Jeanne Boyarsky

author & internet detective

Posts: 42109

935

I like...

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Moving back to the JSP forum as this is a JDBC question.

Reposting the relevant lines to make it easier to read.
<%@ page import="jdbc.try1" %>
<jsp:useBean id="try1" scope="application" class="jdbc.try1" />

Where is the class file for try1 located? Is it already defined in the application scope?

Note that it is common convention for classnames to begin with an uppercase letter.

Agnit Chatterjee

Greenhorn

Posts: 24

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

class file for try1 is located inside WEB-INF\classes\jdbc

I had made some modifications........like some silly programming errors in the jdbc portion which I did eradicate........still get the error:

The value for the useBean class attribute jdbc.try1 is invalid.

The new files are as follows:

myfirst.jsp

try1.java

package testing;
import java.sql.*;
public class try1 {
private String username;
private String userage;
private String userquali;

try1()
{
username="";
userage="";
userquali="";
}

public void setUsername(String name) throws ClassNotFoundException, SQLException
	{
		this.username=name;

}
	public String getUsername()
	{
		return username;
	}

public void setUserage() throws ClassNotFoundException, SQLException
	{
		Class.forName("oracle.jdbc.driver.OracleDriver");
		Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@Agnit-PC:1521:devdb","system","bababobby");
		Statement st=conn.createStatement();
		ResultSet rs=st.executeQuery("select age from a where name='Agnit'");
		userage="";
		rs.next();
		this.userage=(rs.getString(1));

}

public String getUserage()
{
	return userage;
}
public void setUserquali() throws ClassNotFoundException, SQLException
	{
		Class.forName("oracle.jdbc.driver.OracleDriver");
		Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@Agnit-PC:1521:devdb","system","bababobby");
		Statement st=conn.createStatement();
		ResultSet rs=st.executeQuery("select quali from a where name='Agnit'");

rs.next();
		this.userquali=(rs.getString(1));

}

public String getUserquali()
{
	return userquali;
}
}

properties.jsp

I had intentionally put the try1.java file in a new package called testing. The other two files are jsp files

Vijitha Kumara

Bartender

Posts: 4116

I like...