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 =
相关阅读
如何启动Visual Studio 2005中的Visual SQL 2005?多用户同时输入生成一个表格或数据库sybase是用那个程序来执行sql query呢有什么sql,relation algebra转换的软件么sql questionACCESS的测试题软件开发求助Oracle 10gR2 10.2.0.2 for linux X86如何用MFC连接search engine？节日快乐！！MySQL和C的接口？产品类别、产品型号，客户折扣，怎样设计数据库？请教：how to call a COM object in a stored procedure?How to know field names of a record set in SQL Server?FYI: free SQL 2005 e-learning coursesAccess SQL 问题！多谢大家指教MYSQL 的LOG SIZE怎么在不停 变大如何在SYBASE里面show all tables？急问一个奇怪的sql server数据库问题大批量文本的存储与查询，用什么数据库比较合适？