使用Stringbuffer 类型存储表格,然后存入bean ,最后用getProperty获取属性在jsp页面 却显示不出来??????为啥

zyckhuntoria 2018-04-15 04:40:56
//登录输入账号密码
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="servlet.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="Check" method="post">
账户:<input name="act" id="act" type="text" />
密码 :<input name="pw" id="pw" type="text" />
<br>
<button type="submit">提交</button>
<button type="reset">重置</button>
</form>

</body>
</html>


跳转到servlet
package servlet;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.*;
import org.apache.jasper.tagplugins.jstl.core.Out;

import bean.*;
import database.*;

/**
* Servlet implementation class Check
*/
public class Check extends HttpServlet {
private static final long serialVersionUID = 1L;

/**
* @see HttpServlet#HttpServlet()
*/
public Check() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see Servlet#init(ServletConfig)
*/
public void init(ServletConfig config) throws ServletException {
// TODO Auto-generated method stub
}

/**
* @see Servlet#destroy()
*/
public void destroy() {
// TODO Auto-generated method stub
}

/**
* @see HttpServlet#service(HttpServletRequest request, HttpServletResponse response)
*/
/*
protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub

}
*/
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
}

/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//设置服务器响应编码
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html;charset=utf-8");
response.setCharacterEncoding("UTF-8");

PrintWriter out1=response.getWriter();
PrintWriter out2=response.getWriter();
PrintWriter out3=response.getWriter();

//创建session 对象
HttpSession session=request.getSession();

//创建teacher 对象
Teacher t=new Teacher();

//act\pw的值为用户在act栏中输入的值
String act=request.getParameter("act");
String pw=request.getParameter("pw");
//将这个值放在bean里面
t.setAct(act);
t.setPw(pw);

//调用数据库 看是否用户名和密码匹配
Check1 ch=new Check1();
if(ch.login(t))
{
//存储名字到实体中去
String name=ch.getName(t);
t.setName(name);
// 存储查询结果集到实体中
StringBuffer result=ch.showClassimfoo(t);
t.setResult(result);
//存储课时到实体中
StringBuffer test=ch.getTest(t);

// PrintWriter out=response.getWriter();
//存储查询表格结果集到实体中
StringBuffer table=ch.getTable(t);
t.setResult(table);

out1.println(result);
out2.println(test);
out3.println(table);
session.setAttribute("t",t);
request.getRequestDispatcher("gerenzhongxin.jsp").forward(request, response); //跳转到个人中心页面
}
else
response.sendRedirect("login.jsp");
}
}

//out.println("<html><head></head><body>");
//out.print(result+",");
//out.print(test+",");
//out.print(name+",");
//out.print(table+",");
//out.print("</body></html>");



