JDBC中对数据类型（如：日期）的转换
java.sql.Date是java.util.Date的子类，转换时需注意。
package jdbc;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.util.Date;/** * * @author HaoWang */public class DateTest { public static void main(String[] args) {// create(4,"wanghao",true,java.sql.Date.valueOf("1987-11-02"),200.3f); create(4,"wanghao",true,new Date(),200.3f); read(4); } public static void create(int sid, String name, boolean sex, Date birthday, Float money) { Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; String sql = null; try { conn = JdbcUtils.getConnection(); sql = "insert into students(sid,name,sex,birthday,money) value (?,?,?,?,?)"; ps = conn.prepareStatement(sql); ps.setInt(1, sid); ps.setString(2, name); ps.setBoolean(3, sex); ps.setDate(4, new java.sql.Date(birthday.getTime())); ps.setFloat(5, money); int i = ps.executeUpdate(); System.out.println("i="+i); } catch (Exception ex) { System.out.println(ex.toString()); } finally { JdbcUtils.free(conn, ps, rs); } } public static void read(int sid) { Connection conn = null; PreparedStatement ps = null; ResultSet rs = null; String sql = null; try { conn = JdbcUtils.getConnection(); sql = "select birthday from students where sid=?"; ps = conn.prepareStatement(sql); ps.setInt(1, sid); rs = ps.executeQuery(); while(rs.next()) { System.out.println(rs.getObject(1)); } } catch (Exception ex) { System.out.println(ex.toString()); } finally { JdbcUtils.free(conn, ps, rs); } }}?