Spring---JDBC

最近学了一下Spring的JDBC框架,写一篇文章总结一下,因为不太常用,我就简单总结一下增删改查的用法,这里是基于XML配置进行的
注意:我这里使用的是自己的数据库,请将配置信息里的datasource数据源信息以及sql语句改成自己的电脑上的

  • domain实体类
public class User {
     private String account;
     private String password;
     private Float balance;
     public User(String account, String password, Float balance) {
     this.account = account;
     this.password = password;
     this.balance = balance;
     }
        public User(){}
        @Override
     public String toString() {
            return "User{" +
                    "account='" + account + ''' +
                    ", password='" + password + ''' +
                    ", balance=" + balance +
                    '}';
     }
        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;
     }
        public Float getBalance() {
            return balance;
     }
        public void setBalance(Float balance) {
            this.balance = balance;
     }
}
  • dao层的类
public class TestJDBC {
    //数据源:在配置文件中配置,通过Spring自动注入
     private DataSource dataSource;
     //调用增删改查的执行者
     private JdbcTemplate jdbcTemplate;
     public TestJDBC(){}
     
     //初始化
     public TestJDBC(DataSource dataSource){
        this.dataSource = dataSource;
        jdbcTemplate = new JdbcTemplate(this.dataSource);
     }
     public void insert(User user){
        //通过?代替传递进去的参数,必须和update方法传进去的参数顺序一致
        String sql = "insert into atm values(?, ?, ?)";
        jdbcTemplate.update(sql, user.getAccount(), user.getPassword(), user.getBalance());
     }
     public void delete(String account){
        String sql = "delete from atm where account = ?";
        jdbcTemplate.update(sql, account);
     }
     public void update(User user){
        String sql = "update atm set account = ?, password = ?, balance = ? where account = ?";
        jdbcTemplate.update(sql, user.getAccount(), user.getPassword(), user.getBalance(), user.getAccount());
     }
        //查询一条记录
     public User selectOne(String account){
        //通过策略模式,将查询的结果包装成User对象
        String sql = "select * from atm where account = ?";
        return jdbcTemplate.queryForObject(sql, new RowMapper<User>(){
             @Override
             public User mapRow(ResultSet resultSet, int i) throws SQLException {
                String account = resultSet.getString("account");
                 String password = resultSet.getString("password");
                 Float balance = resultSet.getFloat("balance");
                 return new User(account, password, balance);
             }
            }, account);
     }
        //查询多条记录
     public List<User> selectList(){
            String sql = "select *from atm";
            //query方法根据该方法的返回值类型,将所有记录包装成List对象,而策略模式是将每一行记录包装成User对象
     return jdbcTemplate.query(sql, new RowMapper<User>() {
                @Override
     public User mapRow(ResultSet resultSet, int i) throws SQLException {
                    String account = resultSet.getString("account");
     String password = resultSet.getString("password");
     Float balance = resultSet.getFloat("balance");
     return new User(account, password, balance);
     }
            });
     }
}
  • 配置信息
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans
 https://www.springframework.org/schema/beans/spring-beans.xsd">

<!--    JDBC-->
     <bean id="userJdbcTemplate" class="com.cjh.dao.TestJDBC" autowire="constructor"></bean>
     <bean id="datasource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
         <property name="driverClassName" value="com.mysql.cj.jdbc.Driver"/>
         <property name="url" value="jdbc:mysql://localhost:3306/bank?serverTimezone=CST"/>
         <property name="username" value="root"/>
         <property name="password" value="123456"/>
     </bean>
</beans>
  • 主函数调用
public class TestMain {
    public static void main(String[] args) {
        System.out.println(userDao.selectUserByAccount("2018"));
        ApplicationContext context = new ClassPathXmlApplicationContext("ApplicationContext.xml");
        TestJDBC testJDBC = (TestJDBC) context.getBean("userJdbcTemplate");
        //testJDBC.insert(new User("0000", "0000", 999.0f));
        //testJDBC.insert(new User("0001", "0000", 999.0f));
        //testJDBC.delete("0000");
        //testJDBC.update(new User("0001", "1234", 999.0f));
        System.out.println(testJDBC.selectList());
    }
}
阅读 86

推荐阅读