JDBC UserDAOImpl

import com.jdbc.bean.User;

import java.sql.Connection;
import java.util.List;

/**
 * @program: Connection
 * @description: UserDAO的实现类
 * @author: Mr.Fan
 * @create: 2021-05-30 13:52
 **/
public class UserDAOImpl extends BaseDAO<User> implements UserDAO{

    @Override
    public void insert(Connection conn, User user) {
        String sql = "insert into list2(name, money)values(?,?)";
        update(conn, sql, user.getName(), user.getMoney());
    }

    @Override
    public void deleteById(Connection conn, int id) {
        String sql = "delete from list2 where id = ?";
        update(conn, sql, id);
    }

    @Override
    public void updateById(Connection conn, User user) {
        String sql = "update list2 set name = ?, money = ? where id = ?";
        update(conn, sql, user.getName(), user.getMoney(), user.getId());
    }

    @Override
    public User getUserById(Connection conn, int id) {
        String sql = "select * from list2 where id = ?";
        User user = getInstance(conn, sql, id);
        return user;
    }

    @Override
    public List<User> getAll(Connection conn) {
        String sql = "select * from list2";
        List<User> list = getForList(conn, sql);
        return list;
    }

    @Override
    public Long getCount(Connection conn) {
        String sql = "select count(*) from list2";
        return getValue(conn, sql);
    }
}