finally {
scm.release(null, stmt, con);
}
scm.release(null, stmt, con);
}
解决方案 »
- 新手弱问题,jsp 连接sqlserver2008 语句databaseName="***"有错误是怎么回事?
- 请教:EJB中createNativeQuery(sql)对于char类型字段的处理
- s2sh+jxl/poi
- hibernate 缓存问题 有能人帮我不?
- 请问如何从KeyStore中获取证书链
- 关于JSP乱吗提问
- 有关struts的问题,请各位给看看
- 请教一个关于cookie的问题
- 为什么拔掉网线时,用jbuilder4 run jsp 会报错???
- jquery easyui datagrid 如何批量添加???
- 一个简单的document.getelementsbyname问题,在线等!谢谢
- 请教支持包含applet的网页的web server必须要支持servlet吗?
finally {
if (stmt != null)
stmt = null;
if (con != null)
con = null;
}
要关闭的
finally {
if (stmt != null)
stmt = null;
if (con != null)
con = null;
}
我刚才放到我的代码里面,他出错500 Servlet Exception
Note: sun.tools.javac.Main has been deprecated.
C:\resin-2.1.14\doc\bbs\re.jsp:20: 'finally' without 'try'.
finally {
^
1 error, 1 warning--------------------------------------------------------------------------------
Resin 2.1.14 (built Thu Jul 1 18:39:55 PDT 2004) 代码如下:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*"%>
<%@ include file="../inc/check.jsp" %>
<jsp:useBean id="scm" scope="page" class="scm.jdbc"/>
<%
Connection con=scm.getConn();
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sqlStr="select * from re"; String id = request.getParameter("id");
String textfield = request.getParameter("textfield");
String textarea = request.getParameter("textarea");
String reip = request.getRemoteAddr();//获取IP
String sql="INSERT INTO RE VALUES (seq_name.nextval,'"+scm.ex_chinese(textfield)+"',sysdate,"+id+",'"+reip+"','"+scm.ex_chinese(textarea)+"')";
stmt.executeUpdate(sql);
String sqlbody="update body set lasttime=sysdate where id ="+id;
stmt.executeUpdate(sqlbody);
stmt.executeUpdate(sqllog);
finally {
if (stmt != null)
stmt = null;
if (con != null)
con = null;
}
response.sendRedirect("body.jsp?id="+id);
%>
没有try-catch那里来的finally,这个可是基本的JAVA语法,楼主不会连这个都不知道吧,赶快去恶补吧:)
// Decompiled by Jad v1.5.7g. Copyright 2000 Pavel Kouznetsov.
// Jad home page: http://www.geocities.com/SiliconValley/Bridge/8617/jad.html
// Decompiler options: packimports(3) fieldsfirst ansi
// Source File Name: jdbc.javapackage scm;import java.io.PrintStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
import oracle.jdbc.driver.OracleDriver;public class jdbc
{ Connection conn; public jdbc()
{
conn = null;
} public Connection getConn()
{
try
{
DriverManager.registerDriver(new OracleDriver());
String s = "java:oracle:thin:@192.168.120.116:1521:china";
conn = DriverManager.getConnection(s, "system", "manager");
}
catch(Exception exception)
{
exception.printStackTrace();
System.out.println("msroom");
}
return conn;
} }大家帮忙看看,应该怎么修改和调用