当前位置: 代码迷 >> Java Web开发 >> [Microsoft][SQLServer 2000 Driver for JDBC]No ResultSet set was produced.多谢
  详细解决方案

[Microsoft][SQLServer 2000 Driver for JDBC]No ResultSet set was produced.多谢

热度:6037   发布时间:2013-02-25 21:11:42.0
[Microsoft][SQLServer 2000 Driver for JDBC]No ResultSet set was produced.谢谢
Java code
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%><%@include file="dbsconn.jsp"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html>  <head>    <base href="<%=basePath%>">        <title>My JSP 'Exit.jsp' starting page</title>        <meta http-equiv="pragma" content="no-cache">    <meta http-equiv="cache-control" content="no-cache">    <meta http-equiv="expires" content="0">        <meta http-equiv="keywords" content="keyword1,keyword2,keyword3">    <meta http-equiv="description" content="This is my page">    <META name=VI60_defaultClientScript content=VBScript>    <META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">    <!--    <link rel="stylesheet" type="text/css" href="styles.css">    --><%//ID=clientEventHandlersVBS %><SCRIPT  LANGUAGE=vbscript>Sub window_onload    call settimeout("exitWin",1000,"VBScript")End SubSub exitWin     top.location.href="login.jsp"End Sub</SCRIPT>  </head>  <%    Statement st;    String sql="insert into UserOpert(UserName,Operation,grade) Values('" +session.getAttribute("UserName") + "','退出系统','" + session.getAttribute("grade") + "')";    st=conn.createStatement();    ResultSet rs=st.executeQuery(sql);    while(rs.next())    {    //WriteLogDB("退出系统");    session.setAttribute("UserPrivate","");    session.setAttribute("UserId","");    session.setAttribute("grade","");    session.setAttribute("BranchID","");    session.setAttribute("NodeID","");    }     rs.close();    st.close();    conn.close();   %>  <body>  </body></html>


------解决方案--------------------------------------------------------
insert 语句 怎么用 executeQuery 执行查询呢

直接 st.execute(); 返回值是boolean
  相关解决方案