spring data jpa+ spring +maven

最新推荐文章于 2024-09-11 21:56:39 发布

古怪945

最新推荐文章于 2024-09-11 21:56:39 发布

阅读量3.5k

点赞数 2

分类专栏： JAVASE

本文链接：https://blog.csdn.net/gaodml/article/details/68961156

版权

JAVASE 专栏收录该内容

25 篇文章 0 订阅

订阅专栏

demo pro :https://pan.baidu.com/s/1nvwjnk9

用maven创建一个普通maven project.

目录结构如下

2.pom.xml 配置如下:

<?xml version="1.0" encoding="UTF-8"?>
<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>win.gm945</groupId>
    <artifactId>springdemo</artifactId>
    <version>1.0-SNAPSHOT</version>

    <properties>
        <!-- spring版本号 -->
        <spring.version>4.0.2.RELEASE</spring.version>
        <!-- mybatis版本号 -->
        <mybatis.version>3.2.6</mybatis.version>
        <!-- log4j日志文件管理包版本 -->
        <slf4j.version>1.7.7</slf4j.version>
        <log4j.version>1.2.17</log4j.version>
    </properties>
    <dependencies>
        <!-- spring核心包 -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-core</artifactId>
            <version>${spring.version}</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-web</artifactId>
            <version>${spring.version}</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-oxm</artifactId>
            <version>${spring.version}</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-tx</artifactId>
            <version>${spring.version}</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>${spring.version}</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>${spring.version}</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-aop</artifactId>
            <version>${spring.version}</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context-support</artifactId>
            <version>${spring.version}</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>${spring.version}</version>
        </dependency>
        <!-- 导入Mysql数据库链接jar包 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.30</version>
        </dependency>
        <!-- 导入dbcp的jar包，用来在applicationContext.xml中配置数据库 -->
        <dependency>
            <groupId>commons-dbcp</groupId>
            <artifactId>commons-dbcp</artifactId>
            <version>1.2.2</version>
        </dependency>
        <!-- JSTL标签类 -->
        <dependency>
            <groupId>jstl</groupId>
            <artifactId>jstl</artifactId>
            <version>1.2</version>
        </dependency>
        <!-- 日志文件管理包 -->
        <!-- log start -->
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>${log4j.version}</version>
        </dependency>

        <!-- 格式化对象，方便输出日志 -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>1.1.41</version>
        </dependency>

        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-api</artifactId>
            <version>${slf4j.version}</version>
        </dependency>

        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-log4j12</artifactId>
            <version>${slf4j.version}</version>
        </dependency>
        <!-- log end -->
        <!-- 映入JSON -->
        <dependency>
            <groupId>org.codehaus.jackson</groupId>
            <artifactId>jackson-mapper-asl</artifactId>
            <version>1.9.13</version>
        </dependency>
        <!-- 上传组件包 -->
        <dependency>
            <groupId>commons-fileupload</groupId>
            <artifactId>commons-fileupload</artifactId>
            <version>1.3.1</version>
        </dependency>
        <dependency>
            <groupId>commons-io</groupId>
            <artifactId>commons-io</artifactId>
            <version>2.4</version>
        </dependency>
        <dependency>
            <groupId>commons-codec</groupId>
            <artifactId>commons-codec</artifactId>
            <version>1.9</version>
        </dependency>

        <dependency>
            <groupId>org.hibernate</groupId>
            <artifactId>hibernate-core</artifactId>
            <version>4.3.6.Final</version>
        </dependency>
        <dependency>
            <groupId>org.hibernate</groupId>
            <artifactId>hibernate-entitymanager</artifactId>
            <version>4.3.6.Final</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.data</groupId>
            <artifactId>spring-data-jpa</artifactId>
            <version>1.7.0.RELEASE</version>
        </dependency>

    </dependencies>
</project>

3.spring 配置文件 beans.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"
       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-4.1.xsd
		http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.1.xsd
		http://www.springframework.org/schema/data/jpa http://www.springframework.org/schema/data/jpa/spring-jpa-1.3.xsd">

    <context:annotation-config/>

    <context:component-scan base-package="win.gm945"/>

    <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
        <property name="persistenceUnitName" value="gm945"/>
        <property name="persistenceXmlLocation" value="classpath:/persistence.xml"/>
        <property name="jpaVendorAdapter">
            <bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
                <property name="showSql" value="true"/>
                <property name="database" value="MYSQL"/>
            </bean>
        </property>
    </bean>

    <!-- 自动扫描并注入Spring Data JPA -->
    <jpa:repositories base-package="win.gm945.dao" entity-manager-factory-ref="entityManagerFactory"
                      transaction-manager-ref="transactionManager">
    </jpa:repositories>

    <!-- 配置事务管理器 -->
    <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
        <property name="entityManagerFactory" ref="entityManagerFactory"/>
    </bean>

    <tx:annotation-driven transaction-manager="transactionManager" proxy-target-class="false"/>

