JDBC数据类型

1. 详细信息见java.sql.Types
2. 几种特殊且比较常用的类型
   1.DATA,TIME,TIMESTAMP—>date,time,datetime
   存：ps.setDate(i,d); ps.setTime(i,t); ps.setTimestamp(i, ts);
   取：rs.getDate(i); rs.getTime(i); rs.getTimestamp(i);

/**
     * 插入时对时间的处理
     * @param name
     * @param age
     * @param birthday
     */
    public static void create(String name, int age, Date birthday) {
        Connection conn = null;
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            // 建立连接
            conn = JdbcUtils.getConnection();
            // 创建语句
            String sql = "insert into user(name,age,birthday)"
                    + "values(?,?,?)";
            ps = conn.prepareStatement(sql);
            ps.setString(1, name);
            ps.setInt(2, age);
            //处理date类型参数
            ps.setDate(3, new java.sql.Date(birthday.getTime()));
            // 执行语句
            int i = ps.executeUpdate();
            System.out.println("i=" + i);
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            JdbcUtils.free(rs, ps, conn);
        }
    }

2.CLOB --->text
  存：ps.setCharacterStream(index, reader, length);
         ps.setString(i, s);
  取：reader = rs. getCharacterStream(i);
     reader = rs.getClob(i).getCharacterStream();

/**
 * 对文本类型的数据的插入
 */
    public static void create() {
        Connection conn = null;
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            // 建立连接
            conn = JdbcUtils.getConnection();
            // 创建语句
            String sql = "insert into clob_test(clob_text)"
                    + "values(?)";
            ps = conn.prepareStatement(sql);
            File file=new File("src/cn/wtj/jdbc/JdbcUtils.java");
            Reader reader=new BufferedReader(new FileReader(file));
            ps.setCharacterStream(1,reader,file.length());
            // 执行语句
            int i = ps.executeUpdate();
            reader.close();
            System.out.println("i=" + i);
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            JdbcUtils.free(rs, ps, conn);
        }
    }

3.BLOB --> blob
   存：ps.setBinaryStream(i, inputStream, length);
   取：rs.getBinaryStream(i);
       rs.getBlob(i).getBinaryStream(); 

public static void create() {
        Connection conn = null;
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            // 建立连接
            conn = JdbcUtils.getConnection();
            // 创建语句
            String sql = "insert into blob_test(big_bit)"
                    + "values(?)";
            ps = conn.prepareStatement(sql);
            File file=new File("src/cn/wtj/jdbc/20150419.jpg");
            InputStream in=new BufferedInputStream(new FileInputStream(file));
            ps.setBinaryStream(1,in,file.length());
            System.out.println(sql);
            // 执行语句
            int i = ps.executeUpdate();
            in.close();
            System.out.println("i=" + i);
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            JdbcUtils.free(rs, ps, conn);
        }
    }