JDBC基本操作3

原创于 2023-05-16 11:32:56 发布 · 80 阅读

CC 4.0 BY-SA版权

文章标签：

该代码示例展示了如何使用Java进行数据操作，包括创建Dog对象，通过Scanner获取用户输入来设置属性，然后保存到数据库中。提供了save方法插入新记录，update方法更新已有记录的name和love值，以及delete方法根据id删除记录。

数据的增删改

public static void main(String[] args) {

Dog dog = new Dog();
Scanner scanner = new Scanner(System.in);
System.out.println("请输入名字");
dog.setName(scanner.next());
System.out.println("类别");
dog.setStrain(scanner.next());
dog.setLove(80);
dog.setHealth(100);
dog.setDatetime(new Date(System.currentTimeMillis()));
System.out.println(dog);

}

public int save(Dog dog) {
    String saveSql ="insert into dog(name,health,love,strain,datetime) values(?,?,?,?,?)";
    int num = super.executeUpdate(saveSql, dog.getName(), dog.getHealth(), dog.getLove(), dog.getStrain(), dog.getDatetime());
    return num;

}

public int update(Dog dog) {
    String updateSql = "update dog set name=?,love=? where id=?";
    int num=super.executeUpdate(updateSql, dog.getName(), dog.getLove(), dog.getId());
    return num;

}

public int delete(Dog dog) {
    String deleteSql = "delete from dog where id=?";
    int num = super.executeUpdate(deleteSql, dog.getId());
    return num;

}