java(273)时间操作，时间段和日期段查询

我们用jdbc测试通过查找时间段和日期段

下面是两种方式

package com.imust.jdbc;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Timestamp;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;

public class Demo7 {

    public static void main(String[] args) throws Exception {

        Connection conn = null;
        java.sql.PreparedStatement pstl = null;
        ResultSet rs = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/testjdbc", "root", "zzf540266546");
        String sql = "select * from t_user where regTime > ? and regTime < ?";
        pstl = conn.prepareStatement(sql);
        //定义起始时间
        java.sql.Date start = new java.sql.Date(str2Date("2017-4-10 10:23:45"));
        //定义结束时间
        java.sql.Date end = new java.sql.Date(str2Date("2017-4-10 10:23:45"));
        pstl.setObject(1, start);
        pstl.setObject(2, end);

        //方式二
        conn.prepareStatement(sql);
        Timestamp start1 = new Timestamp(str2Date("2015-4-14 10:10:20"));
        Timestamp end1 = new Timestamp(str2Date("2015-4-18 9:9:10"));
        pstl.setObject(1, start1);
        pstl.setObject(2, end1);

        rs = pstl.executeQuery();
        while(rs.next()){
           System.out.println(rs.getInt("id")+rs.getString("username")+rs.getDate("regTime"));  
           System.out.println(rs.getInt("id")+rs.getString("username")+rs.getTimestamp("regTime")); 
        }
    }

    /**
     * 将字符串代表的日期转为long数字(格式 yyyy-MM-dd hh:mm:ss)
     * @param dateStr
     * @return
     */
    public static long str2Date(String dateStr){
        DateFormat format = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
        try {
            return format.parse(dateStr).getTime();
        } catch (ParseException e) {
            e.printStackTrace();
            return 0;
        }

    }

}