总显示数组越界 但是感觉并没有啊
JSP文件（1）
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<html>
<body bgcolor = cyan>
<font size = 2>
<form action = "mhq" method = post>
查询bookdb数据库stu表：
<br>输入ID：<input type = text name = "user" value = "book">
<br>输入密码：<input type = text name = "password" value = "book123">
<br><input type = submit value = "提交">
<input type = reset value = "重置">
</form>
</font>
</body>
</html>
JSP文件（2）
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<jsp:useBean id="mhq" type = "mybean.Hellomhq" scope = "request"/>
<%@ page import = "java.sql.*"%>
<html>
<body bgcolor=cyan>
<table border = 1>
<% String []columnName = mhq.getColumnName(); %>
<tr>
<%for(String s:columnName){
%><th><%= s%></th>
<%
}%>
</tr>
<%
String [][]record = mhq.getTableRecord();
for(int i = 0;i<record.length;i++){
%>
<tr>
<%
for(int j = 0;j<record[i].length;j++){
%>
<td><%= record[i][j]%></td> <%
}
%></tr><%
}
%>
</table>
</body>
</html>
bean 文件：
package mybean ;
public class Hellomhq{
String []columnName;
String [][]tableRecord = null;
public Hellomhq(){
tableRecord = new String[20][20];
columnName = new String[20];
}
public void setTableRecord(String [][]s){
tableRecord = s;
}
public String [][]getTableRecord(){
return tableRecord;
}
public void setColumnName(String []s){
columnName = s;
}
public String []getColumnName(){
return columnName;
}
}
servlet文件：
package myservlet.mmm;
import mybean.Hellomhq;
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class HHH extends HttpServlet {
public void init(ServletConfig config) throws ServletException{
super.init(config);
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doPost(request,response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
Hellomhq mhq = null;
try{
mhq = (Hellomhq)request.getAttribute("mhq");
if(mhq==null){
mhq = new Hellomhq();
request.setAttribute("mhq", mhq);
}
}
catch(Exception e){
mhq = new Hellomhq();
request.setAttribute("mhq", mhq);
}
try{
Class.forName("com.mysql.jdbc.Driver");
}
catch(Exception e){};
String user = request.getParameter("user");
String password = request.getParameter("password");
Connection con;
Statement sql;
ResultSet rs;
try{
String uri = "jdbc:mysql://10.8.131.13/bookdb";
con = DriverManager.getConnection(uri,user,password);
sql = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
String condition = "select * from stu ";
rs = sql.executeQuery(condition);
ResultSetMetaData metadata = rs.getMetaData();
int columncount = metadata.getColumnCount();
String []columnName = new String[columncount];
for(int i = 0;i<columnName.length;i++){
columnName[i] = metadata.getColumnName(i+1);
}
mhq.setColumnName(columnName);
rs.last();
int rowNumber = rs.getRow();
String [][]tableRecord = mhq.getTableRecord();
tableRecord = new String[rowNumber][columncount];
rs.beforeFirst();
int i = 0;
while(rs.next()){
for(int k = 0;k<columncount;k++){
tableRecord[i][k] = rs.getString(k+1);
i++;
}
}
mhq.setTableRecord(tableRecord);
con.close();
RequestDispatcher aa = request.getRequestDispatcher("mhq1.jsp");
aa.forward(request, response);
}
catch(Exception ee){
System.out.println(ee);
}
}
}
web.xml文件：
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1">
<servlet>
<servlet-name>mhq</servlet-name>
<servlet-class>myservlet.mmm.HHH</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>mhq</servlet-name>
<url-pattern>/mhq</url-pattern>
</servlet-mapping>
</web-app>
qq_白水_043412771回答
-
ai睡的熊
你最起码把报错位置说一下啊
随时随地看视频慕课网APP
相关分类
JavaScript
SQL Server