题目
Name jdbc is not bound in this Context
tomcat的conf\catalina\localhost配置samples.xml
eclipse的samples工程里名为ConnPool的servlet
package servlet;
import java.sql.*;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* Servlet implementation class ConnPool
*/
public class ConnPool extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException {
// TODO Auto-generated method stub
response.setContentType("text/html");
response.setCharacterEncoding("GB2312");
PrintWriter out=response.getWriter();
try
{
javax.naming.Context ctx=new javax.naming.InitialContext();
javax.sql.DataSource ds=(javax.sql.DataSource) ctx.lookup("java:/comp/env/jdbc/jdbcdemo");
Connection conn=ds.getConnection();
PreparedStatement pstmt=conn.prepareStatement("select * from t_books");
ResultSet rs=pstmt.executeQuery();
StringBuilder table=new StringBuilder();
table.append("");
");
out.println(table.toString());
pstmt.close();
}
catch(Exception e)
{
out.println(e.getMessage());
}
out.flush();
out.close();
}
}.
为什么会这样呢?
tomcat的conf\catalina\localhost配置samples.xml
eclipse的samples工程里名为ConnPool的servlet
package servlet;
import java.sql.*;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* Servlet implementation class ConnPool
*/
public class ConnPool extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException {
// TODO Auto-generated method stub
response.setContentType("text/html");
response.setCharacterEncoding("GB2312");
PrintWriter out=response.getWriter();
try
{
javax.naming.Context ctx=new javax.naming.InitialContext();
javax.sql.DataSource ds=(javax.sql.DataSource) ctx.lookup("java:/comp/env/jdbc/jdbcdemo");
Connection conn=ds.getConnection();
PreparedStatement pstmt=conn.prepareStatement("select * from t_books");
ResultSet rs=pstmt.executeQuery();
StringBuilder table=new StringBuilder();
table.append("
书名 | 作者 |
"+rs.getString("name")+" | "); table.append(rs.getString("author")+" |
out.println(table.toString());
pstmt.close();
}
catch(Exception e)
{
out.println(e.getMessage());
}
out.flush();
out.close();
}
}.
为什么会这样呢?
提问时间:2020-10-30
答案
在web.xml中配置如下:<resource-ref><res-ref-name>数据库名</res-ref-name><res-type>javax.sql.DataSource</res-type><res-auth>Container</res-auth>{...
举一反三
已知函数f(x)=x,g(x)=alnx,a∈R.若曲线y=f(x)与曲线y=g(x)相交,且在交点处有相同的切线,求a的值和该切线方程.
我想写一篇关于奥巴马的演讲的文章,写哪一篇好呢?为什么好
奥巴马演讲不用看稿子.为什么中国领导演讲要看?
想找英语初三上学期的首字母填空练习……
英语翻译
最新试题
热门考点
- 1一光滑圆环固定在竖直平面内,环上套着两个小球A和B(中央有孔),A、B间由细绳连接着,它们处于如图中所示位置时恰好都能保持静止状态.此情况下,B球与环中心O处于同一水平面上,A
- 2文言文——滥竽充数
- 3the idea sounds great 什么基本结构
- 4已知函数x³ +ax² +bx 5的图像在x=1出的切线方程为y=-12x求fx的解析式.当x属于【-3,2】求函数的单调区间和最值
- 5[急求]为什么量筒&容量瓶&滴定管要标出仪器使用温度啊?
- 6速算,999+98+37+6
- 7初中数学列方程组解应用题(二元二次方程组)请说明列出如下方程的理由,
- 8观察2的正整数次幂:2∧1=2 22=4 23=8 24=16 25=32 26=64 27=128 28=256 29=512...
- 9一只大钟分针长60厘米,时针长40厘米,大钟走了3个小时.分针尖端走的路程是多少厘米?时针划过的面积是多少
- 10a和an的用法 形容词名词前什么情况用a或者an