Spring基础12注解和c3p0

1、测试

public class UserController {
    public static void main(String[] args) throws Exception {
        ApplicationContext ac = new ClassPathXmlApplicationContext("ApplicationContext.xml");
        UserService userService = (UserService) ac.getBean("userServiceImpID");
        User user = new User();
        user.setUid("u018");
        user.setName("Perter四号");
        user.setPsw("123456789");
        user.setImg("default.jpg");
        userService.addUser(user);
        List<User> userList = userService.queryAllUser();
        for (Object o :userList) {
            System.out.println(o.toString());
        }

    }
}

2、结果 返回结果

User{uid='u001', name='Jack', psw='999999', img='男孩.jpg'}
User{uid='u002', name='lili', psw='999999', img='男孩.jpg'}
User{uid='u003', name='peter', psw='123456789', img='男孩.jpg'}
User{uid='u004', name='mary', psw='123456789', img='default.png'}
User{uid='u005', name='liMing', psw='123', img='default.img'}
User{uid='u006', name='LiMing', psw='123', img='default.jgp'}
User{uid='u007', name='李白', psw='111111', img='default.jpg'}
User{uid='u008', name='花无缺', psw='123456', img='default.jpg'}
User{uid='u009', name='小鱼儿', psw='123456', img='default.jpg'}
User{uid='u011', name='Peter', psw='123123', img='de'}
User{uid='u012', name='Peter', psw='123123', img='default.jpg'}
User{uid='u015', name='Peter二号', psw='123123', img='default.jpg'}
User{uid='u016', name='Peter二号', psw='123123', img='default.jpg'}
User{uid='u017', name='Perter三号', psw='123456789', img='default.jpg'}
User{uid='u018', name='Perter四号', psw='123456789', img='default.jpg'}
Process finished with exit code 0

3、xml(ApplicationContext.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: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">
    <!-- 开启组件:一般扫描器(扫描注释) -->
    <!-- 扫描范围在com.company -->
    <context:component-scan base-package="com.company"/>
    <!-- 导入数据源信息 -->
    <!-- 放在src下使用classpath: 来找或者可以不加classpath,但是尽量不要这样！！-->
    <context:property-placeholder location="classpath:db.properties"/>
    <!-- 配置c3p0连接池配置 -->
    <bean id="c3p0ID" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="jdbcUrl" value="${jdbc.url}"/>
        <property name="user" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
        <property name="driverClass" value="${jdbc.driver}"/>
    </bean>
    <!-- 配置jdbc模板(jdbcTemplate) -->
    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <!-- 连接数据库(数据源) -->
        <property name="dataSource" ref="c3p0ID"/>
    </bean>
    <!-- 配置UserDaoImp对象 -->
    <bean id="userDaoImpID" class="com.company.dao.UserDaoImp"></bean>
    <!-- 配置UserServiceImp对象 -->
    <bean id="userServiceImpID" class="com.company.service.UserServiceImp"></bean>
</beans>

4、用户服务层接口实现

public class UserServiceImp implements UserService{
    //注解 在XML(ApplicationContext.xml这是我自己的XML)中配置相关对象
    @Autowired
    private UserDao userDao;
    @Override
    public void addUser(User user) throws Exception {
        userDao.addUser(user);
    }

    @Override
    public List<User> queryAllUser() throws Exception {
        return userDao.queryAllUserInfor();
    }
}

5、用户持久层接口shi实现

public class UserDaoImp implements UserDao {
    //@Autowired是注解，但是XML(ApplicationContext.xml)中一定要有JdbcTemplate类(要自己配置)
    @Autowired
    private JdbcTemplate jdbcTemplate;
    @Override
    public void addUser(User user) throws Exception {
        //创建sql语句
        String sql = " insert into user values (?, ?, ?, ?) ";
        //执行sql语句
        jdbcTemplate.update(sql, user.getUid(), user.getName(), user.getPsw(), user.getImg());
    }

    @Override
    public List<User> queryAllUserInfor() throws Exception {
        //创建sql语句
        String sql = " select * from user ";
        //执行sql语句
        List<User> userList = jdbcTemplate.query(sql, new UserMapper());
        return userList;
    }
}

6、用户对象

public class User {
    private String uid;
    private String name;
    private String psw;
    private String img;

    public String getUid() {
        return uid;
    }

    public void setUid(String uid) {
        this.uid = uid;
    }

    public String getName() {
        return name;
    }

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

    public String getPsw() {
        return psw;
    }

    public void setPsw(String psw) {
        this.psw = psw;
    }

    public String getImg() {
        return img;
    }

    public void setImg(String img) {
        this.img = img;
    }

    @Override
    public String toString() {
        return "\nUser{" +
                "uid='" + uid + '\'' +
                ", name='" + name + '\'' +
                ", psw='" + psw + '\'' +
                ", img='" + img + '\'' +
                '}';
    }
}

7、用户对象映射关系

public class UserMapper implements RowMapper<User> {
    @Override
    public User mapRow(ResultSet resultSet, int i) throws SQLException {
        //创建映射关系
        User user = new User();
        //获取数据库信息
        String uid = resultSet.getString("uid");
        String name = resultSet.getString("name");
        String psw = resultSet.getString("psw");
        String img = resultSet.getString("img");
        //映射规则  column  ->  property
        user.setUid(uid);
        user.setName(name);
        user.setPsw(psw);
        user.setImg(img);
        return user;
    }
}