Name jdbc is not bound in this Context
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();
}
}.
為什么會這樣呢?
其他人氣:330 ℃時間:2020-02-03 22:57:29
優(yōu)質(zhì)解答
在web.xml中配置如下:<resource-ref><res-ref-name>數(shù)據(jù)庫名</res-ref-name><res-type>javax.sql.DataSource</res-type><res-auth>Container</res-auth>{...
我來回答
類似推薦
- 如圖,在平行四邊形ABCD中,E,F分別是BC,DC的中點,G為交點.若AB=a,AD=b,試以a,b為基底表示DE,BF,CG.(a,b,AB,AD,DE,BF,CG均為向量)
- 描寫雨聲的句子
- 三角函數(shù)的變換公式有哪些?
- 難解的幾何題
- 《海濱仲夏夜》的特點
- 一個三角形和一個平行四邊形的面積和底都相等.三角形的高是5cm,平行四邊形的高是()cm
- 已知關(guān)于x的方程a(3x-2)+b(2x-3)=8x-7 問題看下!
- 問一個英語句型問題The letter we looked forward to come last sunday~為什么to的后面是come而不是coming~
- 若直線y=kx+3與直線y=1/kx-5的交點在直線y=x上,則k=
- 車棚里停著三輪車和自行車一共10輛,一共有24個輪子.三輪車和自行車各有多少輛?(調(diào)整假設(shè),列表解答) 假設(shè)三輪車的輛數(shù) 相應(yīng)的自行車的輛數(shù) 輪子總個數(shù) 5 5
- 我的英語老師唱歌唱得好 My english teacher---- -----
- 英語選擇題Yesterday in the bookstore i saw the teacher___you had borrowed the dictionary
猜你喜歡
- 11/2+3/4+7/8+15/16簡算
- 2英語翻譯
- 3104.79用英文怎么表達
- 4已知,p:2x^2-9x+a
- 5英文達人來幫忙解釋下.
- 6求函數(shù)y=(lnx)^1/X微分dx
- 7已知拋物線y=x²-x+a與x軸的兩個交點之間的距離為√5.第一象限內(nèi)的點A在拋物線上,且點A的縱坐標(biāo)為1
- 8AB距31km,甲從A到B,一小時后乙也從A地去B地.已知甲每時行12千米,乙每時行28km.乙0.75h追上甲
- 9雙重否定句怎么改
- 10有一吊車,纏繞其上的鋼絲繩的最大承受力為10^3牛,次吊車能否勻速提升重為2.8×10^3牛的小轎車要公式
- 11已知直線L與直線y=-2x+8的交點橫坐標(biāo)為2,與直線y=-2x-8的交點縱坐標(biāo)為7,求直線L解析式.
- 12六(1)班男生人數(shù)的五分之二等于女生的七分之四,男生比女生多9人,這個班有多少人?