下面我只粘主要的配置文件和实体
applicationContext.xml
<bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="locations">
<list>
<value>classpath:hsm-db-dchsqlserver.properties</value>
<value>classpath:hsm-db-drhsqlserver.properties</value>
</list>
</property>
</bean>
<import resource="db-dch.xml" />
<import resource="db-drh.xml" />
资源文件就不贴了,资源文件主要配置数据库驱动连接等相关配置
db-dch.xml
db-drh.xml
两个数据库都有一个Employee的表,所以这里我分开两个实体
DCHEmployeeEntity
DRHEmployeeEntity
DAO也分两个
DCHEmployeeDAO
DRHEmployeeDAO
目录结构
控制类,项目访问
import javax.servlet.http.HttpServletRequest;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.servlet.ModelAndView;
import com.dch.projects.dch.employee.entity.DCHEmployeeEntity;
import com.dch.projects.dch.employee.service.IDCHEmployeeService;
import com.dch.projects.drh.employee.entity.DRHEmployeeEntity;
import com.dch.projects.drh.employee.service.IDRHEmployeeService;
import com.dch.projects.oms.user.entity.UserEntity;
import com.dch.projects.oms.user.service.IUserService;
@Controller
@RequestMapping("/")
public class IndexController {
@Autowired
private IUserService userService;
@Autowired
private IDCHEmployeeService dchEmployeeService;
@Autowired
private IDRHEmployeeService drhEmployeeService;
@RequestMapping("/main")
public ModelAndView main(HttpServletRequest request) {
List listUsers=this.userService.getAllUsersByHql("from UserEntity");
for(UserEntity user:listUsers){
System.out.println(user.getName());
}
List listDCHEmployees=this.dchEmployeeService.getAllDCHEmployeesByHql("from DCHEmployeeEntity");
for(DCHEmployeeEntity employee:listDCHEmployees){
System.out.println("德诚行:"+employee.getEmpNo()+" "+employee.getEmpName());
}
List listDRHEmployees=this.drhEmployeeService.getAllDRHEmployeesByHql("from DRHEmployeeEntity");
for(DRHEmployeeEntity employee:listDRHEmployees){
System.out.println("德瑞行:"+employee.getEmpNo()+" "+employee.getEmpName());
}
return new ModelAndView("index/main");
}
}
后台错误
页面错误,都一样
DCHEmployee这个能查出数据,就是DRHEmployee报错,配置那里看来看去都没什么问题,除了table的名字是一样,但如果我使用hibernate配置文件配置实体而不用注解的话是没问题,使用注解就出现这问题。
哪位大神帮看下问题出在哪里,谢谢了。