怎么解决jsp网页无法输出结果 Statement.executeQuery() cannot issue statements that do not produce result sets.

Question

问题遇到的现象和发生背景

写jsp学生信息查询的网页报错出不了结果
java.sql.SQLException: Statement.executeQuery() cannot issue statements that do not produce result sets.

问题相关代码，请勿粘贴截图

<%@ page language="java" contentType="text/html;charset=utf-8" import="java.sql.*"%>

<title>学生信息管理系统</title>

<table width="800px"  border="0" align="center">
      <tr height="100" bgcolor="#D9D816" align="center"> 
    <td  colspan="2"  ><h1>学生信息管理系统</h1></td>
  </tr>
  
      
  <tr> 
    <td width="20%" height="380" bgcolor="#C7C6C6"  valign="top">
    <font color="#60579A" size="+1">
    <h3>学生信息</h3>
    <A href="../ex3/StuAddIpt.jsp">信息新增 </A><br>
    <A href="../ex3/StuQryIpt.jsp">信息查询 </A><br>
    <A href="../ex3/StuQryIpt.jsp">信息修改 </A><br>
    <A href="../ex3/StuQryIpt.jsp">信息删除 </A><br>
    
    </td>
    
            
    <td width="81%" bgcolor="#F5E2E2" align="center"   valign="top"  >
    <font color="#000000" >              
    
        <h2 >学生信息查询列表</h2>
      
    <table width="460" border="1" cellspacing="0" bgcolor="#BCE1EF">

    <tr>
        <th>学号</th>
        <th>姓名</th>
        <th>性别</th>
        <th>年龄</th>
        <th>院系</th>
            
      </tr>
        <%
        String strStuID="";
        String strStuName="";
        String strSex="";
        String strAge="";
        String strDept="";
        
        
        strStuID = request.getParameter("txtStuID");
        strStuName = request.getParameter("txtStuName");
        strSex = request.getParameter("rdoSex");
        strAge = request.getParameter("slctAge");
        strDept = request.getParameter("slctDept");
        
        
        String url,sql; 
        Connection conn;
        Statement stmt;
        ResultSet rs;
        
        sql = "select * from baseinfo";

        if( request.getParameter("txtStuID") != null  && !(request.getParameter("txtStuID")).trim().equals("") )
        {
         strStuID = request.getParameter("txtStuID");
         sql = sql + " where sid = '" + strStuID + "'";
    
        }

        try{
            
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            
            url ="jdbc:mysql://localhost:3306/student?serverTimezone=GMT%2B8";      

            conn=DriverManager.getConnection(url,"root","123456");      
            
            stmt=conn.createStatement();

            sql="insert into baseinfo(sid,sname,ssex,sage,sdept) values('"+strStuID+"','"+strStuName+"','"+strSex+"','"+strAge+"','"+strDept+"')";
            
            rs = stmt.executeQuery(sql);
            
            
            System.out.println(sql);
            
            while(rs.next()){
            %>
                
                <tr>
                <td><a href="StuDetailOpt.jsp?txtStuID=<%=rs.getString("sid")%>"> <%=rs.getString("sid")%> </a></td>
                <td><%=rs.getString("strStuName")%> </td>
                <td><%=rs.getString("strDept")%> </td>
                <td><a href="StuModifyIpt.jsp?txtStuID=<%=rs.getString("sid")%>"> 修改 </a></td>
                <td><a href="StuDetailOpt.jsp?txtStuID=<%=rs.getString("sid")%>"> 删除 </a></td>        
                    
                </tr>
                
            <%
            }
            
            rs.close();            
            stmt.close();
            conn.close();
        }
          catch(Exception e){
            out.println(e);            
        }

        
        %>
        

</body>

运行结果及报错内容

我的解答思路和尝试过的方法

我想要达到的结果

Answer 1

您的sql语句为写入语句，不会返回result set， 除非是获取语句，所以第80行是不会有next方法的