另: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();
