大家好,我的ssh集成时,不发sql语句,我的代码如下:
spring配置文件
--------------------------------------------
<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:3306/test"></property>
<property name="username" value="root"></property>
<property name="password" value="000000"></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>
<prop key="hibernate.show_sql">
true
</prop>
</props>
</property>
<property name="mappingResources">
<list>
<value>com/dgj/hibernate/User.hbm.xml</value></list>
</property></bean>
<bean id="transactionManager"
class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory">
<ref local="sessionFactory" />
</property>
</bean>
<bean id="userDAOProxy"
class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
<property name="transactionManager">
<ref bean="transactionManager" />
</property>
<property name="target">
<list>
<ref local="userDAO" />
</list>
</property>
<property name="transactionAttributes">
<props>
<prop key="get*">PROPAGATION_REQUIRED,readOnly</prop>
</props>
</property>
</bean> <bean id="hibernateTemplate"
class="org.springframework.orm.hibernate3.HibernateTemplate">
<property name="sessionFactory">
<ref local="sessionFactory" />
</property>
</bean>
<!-- dao -->
<bean id="userDAO"
class="com.dgj.dao.hibernate.UserDAOImpl">
<property name="sessionFactory">
<ref local="sessionFactory" />
</property>
</bean>
<!-- Action -->
<bean name="/login" class="com.dgj.struts.action.LoginAction" scope="prototype">
<property name="userDAO">
<ref local="userDAO"/>
</property>
</bean>dao的实现类:
-----------------------------------------------------
private String hql = "from User u where u.name=?" +
"and u.password=?";
private String hql1 = "from User u where u.name=?";
protected void initDao(){
}
public User getUser(String username) { List ret = null;
Iterator it = null;
try{
ret = this.getHibernateTemplate().find(hql,username);
it = ret.iterator();
return (User)it.next();
}catch (Exception e){
log.error(e.getMessage());
return null;
}
}
struts的Action核心代码:
---------------------------------------
private UserDAO userDAO;
public UserDAO getUserDAO() {
return userDAO;
} public void setUserDAO(UserDAO userDAO) {
this.userDAO = userDAO;
} public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {
LoginForm logForm = (LoginForm) form;
String username = logForm.getName();
ActionForward af = null;
String tmp = null;
User u = this.getUserDAO().getUser(username);
if(u!=null){
tmp = (String)request.getSession().getAttribute("name");
if(tmp == null){
request.getSession().setAttribute("name", username);
}else{
request.getSession().removeAttribute("name");
request.getSession().setAttribute("name", username);
}
af = mapping.findForward("login");
}else{
request.setAttribute("error", "登陆失败请输入正确的用户名和密码");
af = mapping.findForward("error");
}
return af;
}希望大家给予解决,谢谢
spring配置文件
--------------------------------------------
<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:3306/test"></property>
<property name="username" value="root"></property>
<property name="password" value="000000"></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>
<prop key="hibernate.show_sql">
true
</prop>
</props>
</property>
<property name="mappingResources">
<list>
<value>com/dgj/hibernate/User.hbm.xml</value></list>
</property></bean>
<bean id="transactionManager"
class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory">
<ref local="sessionFactory" />
</property>
</bean>
<bean id="userDAOProxy"
class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
<property name="transactionManager">
<ref bean="transactionManager" />
</property>
<property name="target">
<list>
<ref local="userDAO" />
</list>
</property>
<property name="transactionAttributes">
<props>
<prop key="get*">PROPAGATION_REQUIRED,readOnly</prop>
</props>
</property>
</bean> <bean id="hibernateTemplate"
class="org.springframework.orm.hibernate3.HibernateTemplate">
<property name="sessionFactory">
<ref local="sessionFactory" />
</property>
</bean>
<!-- dao -->
<bean id="userDAO"
class="com.dgj.dao.hibernate.UserDAOImpl">
<property name="sessionFactory">
<ref local="sessionFactory" />
</property>
</bean>
<!-- Action -->
<bean name="/login" class="com.dgj.struts.action.LoginAction" scope="prototype">
<property name="userDAO">
<ref local="userDAO"/>
</property>
</bean>dao的实现类:
-----------------------------------------------------
private String hql = "from User u where u.name=?" +
"and u.password=?";
private String hql1 = "from User u where u.name=?";
protected void initDao(){
}
public User getUser(String username) { List ret = null;
Iterator it = null;
try{
ret = this.getHibernateTemplate().find(hql,username);
it = ret.iterator();
return (User)it.next();
}catch (Exception e){
log.error(e.getMessage());
return null;
}
}
struts的Action核心代码:
---------------------------------------
private UserDAO userDAO;
public UserDAO getUserDAO() {
return userDAO;
} public void setUserDAO(UserDAO userDAO) {
this.userDAO = userDAO;
} public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {
LoginForm logForm = (LoginForm) form;
String username = logForm.getName();
ActionForward af = null;
String tmp = null;
User u = this.getUserDAO().getUser(username);
if(u!=null){
tmp = (String)request.getSession().getAttribute("name");
if(tmp == null){
request.getSession().setAttribute("name", username);
}else{
request.getSession().removeAttribute("name");
request.getSession().setAttribute("name", username);
}
af = mapping.findForward("login");
}else{
request.setAttribute("error", "登陆失败请输入正确的用户名和密码");
af = mapping.findForward("error");
}
return af;
}希望大家给予解决,谢谢
解决方案 »
- 关于连接池的问题
- 新手问一个老问题-----mysql中文显示(实在没办法了)
- 一个打开新窗口的疑问。高手来指导!
- 提问: 关于过滤器的问题 认为自己过滤器不错的高手进!!
- jstl 简单问题 <!-- 给60分不少了 -->
- FCKeditor2.3报空指针异常,请教大家这是什么问题啊
- 如何更新数据到dbf数据表中,其中我用executeUpdate()提示更新成功,但表中数据没有改变啊???
- 我想让浏览器地址栏中的网址一直固定显示某个名称,如何做?
- Tomcat 无论怎么修改端口都报错
- 高手指点!!!!
- 传入access数据库的中文变乱码
- JSP中javaScript 调用delphi插件
<property name="hibernateProperties">
<props>
<prop key="hibernate.hbm2ddl.auto">update</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.dialect">
org.hibernate.dialect.Oracle9Dialect
</prop>
</props>
</property>