package com;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.util.Date;
import utils.DBConnection;
public class demo {
public void add(String content, Date lastTime) throws SQLException {
Connection conn = DBConnection.getConn();
PreparedStatement ps = conn.prepareStatement("insert into daily(content,lasttime) values(?,?)");
ps.setString(1, content);
ps.setDate(2, new java.sql.Date(lastTime.getTime())); // 只存储年月日
ps.setTimestamp(2, new Timestamp(lastTime.getTime()));
int i = ps.executeUpdate();
System.out.println(i);
}
public void queryAll() throws SQLException{
Connection conn = DBConnection.getConn();
PreparedStatement ps = conn.prepareStatement("select content,submitTime,lastTime from daily");
ResultSet rs = ps.executeQuery();
// SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
while(rs.next())
{
String content = rs.getString("content");
Date d1 = rs.getTimestamp("submitTime");
Date d2 = rs.getTimestamp("lastTime");
System.out.println(content+"--"+d1+"--"+d2);
}
}
public static void main(String[] args) throws SQLException {
new demo().add("sdsa", new Date());
new demo().queryAll();
}
}
