1。将xml文档存储为一个文本块
//
create a table to hold the manuals for the games
Statement s = conn.createStatement();
s.executeUpdate( " create table manuals(gameid int, manual long varchar) " );
conn.commit();
// open and read xml document representing game manual
File file = new File( " manuals.xml " );
InputStream is = new FileInputStream(file);
// create a prepared statement to execute this update
PreparedStatement ps = conn.preparedStatement( " insert into manuals value(?,?) " );
// set the value of the first parameter gameid
ps.setInt( 1 , 1285757 );
// set the value of the second parameter manual
ps.setAsciiStream( 2 , is, ( int )file.length());
// execute the update
ps.execute();
conn.commit();
Statement s = conn.createStatement();
s.executeUpdate( " create table manuals(gameid int, manual long varchar) " );
conn.commit();
// open and read xml document representing game manual
File file = new File( " manuals.xml " );
InputStream is = new FileInputStream(file);
// create a prepared statement to execute this update
PreparedStatement ps = conn.preparedStatement( " insert into manuals value(?,?) " );
// set the value of the first parameter gameid
ps.setInt( 1 , 1285757 );
// set the value of the second parameter manual
ps.setAsciiStream( 2 , is, ( int )file.length());
// execute the update
ps.execute();
conn.commit();
2.从列中读取blob类型的xml数据
Statement s
=
conn.createStatement();
Result rs = s.executeQuery( " select * from manuals " );
while (rs.next()) {
int id = rs.getInt( " gameid " );
InputStream bis = rs.getAsciiStream( " manual " );
ByteArrayOutputStream bos = new ByteArrayOutputStream();
int ch = 0 ;
while ((ch = bis.read()) != - 1 )
bos.write(ch);
System.out.println( " gameid: " + id + " " + " namual: " + new String(bos.toByteArray()));
}
Result rs = s.executeQuery( " select * from manuals " );
while (rs.next()) {
int id = rs.getInt( " gameid " );
InputStream bis = rs.getAsciiStream( " manual " );
ByteArrayOutputStream bos = new ByteArrayOutputStream();
int ch = 0 ;
while ((ch = bis.read()) != - 1 )
bos.write(ch);
System.out.println( " gameid: " + id + " " + " namual: " + new String(bos.toByteArray()));
}