Spring框架 事务，ORM，SpringData以操作对象来操作DB数据

事务

保证一组操作完后其他组才能执行。

ORM

new一个对象后会自动判断是否需要insert update等

Spring Data

H2 Database = Memory DB 临时的数据库

JdbcTemplate执行SQL语句

用最原始的JDBC

通过jdbcTemplate 来操作DB

package jp.tuyano.spring.data1;

import java.util.List;
import java.util.Map;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.jdbc.core.JdbcTemplate;

public class App {

	private static JdbcTemplate jdbcTemplate;
	private static ApplicationContext context;

	public static void main(String[] args) {

		context = new ClassPathXmlApplicationContext("classpath:/bean.xml");
		jdbcTemplate = context.getBean(JdbcTemplate.class);

		jdbcTemplate
			.execute("insert into mypersondata (name,mail,age) values('tuyano','syoda@tuyano.com',123)");
		List<Map<String, Object>> list = jdbcTemplate
				.queryForList("select * from mypersondata");
		for (Map<String, Object> obj : list) {
			System.out.println(obj);
		}

	}
	
}

CREATE TABLE mypersondata (
	id INTEGER PRIMARY KEY AUTO_INCREMENT,
	name VARCHAR(20) NOT NULL,
	mail VARCHAR(50),
	age INTEGER
);

INSERT INTO mypersondata (name, mail, age) VALUES('taro', 'taro@yamada', 34);
INSERT INTO mypersondata (name, mail, age) VALUES('hanako', 'hanako@flower', 28);

-bean.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:tx="http://www.springframework.org/schema/tx"
	xmlns:jdbc="http://www.springframework.org/schema/jdbc"
	xsi:schemaLocation="http://www.springframework.org/schema/beans 
	http://www.springframework.org/schema/beans/spring-beans.xsd 
	http://www.springframework.org/schema/tx 
	http://www.springframework.org/schema/tx/spring-tx.xsd
	http://www.springframework.org/schema/jdbc
	http://www.springframework.org/schema/jdbc/spring-jdbc.xsd
	http://www.springframework.org/schema/context 
	http://www.springframework.org/schema/context/spring-context.xsd">
		
	<!-- jdbc  -->
	<jdbc:embedded-database id="dataSource" type="H2">
		<jdbc:script location="classpath:script.sql" />
	 </jdbc:embedded-database>
	
	<bean class="org.springframework.jdbc.core.JdbcTemplate">
		<constructor-arg ref="dataSource" />
	</bean>
 	
</beans>

Spring Data JPA 实例化

连接class和表，通过EntityManager来操作entity class
所需要的东西

1. Spring Data library
2. 用entity class 对应表
   @Table(name=“mypersondata”) entity和table直接关联

package jp.tuyano.spring.data1;

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="mypersondata")
public class MyPersonData {

	@Id
	@Column
	@GeneratedValue(strategy = GenerationType.AUTO)
	private long id;
	
	@Column(length=50, nullable=false)
	private String name;
	
	@Column(length=100, nullable=true)
	private String mail;
	
	@Column(nullable=true)
	private int age;

	public MyPersonData() {
	}
	
	public MyPersonData(String name, String mail, int age) {
		this();
		this.name = name;
		this.mail = mail;
		this.age = age;
	}
	
	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getMail() {
		return mail;
	}

	public void setMail(String mail) {
		this.mail = mail;
	}

	public int getAge() {
		return age;
	}

	public void setAge(int age) {
		this.age = age;
	}

	public long getId() {
		return id;
	}

	@Override
	public String toString() {
		return "MyPersonData [id=" + id + ", name=" + name + ", mail=" + mail
				+ ", age=" + age + "]";
	}

}

3. persistence.xml 连接DB
   src/main/resources/
   　　|
   　　|—META-INF
   　　|　　　　|
   　　| 　　　|–persistance.xml
   　　|—bean.xml
   　　|—database.properties

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.1"
	xmlns="http://xmlns.jcp.org/xml/ns/persistence" 
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence 
	http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd">
	
	<persistence-unit name="persistence-unit"
		transaction-type="RESOURCE_LOCAL">
		<provider>org.hibernate.ejb.HibernatePersistence</provider>
		<properties>
			<property name="hibernate.dialect" value="org.hibernate.dialect.HSQLDialect" />
			<property name="hibernate.hbm2ddl.auto" value="create" />
			<property name="javax.persistence.jdbc.driver" value="${jdbc.driverClassName}" />
			<property name="javax.persistence.jdbc.url" value="${jdbc.url}" />
			<property name="javax.persistence.jdbc.user" value="${jdbc.username}" />
			<property name="javax.persistence.jdbc.password" value="${jdbc.password}" />
		</properties>
	</persistence-unit>
	
