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实体层
- 添加注释Componet(" ")
- 实现java.io.Serializable 并生成UID序列号
- 构建一个无参构造方法
- 加入对象的属性
- 为属性添加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
- 首先创建基类BaseDao接口,Dao层所有接口继承BaseDao
例子:
- 创建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);
}
}