jdbc（插入大对象及读取大对象、存储过程）

/**
 * 插入大对象
 */
    @Test
    public void testSavePic(){
        Connection conn=null;
        Statement st=null;
        PreparedStatement pst=null;
        try {
            conn=DBUtils.getConn();
            conn.setAutoCommit(false);//事物不能自动提交
            st=conn.createStatement();
            long start = System.currentTimeMillis();
            String sql="insert into stu(sid,name,pic,info) values(?,?,?,?)";
            pst=conn.prepareStatement(sql);
            pst.setInt(1, 1);
            pst.setString(2, "tim");
            //设置大对象
            File file =new File("D:\arch\unarch/b.jpg");
            FileInputStream fis = new FileInputStream(file);
            pst.setBinaryStream(3, fis,file.length());//设置二进制流，指定长度
            pst.setString(4, "xxxxxx");
            pst.executeUpdate();
             conn.commit();//提交事务
             System.out.println(System.currentTimeMillis()-start);
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        finally{
            DBUtils.closeAll(null, st, conn);
        }
    }

2、读取大对象

/**
 * 对取大对象
 */
    @Test
    public void testReadPic(){
        Connection conn=null;
        Statement st=null;
        PreparedStatement pst=null;
        try {
            conn=DBUtils.getConn();
            conn.setAutoCommit(false);//事物不能自动提交
            st=conn.createStatement();
            long start = System.currentTimeMillis();
            String sql="select pic from stu where sid=?";
            pst=conn.prepareStatement(sql);
            pst.setInt(1, 1);
            ResultSet rs = pst.executeQuery();
            if(rs.next()){
                byte[] bytes = rs.getBytes(1);
                FileOutputStream fos = new FileOutputStream("d:/kk.jpg");
                fos.write(bytes);
                fos.close();
            }
                    
             conn.commit();//提交事务
             System.out.println("over");
             System.out.println(System.currentTimeMillis()-start);
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        finally{
            DBUtils.closeAll(null, st, conn);
        }
    }

 3、存储过程

    /**
     * 测试存储过程1
     */
        @Test
        public void testInsertBig(){
            Connection conn=null;
            Statement st=null;
            PreparedStatement pst=null;
            long start = System.currentTimeMillis();
            try {
                conn=DBUtils.getConn();
                conn.setAutoCommit(false);//事物不能自动提交
                CallableStatement cas = conn.prepareCall("{call up_biginsert(?)}");
                cas.setInt(1, 1000000);
                cas.execute();
                 conn.commit();//提交事务
                 cas.close();
                 System.out.println("over");
                 System.out.println(System.currentTimeMillis()-start);
            } catch (Exception e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
            finally{
                DBUtils.closeAll(null, st, conn);
            }
        }
    /**
     * 测试存储过程2
     */
        @Test
        public void testProcedure(){
            Connection conn=null;
            Statement st=null;
            PreparedStatement pst=null;
            long start = System.currentTimeMillis();
            try {
                conn=DBUtils.getConn();
                conn.setAutoCommit(false);//事物不能自动提交
                CallableStatement cas = conn.prepareCall("{call up_add(?,?,?)}");
                cas.setInt(1, 1);
                cas.setInt(2, 2);
                cas.registerOutParameter(3, Types.INTEGER);
                cas.execute();
                int r=cas.getInt(3);
                System.out.println(r);
                 conn.commit();//提交事务
                 cas.close();
                 System.out.println("over");
                 System.out.println(System.currentTimeMillis()-start);
            } catch (Exception e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
            finally{
                DBUtils.closeAll(null, st, conn);
            }
        }