javabean为:
package popdomConnDB;
import java.sql.*;
import javax.sql.*;
import javax.naming.*;
import javax.naming.InitialContext;
import javax.sql.DataSource;/**
* <p>Title: </p>
* <p>Description: </p>
* <p>Copyright: Copyright (c) 2004</p>
* <p>Company: </p>
* @author not attributable
* @version 1.0
*/
//一个用于查找数据源的工具类。
public class ConnDB {
private Connection con=null;
private Statement stmt=null;
ResultSet rs=null;public ResultSet executequery(String sql) throws Exception
{
rs=null;
try
{
Context initCtx = new javax.naming.InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource)envCtx.lookup("jdbc/TestDB");
con=ds.getConnection();
stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery (sql);
}
catch(SQLException e){throw e;}
catch(NamingException e){throw e;}
return rs;
}
//执行Insert,Update语句
public int executeUpdate(String sql) throws Exception
{
stmt = null;
rs=null;
int Result =0;
try
{
Context initCtx = new javax.naming.InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource)envCtx.lookup("jdbc/TestDB");//jdbc/TestDB
con=ds.getConnection();
stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
Result = stmt.executeUpdate(sql);
stmt.close();
con.close();
}
catch(SQLException ex)
{
System.err.println("执行SQL语句出错: " + ex.getMessage());
}
return Result;
}// 关闭stmt和关闭连接
public void close_all()
{
try{
stmt.close();
con.close();
}
catch(SQLException e){e.printStackTrace();}
}
}随便一个jsp(举一个没有JDBC操作的)go.jsp
<%@ page contentType="text/html; charset=GBK" %>
<%@ page language="java" import="java.sql.*" %>
<html>
<head>
<title>
系统登陆
</title>
</head>
<body bgcolor="#ffffff">
<jsp:forward page="login.htm">
</jsp:forward>
</body>
</html>结果,无论里面是否有SQL查询操作,都出现当运行
http://localhost:8080/DBTest/login.htm时候是可以的,我还测试其他的HTM也完全正确,但是一遇到是JSP,包括上面的GO。JSP还是CHECKLOGIN。JSP同样出现以下报错信息
HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: /chklogin.jsp(49,2) Expected "param" tag with "name" and "value" attributes
org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:83)
org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:402)
org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:126)
org.apache.jasper.compiler.Parser.parseParam(Parser.java:892)
org.apache.jasper.compiler.Parser.parseBody(Parser.java:1838)
org.apache.jasper.compiler.Parser.parseOptionalBody(Parser.java:1100)
org.apache.jasper.compiler.Parser.parseForward(Parser.java:942)
org.apache.jasper.compiler.Parser.parseStandardAction(Parser.java:1253)
org.apache.jasper.compiler.Parser.parseElements(Parser.java:1597)
org.apache.jasper.compiler.Parser.parse(Parser.java:171)
org.apache.jasper.compiler.ParserController.parse(ParserController.java:247)
org.apache.jasper.compiler.ParserController.parse(ParserController.java:149)
org.apache.jasper.compiler.ParserController.parse(ParserController.java:135)
org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:237)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:456)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:552)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:291)
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)
note The full stack trace of the root cause is available in the Tomcat logs.
--------------------------------------------------------------------------------我使用以下的SQL SERVER FOR JDBC
http://www.microsoft.com/china/sql/downloads/jdbc_sp1.asp
将LIB中的三个文件复制到
C:\Tomcat 5.0\common\lib,C:\Tomcat 5.0\webapps\DBTest\WEB-INF\lib下
并且在classpath=C:\Tomcat 5.0\common\lib\指向三个JAR文件,问题依然如此,是什么原因呢
分已经给完:
地址
http://community.csdn.net/Expert/topic/3376/3376979.xml?temp=.7532465 50分
http://community.csdn.net/Expert/topic/3373/3373518.xml?temp=.750683 20分
http://community.csdn.net/Expert/topic/3169/3169179.xml?temp=.6558344 30分
package popdomConnDB;
import java.sql.*;
import javax.sql.*;
import javax.naming.*;
import javax.naming.InitialContext;
import javax.sql.DataSource;/**
* <p>Title: </p>
* <p>Description: </p>
* <p>Copyright: Copyright (c) 2004</p>
* <p>Company: </p>
* @author not attributable
* @version 1.0
*/
//一个用于查找数据源的工具类。
public class ConnDB {
private Connection con=null;
private Statement stmt=null;
ResultSet rs=null;public ResultSet executequery(String sql) throws Exception
{
rs=null;
try
{
Context initCtx = new javax.naming.InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource)envCtx.lookup("jdbc/TestDB");
con=ds.getConnection();
stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery (sql);
}
catch(SQLException e){throw e;}
catch(NamingException e){throw e;}
return rs;
}
//执行Insert,Update语句
public int executeUpdate(String sql) throws Exception
{
stmt = null;
rs=null;
int Result =0;
try
{
Context initCtx = new javax.naming.InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource)envCtx.lookup("jdbc/TestDB");//jdbc/TestDB
con=ds.getConnection();
stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
Result = stmt.executeUpdate(sql);
stmt.close();
con.close();
}
catch(SQLException ex)
{
System.err.println("执行SQL语句出错: " + ex.getMessage());
}
return Result;
}// 关闭stmt和关闭连接
public void close_all()
{
try{
stmt.close();
con.close();
}
catch(SQLException e){e.printStackTrace();}
}
}随便一个jsp(举一个没有JDBC操作的)go.jsp
<%@ page contentType="text/html; charset=GBK" %>
<%@ page language="java" import="java.sql.*" %>
<html>
<head>
<title>
系统登陆
</title>
</head>
<body bgcolor="#ffffff">
<jsp:forward page="login.htm">
</jsp:forward>
</body>
</html>结果,无论里面是否有SQL查询操作,都出现当运行
http://localhost:8080/DBTest/login.htm时候是可以的,我还测试其他的HTM也完全正确,但是一遇到是JSP,包括上面的GO。JSP还是CHECKLOGIN。JSP同样出现以下报错信息
HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: /chklogin.jsp(49,2) Expected "param" tag with "name" and "value" attributes
org.apache.jasper.compiler.DefaultErrorHandler.jspError(DefaultErrorHandler.java:83)
org.apache.jasper.compiler.ErrorDispatcher.dispatch(ErrorDispatcher.java:402)
org.apache.jasper.compiler.ErrorDispatcher.jspError(ErrorDispatcher.java:126)
org.apache.jasper.compiler.Parser.parseParam(Parser.java:892)
org.apache.jasper.compiler.Parser.parseBody(Parser.java:1838)
org.apache.jasper.compiler.Parser.parseOptionalBody(Parser.java:1100)
org.apache.jasper.compiler.Parser.parseForward(Parser.java:942)
org.apache.jasper.compiler.Parser.parseStandardAction(Parser.java:1253)
org.apache.jasper.compiler.Parser.parseElements(Parser.java:1597)
org.apache.jasper.compiler.Parser.parse(Parser.java:171)
org.apache.jasper.compiler.ParserController.parse(ParserController.java:247)
org.apache.jasper.compiler.ParserController.parse(ParserController.java:149)
org.apache.jasper.compiler.ParserController.parse(ParserController.java:135)
org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:237)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:456)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:552)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:291)
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)
note The full stack trace of the root cause is available in the Tomcat logs.
--------------------------------------------------------------------------------我使用以下的SQL SERVER FOR JDBC
http://www.microsoft.com/china/sql/downloads/jdbc_sp1.asp
将LIB中的三个文件复制到
C:\Tomcat 5.0\common\lib,C:\Tomcat 5.0\webapps\DBTest\WEB-INF\lib下
并且在classpath=C:\Tomcat 5.0\common\lib\指向三个JAR文件,问题依然如此,是什么原因呢
分已经给完:
地址
http://community.csdn.net/Expert/topic/3376/3376979.xml?temp=.7532465 50分
http://community.csdn.net/Expert/topic/3373/3373518.xml?temp=.750683 20分
http://community.csdn.net/Expert/topic/3169/3169179.xml?temp=.6558344 30分
解决方案 »
- 企业应用级问题:JUNIT在使用时如何使用同一个类,运行不同的TESTCASE,但是又能从junit report中看出运行了哪些testcase
- 想用jdbc中实现悲观锁,请达人进来指点一下,项目需要!谢谢!具体流程见文章内容的说明
- java 基于 sip rtp协议的实时 服务器框架
- Tomcat 5.5 启动后,manager/html 访问问题。
- 关于Java语法的问题
- 做struts的HelloWorld还是有问题!愁!!!
- jboss连接mysql出现的问题
- 关于petstore的问题
- 怎么通过jdbc连接db2/400数据库 ???
- hibernate查询非常慢
- 统计一下有多少人在项目中用ejb,up有分
- 请教各位大侠关于使用RMI中出现的错误:java.rmi.ConnectException: Connection refused to host: 127.0.0.1; nested exception
<Context path="/DBTest" docBase="E:\important\qxgl\popdomWeb" debug="0" reloadable="true" crossContext="true"/>
在最后加一个/
呵呵,我遇到过这样的问题,给分吧,等着接分那
还有,记得把JAVABEAN的包文件放到对应的目录下
经过 你的建议,我改动后发现TOMCAT启动的时候出现一大堆错误,最后无法启动!当去掉你那一个/就可以正常启动了所以分暂时不能给你,现在问题达到200分了,希望你能接受挑战!!