如何根据日期和名称删除对应行。

Question

如何根据日期和名称删除对应行。

```java
package com.bwcf.dao;

import com.bwcf.pojo.Dormitory;

import java.util.List;

public interface DormitoryDao {
    //新增
    public String adddormitory(Dormitory dormitory);

    //删除
    public String deletedormitory(String dormitory);

    //修改
    public String updatedormitory(Dormitory dormitory);

    //查询1
    public Dormitory querydormitory(String dormitory);

    //查询2
    public List<Dormitory> querydormitory();
    
}

```java
package com.bwcf.dao.impl;

import com.bwcf.dao.DormitoryDao;
import com.bwcf.pojo.Dormitory;

import java.util.List;

public class DormitoryDaoImpl extends BaseDao implements DormitoryDao {
    @Override
    public String adddormitory(Dormitory dormitory) {

        String sql = "insert into b_sushe(Createtime,dormitory,dianbiao1,dianbiao2,name1,name2,name3,name4,name5,name6) values(?,?,?,?,?,?,?,?,?,?)";
        return String.valueOf(update(sql,dormitory.getCreatetime(),dormitory.getDormitory(),dormitory.getDianbiao1(),dormitory.getDianbiao2(),
                dormitory.getName1(),dormitory.getName2(),dormitory.getName3(),dormitory.getName4(),dormitory.getName5(),dormitory.getName6()));
    }

    @Override
    public String deletedormitory(String dormitory) {
        String sql = "delete from b_sushe where Createtime = ? AND dormitory = ?";
        return String.valueOf(update(sql,dormitory));
    }

    @Override
    public String updatedormitory(Dormitory dormitory) {
        String sql = "update b_sushe set Createtime  = ?,dormitory = ?,dianbiao1 = ?,dianbiao2 = ?,name1 = ?,name2 = ?,name3 = ?,name4 = ?,name5 = ?,name6 = ?";
        return String.valueOf(update(sql,dormitory.getCreatetime(),dormitory.getDormitory(),dormitory.getDianbiao1(),dormitory.getDianbiao2(),
                dormitory.getName1(),dormitory.getName2(),dormitory.getName3(),dormitory.getName4(),dormitory.getName5(),dormitory.getName6()));
    }

    @Override
    public Dormitory querydormitory(String dormitory) {
        String sql = "select Createtime,dormitory,dianbiao1,dianbiao2,name1,name2,name3,name4,name5,name6 from b_sushe where dormitory = ?";
        return (Dormitory) queryForList(Dormitory.class,sql,dormitory);
    }

    @Override
    public List<Dormitory> querydormitory() {
        String sql = "select Createtime,dormitory,dianbiao1,dianbiao2,name1,name2,name3,name4,name5,name6 from b_sushe";
        return queryForList(Dormitory.class,sql);
    }
}

package com.bwcf.test;

import com.bwcf.dao.DormitoryDao;
import com.bwcf.dao.impl.DormitoryDaoImpl;
import com.bwcf.pojo.Dormitory;
import org.junit.Test;

public class DormitoryDaoTest {

    private DormitoryDao dormitoryDao = new DormitoryDaoImpl();

    @Test
    public void adddormitory() {
        dormitoryDao.adddormitory(new Dormitory("2023-02-06","A02",1111,2222,"章子怡",null,null,null,null,null));
    }

    @Test
    public void deletedormitory() {
        dormitoryDao.deletedormitory()
    }

    @Test
    public void updatedormitory() {
    }

    @Test
    public void querydormitory() {
    }

    @Test
    public void testQuerydormitory() {
    }
}

Answer 1

你的代码没贴全，猜着写了下。

daoimpl中的del方法改成下面这样

@Override
    public String deletedormitory(Dormitory dormitory) {
        String sql = "delete from b_sushe where Createtime = ? AND dormitory = ?";
        return String.valueOf(update(sql,dormitory.getCreatetime(),dormitory.getDormitory()));
    }

DormitoryDaoTest 类中的deletedormitory方法改成这样

    @Test
    public void deletedormitory() {
        dormitoryDao.deletedormitory(new Dormitory("2023-02-06","A02",1111,2222,"章子怡",null,null,null,null,null))
    }