package com.lzy.jdbc;
import java.sql.Connection;
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;
public class Demo06 {
public static long str2Date(String dateStr) {//把传入的日期转变为long型返回
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) {
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs = null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/testjdbc", "root", "123456");
ps=conn.prepareStatement("select * from t_user where regTime>? and regTime<?");
java.sql.Date start=new java.sql.Date(str2Date("2020-11-15 12:12:12"));
java.sql.Date end=new java.sql.Date(str2Date("2020-11-21 12:12:12"));
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();
}finally{
try {
if(ps!=null){
ps.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
try {
if(conn!=null){
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}