</beans>

4. dao层使用jpa

package win.gm945.dao;

import org.springframework.data.jpa.repository.JpaRepository;
import win.gm945.vo.User;

import java.util.List;

/**
 * Created by gm on 17-4-3.
 */
public interface UserDao extends JpaRepository<User, Integer> {
    List<User> getListByage(Integer age);

    @Query(value = "select * from user_t a where time>now()", nativeQuery = true)
    List<User> getListByTime();


    @Query(value="select * from user_t where age>1?",nativeQuery = true)
    List<User> getListByAge(Integer age);

5.servcie层代码,注入dao层

package win.gm945.service;

/**
 * Created by gm on 17-4-2.
 */
public interface TestService {
    public void print();
}

package win.gm945.service.impl;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.stereotype.Service;
import win.gm945.dao.UserDao;
import win.gm945.service.TestService;
import win.gm945.vo.User;

import javax.annotation.Resource;
import java.util.List;

/**
 * Created by gm on 17-4-2.
 */
@Service("testService")
public class TestServiceImpl implements TestService {

    @Value("gaoming")
    private String name;

    @Autowired
    private UserDao dao;

    public void print() {
        System.out.println("----hello world---" + name);
        List<User> users = (List<User>)dao.getListByage(23);
        for(User user:users){
            System.out.println(user);
        }
    }
}

6.controller层代码

package win.gm945.controller;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.stereotype.Controller;
import win.gm945.service.TestService;


/**
 * Created by gm on 17-4-2.
 */
@Controller
public class TestContorller {

