test.jsp
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.lang.*" errorPage="" %><html>
<head><title>test@@ go on~!</title></head>
<body>
<center>
<table>
<tr>
<td>ID</td>
<td>item</td>
</tr>
<jsp:useBean id="db" scope="page" class="cosmetic.db"/>
<%! String item;
int id;%>
<%
String str= "select * from items";
ResultSet rs = db.executeQuery(str);
while(rs.next())
{ id=rs.getInt("id");
item=rs.getString("item");
%>
<tr>
<td><%=id%></td>
<td><%=item %></td>
</tr>
<%
}
rs.close(); %>
</center>
</body>
</html>
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.lang.*" errorPage="" %><html>
<head><title>test@@ go on~!</title></head>
<body>
<center>
<table>
<tr>
<td>ID</td>
<td>item</td>
</tr>
<jsp:useBean id="db" scope="page" class="cosmetic.db"/>
<%! String item;
int id;%>
<%
String str= "select * from items";
ResultSet rs = db.executeQuery(str);
while(rs.next())
{ id=rs.getInt("id");
item=rs.getString("item");
%>
<tr>
<td><%=id%></td>
<td><%=item %></td>
</tr>
<%
}
rs.close(); %>
</center>
</body>
</html>
解决方案 »
- 我类用JFreeChart生报表,iText将报表放入PDF里,怎么将PDF通过servlet传入html页面里
- struts1 spring1
- 关于JSP的分页问题,请大家帮帮忙
- 菜鸟跪求分页代码,求求大虾,救命,程序要交了。
- 怎么在web.xml中自动写servlet配置语句,如何重新编译类后不重启tomcat
- --访问远程数据库,那位高手能给个思路!在线等候 --
- 如何删除文件?
- 请教关于数据库的一个问题
- JSP分页的问题
- Safari 5.1加载applet时 提示Missing plug-in 如何处理?
- 用jspSmartUpload下载中文名称的文件.....
- 本人初學,問個菜問題,就是如何架設Web服務器,用什么工具比較好?
exception org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:358)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
root cause java.lang.NullPointerException
org.apache.jsp.test4_jsp._jspService(test4_jsp.java:73)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
那我删除试试看~!