public void testJdbc() {
    String url = "dbLink";
    try(Connection conn = DriverManager.getConnection(url, "root", "password")){
        // 加载MySQL驱动
        Class.forName("com.mysql.cj.jdbc.Driver");
        int author = 1;
        String date = "2018.06.10";
        String sql = "SELECT id, title, content, create_time FROM article WHERE author_id = " + author
                + " AND create_time > '" + date + "'";
        Statement stmt = conn.createStatement();
        ResultSet rs = stmt.executeQuery(sql);
        List<Article> articles = new ArrayList<>(rs.getRow());
        while (rs.next()) {
            Article article = new Article();
            article.setId(rs.getInt("id"));
            article.setTitle(rs.getString("title"));
            article.setContent(rs.getString("content"));
            article.setCreateTime(rs.getDate("create_time"));
            articles.add(article);
        }
        System.out.println("Query SQL ==> " + sql);
        System.out.println("Query Result: ");
        articles.forEach(System.out::println);
    } catch (ClassNotFoundException | SQLException e) {
        e.printStackTrace();
    }
}

public void testMyBatis() throws IOException {
	String resource = "mybatis-config.xml";
    InputStream inputStream = Resources.getResourceAsStream(resource);
    SqlSessionFactory sqlSessionFactory = new
            SqlSessionFactoryBuilder().build(inputStream);
    inputStream.close();
    try(SqlSession session = sqlSessionFactory.openSession()) {
        ArticleDao articleDao = session.getMapper(ArticleDao.class);
        List<Article> articles = articleDao.
                findByAuthorAndCreateTime(1, "2018-06-10");
        System.out.println(articles);
    }
}
inteface ArticleDao {
    @Query({"SELECT id, title, content, create_time FROM article WHERE author_id = #{id} AND create_time > #{time}"})
	List<Article> findByAuthorAndCreateTime(int id, String time);
}