查询的时候如何获取sql中Date型的数据

之前那个用的时ResultSet的方法，我想问Apache Commons DBUtils那个QueryRunner有没有相应的办法可以获取

同学你好，QueryRunner没有对应的方法。获得日期数据直接调用对应属性的get方法就可以了。

例如：

​

祝学习愉快~

package imooc.com.entities;

import java.util.Date;

public class News {
private  int id;
private  String title,content;
private Date creat_time;

public News() {
    }

public News(int id, String title, String content, Date creat_time) {
this.id = id;
this.title = title;
this.content = content;
this.creat_time = creat_time;
    }

public int getId() {
return id;
    }

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

public String getTitle() {
return title;
    }

public void setTitle(String title) {
this.title = title;
    }

public String getContent() {
return content;
    }

public void setContent(String content) {
this.content = content;
    }

public Date getCreat_time() {
return creat_time;
    }

public void setCreat_time(Date creat_time) {
this.creat_time = creat_time;
    }

@Override
    public String toString() {
return "News{" +
"id=" + id +
", title='" + title + '\'' +
", content='" + content + '\'' +
", creat_time=" + creat_time +
'}';
    }
}

​package imooc.com.command;

import com.alibaba.druid.pool.DruidDataSourceFactory;
import com.alibaba.druid.pool.ha.selector.DataSourceSelectorFactory;
import imooc.com.entities.News;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import java.util.Properties;
import java.util.Scanner;

public class QueryCommand implements Command {
    @Override
    public void execute() {
        Properties properties = new Property().getProperties(QueryCommand.class);
        Connection conn = null;
        PreparedStatement stmt = null;
        ResultSet rs = null;
        try {
            //前期准备
            DataSource dataSource = DruidDataSourceFactory.createDataSource(properties);
            conn = dataSource.getConnection();
            conn.setAutoCommit(false);
            //查询执行
           /* System.out.println("请输入要查询的页数");
            Scanner si = new Scanner(System.in);
            int page = si.nextInt();*/
            String sql = "select * from News ";
            QueryRunner qr = new QueryRunner(dataSource);
            List<News> list = qr.query(sql,new BeanListHandler<>(News.class));
            for (News news : list) {
                System.out.println(news);
            }
           /* stmt = conn.prepareStatement(sql);
            rs = stmt.executeQuery();
           while(rs.next()){
               Integer id = rs.getInt("id");
               String title = rs.getString("title");
               String content = rs.getString("content");
               java.util.Date date = rs.getDate("create_time");
               News news = new News(id, title, content, date);
               System.out.println(news);
           }*/
        } catch (Exception e) {
            e.printStackTrace();
        }finally {
            new EndConnect().endConnect(rs,stmt,conn);
        }
    }
}

我这样获取的东西输出的create_time值为null，也就是用QueryRunner的方法时没有成功获取到Date型的数据