javax.servlet.ServletException: No ResultSet was produced
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>");
}
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>");
}
...全文
相关推荐
mysql-connector-net-6.9.9.msi 官方下载原版
mysql-connector-net 可用于连接visual studio 2015 配合mysql-for-visualstudio-1.2.6.msi使用
mysql-connector-net-6.9.9.msi 官网原版
官网下载的原版 mysql-connector-net-6.9.9.msi .NET Connector 工具 连接MYSQL
mysql-connector-net-6.9.11 安装文件MSI
mysql-connector-net-6.9.11 安装文件MSI文件,EF6+mysql必备
mysql-connector-net-6.9.9.msi,mysql-connector-net-7.0.5.msi,***-8.0.13.msi
压缩包中包含三个文件,都是官方原版,分别是mysql-connector-net-6.9.9.msi,mysql-connector-net-7.0.5.msi,mysql-connector-net-8.0.13.msi,目前官网只能下载最新版,这里整理收集了这三个版本,提供与mysql的数据库连接文件。
mysql-connector-net-6.9.9.msi
用于.net运用EF开发mysql时的连接mysql的插件,版本6.99从官方网站上下载的。是msi安装文件。


Web 开发
