测试时间处理

客官°小女子只卖身不卖艺 2022-01-05 10:19 170阅读 0赞

package jdbc;
    import java.io.DataInputStream;
    import java.sql.Connection;
    import java.sql.Date;
    import java.sql.DriverManager;
    import java.sql.PreparedStatement;
    import java.sql.SQLException;
    import java.sql.Timestamp;
    import java.util.Random;
    
    import com.mysql.fabric.xmlrpc.base.Data;
    
    
    public class g_Date {
    
    	/**
    	 * 1.测试时间处理Date和Timestamp
    	 * 2.插入随机日期
    	 * 
    	 * java.util.Date
    	 * -子类：java.sql.Date  表示年月日
    	 * -子类：java.sql.Time  表示时分秒
    	 * -子类：java.sql.Timestamp  表示年月日时分秒
    	 * 
    	 * 
    	 * @param args
    	 */
    	public static void main(String[] args) {
    		// TODO Auto-generated method stub
    		Connection conn=null;
    		PreparedStatement ps1=null;
    		try { 
    			Class.forName("com.mysql.jdbc.Driver");
    			conn=DriverManager.getConnection("jdbc:mysql://localhost:3307/TestJdbc","root","123456");
    			
    			for(int i=0;i<1000;i++){
    				ps1=conn.prepareStatement("insert into t_user (username,pwd,regTime,lastLoginTime) values(?,?,?,?)");
    				ps1.setObject(1, "test");
    				ps1.setObject(2, "123456");
    				
    				//插入随机日期
    				int rand=100000000+new Random().nextInt(1000000000);
    				
    				Date date=new Date(System.currentTimeMillis()-rand);
    				ps1.setDate(3, date);
    				Timestamp stamp=new Timestamp(System.currentTimeMillis()-rand);
    				ps1.setTimestamp(4, stamp);
    				ps1.execute();
    			}
    	
    		} catch (ClassNotFoundException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		} catch (SQLException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		}finally{
    			if(conn!=null){
    				try {
    					conn.close();
    				} catch (SQLException e) {
    					// TODO Auto-generated catch block
    					e.printStackTrace();
    				}
    			}
    		}
    
    	}
    
    }

package jdbc;
    import java.security.interfaces.RSAKey;
    import java.sql.Connection;
    import java.sql.Date;
    import java.sql.DriverManager;
    import java.sql.PreparedStatement;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.text.DateFormat;
    import java.text.ParseException;
    import java.text.SimpleDateFormat;
    
    
    
    
    /**
     * 取出指定时间段数据
     * @param args
     */
    
    public class h_QueryDate {
    	
    	/**
    	 * 将字符串代表的日期转为long数字（格式：yyyy-MM-dd hh:mm:ss）
    	 * @param args
    	 */
    	public static long StrToDate(String dateStr){
    		 DateFormat format=new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
    		 try {
    			return format.parse(dateStr).getTime();
    		} catch (ParseException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    			return 0;
    		}
    	}
    	
    
    	public static void main(String[] args) {
    		// TODO Auto-generated method stub
    		Connection conn=null;
    		PreparedStatement ps=null;
    		ResultSet rs=null;
    		
    		try {
    			Class.forName("com.mysql.jdbc.Driver");
    			conn=DriverManager.getConnection("jdbc:mysql://localhost:3307/TestJdbc","root","123456");
    			
    		    ps=conn.prepareStatement("select * from t_user where regTime>? and regTime<? order by regTime");
    		    
    		    Date start=new Date(StrToDate("2019-6-09 10:23:45"));
    		    Date end=new Date(StrToDate("2019-6-15 10:23:45"));
    		    
    		    ps.setObject(1, start);
    		    ps.setObject(2, end);
    		    
    		    rs=ps.executeQuery();
    		    while(rs.next()){
    		    	System.out.println(rs.getInt("id")+"---"+rs.getString("username")+"---"+rs.getDate("regTime"));
    		    }
    		    
    		} catch (ClassNotFoundException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		} catch (SQLException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		}
    		
    
    	}
    
    }