JDBC中文本数据与二进制数据处理

1.二进制数据

		import java.io.File;
		import java.io.FileInputStream;
		import java.io.FileNotFoundException;
		import java.io.FileOutputStream;
		import java.io.IOException;
		import java.io.InputStream;
		import java.io.OutputStream;
		import java.sql.Connection;
		import java.sql.PreparedStatement;
		import java.sql.ResultSet;
		import java.sql.SQLException;
		import java.sql.Statement;
		import org.junit.Test;
		/**
		 * 该类主要实现对二进制数据的保存和读取
		 * @author Administrator
		 *
		 */
		public class BlobOperation {
	    @Test
	    public void saveBlob() throws SQLException, FileNotFoundException
	    {
	        //获得连接对象
	        Connection conn=JdbcUtils.getConnection();
	        //获得预处理对象
	        PreparedStatement pstmt=conn.prepareStatement("insert into imagetable values(?,?)");
	        File file=new File("src/youjiao.jpg");
	        InputStream in=new FileInputStream(file);
	        pstmt.setString(1, "1");
	        pstmt.setBinaryStream(2,in, (int)file.length());
	        //执行sql语句
	        pstmt.executeUpdate();
	        JdbcUtils.release(null, pstmt, conn);
	    }

	    @Test
	    public void QueryBlob() throws SQLException, Exception
	    {
	        Connection conn=JdbcUtils.getConnection();
	        PreparedStatement pstmt=conn.prepareStatement("SELECT * FROM imagetable");
	        ResultSet rs=pstmt.executeQuery();
	        while(rs.next())
	        {
	            int id=rs.getInt("id");
	            InputStream in=rs.getBinaryStream("image");
	            File f=new File("src/5.jpg");
	            OutputStream os=new FileOutputStream(f);
	            Byte[] bs=new byte[2014];
	            int b=0;
	
	            while((b=in.read(bs))!=-1)
	            {
	                os.write(bs, 0, b);
	            }
	            in.close();
	            os.close();
	        }
	        JdbcUtils.release(null, pstmt, conn);
	    }
	}

2.大文本数据

		import java.io.BufferedReader;
		import java.io.BufferedWriter;
		import java.io.File;
		import java.io.FileNotFoundException;
		import java.io.FileReader;
		import java.io.FileWriter;
		import java.io.Reader;
		import java.sql.Connection;
		import java.sql.PreparedStatement;
		import java.sql.ResultSet;
		import java.sql.SQLException;
		import org.junit.Test;
		/**
		 * 该类主要实现对大文本数据的保存和读取
		 * @author Administrator
		 *
		 */
		public class ClobOperation {

	    @Test
	    public void saveClob() throws SQLException, FileNotFoundException
	    {
	        //获得连接对象
	        Connection conn=JdbcUtils.getConnection();
	        //获得预处理对象
	        PreparedStatement pstmt=conn.prepareStatement("insert into bigtext values(?,?)");
	        pstmt.setString(1, "1");
	        File file=new File("src/原创诗歌.txt");
	        FileReader reader=new FileReader(file);
	        pstmt.setCharacterStream(2, reader,(int)file.length());
	        //执行sql语句
	        pstmt.executeUpdate();
	        JdbcUtils.release(null, pstmt, conn);
	    }
	
	    @Test
	    public void QueryClob() throws SQLException, Exception
	    {
	        Connection conn=JdbcUtils.getConnection();
	        PreparedStatement pstmt=conn.prepareStatement("SELECT * FROM bigtext");
	        ResultSet rs=pstmt.executeQuery();
	        while(rs.next())
	        {
	            int id=rs.getInt("id");
	            Reader rd=rs.getCharacterStream("txt");
	            File f=new File("src/a.txt");
	            BufferedWriter bw=new BufferedWriter(new FileWriter(f));
	            BufferedReader  br=new BufferedReader(rd);
	            String s="";
	            while((s=br.readLine())!=null)
	            {
	                bw.write(s);
	                bw.newLine();
	            }
	            br.close();
	            bw.close();
	        }
	        JdbcUtils.release(null, pstmt, conn);
	    }
	}