    public static void main(String[] args) {
        System.out.println("---start---");
        ApplicationContext applicationContext = new ClassPathXmlApplicationContext("beans.xml");
        TestService testService = (TestService) applicationContext.getBean("testService");
        testService.print();
    }
}

7.数据库和表结构

8.输出

/usr/local/jdk8/bin/java -javaagent:/usr/local/idea-IU-171.3780.95/lib/idea_rt.jar=32915:/usr/local/idea-IU-171.3780.95/bin -Dfile.encoding=UTF-8 -classpath /usr/local/jdk8/jre/lib/charsets.jar:/usr/local/jdk8/jre/lib/deploy.jar:/usr/local/jdk8/jre/lib/ext/cldrdata.jar:/usr/local/jdk8/jre/lib/ext/dnsns.jar:/usr/local/jdk8/jre/lib/ext/jaccess.jar:/usr/local/jdk8/jre/lib/ext/jfxrt.jar:/usr/local/jdk8/jre/lib/ext/localedata.jar:/usr/local/jdk8/jre/lib/ext/nashorn.jar:/usr/local/jdk8/jre/lib/ext/sunec.jar:/usr/local/jdk8/jre/lib/ext/sunjce_provider.jar:/usr/local/jdk8/jre/lib/ext/sunpkcs11.jar:/usr/local/jdk8/jre/lib/ext/zipfs.jar:/usr/local/jdk8/jre/lib/javaws.jar:/usr/local/jdk8/jre/lib/jce.jar:/usr/local/jdk8/jre/lib/jfr.jar:/usr/local/jdk8/jre/lib/jfxswt.jar:/usr/local/jdk8/jre/lib/jsse.jar:/usr/local/jdk8/jre/lib/management-agent.jar:/usr/local/jdk8/jre/lib/plugin.jar:/usr/local/jdk8/jre/lib/resources.jar:/usr/local/jdk8/jre/lib/rt.jar:/home/gm/workspace/java/springdemo/target/classes:/home/gm/repo/org/springframework/spring-core/4.0.2.RELEASE/spring-core-4.0.2.RELEASE.jar:/home/gm/repo/commons-logging/commons-logging/1.1.3/commons-logging-1.1.3.jar:/home/gm/repo/org/springframework/spring-web/4.0.2.RELEASE/spring-web-4.0.2.RELEASE.jar:/home/gm/repo/org/springframework/spring-beans/4.0.2.RELEASE/spring-beans-4.0.2.RELEASE.jar:/home/gm/repo/org/springframework/spring-context/4.0.2.RELEASE/spring-context-4.0.2.RELEASE.jar:/home/gm/repo/org/springframework/spring-oxm/4.0.2.RELEASE/spring-oxm-4.0.2.RELEASE.jar:/home/gm/repo/org/springframework/spring-tx/4.0.2.RELEASE/spring-tx-4.0.2.RELEASE.jar:/home/gm/repo/org/springframework/spring-jdbc/4.0.2.RELEASE/spring-jdbc-4.0.2.RELEASE.jar:/home/gm/repo/org/springframework/spring-webmvc/4.0.2.RELEASE/spring-webmvc-4.0.2.RELEASE.jar:/home/gm/repo/org/springframework/spring-expression/4.0.2.RELEASE/spring-expression-4.0.2.RELEASE.jar:/home/gm/repo/org/springframework/spring-aop/4.0.2.RELEASE/spring-aop-4.0.2.RELEASE.jar:/home/gm/repo/aopalliance/aopalliance/1.0/aopalliance-1.0.jar:/home/gm/repo/org/springframework/spring-context-support/4.0.2.RELEASE/spring-context-support-4.0.2.RELEASE.jar:/home/gm/repo/org/springframework/spring-test/4.0.2.RELEASE/spring-test-4.0.2.RELEASE.jar:/home/gm/repo/mysql/mysql-connector-java/5.1.30/mysql-connector-java-5.1.30.jar:/home/gm/repo/commons-dbcp/commons-dbcp/1.2.2/commons-dbcp-1.2.2.jar:/home/gm/repo/commons-pool/commons-pool/1.3/commons-pool-1.3.jar:/home/gm/repo/jstl/jstl/1.2/jstl-1.2.jar:/home/gm/repo/log4j/log4j/1.2.17/log4j-1.2.17.jar:/home/gm/repo/com/alibaba/fastjson/1.1.41/fastjson-1.1.41.jar:/home/gm/repo/org/slf4j/slf4j-api/1.7.7/slf4j-api-1.7.7.jar:/home/gm/repo/org/slf4j/slf4j-log4j12/1.7.7/slf4j-log4j12-1.7.7.jar:/home/gm/repo/org/codehaus/jackson/jackson-mapper-asl/1.9.13/jackson-mapper-asl-1.9.13.jar:/home/gm/repo/org/codehaus/jackson/jackson-core-asl/1.9.13/jackson-core-asl-1.9.13.jar:/home/gm/repo/commons-fileupload/commons-fileupload/1.3.1/commons-fileupload-1.3.1.jar:/home/gm/repo/commons-io/commons-io/2.4/commons-io-2.4.jar:/home/gm/repo/commons-codec/commons-codec/1.9/commons-codec-1.9.jar:/home/gm/repo/org/hibernate/hibernate-core/4.3.6.Final/hibernate-core-4.3.6.Final.jar:/home/gm/repo/org/jboss/logging/jboss-logging/3.1.3.GA/jboss-logging-3.1.3.GA.jar:/home/gm/repo/org/jboss/logging/jboss-logging-annotations/1.2.0.Beta1/jboss-logging-annotations-1.2.0.Beta1.jar:/home/gm/repo/org/jboss/spec/javax/transaction/jboss-transaction-api_1.2_spec/1.0.0.Final/jboss-transaction-api_1.2_spec-1.0.0.Final.jar:/home/gm/repo/dom4j/dom4j/1.6.1/dom4j-1.6.1.jar:/home/gm/repo/xml-apis/xml-apis/1.0.b2/xml-apis-1.0.b2.jar:/home/gm/repo/org/hibernate/common/hibernate-commons-annotations/4.0.5.Final/hibernate-commons-annotations-4.0.5.Final.jar:/home/gm/repo/org/hibernate/javax/persistence/hibernate-jpa-2.1-api/1.0.0.Final/hibernate-jpa-2.1-api-1.0.0.Final.jar:/home/gm/repo/org/javassist/javassist/3.18.1-GA/javassist-3.18.1-GA.jar:/home/gm/repo/antlr/antlr/2.7.7/antlr-2.7.7.jar:/home/gm/repo/org/jboss/jandex/1.1.0.Final/jandex-1.1.0.Final.jar:/home/gm/repo/org/hibernate/hibernate-entitymanager/4.3.6.Final/hibernate-entitymanager-4.3.6.Final.jar:/home/gm/repo/org/springframework/data/spring-data-jpa/1.7.0.RELEASE/spring-data-jpa-1.7.0.RELEASE.jar:/home/gm/repo/org/springframework/data/spring-data-commons/1.9.0.RELEASE/spring-data-commons-1.9.0.RELEASE.jar:/home/gm/repo/org/springframework/spring-orm/4.0.7.RELEASE/spring-orm-4.0.7.RELEASE.jar:/home/gm/repo/org/aspectj/aspectjrt/1.8.2/aspectjrt-1.8.2.jar:/home/gm/repo/org/slf4j/jcl-over-slf4j/1.7.7/jcl-over-slf4j-1.7.7.jar win.gm945.controller.TestContorller
---start---
log4j:WARN No appenders could be found for logger (org.springframework.core.env.StandardEnvironment).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
----hello world---gaoming
Hibernate: 
    select
        user0_.id as id1_0_,
        user0_.age as age2_0_,
        user0_.password as password3_0_,
        user0_.user_name as user_nam4_0_ 
    from
        user_t user0_ 
    where
        user0_.age=?
User{id=2, userName='test', password='pass', age=23}