Hi guys
I have foloowing 2 file (a jsp file and a bean ) and want to show my
recordset(which contains multiple rows of data ) on my jsp page my code is
showing me the following error pls help me out guys .. I'm very new to JSP
this error is coming on my JSP page ..
The error is
"Can't make static reference to method java.util.Vector query() in class
shop.disBean.
vect=disBean.query();
^ "
and my JSp page is now :
<%@ page language="java" import="java.util.*" %>
<%@ page import="shop.disBean"%>
<HTML>
<HEAD>
<TITLE>
Display Products
</TITLE>
</HEAD>
<BODY topmargin="0" leftmargin="0">
<table cellspacing="2" cellpadding="2" border="1">
<tr>
List of Products
<table border="3">
<tr>
<td>Product Name</td>
<td>Price</td>
<td>Color</td>
<td>Brand</td>
<td>Category Name</td>
</tr>
<%
Vector vect=new Vector();
vect=disBean.query();
int size=vect.size();
for(int i=0;i<size;i++)
{
disBean dsp=vect.elementAt(i);
%>
<tr>
<td><%= dsp.getProduct_name()%></a></td>
<td><%= dsp.getPrice()%></td>
<td><%= dsp.getColor() %></td>
<td><%= dsp.getBrand() %></td>
<td><%= dsp.getCategory_name() %></td>
</tr>
<%
}
%>
</table>
</td></tr></table>
</BODY>
</HTML>
and my bean is :
package shop;
import java.sql.*;
import java.util.Vector;
public class disBean {
private String product_name;
private int price;
private String color;
private String brand;
private String category_name;
String url = "jdbc:odbc:test";
Connection conn;
Statement stmt;
public void setProduct_name(String pname)
{
this.product_name = pname;
}
public String getProduct_name()
{
return product_name;
}
public void setPrice(int prc)
{
this.price = prc;
}
public int getPrice()
{
return price;
}
public void setColor(String col)
{
this.color = col;
}
public String getColor()
{
return color;
}
public void setBrand(String brd)
{
this.brand = brd;
}
public String getBrand()
{
return brand;
}
public void setCategory_name(String catname)
{
this.category_name = catname;
}
public String getCategory_name()
{
return category_name;
}
public String connect()
{
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
return "Driver Loaded!";
}
catch (Exception E) {
return "Unable to load driver.";
}
}
public Vector query() throws SQLException, ClassNotFoundException {
try
{
conn = DriverManager.getConnection(url, "sa", "");
stmt = conn.createStatement();
String query = " select * from product p, category c where
p.category_id = c.category_id " ;
ResultSet rs = stmt.executeQuery(query);
Vector res = new Vector();
while (rs.next())
{
disBean db = new disBean();
db.setProduct_name(rs.getString("product_name"));
db.setPrice(rs.getInt("price"));
db.setColor(rs.getString("color"));
db.setBrand(rs.getString("brand"));
db.setCategory_name(rs.getString("category_name"));
res.addElement(db);
}
stmt.close();
conn.close();
return res;
}//end of try
catch (SQLException e) {
conn.close();
throw e;
}
}
}
pls tell what is the problem
Thanks Preeti
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
