问题遇到的现象和发生背景
写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>