Spring AOP

1.  切点pointcut类

public class UserService {

    public void findAllUser(){
        System.out.println("查询全部用户。。。");
    }
}

2.  切面aspect类

public class AdUserService {
    public void before(){
        System.out.println("增强之前before()...");
    }
    public void after(){
        System.out.println("增强之后after()...");
    }
}

3.  springContext.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:aop="http://www.springframework.org/schema/aop"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/aop https://www.springframework.org/schema/aop/spring-aop.xsd">

<!--    1.配置对象-->
    <bean id="userService" class="com.liu.demo.service.UserService"></bean>
    <bean id="adUserService" class="com.liu.demo.AdUserService"></bean>
<!-- 2.配置AOP操作 -->
    <aop:config >
        <!--       切点 被增强的方法-->
        <aop:pointcut id="pointcut1" expression="execution(* com.liu.demo.service.*.*(..))"/>
        <!--        切面 增强的方法-->
        <aop:aspect id="aspect" ref="adUserService">
            <aop:before pointcut-ref="pointcut1" method="before" ></aop:before>
            <aop:after pointcut-ref="pointcut1" method="after" ></aop:after>
        </aop:aspect>
    </aop:config>
</beans>

4. 结果

public class Test {
public static void main(String[]args){
    //1.找到配置文件
    ApplicationContext classPath = new ClassPathXmlApplicationContext("springContext.xml");
    //2.通过spring配置文件加载类对象
    UserService bean = classPath.getBean(UserService.class);
    bean.findAllUser();
}
}

小案例通过dbcp实现增删改查。

项目结构

springContext2.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"
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">
<!--自动扫描注解-->
    <context:component-scan base-package="com.liu.demo.*"></context:component-scan>
<!--    1.加载数据库配置文件-->
    <context:property-placeholder file-encoding="UTF-8" location="db.properties"></context:property-placeholder>
<!--    2.链接数据库配置文件-->
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName" value="${jdbc.driver}"></property>
        <property name="url" value="${jdbc.url}"></property>
        <property name="username" value="${jdbc.user}"></property>
        <property name="password" value="${jdbc.pwd}"></property>
    </bean>

    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"></property>
    </bean>
</beans>

db.properties

jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/schooldb?characterEncoding=utf8&serverTimezone=UTC
jdbc.user=root
jdbc.pwd=123456

DAO

@Repository
public class UserDao implements RowCallbackHandler {
    private List<User> list = new ArrayList<>();
    @Autowired
    JdbcTemplate jdbcTemplate;
    public List<User> findAllUser(){
        String sql = "select * from users";
        jdbcTemplate.query(sql,this);
        return this.list;
    }

    @Override
    public void processRow(ResultSet resultSet) throws SQLException {
        User user = new User();
        user.setId(resultSet.getInt("id"));
        user.setName(resultSet.getString("username"));
        user.setAccount(resultSet.getString("account"));
        user.setPassword(resultSet.getString("password"));
        list.add(user);

    }

    public void addUser(User user) {
        String sql = "insert into users values(?,?,?,?)";
        jdbcTemplate.update(sql,user.getId(),user.getName(),user.getAccount(),user.getPassword());
    }

    public void updateUser(int id,User user) {
        String sql = "update users set id=?,username=?,account=?,password=? where id=?";
        jdbcTemplate.update(sql, user.getId(), user.getName(), user.getAccount(), user.getPassword(), id);
    }

    public void delleteUser(int id) {
        String sql = "delete  from users where id = ?";
        jdbcTemplate.update(sql,id);
    }
}

service

@Service
public class UserService {
@Autowired
    UserDao dao;
//由于业务层暂时没有逻辑，简单的写写
    public List<User> findAllUser(){
        return dao.findAllUser();
    }

    public void addUser(User user) {
        dao.addUser(user);
    }

    public void updateUser(int id,User user) {
        dao.updateUser(id,user);
    }

    public void deleteUser(int id) {
        dao.delleteUser(id);
    }
}

controller  这里没有真正的前后端交互

@Controller
public class Test {
//@Autowired
//UserService userService;
public static void main(String[]args){
    //必须读取配置文件
    ApplicationContext applicationContext = new ClassPathXmlApplicationContext("springContext2.xml");
    UserService userService = (UserService)applicationContext.getBean("userService");
    //1.查询
    List<User> allUser = userService.findAllUser();
    System.out.println(allUser);
    //2.增加
    /*
    User user = new User(3, "张飞", "1003", "333333");
    userService.addUser(user);*/
    //3.修改
   /* int id=3;
    User user = new User(3,"赵云","1004","555555");
    userService.updateUser(id,user);*/
    //4.删除
   /* int id = 3;
    userService.deleteUser(id);*/
}

}

entity

public class User {
    int id;
    String name;
    String account;
    String password;

    public User() {

    }

    public User(int id, String name, String account, String password) {
        this.id = id;
        this.name = name;
        this.account = account;
        this.password = password;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", account='" + account + '\'' +
                ", password='" + password + '\'' +
                '}';
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

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

    public String getAccount() {
        return account;
    }

    public void setAccount(String account) {
        this.account = account;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }
}

还有一个简单的数据库