介紹三種操作數(shù)據(jù)庫的對比
第一種直接JDBC
思路：寫個工具類，獲取連接的方法，釋放資源的方法
-
實現(xiàn)：
pom.xml添加mysql驅(qū)動包<dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.38</version> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.10</version> </dependency>寫工具類utils.java
public class JdbcUtils { public static Connection getConn() throws Exception{} public static void release(ResultSet rs, Statement sm, Connection conn){} }寫單元測試test.java
public class JDBCUtilsTest { @Test public void testGetConn() throws Exception { Connection connection = JDBCUtils.getConnection(); Assert.assertNotNull(connection); } }
寫業(yè)務代碼
先實體entity/Student.java
public class Student {
private int id;
private String name;
private int age;
get()/set()...
}
在數(shù)據(jù)接口層dao/StudentDao.java
public interface StudentDao {
public List<Student> queryAllStudent();
public void saveStudent(Student student);
}
在數(shù)據(jù)實現(xiàn)層dao/StudentDaoImpl.java
public class StudentDaoImpl implements StudentDao{
@Override
public List<Student> queryAllStudent() {
List<Student> list = new ArrayList<>();
Connection connection = null;
PreparedStatement statement = null;
ResultSet resultSet = null;
try {
connection = JDBCUtils.getConnection();
String sql = "select * from student";
statement = connection.prepareStatement(sql);
resultSet = statement.executeQuery();
while (resultSet.next()) {
Student student = new Student();
student.setId(resultSet.getInt("id"));
student.setName(resultSet.getString("name"));
student.setAge(resultSet.getInt("age"));
list.add(student);
}
}catch (Exception e){
e.printStackTrace();
}finally {
JDBCUtils.release(resultSet,statement,connection);
}
return list;
}
@Override
public void saveStudent(Student student) {
Connection connection = null;
PreparedStatement statement = null;
ResultSet resultSet = null;
try {
connection = JDBCUtils.getConnection();
String sql = "insert into student (name,age) values (?,?)";
statement = connection.prepareStatement(sql);
statement.setString(1,student.getName());
statement.setInt(2,student.getAge());
statement.executeUpdate();
}catch (Exception e){
e.printStackTrace();
}finally {
JDBCUtils.release(resultSet,statement,connection);
}
}
}
第二種就是spring Template
痛點：在第一種寫業(yè)務代碼時，與數(shù)據(jù)庫交互都需要處理
Connection,Statement,ResultSet對象，很繁瑣思路：通過操作模板就能執(zhí)行sql語句操作數(shù)據(jù)庫
通過bean來維護所有人，datasource，template，dao層
在bean里面把datasource引入template，在數(shù)據(jù)實現(xiàn)層引入template，在實現(xiàn)層的代碼中get/set注入屬性，通過屬性操作db
這種思路的好處，重復代碼只需要通過bean管理dao，在dao注入屬性，即可操作數(shù)據(jù)庫-
實現(xiàn)：
pom.xml添加jar包<dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>4.3.5.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-context</artifactId> <version>4.3.5.RELEASE</version> </dependency>
寫resources/beans.xml配置
<!--datasource-->
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://127.0.0.1:3306/zxkdb"/>
<property name="username" value="root"/>
<property name="password" value="root"/>
</bean>
寫單元測試test.java
public class DataSourceTest {
private ApplicationContext context = null;
@Before
public void createContext(){
context = new ClassPathXmlApplicationContext("beans.xml");
}
@After
public void distoryContext(){
context = null;
}
@Test
public void testDataSource(){
DataSource dataSource = (DataSource) context.getBean("dataSource");
Assert.assertNotNull(dataSource);
}
寫業(yè)務代碼
先實體entity/Student.java
public class Student {
private int id;
private String name;
private int age;
get()/set()...
}
在數(shù)據(jù)接口層dao/StudentDao.java
public interface StudentDao {
public List<Student> queryAllStudent();
public void saveStudent(Student student);
}
在數(shù)據(jù)實現(xiàn)層dao/StudentDaoImpl.java
public class SpringJdbcImpl implements StudentDao {
//在數(shù)據(jù)實現(xiàn)層代碼中set/get注入模板屬性
private JdbcTemplate jdbcTemplate;
public JdbcTemplate getJdbcTemplate() {
return jdbcTemplate;
}
public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
this.jdbcTemplate = jdbcTemplate;
}
@Override
public List<Student> queryAllStudent() {
final List<Student> list = new ArrayList<>();
String sql = "select * from student";
jdbcTemplate.query(sql,new RowCallbackHandler(){
@Override
public void processRow(ResultSet rs) throws SQLException {
Student student = new Student();
student.setId(rs.getInt("id"));
student.setName(rs.getString("name"));
student.setAge(rs.getInt("age"));
list.add(student);
}
});
return list;
}
@Override
public void saveStudent(Student student) {
String sql = "insert into student (name,age) values (?,?)";
jdbcTemplate.update(sql,new Object[]{student.getName(),student.getAge()});
}
}
在beans.xml注入實體
<!--模板引用數(shù)據(jù)源-->
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource"/>
</bean>
<!--實體類引用模板-->
<bean id="studentDao" class="com.imooc.dao.SpringJdbcImpl">
<property name="jdbcTemplate" ref="jdbcTemplate"/>
</bean>
第三種就是spring data
痛點：數(shù)據(jù)實現(xiàn)層的代碼雖然少了，但注入模板也存在重復，分頁等通用功能還需要開發(fā)，等等
思路：前面兩種方式，都需要自己在數(shù)據(jù)庫中手動建表，springdata可以實現(xiàn)實體與表映射，直接寫實體類即可，映射通過@注解實現(xiàn)
只需要寫接口，寫方法，不需要寫實現(xiàn)類-
實現(xiàn)：
pom.xml添加mysql驅(qū)動包<!--spring data jpa--> <dependency> <groupId>org.springframework.data</groupId> <artifactId>spring-data-jpa</artifactId> <version>1.8.0.RELEASE</version> </dependency> <dependency> <groupId>org.hibernate</groupId> <artifactId>hibernate-entitymanager</artifactId> <version>4.3.6.Final</version> </dependency>
寫resources/beans-new.xml配置
<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>
<property name="packagesToScan" value="com.imooc"/>
<property name="jpaProperties">
<props>
<prop key="hibernate.ejb.naming_strategy">org.hibernate.cfg.ImprovedNamingStrategy</prop>
<prop key="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect</prop>
<prop key="hibernate.show_sql">true</prop>
<prop key="hibernate.format_sql">true</prop>
<prop key="hibernate.hbm2ddl.auto">update</prop>
</props>
</property>
</bean>
寫單元測試test.java
public class SpringDataTest {
private ApplicationContext context = null;
@Before
public void createContext(){
context = new ClassPathXmlApplicationContext("beans-new.xml");
}
@After
public void distoryContext(){
context = null;
}
@Test
public void testCreateTab(){
// 自動創(chuàng)建表
}
}
寫業(yè)務代碼
之前的事務是靠代碼維護的，現(xiàn)在要交給框架維護，我們需要配置
