如题~
解决方案 »
- 求一数据库查询语句
- 怎么用 PLSQL Developer 创建新的oracle数据库
- window.parent问题,求助
- load-on-startup 默认值是1还是0?
- 关于jsp页面的显示
- 无意把工程SERVER改成TOMCAT再改回WEBLOGIC时EJB就不能用了抱好多错请问怎么回事??
- 在struts helloword实例中jbuilder编译中的问题 急救
- Struts高手请帮忙!--几个 初级问题。
- struts中各组件名词解释--入门级迷惑
- jboss+mysql开发cmp
- 为何找不到servlet.....求助.....
- 大家能不能帮我看看ajax+php实现多级联动下拉列表的代码到底是哪里出错啦!!
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class ShowResultSetWithDBBean extends HttpServlet{ private static final long serialVersionUID = 1L; @Override
protected void doGet(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
resp.setContentType("text/html;charset=gb2312");
PrintWriter out = resp.getWriter();
out.println("<table border=1>");
out.println("<tr><td>Content:</td></tr>");
Connection conn = DBBean.getConnction();
Statement stat = DBBean.getStatement(conn);
String sql = "select * from books";
ResultSet rs = DBBean.getResultSet(sql, stat);
try {
while(rs.next()){
out.println("<tr>");
out.println("<td>"+rs.getString("title")+"</td>");
out.println("</tr>");
}
out.println("</table>");
} catch (SQLException e) {
e.printStackTrace();
}finally{
DBBean.closeConnction(conn);
DBBean.closeStatment(stat);
DBBean.closeResultSet(rs);
}
} @Override
protected void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException {
doGet(req, resp);
}}
tomcat报500的错。:
java.lang.Error: Unresolved compilation problems:
The method getConnction() is undefined for the type DBBean
The method getStatement(Connection) is undefined for the type DBBean
The method getResultSet(String, Statement) is undefined for the type DBBean
The method closeConnction(Connection) is undefined for the type DBBean
The method closeStatment(Statement) is undefined for the type DBBean
The method closeResultSet(ResultSet) is undefined for the type DBBean ShowResultSetWithDBBean.doGet(ShowResultSetWithDBBean.java:25)
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
看看这个地址,是CSDN的。希望能够帮到你。
文件里就可以了
太简单了 HOHO~~