<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@page import="java.util.*,org.spring.dao.factory.DaoFactory"%>
<%@page import="com.web.dao.*"%>
<%@page import="com.web.deal.*"%>
<%@page import="com.web.manager.*"%>
<%@page import="com.web.defince.*,org.spring.jdbc.core.DateAccessException" %>
<jsp:useBean id="content" scope="page" class="com.web.defince.content" />
<jsp:useBean id="myUpload" scope="page" class="xiaoxiang.fileUpload.upBean" />
<jsp:setProperty name="content" property="*" /><head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head><body>
<%
String jdid=myUpload.getRequest().getParameter("jdid");String sql="DELETE FROM content WHERE (jdid ="+jdid+")"; try {
stmt.executeUpdate(sql);
out.print("<script>alert('删除成功');window.location='AppraisalData2.jsp';</script>");
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
out.print("<script>alert('删除失败');</script>");
}
%>
</body>
</html>
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 17 in the jsp file: /appraisal/save.jsp
Generated servlet error:
C:\Tomcat 5.0\work\Catalina\localhost\Tbr\org\apache\jsp\appraisal\save_jsp.java:113: cannot resolve symbol
symbol : variable stmt
location: class org.apache.jsp.appraisal.save_jsp
stmt.executeUpdate(sql);
^
1 error org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:332)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:437)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:497)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:476)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:464)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.jdon.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:48)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.30 logs.
--------------------------------------------------------------------------------Apache Tomcat/5.0.30这个错误要怎么改呀???
<%@page import="java.util.*,org.spring.dao.factory.DaoFactory"%>
<%@page import="com.web.dao.*"%>
<%@page import="com.web.deal.*"%>
<%@page import="com.web.manager.*"%>
<%@page import="com.web.defince.*,org.spring.jdbc.core.DateAccessException" %>
<jsp:useBean id="content" scope="page" class="com.web.defince.content" />
<jsp:useBean id="myUpload" scope="page" class="xiaoxiang.fileUpload.upBean" />
<jsp:setProperty name="content" property="*" /><head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head><body>
<%
String jdid=myUpload.getRequest().getParameter("jdid");String sql="DELETE FROM content WHERE (jdid ="+jdid+")"; try {
stmt.executeUpdate(sql);
out.print("<script>alert('删除成功');window.location='AppraisalData2.jsp';</script>");
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
out.print("<script>alert('删除失败');</script>");
}
%>
</body>
</html>
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Unable to compile class for JSPAn error occurred at line: 17 in the jsp file: /appraisal/save.jsp
Generated servlet error:
C:\Tomcat 5.0\work\Catalina\localhost\Tbr\org\apache\jsp\appraisal\save_jsp.java:113: cannot resolve symbol
symbol : variable stmt
location: class org.apache.jsp.appraisal.save_jsp
stmt.executeUpdate(sql);
^
1 error org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:332)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:437)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:497)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:476)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:464)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.jdon.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:48)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.30 logs.
--------------------------------------------------------------------------------Apache Tomcat/5.0.30这个错误要怎么改呀???
location: class org.apache.jsp.appraisal.save_jsp stmt.executeUpdate(sql);
不能解决的标识符 变量名:stmt
本地位置:类org.apache.jsp.appraisal.save_jsp中的stmt.executeUpdate(sql);
dbconn = DbOperation.getConnection();//获得库连接
stmt = dbconn.createStatement(1004, 1007);
stmt.executeUpdate(sql);
stmt=conn.createStatement();
Generated servlet error:
C:\Tomcat 5.0\work\Catalina\localhost\Tbr\org\apache\jsp\appraisal\save_jsp.java:136: sql is already defined in _jspService(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse)
String sql="DELETE FROM content WHERE (jdid ="+jdid+")";
^
1 error org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:332)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:437)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:497)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:476)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:464)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.jdon.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:48)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.30 logs.
--------------------------------------------------------------------------------Apache Tomcat/5.0.30我定义好了,可是又报新的错误,这个是又是什么丫?
到save_jsp.java:136 到136行看看
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:846)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.appraisal.save_jsp._jspService(save_jsp.java:179)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.jdon.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:48)
root cause java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Error establishing socket.
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(DriverManager.java:512)
java.sql.DriverManager.getConnection(DriverManager.java:171)
org.apache.jsp.appraisal.save_jsp._jspService(save_jsp.java:72)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.jdon.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:48)
note The full stack trace of the root cause is available in the Apache Tomcat/5.0.30 logs.
--------------------------------------------------------------------------------Apache Tomcat/5.0.30
改成
String sql="DELETE FROM content WHERE (jdid ='"+jdid+"')";
[Microsoft][SQLServer JDBC Driver]Error establishing socket.
连接不上SQL Server。可能你写错地址,可能是你SQL Server安装时没有选择混合验证方式,所以没有启用1433端口
这条语句有问题
应该改为String sql="DELETE FROM content WHERE (jdid ='"+jdid+"')";