Maven项目(v1)

IDEA创建一个Maven工程

1、在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>edu.prj</groupId>
    <artifactId>ssj-v20</artifactId>
    <version>1.0-SNAPSHOT</version>
    <packaging>war</packaging>

    <name>ssj-v20 Maven Webapp</name>
    <!-- FIXME change it to the project's website -->
    <url>http://www.example.com</url>

    <properties>

        <!-- ***** 2033 [druid][props] -->
        <ds.druid.version>1.1.14</ds.druid.version>

        <junit.version>4.12</junit.version>

        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>

        <!-- ****[compile plugin][props] -->
        <java.version>1.8</java.version>
        <jdk.source.version>1.8</jdk.source.version>
        <jdk.target.version>1.8</jdk.target.version>
        <maven.compiler.plugin.version>3.8.1</maven.compiler.plugin.version>
        <maven.compiler.source>1.8</maven.compiler.source>
        <maven.compiler.target>1.8</maven.compiler.target>
        <maven.compiler.compilerVersion>1.8</maven.compiler.compilerVersion>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <project.build.outputEncoding>UTF-8</project.build.outputEncoding>
        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>

        <!-- ****[javaee31][props] -->
        <javaee31.servletapi.version>3.1.0</javaee31.servletapi.version>
        <javaee31.jspapi.version>2.2</javaee31.jspapi.version>
        <javaee31.jstl.version>1.2</javaee31.jstl.version>
        <javaee31.taglibs.version>1.1.2</javaee31.taglibs.version>


        <!-- ****[war empty][props] -->
        <maven.war.plugin.version>3.2.0</maven.war.plugin.version>


        <!-- ***** 0110.[jetty run web app][props] [9.4.19.v20190610] -->
        <maven.jetty.plugin.version>9.4.19.v20190610</maven.jetty.plugin.version>
        <maven.jetty.plugin.port>9091</maven.jetty.plugin.port>
        <!-- ***** 2000. [Spring app][props]-->
        <spring.app.version>5.2.0.RELEASE</spring.app.version>
        <aopalliance.version>1.0</aopalliance.version>
        <asm.version>5.2</asm.version>
        <cglib.version>3.2.10</cglib.version>

        <maven.surefire.plugin.version>2.22.1</maven.surefire.plugin.version>

        <!-- ***** 1051. [jackson][props] -->
        <json.jackson.version>2.10.0</json.jackson.version>
    </properties>

    <dependencies>


        <!--Spring 只需要dependency上下文context -->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>${spring.app.version}</version>
        </dependency>

        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context-support</artifactId>
            <version>${spring.app.version}</version>
        </dependency>

        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-orm</artifactId>
            <version>${spring.app.version}</version>
        </dependency>

        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-web</artifactId>
            <version>${spring.app.version}</version>
        </dependency>

        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>${spring.app.version}</version>
        </dependency>

        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-aspects</artifactId>
            <version>${spring.app.version}</version>
        </dependency>

        <dependency>
            <groupId>aopalliance</groupId>
            <artifactId>aopalliance</artifactId>
            <version>${aopalliance.version}</version>
        </dependency>

        <dependency>
            <groupId>org.ow2.asm</groupId>
            <artifactId>asm</artifactId>
            <version>${asm.version}</version>
        </dependency>

        <dependency>
            <groupId>cglib</groupId>
            <artifactId>cglib</artifactId>
            <version>${cglib.version}</version>
        </dependency>


        <dependency>
            <groupId>com.liuvei.common</groupId>
            <artifactId>liuvei-common</artifactId>
            <version>1.0.0</version>

        </dependency>
        <dependency>
            <groupId>com.liuvei.common.web</groupId>
            <artifactId>liuvei-common-web</artifactId>
            <version>1.0.0</version>

        </dependency>

        <!-- 		c3p0jar -->
        <dependency>
            <groupId>com.mchange</groupId>
            <artifactId>c3p0</artifactId>
            <version>0.9.5.4</version>
        </dependency>

        <!--**** [jdbc.mysql][jar] -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.44</version>
        </dependency>


        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-dbcp2</artifactId>
            <version>2.5.0</version>

        </dependency>

        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-io</artifactId>
            <version>1.3.2</version>

        </dependency>

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.20</version>
        </dependency>


        <dependency>
            <groupId>commons-fileupload</groupId>
            <artifactId>commons-fileupload</artifactId>
            <version>1.3.3</version>

        </dependency>

        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>${junit.version}</version>
            <scope>test</scope>
        </dependency>

        <!-- ****************************************************** -->
        <!-- [javaee31][jar] -->
        <!-- ****************************************************** -->
        <!-- 1)servlet-api和jsp-api的jar包,容器中没有: -->
        <!-- scope默认为provided可比避免打包时复制到lib目录 -->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>javax.servlet-api</artifactId>
            <version>${javaee31.servletapi.version}</version>
            <scope>provided</scope>
        </dependency>

        <dependency>
            <groupId>com.google.code.gson</groupId>
            <artifactId>gson</artifactId>
            <version>2.8.5</version>
        </dependency>


        <dependency>
            <groupId>javax.servlet.jsp</groupId>
            <artifactId>jsp-api</artifactId>
            <version>${javaee31.jspapi.version}</version>
            <scope>provided</scope>
        </dependency>

        <!-- 2)jstl和taglibs的jar包,容器中没有: -->
        <!-- scope默认为compile,打包时会复制到lib目录 -->


        <dependency>
            <groupId>jstl</groupId>
            <artifactId>jstl</artifactId>
            <version>${javaee31.jstl.version}</version>
            <scope>compile</scope>
        </dependency>

        <dependency>
            <groupId>taglibs</groupId>
            <artifactId>standard</artifactId>
            <version>${javaee31.taglibs.version}</version>
            <scope>compile</scope>
        </dependency>
        <!-- ****************************************************** -->
        <!-- ****************************************************** -->


        <!-- ********************************************************************** -->
        <!-- ***** 1031. [ds-dbcp2][jar] -->
        <!-- ********************************************************************** -->
        <!-- 数据库连接池 :dbcp2 -->

        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-dbcp2</artifactId>
            <version>2.5.0</version>
        </dependency>


        <!-- ********************************************************************** -->
        <!-- ***** 1031. [ds-dbcp2][jar] -->
        <!-- ********************************************************************** -->
        <!-- 数据库连接池 :dbcp2 -->

        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-io</artifactId>
            <version>1.3.2</version>
        </dependency>


        <!-- ********************************************************************** -->
        <!-- ***** 1051. [jackson][jar] -->
        <!-- ********************************************************************** -->
        <dependency>
            <groupId>com.fasterxml.jackson.core</groupId>
            <artifactId>jackson-databind</artifactId>
            <version>${json.jackson.version}</version>
        </dependency>
        <!-- ********************************************************************** -->

        <!-- part a2 : spring mvc -->
        <!--        <dependency>-->
        <!--            <groupId>org.springframework</groupId>-->
        <!--            <artifactId>spring-webmvc</artifactId>-->
        <!--            <version>${spring.app.version}</version>-->
        <!--        </dependency>-->
        <!-- ********************************************************************** -->

        <dependency>
            <groupId>commons-fileupload</groupId>
            <artifactId>commons-fileupload</artifactId>
            <version>1.3.3</version>
        </dependency>
        <!-- 	<dependency>
                    <groupId>com.liuvei.common</groupId>
                    <artifactId>liuvei-common</artifactId>
                    <version>1.0.0</version>
                </dependency> -->

        <!-- ********************************************************************** -->
        <!-- ***** 1051. [ds-druid][jar] -->
        <!-- ********************************************************************** -->
        <!-- 数据库连接池 阿里的druid -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
          <version>${ds.druid.version}</version>
        </dependency>
        <!-- ********************************************************************** -->

    </dependencies>


    <build>
        <finalName>ssj-v20</finalName>


        <plugins>


            <!-- ****************************************************** -->
            <!-- ****************************************************** -->
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-compiler-plugin</artifactId>
                <version>3.8.1</version>

                <configuration>
                    <source>${maven.compiler.source}</source>
                    <target>${maven.compiler.target}</target>
                    <encoding>${project.build.sourceEncoding}</encoding>
                </configuration>

            </plugin>


            <!-- ***** 0100. [war empty][plugin] -->
            <!-- ********************************************************************** -->
            <!-- web空处理——空目录处理和无web.xml处理 -->
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-war-plugin</artifactId>
                <version>${maven.war.plugin.version}</version>
                <!-- 解决Cannot detect Web Project version. -->
                <!-- Please specify version of Web Project through Maven project property. -->
                <configuration>
                    <!--<version>${project.war.config.version}</version> -->
                    <includeEmptyDirectories>true</includeEmptyDirectories>
                    <failOnMissingWebXml>false</failOnMissingWebXml>
                </configuration>
            </plugin>
            <!-- ********************************************************************** -->


            <!-- ********************************************************************** -->
            <!-- ***** 0110. [jetty run web app][plugin] -->
            <!-- ********************************************************************** -->
            <!-- 说明1:默认端口号为9090(可自行修改) -->
            <!-- 说明1:默认上下文目录 是项目的artifactId(也可自行修改) -->
            <plugin>
                <groupId>org.eclipse.jetty</groupId>
                <artifactId>jetty-maven-plugin</artifactId>
                <version>${maven.jetty.plugin.version}</version>
                <configuration>
                    <webApp>
                        <contextPath>/${project.artifactId}</contextPath>
                        <descriptor>${basedir}/src/main/webapp/WEB-INF/web.xml</descriptor>
                    </webApp>

                    <webAppSourceDirectory>${project.basedir}/src/main/webapp</webAppSourceDirectory>
                    <scanIntervalSeconds>1</scanIntervalSeconds>
                    <httpConnector>
                        <port>${maven.jetty.plugin.port}</port>
                    </httpConnector>
                </configuration>
            </plugin>
            <!-- ********************************************************************** -->

            <plugin>
                <!--测试防止乱码-->
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-surefire-plugin</artifactId>
                <version>${maven.surefire.plugin.version}</version>
                <configuration>
                    <forkMode>once</forkMode>
                    <!-- IDE控制台输出乱码处理:指定编码方式 -->
                    <argLine>-Dfile.encoding=UTF-8</argLine>
                </configuration>
            </plugin>


        </plugins>


    </build>
