10.10

最新推荐文章于 2025-10-22 16:59:33 发布

原创最新推荐文章于 2025-10-22 16:59:33 发布 · 106 阅读

0 ·

CC 4.0 BY-SA版权

Spring
1 IOC 控制反转控制权的转移帮我们New对象
2 DI 依赖注入
3 AOP面向切面

使用spring
1 导jar包
2 配置xml

Spring注解
1 xml开启扫描
2在类上加注解

<?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 http://www.springframework.org/schema/context/spring-context.xsd">

    <context:component-scan base-package="com.gm"></context:component-scan>

    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
        <property name="url" value="jdbc:mysql://127.0.0.1:3306/zjgm?characterEncoding=utf-8"></property>
        <property name="username" value="root"></property>
        <property name="password" value="123456"></property>
    </bean>

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


</beans>

import java.util.List;
@Component
public class UserDao implements IUserDao {
    @Autowired
    private JdbcTemplate jdbcTemplate;
    @Override
    public List<User> findAll() {
        String sql = "select * from fuser";
        BeanPropertyRowMapper<User> rowMapper = new BeanPropertyRowMapper<>(User.class);
        List<User> users = jdbcTemplate.query(sql,rowMapper);
        return users;
    }

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

    @Override
    public void update(int id, String username, String password) {
        String sql = "update fuser set username=?,password=? where id=?";
        jdbcTemplate.update(sql,username,password,id);
    }

    @Override
    public void insert(String username, String password) {
        String sql = "insert into fuser(username,password,type) value(?,?,1)";
        jdbcTemplate.update(sql,username,password);
    }

import java.util.List;
@Service
public class UserService implements IUserService {
    @Autowired
    private IUserDao userDao;
    @Override
    public List<User> findAll() {
        List<User> users = userDao.findAll();
        return users;
    }

    @Override
    public void insert(String username, String password) {
        userDao.insert(username,password);
    }

    @Override
    public void update(int id, String username, String password) {
        userDao.update(id,username,password);
    }

    @Override
    public void delete(int id) {
        userDao.delete(id);
    }
}