Struts2+Hibernate+Spring框架搭建(二)
二:创建数据库和搭建Hibernate环境配置
1.首先将Hibernate的Jar包拷贝到“WEB-INF”的lib目录下面
2.使用Oracle数据库创建表Student
3.在src目录下新建包“com.wl.po”,在这个包下面“Student”的类及对应的映射文件“student.hbm.xml”
Student.java
package com.wl.po;public class Student {private String id;private String stuName;private String stuNo;private String stuSex;private int stuAge;private String stuGrade;public int getStuAge() {return stuAge;}public void setStuAge(int stuAge) {this.stuAge = stuAge;}public String getStuGrade() {return stuGrade;}public void setStuGrade(String stuGrade) {this.stuGrade = stuGrade;}public String getStuName() {return stuName;}public void setStuName(String stuName) {this.stuName = stuName;}public String getStuNo() {return stuNo;}public void setStuNo(String stuNo) {this.stuNo = stuNo;}public String getStuSex() {return stuSex;}public void setStuSex(String stuSex) {this.stuSex = stuSex;}public String getId() {return id;}public void setId(String id) {this.id = id;}}
student.hbm.xml
<?xml version="1.0"?><!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"><hibernate-mapping package="com.wl.po"> <class name="Student" table="student"> <id name="id"> <generator column="stuName" type="java.lang.String"></property> <property name="stuNo" column="stuNo" type="java.lang.String"></property> <property name="stuSex" column="stuSex" type="java.lang.String"></property> <property name="stuGrade" column="stuGrade" type="java.lang.String"></property> <property name="stuAge" column="stuAge" type="java.lang.Integer"></property> </class></hibernate-mapping>
4.在src下面新建包“com.wl.dao”,在下面新建接口“studentDao"
package com.wl.dao;import com.wl.po.Student;public interface studentDao {public void save(Student stu);public void delete(Student stu);public void update(Student stu);}
5.在src下面新建包“com.wl.dao.impl”,在下面新建类“studentDaoImpl"
package com.wl.dao.impl;import org.springframework.orm.hibernate3.support.HibernateDaoSupport;import com.wl.dao.studentDao;import com.wl.po.Student;public class studentDaoImpl extends HibernateDaoSupport implements studentDao{public void save(Student stu){getHibernateTemplate().save(stu);}public void delete(Student stu){getHibernateTemplate().delete(stu);}public void update(Student stu){getHibernateTemplate().update(stu);}}
6.在src下新建包”com.wl.service“,在下面新建接口"studentService"
package com.wl.service;import com.wl.po.Student;public interface studentService {public void saveStudent(Student stu);public void updateStudent(Student stu);public void deleteStudent(Student stu);}
7.在src下新建包“com.wl.serviceImpl”,在下面新建类“serviceImpl”
package com.wl.service.impl;import com.wl.dao.studentDao;import com.wl.po.Student;import com.wl.service.studentService;public class studentServiceImpl implements studentService {private studentDao stuDao;public studentDao getStuDao() {return stuDao;}public void setStuDao(studentDao stuDao) {this.stuDao = stuDao;}public void deleteStudent(Student stu) {// TODO Auto-generated method stubstuDao.delete(stu);}public void saveStudent(Student stu) {// TODO Auto-generated method stubstuDao.save(stu);}public void updateStudent(Student stu) {// TODO Auto-generated method stubstuDao.update(stu);}}
8.配置Hibernate的映射文件Hibernate.cfg.xml
<?xml version='1.0' encoding='utf-8'?><!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN" "http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd"><hibernate-configuration> <session-factory> <!-- properties --> <property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property> <property name="connection.url">jdbc:oracle:thin:@127.0.0.1:1521:xe</property> <property name="connection.username">WANGLEI</property> <property name="connection.password">leiwang</property> <property name="dialect">org.hibernate.dialect.Oracle10gDialect</property> <property name="show_sql">true</property> <!-- mapping files --> <mapping resource="com/wl/po/student.hbm.xml"/> </session-factory> </hibernate-configuration>