67,515
社区成员
发帖
与我相关
我的任务
分享
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd">
<bean id="dataSource"
class="com.mchange.v2.c3p0.ComboPooledDataSource"
destroy-method="close">
<property name="driverClass" value="com.mysql.jdbc.Driver" />
<property name="jdbcUrl"
value="jdbc:mysql://localhost:3306/test" />
<property name="user" value="root" />
<property name="password" value="2650631" />
<property name="maxPoolSize" value="20" />
<property name="minPoolSize" value="1" />
<property name="maxIdleTime" value="20" />
</bean>
<bean id="sessionFactory"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="mappingResources">
<list>
<value>Users.hbm.xml</value>
</list>
</property>
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">
org.hibernate.dialect.MySQLDialect
</prop>
<prop key="show_sql">true</prop>
<prop key="hibernate.hbm2ddl.auto">update</prop>
<prop key="hibernate.jdbc.batch_size">20</prop>
</props>
</property>
</bean>
<bean id="usersDao"
class="login_system.DaoIpml.UsersDaoHibernate">
<property name="sessionFactory" ref="sessionFactory" />
</bean>
</beans>
package login_system.DaoIpml;
import java.util.List;
import login_system.Dao.UsersDao;
import login_system.bean.HibernateUtils;
import login_system.bean.Users;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
public class UsersDaoHibernate extends HibernateDaoSupport implements UsersDao
{
public void delete(Users users)
{
getHibernateTemplate().delete(users);
}
public void delete(int id)
{
getHibernateTemplate().delete(
getHibernateTemplate().get(Users.class, id));
}
public List<Users> findAll()
{
return getHibernateTemplate().find("from Users");
}
public Users findUsersByName(String name)
{
List li = getHibernateTemplate().find("from Users ac where ac.name=? ",
name);
if (li != null && li.size() > 0)
{
return (Users) li.get(0);
}
return null;
}
public Users findUsersByNameAndPassword(String name, String password)
{
List li = getHibernateTemplate().find(
"from Users ac where ac.name=? and ac.password=? ",
new String[]
{ name, password });
if (li != null && li.size() > 0)
{
return (Users) li.get(0);
}
return null;
}
public Users get(int id)
{
return (Users)getHibernateTemplate().load(Users.class, id);
}
public void save(Users users)
{
getHibernateTemplate().save(users);
}
public void update(Users users)
{
getHibernateTemplate().update(users);
}
}
package test;
import junit.framework.TestCase;
import login_system.DaoIpml.UsersDaoHibernate;
import login_system.bean.Users;
public class TestUserDaoImpl extends TestCase
{
public void testsave()
{
try{
UsersDaoHibernate h1=new UsersDaoHibernate();
System.out.print(h1.get(1).getName());
}
catch(Exception e)
{
e.printStackTrace();
}
// Users u1 =new Users();
// u1.setName("admin");
// u1.setPassword("123456");
// u1.setEmail("wjk2813@163.com");
// h1.save(u1);
}
}
<property name="mappingResources">
<list>
<value>Users.hbm.xml</value>
</list>
</property>
private ApplicationContext ac;
private UsersDao dao;
@Before
public void setUp() throws Exception {
ac = new ClassPathXmlApplicationContext("applicationContext.xml");
dao = (UsersDao)ac.getBean("usersDao");
}
@After
public void tearDown() throws Exception {
ac = null;
dao = null;
}