81,092
社区成员
发帖
与我相关
我的任务
分享
<bean id="dataSource"
class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver">
</property>
<property name="url"
value="jdbc:sqlserver://localhost:1433; DatabaseName=xy">
</property>
<property name="username" value="sa"></property>
<property name="password" value="xyz"></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.SQLServerDialect
</prop>
<prop key="show_sql">true</prop>
</props>
</property>
<property name="mappingResources">
<list>
<value>com.highsun.model.Employee.hbm.xml</value>
</list>
</property>
</bean>
<bean id="transactionManager"
class="org.springframework.orm.hibernate3.HibernateTransactionManager">
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
<aop:config proxy-target-class="true">
<aop:pointcut id="orderServiceOperation"
expression="execution(* com.highsun.service.impl.*ServiceImpl.*(..))" />
<aop:advisor pointcut-ref="orderServiceOperation"
advice-ref="orderTxAdvice" />
</aop:config>
<tx:advice id="orderTxAdvice"
transaction-manager="transactionManager">
<bean id="employeeandroleDao"
class="com.highsun.dao.EmployeeandroleDAO">
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
<bean id="employeeDao" class="com.highsun.dao.EmployeeDAO">
<property name="sessionFactory">
<ref bean="sessionFactory" />
</property>
</bean>
<bean id="employeeService"
class="com.highsun.service.impl.EmployeeServiceImpl">
<property name="employeeDao">
<ref bean="employeeDao" />
</property>
<property name="employeeandroleDao">
<ref bean="employeeandroleDao" />
</property>
</bean>
public class EmployeeServiceImpl implements EmployeeService {
private static final Log log = LogFactory.getLog(EmployeeServiceImpl.class);
private EmployeeDAO employeeDao;
private EmployeeandroleDAO employeeandroleDao;
public void setEmployeeDao(EmployeeDAO employeeDao) {
this.employeeDao = employeeDao;
}
public void setEmployeeandroleDao(EmployeeandroleDAO employeeandroleDao) {
this.employeeandroleDao = employeeandroleDao;
}
public Employee findById(java.lang.Integer employeeid) {
return employeeDao.findById(employeeid);
}
public List findAll() {
return employeeDao.findAll();
}
public void addEmployee(Employee transientInstance) {
transientInstance.setEmployeeid(null);
Employeeandrole employeeandrole = new Employeeandrole();
if (transientInstance.getEmployeetype().intValue() == 1){//管理员
Roleinfo roleinfo = new Roleinfo("管理员");
EmployeeandroleId employeeandroleId = new EmployeeandroleId(transientInstance,roleinfo);
employeeandrole.setId(employeeandroleId);
}
if (transientInstance.getEmployeetype().intValue() == 2){//维修人员
Roleinfo roleinfo = new Roleinfo("维修人员");
EmployeeandroleId employeeandroleId = new EmployeeandroleId(transientInstance,roleinfo);
employeeandrole.setId(employeeandroleId);
}
if (transientInstance.getEmployeetype().intValue() == 3){//销售
Roleinfo roleinfo = new Roleinfo("销售");
EmployeeandroleId employeeandroleId = new EmployeeandroleId(transientInstance,roleinfo);
employeeandrole.setId(employeeandroleId);
}
employeeDao.save(transientInstance);
employeeandroleDao.save(employeeandrole);
}
public void deleteEmployee(Employee persistentInstance) {
employeeDao.delete(persistentInstance);
}
public List find(Employee instance) {
return employeeDao.findByExample(instance);
}
public Employee findUser(String userName, String password) {
Employee employee = new Employee();
employee.setLoginname(userName);
employee.setPwd(password);
List list = employeeDao.findByExample(employee);
if(list!=null && list.size()==1){
return (Employee)list.get(0);
}
return null;
}
public void saveEmployee(Employee persistentInstance) {
employeeDao.attachDirty(persistentInstance);
}
//此方法已经不用
public Long getTotalRows(String hql,Employee instance) {
//return employeeDao.findTotalRow(hql,instance);
return null;
}
public void updateEmployee(Employee instance) {
employeeDao.attachDirty(instance);
}
public PaginationSupport findPage(DetachedCriteria detachedCriteria,int startIndex) {
return employeeDao.findPageByCriteria(detachedCriteria, PaginationSupport.PAGESIZE, startIndex);
}
}