jsp问题:HTTP Status 500 - Can't find a method to write property 'tableName' of typ
jsp:
<%@ page language="java" contentType="text/html; charset=GBK" pageEncoding="GBK"%>
<%@ page import="毕业设计管理子系统.query" %>
<jsp:useBean id="look" class="毕业设计管理子系统.query" scope="request"/>
<jsp:setProperty name="look" property="databaseName" value="Test"/>
<jsp:setProperty name="look" property="tableName" value="teacher"/>
<jsp:setProperty name="look" property="user" value="sa"/>
<jsp:setProperty name="look" property="secret" value="123456"/>
<html>
<head>
<title>Insert title here</title>
</head>
<body>
<a href="renew.jsp">更新操作</a>
<a href="add.jsp">添加操作</a>
<a href="delete.jsp">
删除操作</a>
<p>数据库当前的数据是:
<jsp:getProperty property="queryResult" name="look"/>
</body>
</html>
query.java:
package 毕业设计管理子系统;
import java.sql.*;
public class query {
String databaseName = "";
String tableName = "";
String user = "";
String secret = "";
StringBuffer queryResult;
public query() {
queryResult = new StringBuffer();
try {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
} catch (Exception e) {
queryResult = new StringBuffer();
queryResult.append("" + e);
}
}
public void setDatabaseName(String s) {
databaseName = s.trim();
}
public String getDatabaseName() {
return databaseName;
}
public void setTableName(String s) {
tableName = s.trim();
}
public String getTableName() {
return tableName;
}
public void setSecret(String s) {
secret = s.trim();
}
public String getSecret() {
return secret;
}
public void setUser(String s) {
user = s.trim();
}
public String getUser() {
return user;
}
public StringBuffer getQueryResult() {
Connection con;
Statement sql;
ResultSet rs;
try {
queryResult.append("<table border=1>");
String uri = "jdbc:sqlserver://localhost:1433; DatabaseName=" + databaseName;
String id = user;
String password = secret;
con = DriverManager.getConnection(uri, id, password);
DatabaseMetaData metadata = con.getMetaData();
ResultSet rs1 = metadata.getColumns(null, null, tableName, null);
int 字体个数 = 0;
queryResult.append("<tr>");
while (rs1.next()) {
字体个数++;
String clumnName = rs1.getString(4);
queryResult.append("<td>" + clumnName + "</td>");
}
queryResult.append("</tr>");
sql = con.createStatement();
rs = sql.executeQuery("SELECT * FROM" + tableName);
while (rs.next()) {
queryResult.append("<tr>");
for (int k = 1; k <= 字体个数; k++) {
queryResult.append("<td>" + rs.getString(k) + "<td>");
}
queryResult.append("</tr>");
}
queryResult.append("</table>");
con.close();
} catch (SQLException e) {
queryResult.append(e);
}
return queryResult;
}
}