7.9w+
社区成员
- 主页
...全文
请发表友善的回复…
发表回复
chenxb1980 2004-10-10
上面写错了
----------
java.io.File file = new java.io.File("/tmp/data");
int fileLength = file.length();
java.io.InputStream fin = new java.io.FileInputStream(file);
java.sql.PreparedStatement pstmt = con.prepareStatement(
--->"insert into table2(a,b,c)values(?,?,?)");
pstmt.setInt(1, id);
pstmt.setInt(2,num);
pstmt.setBinaryStream (3, fin, fileLength);
pstmt.executeUpdate();
fin.close();
----------
java.io.File file = new java.io.File("/tmp/data");
int fileLength = file.length();
java.io.InputStream fin = new java.io.FileInputStream(file);
java.sql.PreparedStatement pstmt = con.prepareStatement(
--->"insert into table2(a,b,c)values(?,?,?)");
pstmt.setInt(1, id);
pstmt.setInt(2,num);
pstmt.setBinaryStream (3, fin, fileLength);
pstmt.executeUpdate();
fin.close();
chenxb1980 2004-10-10
java.io.File file = new java.io.File("/tmp/data");
int fileLength = file.length();
java.io.InputStream fin = new java.io.FileInputStream(file);
java.sql.PreparedStatement pstmt = con.prepareStatement(
--->"insert Table5 SET stuff = ? WHERE index = 4");
pstmt.setBinaryStream (1, fin, fileLength);
pstmt.executeUpdate();
int fileLength = file.length();
java.io.InputStream fin = new java.io.FileInputStream(file);
java.sql.PreparedStatement pstmt = con.prepareStatement(
--->"insert Table5 SET stuff = ? WHERE index = 4");
pstmt.setBinaryStream (1, fin, fileLength);
pstmt.executeUpdate();
mm45 2004-10-10
up 来人呀........
mm45 2004-10-09
详细说下好吗？ 各位老大。。。。。。。。。。 谢谢。。。。。。。。。。。。。。。。。。了呀
fristfly 2004-10-09
insrert 后append
mm45 2004-10-09
to:chinajava(chinajava)
这个是更新的代码啊... 插入的代码怎么写啊..
我是用连接池连接ORACLE的...这个可以通用吗?
这个是更新的代码啊... 插入的代码怎么写啊..
我是用连接池连接ORACLE的...这个可以通用吗?
mm45 2004-10-09
这个答案我得要看哪方面的资料能懂啊? (JAVA的IP流有点明白,但与SQL连用我就晕了..)
chinajava 2004-10-09
java.io.File file = new java.io.File("/tmp/data");
int fileLength = file.length();
java.io.InputStream fin = new java.io.FileInputStream(file);
java.sql.PreparedStatement pstmt = con.prepareStatement(
"UPDATE Table5 SET stuff = ? WHERE index = 4");
pstmt.setBinaryStream (1, fin, fileLength);
pstmt.executeUpdate();
int fileLength = file.length();
java.io.InputStream fin = new java.io.FileInputStream(file);
java.sql.PreparedStatement pstmt = con.prepareStatement(
"UPDATE Table5 SET stuff = ? WHERE index = 4");
pstmt.setBinaryStream (1, fin, fileLength);
pstmt.executeUpdate();