1、创建一个maven项目PomDependency,以pom方式打包。 在pom.xml中添加如下依赖:
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.guo</groupId>
<artifactId>PomDependency</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>pom</packaging>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>test</scope>
</dependency>
<dependency><!--servelt -->
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
<version>4.0.0-b07</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>redis.clients</groupId>
<artifactId>jedis</artifactId>
<version>3.0.1</version>
</dependency>
<dependency>
<groupId>mysql</groupId><!-- MySql -->
<artifactId>mysql-connector-java</artifactId>
<version>5.1.39</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-orm</artifactId>
<version>4.3.21.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>4.3.21.RELEASE</version>
</dependency>
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjrt</artifactId>
<version>1.9.2</version>
</dependency>
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.9.2</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-core</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-beans</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework.data</groupId>
<artifactId>spring-data-jpa</artifactId>
<version>1.8.0.RELEASE</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.datatype</groupId>
<artifactId>jackson-datatype-hibernate5</artifactId>
<version>2.9.9</version>
</dependency>
<!-- 2.Spring dao依赖 -->
<!-- spring-jdbc包括了一些如jdbcTemplate的工具类 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<!-- 3.Spring web依赖 -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>4.3.7.RELEASE</version>
</dependency>
<!-- 4.Spring test依赖:方便做单元测试和集成测试 <dependency> <groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId> <version>4.3.7.RELEASE</version> </dependency> -->
<!-- Log4J -->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
<!--mybatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.4.1</version>
</dependency>
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.2.1</version>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.0</version>
</dependency>
<!-- JSTL -->
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>2.9.1</version>
</dependency>
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.0.0</version>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jsp-api</artifactId>
<version>2.0</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-orm</artifactId>
<version>5.0.8.RELEASE</version>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>servlet-api</artifactId>
<version>2.5</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-core</artifactId>
<version>5.0.7.Final</version>
</dependency>
<dependency>
<groupId>org.javassist</groupId>
<artifactId>javassist</artifactId>
<version>3.20.0-GA</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-nop</artifactId>
<version>1.6.4</version>
</dependency>
</dependencies>
</project>
2、再新建一个Maven项目,以jar形式打包,继承PomDependency
在src/mian/resources下创建spring.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd">
<context:property-placeholder location="classpath:db.properties" />
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="${mysql.driver}" />
<property name="jdbcUrl" value="${mysql.url}" />
<property name="user" value="${mysql.username}" />
<property name="password" value="${mysql.password}" />
</bean>
<bean id="sessionFactory"
class="org.springframework.orm.hibernate5.LocalSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="hibernateProperties">
<props>
<prop key="hibernate.show_sql">true</prop><!-- 显示当前执行的sql语句 -->
<prop key="hibernate.hbm2ddl.auto">update</prop><!-- 开启正向工程 -->
</props>
</property>
<property name="packagesToScan"><!-- 扫描实体所在的包 -->
<list>
<value>com.guo.bean</value>
</list>
</property>
</bean>
<!-- 配置HiberanteTemplate对象 -->
<bean id="template" class="org.springframework.orm.hibernate5.HibernateTemplate">
<property name="sessionFactory" ref="sessionFactory" />
</bean>
<!-- 配置Hibernate的事务管理器 -->
<bean id="transactionManager"
class="org.springframework.orm.hibernate5.HibernateTransactionManager">
<property name="sessionFactory" ref="sessionFactory" />
</bean>
<tx:annotation-driven transaction-manager="transactionManager" />
<!-- 注解装配 -->
<context:component-scan
base-package="com.guo.dao.impl,com.guo.service.impl,com.guo.action" />
</beans>
3、创建实体类、dao、service、action等接口与实现类
package com.guo.bean;
import java.io.Serializable;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
@Entity
@Table(name="person") //表名
public class Person implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy=GenerationType.IDENTITY)//主键自增长
private Integer id;
@Column(name="name")
private String name;
@Column(name="gender")
private Character gender;
@Column(name="age")
private Integer age;
@Column(name="province")
private String province;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public Character getGender() {
return gender;
}
public void setGender(Character gender) {
this.gender = gender;
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
public String getProvince() {
return province;
}
public void setProvince(String province) {
this.province = province;
}
@Override
public String toString() {
return "Person [id=" + id + ", name=" + name + ", gender=" + gender + ", age=" + age + ", province=" + province
+ "]";
}
public Person(Integer id, String name, Character gender, Integer age, String province) {
this.id = id;
this.name = name;
this.gender = gender;
this.age = age;
this.province = province;
}
public Person(String name, Character gender, Integer age, String province) {
this.name = name;
this.gender = gender;
this.age = age;
this.province = province;
}
public Person() {
}
public Person(int id) {
this.id = id;
}
}
package com.guo.dao;
import java.util.List;
import com.guo.bean.Person;
public interface PersonDao {
void add(Person p);
Person getByID(Integer id);
void update(Person p);
void delete(Person p);
List<Person> getAll();
List<Person> getByName(String name);
}
package com.guo.dao.impl;
import java.util.List;
import org.hibernate.Criteria;
import org.hibernate.Session;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.orm.hibernate5.HibernateTemplate;
import org.springframework.stereotype.Repository;
import com.guo.bean.Person;
import com.guo.dao.PersonDao;
@Repository
public class PersonDaoImpl implements PersonDao {
@Autowired
private HibernateTemplate template;
public void setHibernateTemplate(HibernateTemplate template) {
this.template = template;
}
@Override
public void add(Person p) {
template.save(p);
}
@Override
public Person getByID(Integer id) {
return template.get(Person.class, id);
}
@Override
public void update(Person p) {
template.update(p);
}
@Override
public void delete(Person p) {
template.delete(p);
}
@Override
public List<Person> getAll() {
Session session = template.getSessionFactory().getCurrentSession();
try {
Criteria c = session.createCriteria(Person.class);
return (List<Person>)c.list();
} finally {
//session.close();关闭会出现异常LogicalConnectionManagedImpl@654c1a54 is closed
}
}
@Override
public List<Person> getByName(String name) {
Session session = template.getSessionFactory().getCurrentSession();
try {
//方式一:
Query query = session.createQuery(" from Person where name = :abc");
Query queryTemp = query.setString("abc",name);
return queryTemp.list();
} catch (Exception e) {
//方式二:
SQLQuery entity = session.createSQLQuery("select * person where name = ?").addEntity(Person.class);
entity.setString(0, name);
return entity.list();
}finally {
//session.close();关闭会出现异常LogicalConnectionManagedImpl@654c1a54 is closed
}
}
}
package com.guo.service.impl;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import com.guo.bean.Person;
import com.guo.dao.PersonDao;
import com.guo.service.PersonService;
@Service
@Transactional//对于事务提交方式默认的是回滚
public class PersonServiceImpl implements PersonService {
@Autowired
private PersonDao personDao;
public void setPersonDao(PersonDao personDao) {
this.personDao = personDao;
}
@Override
public void add(Person p) {
if (p != null)
personDao.add(p);
}
@Override
public Person getByID(Integer id) {
return personDao.getByID(id);
}
@Override
public void update(Person p) {
if (p != null)
personDao.update(p);
}
@Override
public void delete(Person p) {
if (p != null)
personDao.delete(p);
}
@Override
public List<Person> getAll() {
return personDao.getAll();
}
@Override
public List<Person> getByName(String name) {
return personDao.getByName(name);
}
}
package com.guo.action;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import com.guo.bean.Person;
import com.guo.service.PersonService;
@Controller
@Scope(scopeName="prototype")//多例模式
public class PersonAction {
@Autowired//自动装配
private PersonService personService;
public void setPersonService(PersonService personService) {
this.personService = personService;
}
public void add(Person p) {
personService.add(p);
}
Person getByID(Integer id){
return personService.getByID(id);
}
public void update(Person p){
personService.update(p);
}
public void delete(Person p){
personService.delete(p);
}
public List<Person> getAll(){
return personService.getAll();
}
public List<Person> getByName(String name) {
return personService.getByName(name);
}
}
4、测试:
ApplicationContext context = new ClassPathXmlApplicationContext("spring.xml");
PersonAction action = context.getBean(PersonAction.class);
Person add = new Person("张三", '男', 20, "京");
//插入
action.add(add);
//删除
//Person delete = new Person(1);
//action.delete(delete);
//按主键查询
System.out.println(action.getByID(2));
//按姓名查询
System.out.println(action.getByName("张三"));