javax.servlet.ServletException: No ResultSet was produced

linuxguoyy linuxguoyy 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
Error: 500
Location: /cjy/user_manage/insert_user.jsp
Internal Servlet Error:

javax.servlet.ServletException: No ResultSet was produced
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:386)
at cjy.user_0005fmanage._0002fcjy_0002fuser_0005fmanage_0002finsert_0005fuser_0002ejspinsert_0005fuser_jsp_9._jspService(_0002fcjy_0002fuser_0005fmanage_0002finsert_0005fuser_0002ejspinsert_0005fuser_jsp_9.java:121)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:126)

-------------------------------------------------------
<%@page import="java.sql.*" %>
<%@include file="../inc/header.jsp"%>
<%
//String jgbm=new String();
String yhid=new String();
String yhmm=new String();
String yhxm=new String();
String jsdm=new String();
String yhzt;
//out.print(session.getAttribute("JGBM"));
String jgbm=(String)session.getAttribute("JGBM");//"44444:";
yhid=request.getParameter("yhid");
yhmm=request.getParameter("yhmm");
yhxm=request.getParameter("yhxm");
jsdm=request.getParameter("jsdm");
yhzt="1";

String SQL;
String sql1;
SQL="select * from tCJ_YHXX where YHID='"+yhid+"'";
Statement stmt6=con.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
ResultSet rs=stmt6.executeQuery(SQL);
if(!rs.next()){
sql1="insert into tCJ_YHXX values('"+yhid+"','"+yhmm+"','"+yhxm+"','"+jgbm+"','"+jsdm+"','"+yhzt+"')";
stmt6.executeQuery(sql1);
try{
ResultSet rs3=stmt6.executeQuery(sql1);}
catch(Exception e){
System.err.println("aq.executeQuery: " + e.getMessage());
}
response.sendRedirect("local_admin.jsp");
}
else{
out.print("<center><input type='button' onclick='history.back();' value='此用户ID已经存在,返回修改'></center>");
}


...全文
评论 2
收藏 已收藏
分享
返回顶部
linuxguoyy
Web 开发 81,108 成员 341,721 内容