1 Bean.java
@Entity
@Table(name = "region")
public class Region {
private int regionId;
private int parentId;
private String regionName;
private int type;
/* @Id @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "seq") */
@Id @GeneratedValue(strategy=GenerationType.AUTO)
@Column(name = "region_id", unique = true, nullable = false)
public int getRegionId() {
return regionId;
}
public void setRegionId(int regionId) {
this.regionId = regionId;
}
@Column(name = "parent_id", nullable = false)
public int getParentId() {
return parentId;
}
public void setParentId(int parentId) {
this.parentId = parentId;
}
@Column(name = "region_name", nullable = false)
public String getRegionName() {
return regionName;
}
public void setRegionName(String regionName) {
this.regionName = regionName;
}
@Column(name = "type", nullable = false)
public int getType() {
return type;
}
public void setType(int type) {
this.type = type;
}
}
2 Dao
@Repository("regionDao")
public class RegionDAOImpl extends HibernateDaoSupport implements RegionDAO{
private static Logger sysLog = Logger.getLogger(RegionDAOImpl.class);
// 获得所有的省份
public List<Region> getProvinces() throws Exception {
try {
return getHibernateTemplate().find("from Region");
} catch (Exception ex) {
throw new Exception("获得所有的省份发生错误..."+ ex.getMessage());
}
}
}
3 service
@Service("regionService")
public class RegionServiceImpl implements RegionService {
private RegionDAO regionDao;
public RegionDAO getRegionDao() {
return regionDao;
}
public void setRegionDao(RegionDAO regionDao) {
this.regionDao = regionDao;
}
// 获得所有的省份
public List<Region> getProvinces() throws Exception {
return regionDao.getProvinces();
}
}
4 control.java
@Controller
public class HomeController {
private RegionService regionService;
public RegionService getRegionService() {
return regionService;
}
public void setRegionService(RegionService regionService) {
this.regionService = regionService;
}
@RequestMapping(value="/home", method=RequestMethod.GET)
public String home(Model model) throws Exception{
//
List<Region> plist = regionService.getProvinces();
model.addAttribute("plist", plist);
return "login";
}
}
@Entity
@Table(name = "region")
public class Region {
private int regionId;
private int parentId;
private String regionName;
private int type;
/* @Id @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "seq") */
@Id @GeneratedValue(strategy=GenerationType.AUTO)
@Column(name = "region_id", unique = true, nullable = false)
public int getRegionId() {
return regionId;
}
public void setRegionId(int regionId) {
this.regionId = regionId;
}
@Column(name = "parent_id", nullable = false)
public int getParentId() {
return parentId;
}
public void setParentId(int parentId) {
this.parentId = parentId;
}
@Column(name = "region_name", nullable = false)
public String getRegionName() {
return regionName;
}
public void setRegionName(String regionName) {
this.regionName = regionName;
}
@Column(name = "type", nullable = false)
public int getType() {
return type;
}
public void setType(int type) {
this.type = type;
}
}
2 Dao
@Repository("regionDao")
public class RegionDAOImpl extends HibernateDaoSupport implements RegionDAO{
private static Logger sysLog = Logger.getLogger(RegionDAOImpl.class);
// 获得所有的省份
public List<Region> getProvinces() throws Exception {
try {
return getHibernateTemplate().find("from Region");
} catch (Exception ex) {
throw new Exception("获得所有的省份发生错误..."+ ex.getMessage());
}
}
}
3 service
@Service("regionService")
public class RegionServiceImpl implements RegionService {
private RegionDAO regionDao;
public RegionDAO getRegionDao() {
return regionDao;
}
public void setRegionDao(RegionDAO regionDao) {
this.regionDao = regionDao;
}
// 获得所有的省份
public List<Region> getProvinces() throws Exception {
return regionDao.getProvinces();
}
}
4 control.java
@Controller
public class HomeController {
private RegionService regionService;
public RegionService getRegionService() {
return regionService;
}
public void setRegionService(RegionService regionService) {
this.regionService = regionService;
}
@RequestMapping(value="/home", method=RequestMethod.GET)
public String home(Model model) throws Exception{
//
List<Region> plist = regionService.getProvinces();
model.addAttribute("plist", plist);
return "login";
}
}