[4]jdbc中的数据类型与日期问题

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

public class DateTest {

	/**
	 * @param args
	 * @throws SQLException
	 */
	public static void main(String[] args) throws SQLException {
		// create("name2", new Date(), 500.0f);
		Date d = read(7);
		System.out.println(d);
	}

	static Date read(int id) throws SQLException {
		Connection conn = null;
		Statement st = null;
		ResultSet rs = null;
		Date birthday = null;
		try {
			// 2.建立连接
			conn = JdbcUtils.getConnection();
			// conn = JdbcUtilsSing.getInstance().getConnection();
			// 3.创建语句
			st = conn.createStatement();

			// 4.执行语句
			rs = st.executeQuery("select birthday  from user where id=" + id);

			// 5.处理结果
			while (rs.next()) {
				//birthday = new Date(rs.getDate("birthday").getTime());
				birthday = rs.getDate("birthday");
			}
		} finally {
			JdbcUtils.free(rs, st, conn);
		}
		return birthday;
	}

	static void create(String name, Date birthday, float money)
			throws SQLException {
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		try {
			// 2.建立连接
			conn = JdbcUtils.getConnection();
			// conn = JdbcUtilsSing.getInstance().getConnection();
			// 3.创建语句
			String sql = "insert into user(name,birthday, money) values (?, ?, ?) ";
			ps = conn.prepareStatement(sql);
			ps.setString(1, name);
			ps.setDate(2, new java.sql.Date(birthday.getTime()));
			ps.setFloat(3, money);

			// 4.执行语句
			int i = ps.executeUpdate();

			System.out.println("i=" + i);
		} finally {
			JdbcUtils.free(rs, ps, conn);
		}
	}
}

 jdbc中的数据类型与日期问题