(Java)业务逻辑处理——增删改查

1.实体类

package cn.edu.mju.project1.entity;

public class Band {
    private Integer id;
    private  String name;
    private  String remark;

    public Integer getId() {
        return id;
    }
    public Band(){

    }
    public Band(Integer id,String name,String remark){
        this.id=id;
        this.name=name;
        this.remark=remark;
    }

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

    public String getName() {
        return name;
    }

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

    public String getRemark() {
        return remark;
    }

    public void setRemark(String remark) {
        this.remark = remark;
    }
}

2.新建一个接口和实现类
接口：

package cn.edu.mju.project1.persiste;

import cn.edu.mju.project1.entity.Band;
import cn.edu.mju.project1.util.Pager;

import java.util.List;

public interface IBandDao {
    /**
     * 添加数据到数据库band表中
     * @param band
     * @return
     */
    public boolean insert(Band band);
    /**
     * 根据主键修改数据库表中的相应数据
     * @param band
     * @return
     */
    public boolean update(Band band);
    /**
     * 根据主键删除记录
     * @param id
     * @return
     */
    public boolean delete(Integer id);
    /**
     * 根据主键查询数据
     * @param id 主键编号
     * @return
     */
    public  Band findById(Integer id);
    /**
     * 查询所有的数据
     * @return
     */
    public List<Band> findAll();
    /**
     * 根据条件查询相关数据
     * @param band
     * @return
     */
    public List<Band> find(Band band);
    /**
     * 分页查询相关数据
     * @param page
     * @param pageSize 
     * @param band
     * @return
     */
    public Pager paginate(int page, int pageSize, Band band);

}

实现类：

package cn.edu.mju.project1.persiste.impl;

import cn.edu.mju.project1.entity.Band;
import cn.edu.mju.project1.persiste.IBandDao;
import cn.edu.mju.project1.util.Pager;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

public class BandDao implements IBandDao {
    @Override
    public boolean insert(Band band) {
        boolean ret = false;
        try {
            Connection conn = MySqlDbUtil.getConnection();
            String sql = "INSERT INTO band(name,remark) VALUES(?,?)";
            PreparedStatement pstmt = conn.prepareStatement(sql);
            pstmt.setString(1,band.getName());
            pstmt.setString(2, band.getRemark());
            int  result = pstmt.executeUpdate();
            System.out.println(result);
            if(result > 0){
                ret = true;
            }
            pstmt.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return ret;
    }

    @Override
    public boolean update(Band band) {
        boolean ret = false;
        try {
            Connection conn = MySqlDbUtil.getConnection();
            String sql = "UPDATE band SET name=?,remark=? WHERE id=?";
            PreparedStatement pstmt = conn.prepareStatement(sql);
            pstmt.setString(1,band.getName());
            pstmt.setString(2, band.getRemark());
            pstmt.setInt(3, band.getId());
            int  result = pstmt.executeUpdate();
            if(result > 0){
                ret = true;
            }
            pstmt.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return ret;
    }

    @Override
    public boolean delete(Integer id) {
        boolean ret = false;
        try {
            Connection conn = MySqlDbUtil.getConnection();
            String sql = "DELETE FROM band WHERE id=?";
            PreparedStatement pstmt = conn.prepareStatement(sql);
            pstmt.setInt(1, id);
            int  result = pstmt.executeUpdate();
            if(result > 0){
                ret = true;
            }
            pstmt.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return ret;
    }

    @Override
    public Band findById(Integer id) {
        Band band = null;
        try {
            Connection conn = MySqlDbUtil.getConnection();
            String sql = "SELECT * FROM band WHERE id=?";
            PreparedStatement pstmt = conn.prepareStatement(sql);
            pstmt.setInt(1,id);
            ResultSet rs = pstmt.executeQuery();
            if(rs.next()){
                band = new Band();
                band.setId(rs.getInt("id"));
                band.setName(rs.getString("name"));
                band.setRemark(rs.getString("remark"));
            }
            rs.close();
            pstmt.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return band;
    }

    @Override
    public List<Band> findAll() {
        List<Band> bands = new ArrayList<>();
        try {
            Connection conn = MySqlDbUtil.getConnection();
            String sql = "SELECT * FROM band";
            PreparedStatement pstmt = conn.prepareStatement(sql);
            ResultSet rs = pstmt.executeQuery();
            while(rs.next()){
                Band band = new Band();
                band.setId(rs.getInt("id"));
                band.setName(rs.getString("name"));
                band.setRemark(rs.getString("remark"));
                bands.add(band);
            }
            rs.close();
            pstmt.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return bands;
    }

    @Override
    public List<Band> find(Band band) {
        List<Band> bands = new ArrayList<>();
        List<Object> params = new ArrayList<>();
        try {
            Connection conn = MySqlDbUtil.getConnection();
            String sql = "SELECT * FROM band WHERE 1=1 ";
            if(band != null){
                if(band.getName() != null && !"".equals(band.getName())){
                    sql = sql + " AND name LIKE ? ";
                    params.add("%" + band.getName() + "%");
                }
                if(band.getRemark() != null && !"".equals(band.getRemark())){
                    sql = sql + " AND remark LIKE ? ";
                    params.add("%" + band.getRemark() + "%");
                }
            }
            PreparedStatement pstmt = conn.prepareStatement(sql);
            for(int i=0; i< params.size(); i++){
                pstmt.setObject(i+1, params.get(i));
            }
            ResultSet rs = pstmt.executeQuery();
            while(rs.next()){
                band = new Band();
                band.setId(rs.getInt("id"));
                band.setName(rs.getString("name"));
                band.setRemark(rs.getString("remark"));
                bands.add(band);
            }
            rs.close();
            pstmt.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
        return bands;
    }
}