日期:2014-05-18  浏览次数:20812 次

loginAction 中如何查询数据库里面数据
     我用的Struts2和hibernate、Spring整合,loginAction里面数据库Dao类直接用的是Spring配置文件里面注入的,但是出错,这句代码Userinfo userinfo = userDao.findById(4);不知道时查询不出数据还是没有作用,一时搞不清楚,反正客户端访问到这就报500,求大神指点一二!谢谢!
  下面是我的loginAction里面代码:
    
public class LoginAction extends ActionSupport implements ServletRequestAware,
ServletResponseAware {

private HttpServletRequest request;
private HttpServletResponse response;
private String format;



public void setServletRequest(HttpServletRequest request) {
// TODO Auto-generated method stub
this.request = request;
}

public void setServletResponse(HttpServletResponse response) {
// TODO Auto-generated method stub
this.response = response;
}

UserinfoDAO userDao;

public void setUserDao(UserinfoDAO userDao) {
this.userDao = userDao;
}
public void login() {

Userinfo userinfo = userDao.findById(4);// 获取数据库里面的数据
System.out.println("aaaaaaaaaaaa");
System.out.println(this.request.getParameter("username"));
try {
this.response.setContentType("text/html;charset=utf-8");
this.response.setCharacterEncoding("UTF-8");
if (this.request.getParameter("username").equals(userinfo.getUsername())) {
this.response.getWriter().write("登录成功");
}else{
this.response.getWriter().write("名字不一样");
}
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}

}



下面是我applicationContext.xml文件里面的代码

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver">
</property>
<property name="url"
value="jdbc:mysql://localhost:3307/shopping_community">
</property>
<property name="username" value="root"></property>
<property name="password" value="123456"></property>
</bean>
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.MySQLDialect
</prop>
</props>
</property>
<property name="mappingResources">
<list>
<value>com/csw/entity/Userinfo.hbm.xml</value>
</list>
</property>
</bean>
<bean id="UserinfoDAO" class="com.csw.entity.UserinfoDAO">
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>


<!-- 配置action类 -->
<bean id="loginAction" class="com.csw.action.LoginAction">
<property name="userDao" ref="UserinfoDAO" />
</bean>



求大神看看是哪出问题了,谢谢!