</project>

2、applicationContext.xml

模板:(要用是复制 修改即可)
1、_applicationContext_00_mb.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:p="http://www.springframework.org/schema/p"
       xmlns:c="http://www.springframework.org/schema/c"
       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">


</beans>

2、dataSource部分 applicationContext_01_ds.xml

切换时,修改id为dataSource即可

<?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:p="http://www.springframework.org/schema/p"
       xmlns:c="http://www.springframework.org/schema/c"
       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">

    <!--Spring 读取数据库四大金刚的内容 :注意类全名中的子包beans.factory.config -->
    <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
        <property name="location">
            <value>classpath:app.properties</value>
        </property>
    </bean>


    <!-- 定义dbcp数据源————方案一:四大金刚都写在properties -->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
        <!-- 指定JDBC驱动类 -->
        <property name="name" value="${driverClassName}">
        </property>
        <!-- 提供连接数据库的url地址 -->
        <property name="url" value="${url}">
        </property>
        <!-- 提供连接数据库的用户名和密码 -->
        <property name="username" value="${username}"></property>
        <property name="password" value="${password}"></property>

    </bean>

    <!-- 定义dbcp数据源————方案二:四大金刚都写在Spring配置文件中 -->

    <bean id="dataSource2" class="org.apache.commons.dbcp2.BasicDataSource">

        <!-- 指定JDBC驱动类 -->
        <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
        <!-- 提供连接数据库的url地址 -->
        <property name="url">
            <value>
                <![CDATA[jdbc:mysql://127.0.0.1:3306/examsysyzz?useSSL=false&useUnicode=true&characterEncoding=true]]></value>
        </property>
        <!-- 提供连接数据库的用户名和密码 -->
        <property name="username" value="root"></property>
        <property name="password" value="root"></property>

    </bean>


    <!-- 定义dbcp数据源————方案二:四大金刚都写在Properties中 -->
    <bean id="dataSource3" class="com.mchange.v2.c3p0.ComboPooledDataSource"
          lazy-init="true">

        <!-- 指定JDBC驱动类 -->
        <property name="driverClass" value="${driverClassName}"></property>
        <!-- 提供连接数据库的url地址 -->
        <property name="jdbcUrl">
            <value>
                <![CDATA[jdbc:mysql://127.0.0.1:3306/examsysyzz?useSSL=false&useUnicode=true&characterEncoding=true]]></value>
        </property>
        <!-- 提供连接数据库的用户名和密码 -->
        <property name="user" value="${username}"></property>
        <property name="password" value="${password}"></property>

    </bean>

    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">

        <property name="dataSource" ref="dataSource"></property>
    </bean>

    <!--    <context:component-scan base-package="edu.prj.dao.impl,edu.prj.service.impl"/>-->

</beans>

3、applicationContext_40_annotation.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:p="http://www.springframework.org/schema/p"
       xmlns:c="http://www.springframework.org/schema/c"
       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:component-scan base-package="edu.uc.dao.std20,edu.uc.service.impl"/>


</beans>

4、事务管理器的xml配置

applicationContext_03_tx.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:p="http://www.springframework.org/schema/p"
       xmlns:c="http://www.springframework.org/schema/c"
       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">

    <!-- 1、 定义事务管理器的bean(需要注入dataSource) -->
    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"/>
    </bean>

    <!-- 2、 定义事务增强或事务通知(事务处理的代码,可以设置各个方法是否支持事务并配置事务属性) -->
    <tx:advice id="txAdvice" transaction-manager="transactionManager">

        <!-- 定义事务属性,声明事务规则 -->
        <tx:attributes>
            <tx:method name="load" read-only="true"/>
            <tx:method name="list" read-only="true"/>
            <tx:method name="count" read-only="true"/>
            <tx:method name="pager" read-only="true"/>
            <tx:method name="insert" propagation="REQUIRED"/>
            <tx:method name="delete" propagation="REQUIRED"/>
            <tx:method name="update" propagation="REQUIRED"/>

            <!-- NOT_SUPPORTED 不支持事务 -->
            <tx:method name="trans00" propagation="NOT_SUPPORTED"/>
            <!-- REQUIRED 支持事务 -->
            <tx:method name="trans01" propagation="REQUIRED"/>

            <tx:method name="*" propagation="REQUIRED"/>
        </tx:attributes>

    </tx:advice>

    <!-- 3、 aop配置:advisor切面————表示哪些包的哪些类的哪些方法,需要添加事务增加  -->
    <aop:config proxy-target-class="true">
        <!-- 定义切入点:包类方法 -->
        <aop:pointcut id="serviceMethod" expression="execution(* edu.uc.service..*.*(..))"/>
        <!-- 将切入点组合与事务通知 -->
        <aop:advisor pointcut-ref="serviceMethod" advice-ref="txAdvice"/>
    </aop:config>

</beans>

5、在applicationContext.xml中导入其余2个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:p="http://www.springframework.org/schema/p"
       xmlns:c="http://www.springframework.org/schema/c"
       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">


    <aop:aspectj-autoproxy/>

    <import resource="applicationContext_01_ds.xml"/>
 	<import resource="applicationContext_03_tx.xml"/>
    <import resource="applicationContext_40_annotation.xml"/>

</beans>

3、app.properties

STD_DRIVER=com.mysql.jdbc.Driver
STD_URL=jdbc:mysql://127.0.0.1:3306/uc00?useSSL=false&useUnicode=true&characterEncoding=utf8
STD_USERNAME=root
STD_PASSWORD=root

#Druid
url=jdbc:mysql://127.0.0.1:3306/uc00?useSSL=false&useUnicode=true&characterEncoding=utf8
driverClassName=com.mysql.jdbc.Driver
username=root
password=root
filters=stat
maxActive=20
initialSize=2
maxWait=3000
maxIdle=15
minIdle=10
timeBetweenEvictionRunsMillis=60000
minEvictableIdleTimeMillis=300000
validationQuery=SELECT'x'
testWhileIdle=true
testOnBorrow=false
testOnReturn=false
removeAbandoned=true
removeAbandonedTimeout=1800
logAbandoned:true


jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/uc00?useSSL=false&useUnicode=true&characterEncoding=utf8
jdbc.username=root
jdbc.password=root

4、新建目录


分别完善这5个文件目录并mark directory as

将前面的xml文件以及app.properties文件分别放在main与test中的resources目录中

在这里插入图片描述

创建三层结构

1、bean实体层

  1. 添加注释Componet(" ")
  2. 实现java.io.Serializable 并生成UID序列号
  3. 构建一个无参构造方法
  4. 加入对象的属性
  5. 为属性添加getter/setter方法

例子:

package edu.uc.bean;

import org.springframework.stereotype.Component;

import java.util.Date;

@Component("newsCat")
public class NewsCat implements java.io.Serializable{

    private static final long serialVersionUID = -2120504439695282712L;

    public NewsCat() {
    }

    private Long catId;
    private String catName;
    private String catDesc;
    private String status;
    private Long isDeleted;
    private Long createBy;
    private Long updateBy;
    private java.util.Date createOn;
    private java.util.Date updateOn;

    public Long getCatId() {
        return catId;
    }

    public void setCatId(Long catId) {
        this.catId = catId;
    }

    public String getCatName() {
        return catName;
    }

    public void setCatName(String catName) {
        this.catName = catName;
    }

    public String getCatDesc() {
        return catDesc;
    }

    public void setCatDesc(String catDesc) {
        this.catDesc = catDesc;
    }

    public String getStatus() {
        return status;
    }

    public void setStatus(String status) {
        this.status = status;
    }

    public Long getIsDeleted() {
        return isDeleted;
    }

    public void setIsDeleted(Long isDeleted) {
        this.isDeleted = isDeleted;
    }

    public Long getCreateBy() {
        return createBy;
    }

    public void setCreateBy(Long createBy) {
        this.createBy = createBy;
    }

    public Long getUpdateBy() {
        return updateBy;
    }

    public void setUpdateBy(Long updateBy) {
        this.updateBy = updateBy;
    }

    public Date getCreateOn() {
        return createOn;
    }

    public void setCreateOn(Date createOn) {
        this.createOn = createOn;
    }

    public Date getUpdateOn() {
        return updateOn;
    }

    public void setUpdateOn(Date updateOn) {
        this.updateOn = updateOn;
    }
}

2、Dao 业务逻辑层

一、接口层beanDao

  1. 首先创建基类BaseDao接口,Dao层所有接口继承BaseDao

例子:
在这里插入图片描述

  1. 创建BeanDao,继承BaseDao

例子:
在这里插入图片描述

二、实现层beanDaoImpl

1、首先创建基类BaseDaoImpl
例子:

package edu.uc.dao.std20;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class BaseDaoImpl<T> {

    public BaseDaoImpl() {
        System.out.println(this);
    }
    @Autowired
    private JdbcTemplate jdbcTemplate;

    public JdbcTemplate getJdbcTemplate() {
        return jdbcTemplate;
    }

    public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }

    public JdbcTemplate getTmpl() {
        return jdbcTemplate;
    }

    /**
     * 自定义映射器00: 单行转为实体
     *
     * @param rs
     * @return
     * @throws SQLException
     */
    protected T toBean(ResultSet rs) {
        return null;
    }

    /**
     * 自定义映射器01: 结果处理器[实体],在列名和属性名不一致时使用
     *
     * @return
     */
    public org.springframework.jdbc.core.ResultSetExtractor<T> getRshBeanCustom() {

        org.springframework.jdbc.core.ResultSetExtractor<T> handler = null;
        handler = new org.springframework.jdbc.core.ResultSetExtractor<T>() {

            @Override
            public T extractData(ResultSet arg0)
                    throws SQLException, org.springframework.dao.DataAccessException {
                // TODO Auto-generated method stub
                if (arg0.next()) {
                    return toBean(arg0);
                } else {
                    return null;
                }
            }

        };
        return handler;
    }

    /**
     * 自定义映射器02: 结果处理器[实体列表],在列名和属性名不一致时使用
     *
     * @return
     */
    public org.springframework.jdbc.core.ResultSetExtractor<List<T>> getRshBeanListCustom() {
        org.springframework.jdbc.core.ResultSetExtractor<List<T>> handler = null;
        handler = new org.springframework.jdbc.core.ResultSetExtractor<List<T>>() {

            @Override
            public List<T> extractData(ResultSet arg0)
                    throws SQLException, org.springframework.dao.DataAccessException {
                // TODO Auto-generated method stub
                List<T> vList = new ArrayList<T>();
                try {
                    while (arg0.next()) {
                        vList.add(toBean(arg0));
                    }
                } catch (SQLException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();

                    throw new RuntimeException(e);
                }
                return vList;
            }
        };
        return handler;
    }
}

2、创建beanDaoImpl
(1)继承BaseDaoImpl,并实现beanDao
(2)类名上加入注解 @Repository(" beanDao ")

例子:

package edu.uc.dao.std20;

import edu.uc.bean.NewsCat;
import edu.uc.dao.NewsCatDao;
import org.springframework.stereotype.Repository;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

@Repository("newsCatDao")
public class NewsCatDaoImpl extends BaseDaoImpl<NewsCat> implements NewsCatDao {

    @Override
    public List<NewsCat> list() {

        List<NewsCat> list = new ArrayList<NewsCat>();

        StringBuffer sbSQL = new StringBuffer();
        List<Object> paramsList = new ArrayList<Object>();

        sbSQL.append(" select * from NewsCat ");
        sbSQL.append(" where 1 = 1 ");

        String sql = sbSQL.toString();
        Object[] params = paramsList.toArray();

        try {
            list = getTmpl().query(sql, getRshBeanListCustom(), params);
        } catch (Exception e) {
            //若发现异常,会回滚
            throw new RuntimeException(e);

        }
        return list;

    }

    @Override
    public Long update(NewsCat bean) {

        Long result = 0L;

        StringBuffer sbSQL = new StringBuffer();
        List<Object> paramsList = new ArrayList<>();

        sbSQL.append(" update NewsCat set ");
        sbSQL.append(" catName = ? ");
        sbSQL.append(" ,catDesc = ? ");
        sbSQL.append(" ,status = ? ");
        sbSQL.append(" ,isDeleted = ? ");

        sbSQL.append(" ,createBy = ? ");
        sbSQL.append(" ,updateBy = ? ");
        sbSQL.append(" ,createOn = ? ");
        sbSQL.append(" ,updateOn = ? ");
        sbSQL.append(" where catId = ? ");

        paramsList.add(bean.getCatName());
        paramsList.add(bean.getCatDesc());
        paramsList.add(bean.getStatus());
        paramsList.add(bean.getIsDeleted());

        paramsList.add(bean.getCreateBy());
        paramsList.add(bean.getUpdateBy());
        paramsList.add(bean.getCreateOn());
        paramsList.add(bean.getUpdateOn());

        paramsList.add(bean.getCatId());

        String sql = sbSQL.toString();
        Object[] params = paramsList.toArray();

        try {
            result = (long) getTmpl().update(sql, params);
        } catch (Exception e) {
            e.printStackTrace();
            throw new RuntimeException(e);
        } finally {

        }

        return result;
    }

    @Override
    public NewsCat load(Long catId) {

        NewsCat bean = null;

        StringBuffer sbSQL = new StringBuffer();
        List<Object> paramsList = new ArrayList<>();

        sbSQL.append(" select * from NewsCat ");
        sbSQL.append(" where 1=1 ");
        sbSQL.append(" and catId = ? ");

        paramsList.add(catId);

        String sql = sbSQL.toString();
        Object[] params = paramsList.toArray();

        try {
            bean = getTmpl().query(sql, getRshBeanCustom(), params);

        } catch (Exception e) {
            e.printStackTrace();
            throw new RuntimeException(e);
        }

        return bean;
    }

    /**
     * 自定义映射器00: 单行转为实体
     *
     * @param rs
     * @return
     * @throws SQLException
     */
    protected NewsCat toBean(ResultSet rs) {
        NewsCat bean = new NewsCat();
        try {
            bean.setCatId(rs.getLong("catId"));
            bean.setCatName(rs.getString("catName"));
            bean.setCatDesc(rs.getString("catDesc"));
            bean.setStatus(rs.getString("status"));
            bean.setCreateBy(rs.getLong("createBy"));
            bean.setUpdateBy(rs.getLong("updateBy"));
            bean.setCreateOn(rs.getDate("createOn"));
            bean.setUpdateOn(rs.getDate("updateOn"));

        } catch (SQLException e) {
            e.printStackTrace();
        }
        return bean;
    }


}

Service业务层

一、service接口层

1、创建baseService

例子:

package edu.uc.service;

import java.util.List;

public interface BaseService<T> {
    List<T> list();

    Long update(T bean);

    T load(Long catId);

}

2、创建beanService接口类,继承baseService

与Dao层类似

package edu.uc.service;

import edu.uc.bean.NewsCat;

public interface NewsCatService extends BaseService<NewsCat> {

}

二、Service实现层

1、创建基类BaseServiceImpl

package edu.uc.service.impl;

public class BaseServiceImpl<T> {
    
}

2、创建beanServiceImpl,继承baseServiceImpl并实现beanService

类名上添加注解 @Service(" beanService ")
实现Dao层方法时,不能直接实例化
通过@AutoWired 导入

例子

package edu.uc.service.impl;

import edu.uc.bean.NewsCat;
import edu.uc.dao.NewsCatDao;
import edu.uc.service.BaseService;
import edu.uc.service.NewsCatService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Scope;
import org.springframework.stereotype.Service;

import java.util.List;

@Service("newsCatService")
public class NewsCatServiceImpl extends BaseServiceImpl<NewsCat> implements NewsCatService {

    @Autowired
    private NewsCatDao newsCatDao;

    @Override
    public List<NewsCat> list() {
        return newsCatDao.list();
    }

    @Override
    public Long update(NewsCat bean) {
        return newsCatDao.update(bean);
    }

    @Override
    public NewsCat load(Long catId) {
        return newsCatDao.load(catId);
    }
}

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值