实习19

实习19
结构

user

package com.zhongruan.bean;

public class User {
    private int id;
    private String zh;
    private String mm;

    public int getId() {
        return id;
    }

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

    public String getZh() {
        return zh;
    }

    public void setZh(String zh) {
        this.zh = zh;
    }

    public String getMm() {
        return mm;
    }

    public void setMm(String mm) {
        this.mm = mm;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", zh='" + zh + '\'' +
                ", mm='" + mm + '\'' +
                '}';
    }
}

userdao

package com.zhongruan.dao.Impl;

import com.zhongruan.bean.User;
import com.zhongruan.dao.IUserDao;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Component;

import java.util.List;

@Component
public class UserDao implements IUserDao {
    @Autowired
    private JdbcTemplate jdbcTemplate;
    @Override
    public List<User> findAll(){
        String sql="select * from dr";
        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 dr where id=?";
        jdbcTemplate.update(sql,id);
    }

    @Override
    public void add(String zh, String mm) {
        String sql="insert into dr(zh,mm) values (?,?)";
        jdbcTemplate.update(sql,zh,mm);
    }

    @Override
    public void update(int id, String zh, String mm) {
        String sql="update dr set zh=?,mm=? where id=?";
        jdbcTemplate.update(sql,zh,mm,id);
    }
}

iuserdao

package com.zhongruan.dao;

import com.zhongruan.bean.User;
import org.springframework.jdbc.core.JdbcTemplate;

import java.util.List;

public interface IUserDao {
    List<User> findAll();
    void delete(int id);
    void add(String zh,String mm);
    void update(int id,String zh,String mm);
}

userservice

package com.zhongruan.service.Impl;

import com.zhongruan.bean.User;
import com.zhongruan.dao.IUserDao;
import com.zhongruan.service.IUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

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 delete(int id) {
        userDao.delete(id);
    }

    @Override
    public void add(String zh, String mm) {
        userDao.add(zh,mm);
    }

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

iuserservice

package com.zhongruan.service;

import com.zhongruan.bean.User;

import java.util.List;

public interface IUserService {
    List<User> findAll();
    void delete(int id);
    void add(String zh,String mm);
    void update(int id,String zh,String mm);
}

test

package com.zhongruan.test;

import com.zhongruan.bean.User;
import com.zhongruan.dao.IUserDao;
import com.zhongruan.service.IUserService;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import java.util.List;

public class Test {
    public static void main(String[] args){
//        User user=new User();
//        user.setZh("hhhhhh");
//        user.setMm("123");
        ApplicationContext context=new ClassPathXmlApplicationContext("spring.xml");
//        IUserService userService=(IUserService) context.getBean("userService");
//        userService.findAll();

//        User user=(User) context.getBean("user");
//        System.out.println(user);

//        IUserDao userDao=(IUserDao) context.getBean("userDao");
//        List<User> users=userDao.findAll();
//        userDao.delete(14);
//        System.out.println(users);

//        IUserService userService=(IUserService) context.getBean("userService");
//        List<User> users1=userService.findAll();
//        System.out.println(users1);
//        userService.add("whb","1");
//        List<User> users2=userService.findAll();
//        System.out.println(users2);
        IUserService userService=(IUserService) context.getBean("userService");
        List<User> users1=userService.findAll();
        System.out.println(users1);
        userService.update(28,"whb","12");
        List<User> users2=userService.findAll();
        System.out.println(users2);
    }
}