您好,欢迎来到三六零分类信息网!老站,搜索引擎当天收录,欢迎发信息

文件类数据导入与导出数据库_MySQL

2024/3/22 10:08:19发布25次查看
create table(…,content mediumtext,image mediumblob……);
另:blob,text最大64kb,blob对大小写敏感,text不敏感;
mediumblob,mediumtext最大16mb;
longblob,longtext最大4gb;
txt读入:以字符流的形式读入
fileinputstream f=new fileinputstream(d:/a.txt);
bufferedreader dr=new bufferedreader(new inputstreamreader(f));
pstmt.setcharacterstream(3, dr,f.available());
或者是以字符串的形式读入
filereader d=new filereader(d:/a.txt);
char[] a = new char[1024];
int c;
  stringbuffer buffer = new stringbuffer();
    while((c = d.read(a)) != -1)
    {
buffer.append(a, 0, c);
     }    
   pstmt.setstring(3, buffer.tostring());
txt读出:可以直接以字符串的形式读出来,pstmt.getstring()…
也可以以流的形式读出来:
reader rd=rs.getcharacterstream(1);
        bufferedreader br=new bufferedreader(rd);
        string str=;
        string s=null;
        while((s=br.readline())!=null)   
                str=str+s+/n;       
        system.out.println(str);
图片的读入:
fileinputstream isimg=new fileinputstream(d:/a.bmp);
pstmt.setbinarystream(4, isimg,isimg.available());
图片的读出:
blob blob=rs.getblob(2);
bufferedinputstream bis=new bufferedinputstream(blob.getbinarystream());
bufferedoutputstream bos=new bufferedoutputstream(
                new fileoutputstream(d:/ab.bmp));
        byte[] buffer =new byte[1024];
        int count=-1;
        while((count=bis.read(buffer,0,1024))!=-1)
        {   
            bos.write(buffer,0,count);
        }
        bos.flush();
        bos.close();
该用户其它信息

VIP推荐

免费发布信息,免费发布B2B信息网站平台 - 三六零分类信息网 沪ICP备09012988号-2
企业名录 Product