</persistence>

4. bean.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:jpa="http://www.springframework.org/schema/data/jpa"
	xmlns:tx="http://www.springframework.org/schema/tx"
	xmlns:jdbc="http://www.springframework.org/schema/jdbc"
	xsi:schemaLocation="http://www.springframework.org/schema/beans 
	http://www.springframework.org/schema/beans/spring-beans.xsd 
	http://www.springframework.org/schema/data/jpa
	http://www.springframework.org/schema/data/jpa/spring-jpa.xsd
	http://www.springframework.org/schema/tx 
	http://www.springframework.org/schema/tx/spring-tx.xsd
	http://www.springframework.org/schema/jdbc
	http://www.springframework.org/schema/jdbc/spring-jdbc.xsd
	http://www.springframework.org/schema/context 
	http://www.springframework.org/schema/context/spring-context.xsd">
	
	<context:property-placeholder location="classpath:bean.properties" />
	
	<bean id="entityManagerFactory"
		class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
		<property name="dataSource" ref="dataSource" />
		<property name="jpaVendorAdapter">
			<bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
				<property name="generateDdl" value="true" />
				<property name="database" value="${jdbc.type}" />
			</bean>
		</property>
	</bean>

	<!-- jdbc  -->
	<jdbc:embedded-database id="dataSource" type="H2">
		<jdbc:script location="${jdbc.scriptLocation}" />
	</jdbc:embedded-database>

</beans>

5. .properties

jdbc.type=H2
jdbc.scriptLocation=classpath:script.sql
jdbc.driverClassName=org.h2.Driver
jdbc.url=jdbc:h2:mem:mydata
jdbc.username=sa
jdbc.password=

6. main class
   用manager对象来管理Entity

package jp.tuyano.spring.data1;

import javax.persistence.EntityManager;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean;

public class App {

	private static ApplicationContext context;
	private static EntityManager manager;

	public static void main(String[] args) {

		context = new ClassPathXmlApplicationContext("classpath:/bean.xml");
		LocalContainerEntityManagerFactoryBean factory =
				context.getBean(LocalContainerEntityManagerFactoryBean.class);
		// 用manager对象来管理Entity
		manager = factory.getNativeEntityManagerFactory().createEntityManager();
			
		MyPersonData data = manager.find(MyPersonData.class, 1L); // 找到主Key为1 的对象，所以只有一条
		System.out.println(data);
	}

}

DAO

MVC中的M
业务层，DAO，table(entity)
DAO: 连接DB和业务层的

package jp.tuyano.spring.data1;

import java.util.List;

import javax.persistence.EntityManager;
import javax.persistence.EntityTransaction;
import javax.persistence.Query;

public class MyPersonDataDaoImpl<MyPersonData> implements MyPersonDataDao {
	private EntityManager manager = null;
	
	public MyPersonDataDaoImpl(EntityManager manager) {
		super();
		this.manager = manager;
	}
	
	public List<MyPersonData> getAllEntity() {
		Query query = manager.createQuery("from MyPersonData");
		return query.getResultList();
	}

	public List<MyPersonData> findByField(String field, String find) {
		Query query = manager.createQuery("from MyPersonData where " + field + " = '" + find + "'");
		return query.getResultList();
	}

	public void addEntity(Object entity) {
		EntityTransaction transaction = manager.getTransaction();
		transaction.begin();
		manager.persist(entity);
		manager.flush(); // 必须flush使得操作后DB被更新
		transaction.commit();
	}

	public void updateEntity(Object entity) {
		EntityTransaction transaction = manager.getTransaction();
		transaction.begin();
		manager.merge(entity);
		manager.flush();
		transaction.commit();
	}


	public void removeEntity(Object data) {
		EntityTransaction transaction = manager.getTransaction();
		transaction.begin();
		manager.remove(data);
		manager.flush();
		transaction.commit();
	}

	public void removeEntity(Long id) {
		MyPersonData entity = manager.find(MyPersonData.class, id);
		this.removeEntity(entity);
	}
}