<%@ page contentType="text/html;charset=BIG5"%>
<%@ page import="java.util.*"%>
<html>
<head>
<title>商品分類查詢結果</title>
</head>
<body>
<center>
<jsp:useBean id="category" class="ltk.Category" scope="page">
<jsp:setProperty name="category" property="*"/>
</jsp:useBean>
<%
java.util.ArrayList categorys = categoryBean.queryCategory(category);
if(null == categorys || categorys.isEmpty())
{
out.print("沒有找到符合條件的商品分類信息");
}
else
{
out.print("success");
}</center>
</body>
</html>javaBean如下:
放在C:\Program Files\Apache Group\Tomcat 4.1\webapps\ROOT\WEB-INF\classes\ltk
第一個:
package ltk;
public class Category
{
private int categoryid;
private String name; public void setCategoryID( int categoryid)
{
this.categoryid = categoryid;
}
public int getCategoryID()
{
return this.categoryid;
}
public void setName( String name)
{
this.name = name;
}
public String getName()
{
return this.name;
}} //此class測試沒有問題
另一個:
package ltk;
import java.sql.*;
import java.util.*;public class CategoryBean
{
public ArrayList queryCategory(Category category)
{
ArrayList lst = new ArrayList();
Connection conn = null;
Statement st = null;
ResultSet rs = null;
try
{
conn = ch08_DatabaseBean.getConnection();
st = conn.createStatement(); String sql = "select categoryid,name from category ";
if(category != null && ! StringUtil.isEmptyString(category.getName()))
sql = sql + " where name like '%" +category.getName() +"%'";
sql = sql + " order by name asc";
rs = st.executeQuery(sql); while(rs.next())
{
Category c = new Category();
c.setCategoryID(rs.getInt(1));
c.setName(rs.getString(2));
lst.add(c);
}
}
catch (SQLException ex)
{
ex.printStackTrace(System.err);
}
finally
{
ch08_DatabaseBean.close(rs,st,conn);
}
return lst;
}
} //此class測試沒有問題但是問題出現在jsp運行時出現錯誤:
The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: ltk.CategoryBean.queryCategory(Lltk/Category;)Ljava/util/ArrayList;請教高手指點迷津!
<%@ page import="java.util.*"%>
<html>
<head>
<title>商品分類查詢結果</title>
</head>
<body>
<center>
<jsp:useBean id="category" class="ltk.Category" scope="page">
<jsp:setProperty name="category" property="*"/>
</jsp:useBean>
<%
java.util.ArrayList categorys = categoryBean.queryCategory(category);
if(null == categorys || categorys.isEmpty())
{
out.print("沒有找到符合條件的商品分類信息");
}
else
{
out.print("success");
}</center>
</body>
</html>javaBean如下:
放在C:\Program Files\Apache Group\Tomcat 4.1\webapps\ROOT\WEB-INF\classes\ltk
第一個:
package ltk;
public class Category
{
private int categoryid;
private String name; public void setCategoryID( int categoryid)
{
this.categoryid = categoryid;
}
public int getCategoryID()
{
return this.categoryid;
}
public void setName( String name)
{
this.name = name;
}
public String getName()
{
return this.name;
}} //此class測試沒有問題
另一個:
package ltk;
import java.sql.*;
import java.util.*;public class CategoryBean
{
public ArrayList queryCategory(Category category)
{
ArrayList lst = new ArrayList();
Connection conn = null;
Statement st = null;
ResultSet rs = null;
try
{
conn = ch08_DatabaseBean.getConnection();
st = conn.createStatement(); String sql = "select categoryid,name from category ";
if(category != null && ! StringUtil.isEmptyString(category.getName()))
sql = sql + " where name like '%" +category.getName() +"%'";
sql = sql + " order by name asc";
rs = st.executeQuery(sql); while(rs.next())
{
Category c = new Category();
c.setCategoryID(rs.getInt(1));
c.setName(rs.getString(2));
lst.add(c);
}
}
catch (SQLException ex)
{
ex.printStackTrace(System.err);
}
finally
{
ch08_DatabaseBean.close(rs,st,conn);
}
return lst;
}
} //此class測試沒有問題但是問題出現在jsp運行時出現錯誤:
The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: ltk.CategoryBean.queryCategory(Lltk/Category;)Ljava/util/ArrayList;請教高手指點迷津!
解决方案 »
- 将任务在线程池之间传递,对效率影响大吗?
- 急!急!急!Java中对类名大小写有什么要求?javac是否识别大小写?
- Runtime.getRuntime().exec("shutdown -a");
- 请教关于java远程控制的一个问题?
- static 关键字的意思。帮小弟看看
- getDocumentBase()和getCodeBase()分别返回什么?
- mysql老是连不上去,请教连接代码,谢谢!
- 有谁知道jdk1.5带的demo程序那酷酷的界面是怎么实现的?
- 一个简单的问题:如何设置jTable使表格不可编辑,但可以选取行?
- 如何让浏览器可以打开SWing的Applet
- JAVA打印问题,各种打印方案都没满足我的打印要求,难难难啊,各位帮忙找个好方法
- 你动了你的鼠标了吗?屏幕捕捉求解
{
this.categoryid = categoryid;
}
CategoryBean 要按照JavaBean的规范来写set/get方法 格式为setCategoryid
getCategoryid
錯誤提示:
The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: ltk.CategoryBean.queryCategory(Lltk/Category;)Ljava/util/ArrayList;
java.lang.NoSuchMethodError: ltk.CategoryBean.queryCategory(Lltk/Category;)Ljava/util/ArrayList;修改的程序如下:
package ltk;
import java.sql.*;
import java.util.*;public class CategoryBean
{
public static void main(String [] args)
{
Category category = new Category();
//category.setCategoryid(8);
category.setName("abc"); CategoryBean categoryBean = new CategoryBean();
ArrayList categorys = categoryBean.queryCategory(category);
for(int i=0;i<categorys.size();i++)
{
Category c = (Category)(categorys.get(i));
i++;
System.out.println(i+" "+c.getName());
} }
public ArrayList queryCategory(Category category)
{......}
}