datetest.java

来自「各种数据保存：字符型」· Java 代码 · 共 63 行

package cn.itcast.jdbc;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.util.Date;

public class DateTest {

	/**
	 * @param args
	 * @throws Exception
	 */
	public static void main(String[] args) throws Exception {
		// addUser(new Date());
		System.out.println(readUser(6));
		System.out.println("end");
	}

	static void addUser(Date birthDay) throws SQLException {
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			String sql = "insert into user(name, age, birth_day) values(?,?,?)";
			conn = JdbcUtils.getConnection();
			ps = conn.prepareStatement(sql);
			ps.setString(1, "name");
			ps.setInt(2, 20);
			ps.setTimestamp(3, new Timestamp(birthDay.getTime()));
			int i = ps.executeUpdate();
			System.out.println("i=" + i);
		} finally {
			JdbcUtils.realse(rs, ps, conn);
		}
	}

	static Date readUser(int id) throws Exception {
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		Date d = null;
		try {
			conn = JdbcUtils.getConnection();
			String sql = "select birth_day from user where id=?";
			ps = conn.prepareStatement(sql);
			ps.setInt(1, id);
			rs = ps.executeQuery();

			while (rs.next()) {
				Timestamp ts = rs.getTimestamp("birth_day");
				d = new Date(ts.getTime());
			}
		} finally {
			JdbcUtils.realse(rs, ps, conn);
		}
		return d;
	}

}