其中调用了check1中的方法
package database;
import java.sql.*;
import bean.Teacher;
import database.Databasebean;
public class Check1 {
public boolean login(Teacher t){
boolean b=false;
//创建链接数据库的对象
Connection con=Databasebean.getCon();
PreparedStatement ps=null;
ResultSet rs=null;
try{

ps=con.prepareStatement("select * from timfo where act=? and pw=?");
//执行查询
ps.setString(1,t.getAct());//第一个问号的值是u.getId() //这中的t不是session传过来的,而是调用ch.login(t)方法作为形参传过来的
ps.setString(2,t.getPw());//第二个问好的值是u.getpwd()
rs=ps.executeQuery();
if(rs.next())
{
b=true;
}
}
catch(SQLException e){
e.printStackTrace();
}finally{
Databasebean.close(ps);
Databasebean.close(con);
Databasebean.close(rs);
}
return b;
}


public String getName(Teacher t){
String name = null;
//创建链接数据库的对象
Connection con=Databasebean.getCon();
PreparedStatement ps=null;
ResultSet rs=null;
try{

ps=con.prepareStatement("select name from timfo where act=? ");
//执行查询
ps.setString(1,t.getAct());//第一个问号的值是u.getId() //这中的t不是session传过来的,而是调用ch.login(t)方法作为形参传过来的
rs=ps.executeQuery();
if(rs.next())
{
name=rs.getString(1);
}
}
catch(SQLException e){
e.printStackTrace();
}finally{
Databasebean.close(ps);
Databasebean.close(con);
Databasebean.close(rs);
}
return name;
}

public StringBuffer showClassimfoo(Teacher t){

//创建链接数据库的对象
Connection con=Databasebean.getCon();
PreparedStatement ps=null;
ResultSet rs=null;
StringBuffer str=new StringBuffer();
try{
ps=con.prepareStatement("select * from classimfoo where act=?");
//执行查询
ps.setString(1,t.getAct());
rs=ps.executeQuery();
str.append("<table border=1 >");
str.append("<tr>");
str.append("<th>视频名称</th>");
str.append("<th>视频课时</th>");
str.append("<th>作者</th>");
str.append("</tr>");
while(rs.next())
{
str.append("<tr>");
str.append("<td>"+rs.getString(2)+"</td>");
str.append("<td>"+rs.getString(4)+"</td>");
str.append("<td>"+rs.getString(5)+"</td>");
str.append("</tr>");
}
str.append("</table>");
}
catch(SQLException e){
e.printStackTrace();
}finally{
Databasebean.close(ps);
Databasebean.close(con);
Databasebean.close(rs);
}
return str;
}


public StringBuffer getTest(Teacher t){
//创建链接数据库的对象
Connection con=Databasebean.getCon();
PreparedStatement ps=null;
ResultSet rs=null;
StringBuffer str=new StringBuffer();
try{
ps=con.prepareStatement("select keshi from classimfoo where act=?");
//执行查询
ps.setString(1,t.getAct());
rs=ps.executeQuery();
str.append("<table border=1 >"+"<th>视频课时</th>"+"</tr>");
while(rs.next())
{
str.append("<tr>");
str.append("<td>"+rs.getString(1)+"</td>");
str.append("</tr>");
}
str.append("</table>");

}
catch(SQLException e){
e.printStackTrace();
}finally{
Databasebean.close(ps);
Databasebean.close(con);
Databasebean.close(rs);
}

return str;
}


public StringBuffer getTable(Teacher t){
//创建链接数据库的对象
Connection con=Databasebean.getCon();
PreparedStatement ps=null;
ResultSet rs=null;
StringBuffer str=new StringBuffer();
try{
ps=con.prepareStatement("select * from testimfo where act=?");
//执行查询
ps.setString(1,t.getAct());
rs=ps.executeQuery();
str.append("<table border=1 >"+"<tr>"+"<th>作者</th>"+"<th>账号</th>"+"<th>密码</th>"+"</tr>");
while(rs.next())
{
str.append("<tr>");
str.append("<td>"+rs.getString(1)+"</td>");
str.append("<td>"+rs.getString(2)+"</td>");
str.append("<td>"+rs.getString(3)+"</td>");
str.append("</tr>");
}
str.append("</table>");

}
catch(SQLException e){
e.printStackTrace();
}finally{
Databasebean.close(ps);
Databasebean.close(con);
Databasebean.close(rs);
}

return str;
}
}







gerenzhongxin.jsp的代码是
<%@ page language="java" contentType="text/html; charset=GB2312"
pageEncoding="GB2312"%>
<%@ page import="bean.Teacher" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title></title>
</head>
<body>
<jsp:useBean id="t" type="bean.Teacher" scope="session">
</jsp:useBean>
<jsp:getProperty property="name" name="t" />
<jsp:getProperty property="keshi" name="t" />
的个人中心显示全部课程管理页面
5555
<jsp:getProperty property="table" name="t" />


<a href="initiate.jsp">发布课程</a>
<br>
<a href="#">上传课程作业、上传考试内容、</a>
<a href="#">讨论区问题答疑</a>
<table border="1" >
<tr>
<td width="300">视频信息</td>
<td width="70">课时 </td>
<td width="70">来源</td>
<td width="70">状态</td>
<td width="70">操作</td>
</tr>

<tr>
<td width="300">视频信息 </td>
<td width="70">课时 </td>
<td width="70">来源</td>
<td width="70">状态</td>
<td width="70">操作</td>
</tr>

<tr>
<td width="300">视频信息 </td>
<td width="70">课时 </td>
<td width="70">来源</td>
<td width="70">状态</td>
<td width="70">操作</td>
</tr>

<tr>
<td width="300">视频信息 </td>
<td width="70">课时 </td>
<td width="70">来源</td>
<td width="70">状态</td>
<td width="70">操作</td>
</tr>

<tr>
<td width="300">视频信息 </td>
<td width="70">课时 </td>
<td width="70">来源</td>
<td width="70">状态</td>
<td width="70">操作</td>
</tr>
</table>

</body>
</html>



最后在gerenzhongxin,jsp页面显示的只是出来名字,没有出现表格
为什么??????????


...全文
1064 2 打赏 收藏 转发到动态 举报
写回复
用AI写文章
2 条回复
切换为时间正序
请发表友善的回复…
发表回复
zyckhuntoria 2018-04-15
  • 打赏
  • 举报
回复
zyckhuntoria 2018-04-15
  • 打赏
  • 举报
回复
显示结果如上图,什么也显示不出来

87,923

社区成员

发帖
与我相关
我的任务
社区描述
Web 开发 JavaScript
社区管理员
  • JavaScript
  • 无·法
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