How to insert image to DB2 ?# Database - 数据库
s*i
1 楼
dear all :
How to insert image in a table of DB2 ?
please tall me,thank you !!
How to insert image in a table of DB2 ?
please tall me,thank you !!
q*e
2 楼
The best way for you is to go to
http://www.redbooks.ibm.com
and search all db2 materials(input db2 to search), choose
associate platform and tools you use.
If you use java, you can also go to
http://java.sun.com/docs/books/tutorial/jdbc/jdbc2dot0/index
.html
and read "Using SQL3 Datatypes" for more detail.
【在 s******i 的大作中提到】
: dear all :
: How to insert image in a table of DB2 ?
: please tall me,thank you !!
f*h
3 楼
An example in Java:
Suppose you have a table (id varchar, image blob)
public static void loadImage(Connection con, String fileName, String
tableName, String idValue){
File imageFile;
try{
imageFile = new File(fileName);
} catch (Exception e) {
System.out.println("File not found!");
return;
}
String queryString = "INSERT INTO "+tableName+" VALUES(?,?)";
try{
PreparedStatement pstmt =
Suppose you have a table (id varchar, image blob)
public static void loadImage(Connection con, String fileName, String
tableName, String idValue){
File imageFile;
try{
imageFile = new File(fileName);
} catch (Exception e) {
System.out.println("File not found!");
return;
}
String queryString = "INSERT INTO "+tableName+" VALUES(?,?)";
try{
PreparedStatement pstmt =
相关阅读
招聘oracle9作者seems it's better to download JHQ le.oracle problemsdata mining tools? helpJDBC and embedded SQL programmingRemote Oracle database connection using ASPhow to call pl/sql in vb?请问有没有现成的管理文献的数据库？Help: Perl DBI to access oracle数据库问题求解怎么将mysql装到别的目录下Re: 有把ORACLE PL/SQL Package自动变成SQL Server Package的东东吗How to create a new database under SQL 7.0 from remote host?what is the size limitation of Oracle JDBC Statement?HELP!! How to run SQL Server 7 in my local computer?how to dump a file from OracleRe: How to change Default SQL String Buffer Size(1K) for ODBC DriverDatabase Comparsion Charthelp: question on oracle sys_context()请问广义表的英文怎么说? 多谢