java初学之JDBC_时间操作_时间段和日期段查询

开门见山，直接贴图和代码，

package mysql;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import com.mysql.jdbc.PreparedStatement;

public class Testjdbc {
	public static void main(String[] args){
		Connection conn=null;
		java.sql.PreparedStatement stmt=null;
		ResultSet rs=null;
		try{
    		System.out.println("in db");
    		Class.forName("com.mysql.jdbc.Driver"); 
    		long start =System.currentTimeMillis();
    		conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/thc","root","123456");
    		String sql="select * from t_user where regtime between ? and ? ";//预编译&占位符
    		stmt = conn.prepareStatement(sql);
    		stmt.setObject(1,"2017-03-28");
    		stmt.setObject(2,"2017-03-29");
    		
    		rs=stmt.executeQuery();
    		while(rs.next()){
    			System.out.println(rs.getObject(1)+"\t"+rs.getObject(2)+"\t"+rs.getObject(3)+"\t"+rs.getObject(4));
    		}
    		
    	}catch(ClassNotFoundException e){
    		e.printStackTrace();
    	}catch(SQLException e){
    		e.printStackTrace();
    	}finally{
    		try{
    			if(conn!=null){
    				conn.close();
    			}
    		}catch(SQLException e){
    			e.printStackTrace();
    		}
    		try{
    			if(stmt!=null){
    				stmt.close();
    			}
    		}catch(SQLException e){
    			e.printStackTrace();
    		}
    	}
    
	}

}