apache-DBUtis 工具类 + druid 完成对表的crud操作报错解决

本文链接：https://blog.csdn.net/qq_46110710/article/details/124411055

apache-DBUtis 工具类 + druid 完成对表的crud操作报错解决

解决方法1

数据库字段类型使用timestamp,实体类对应使用Date(util包下的)

ActorDAO actorDAO = new ActorDAO();
        List<Actor> actors = actorDAO.queryMulti("select * from actor where id >= ?", Actor.class, 1);
        for (Actor actor : actors) {
            System.out.println(actor);
        }

在这里插入图片描述
这样解决，使用apache-DBUtis 工具类没有问题，但是土方法封装得不到全部数据，只能得到日期没有时间

public void testSelectToArrayList() {
        Connection connection = null;
        PreparedStatement preparedStatement = null;
        ResultSet set = null;
        String sql = "select * from actor where id = ?";
        ArrayList<Actor> list = new ArrayList<>();
        try {
            connection = JDBCUtilsByDruid.getConnection();
            System.out.println(connection.getClass());
            preparedStatement = connection.prepareStatement(sql);
            preparedStatement.setInt(1,1);
            set = preparedStatement.executeQuery();
            while (set.next()) {
                int id = set.getInt("id");
                String name = set.getString("name");
                String sex = set.getString("sex");
                java.util.Date borndate = set.getDate("borndate");
                String phone = set.getString("phone");
                list.add(new Actor(id,name,sex,borndate,phone));
            }
            System.out.println(list);
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            JDBCUtilsByDruid.close(set, preparedStatement, connection);
        }
}