MVC—MySQL增删改查测试

在persist包下的impl中的BandDao实施

public class BandDao implements IBandDao {
    @Override
    public Boolean insert(band band) {
        boolean ret = false;

        try {
            Connection connn =MySqlDbUtil.getConnection();
            String sql ="INSERT INTO band(name,remark,status) VALUES(?,?,?）";
            PreparedStatement stmt = connn.prepareStatement(sql);

            stmt.setString(1,band.getName());
            stmt.setString(2,band.getRemark());
            stmt.setByte(3,band.getStatus());
            int i = stmt.executeUpdate();
            stmt.close();
            if(i>0){
                ret=true;
            }
            stmt.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return ret;
    }

    @Override
    public Boolean delete(Integer id) {
        boolean ret = false;

        try {
            Connection connn =MySqlDbUtil.getConnection();
            String sql ="DELETE FROM  band WHERE id=?";
            PreparedStatement stmt = connn.prepareStatement(sql);

            stmt.setInt(1,id);

            int i = stmt.executeUpdate();
            stmt.close();
            if(i>0){
                ret=true;
            }
            stmt.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return ret;
    }

    @Override
    public Boolean updata(band band) {
        boolean ret = false;

        try {
            Connection connn =MySqlDbUtil.getConnection();
            String sql ="UPDATE  band SET name=?,remark=?,status=? WHERE id=?";
            PreparedStatement stmt = connn.prepareStatement(sql);

            stmt.setString(1,band.getName());
            stmt.setString(2,band.getRemark());
            stmt.setByte(3,band.getStatus());
            stmt.setInt(4,band.getId());
            int i = stmt.executeUpdate();
            stmt.close();
            if(i>0){
                ret=true;
            }
            stmt.executeUpdate();
        } catch (SQLException 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 stmt = conn.prepareStatement(sql);
            stmt.setInt(1,id);
            ResultSet rs = stmt.executeQuery();
            if (rs.next()){
                band = new band();
                band.setId( rs.getInt("id"));
                band.setName(rs.getString("name"));
                band.setRemark(rs.getString("remark"));
                band.setStatus(rs.getByte("status"));


            }
            rs.close();
            stmt.close();
        } catch (SQLException 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 stmt = conn.prepareStatement(sql);
            ResultSet rs = stmt.executeQuery();
            while (rs.next()){
                band  band = new band();
                band.setId( rs.getInt("id"));
                band.setName(rs.getString("name"));
                band.setRemark(rs.getString("remark"));
                band.setStatus(rs.getByte("status"));
                bands.add(band);

            }
            rs.close();
            stmt.close();;
        } catch (SQLException e) {
            e.printStackTrace();
        }

        return bands;
    }