(新手)ssh中数据库中的值显示不出在jsp页面

摸鱼飞弹 2018-07-14 10:00:28
改了好久,但是jsp页面还是显示不出来数据库里面的值。

这是jsp页面代码
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@taglib uri="/struts-tags" prefix="s"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">

<title>My JSP 'index.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>

<body bgcolor="#D9DFAA">
<table border="1" cellspacing="1" cellpadding="8" width="700">
<tr align="center" bgcolor="silver" >
<th>用户</th><th>密码</th>
</tr>
<s:iterator value="#request.list" id="dl">
<tr>
<td><s:property value="username"/></td>
<td><s:property value="passwrod"/></td>
</tr>
</s:iterator>

</table>
</body>
</html>

action类代码
package com.action;

import java.util.List;
import java.util.Map;

import com.bean.Dlb;
import com.dao.DlbDao;
import com.opensymphony.xwork2.ActionContext;
import com.opensymphony.xwork2.ActionSupport;

public class LoginAction extends ActionSupport{
private Dlb dl;
private DlbDao dlbdao;
private String username;
private String passwrod;

public DlbDao getDlbdao() {
return dlbdao;
}
public void setDlbdao(DlbDao dlbdao) {
this.dlbdao = dlbdao;
}
public Dlb getDl() {
return dl;
}
public void setDl(Dlb dl) {
this.dl = dl;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPasswrod() {
return passwrod;
}
public void setPasswrod(String passwrod) {
this.passwrod = passwrod;
}

@Override
public String execute() throws Exception {
return super.execute();
}
public String find()throws Exception{
List list=dlbdao.findAll();
Map request=(Map)ActionContext.getContext().get("request");
request.put("list", list);
return "success";
}
}

dao类代码
package com.dao;

import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;



import org.hibernate.criterion.Example;

import com.bean.Dlb;

public class DlbDaoimpl implements DlbDao{
SessionFactory sessionFactory;
public SessionFactory getSessionFactory() {
return sessionFactory;
}

public void setSessionFactory(SessionFactory sessionFactory) {
this.sessionFactory = sessionFactory;
}

//查找所有用户信息
@Override
public List findAll() {
Session session=sessionFactory.getCurrentSession();
Transaction tx=session.beginTransaction();
Query query=session.createQuery("from Dlb"); //Dlb是指类名,不是表名,注意大小写
List list=query.list();
tx.commit();
return list;
}
//添加账号密码保存进数据库
@Override
public void save(Dlb condition) {
Session session=sessionFactory.getCurrentSession();
//getCurrentSession() 必须在applicationContext.xml中配置 <property name="current_session_context_class">thread</property>
//因为getCurrentSession()要根据上下文来生成session,如果上下文存在session则不创建新的session,否则创建新的
Transaction tx=session.beginTransaction(); //开启事务
session.save(condition);
tx.commit(); //提交事务
}
//删除:根据输入学号,将对应的学生删除
@Override
public void delete(String un) {
Session session=sessionFactory.getCurrentSession();
Transaction tx=session.beginTransaction();
Query query=session.createQuery("from Dlb");
Dlb dl=(Dlb)session.get(Dlb.class, un);
session.delete(dl);
tx.commit();
}
//更改:

@Override
public void update(Dlb condition) {
Session session=sessionFactory.getCurrentSession();
Transaction tx=session.beginTransaction();
session.update(condition);
tx.commit();
}
}

struts.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 2.1//EN" "http://struts.apache.org/dtds/struts-2.1.dtd">
<struts>

<package name="package" namespace="/" extends="struts-default">
<action name="login" class="LoginAction">
<result name="success">/success.jsp</result>

</action>
</package>
</struts>

applicationContext.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans
xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:p="http://www.springframework.org/schema/p"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.1.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd" xmlns:tx="http://www.springframework.org/schema/tx">


<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver"></property> <!-- 指定连接数据库的jdbc驱动 -->
<property name="url"
value="jdbc:mysql://localhost:3306/test1">
</property>
<property name="username" value="root"></property>
<property name="password" value="123456"></property>
</bean>
<bean id="sessionFactory"
class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.MySQLDialect
</prop>
<prop key="hibernate.current_session_context_class"> <!-- 将线程配置成thread级别 -->
thread
</prop>
</props>
</property>
<property name="mappingResources">
<list>
<value>com/bean/Dlb.hbm.xml</value></list>
</property></bean>
<bean id="transactionManager"
class="org.springframework.orm.hibernate4.HibernateTransactionManager">
<property name="sessionFactory" ref="sessionFactory" />
</bean>
<bean id="dl" class="com.bean.Dlb"></bean>

<bean id="DlbDao" class="com.dao.DlbDaoimpl">
<property name="sessionFactory" ref="sessionFactory"></property>
</bean>

<bean id="LoginAction" class="com.action.LoginAction">
<property name="dl" ref="dl"></property>
<property name="dlbdao" ref="DlbDao"></property>
</bean>
<tx:annotation-driven transaction-manager="transactionManager" /></beans>
...全文
273 6 打赏 收藏 转发到动态 举报
写回复
用AI写文章
6 条回复
切换为时间正序
请发表友善的回复…
发表回复
摸鱼飞弹 2018-07-19
  • 打赏
  • 举报
回复
楼上的老哥能再详细一点吗?是哪里改成${list}
卡卡罗特琪琪 2018-07-18
  • 打赏
  • 举报
回复
不应该用$这个符号吗${list}
摸鱼飞弹 2018-07-18
  • 打赏
  • 举报
回复
还是不行..
dengdaip 2018-07-17
  • 打赏
  • 举报
回复
dl.username试试
摸鱼飞弹 2018-07-15
  • 打赏
  • 举报
回复
老哥,改了你说的还是显示不出来
tongkaiming 2018-07-15
  • 打赏
  • 举报
回复
<s:iterator value="#list" id="dl">

81,090

社区成员

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

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