- 387 名前：デフォルトの名無しさん mailto:sage [2017/02/05(日) 21:45:53.48 ID:1Zv0XByL.net]
- >>360
↓のソースで試したけどできたよ
//CREATE TABLE filetest (filename text, filedate bytea);
Connection conn = ;
String fileName = ;
{
File file = new File(fileName);
FileInputStream fis = new FileInputStream(file);
byte[] data = new byte[(int)file.length()];
fis.read(data);
PreparedStatement ps = conn.prepareStatement("INSERT INTO filetest VALUES (?, ?)");
ps.setString(1, file.getName());
ps.setBytes(2, data);
ps.executeUpdate();
ps.close();
fis.close();
}
{
PreparedStatement ps = conn.prepareStatement("SELECT filedate FROM filetest WHERE filename = ?");
ps.setString(1, fileName);
ResultSet rs = ps.executeQuery();
if (rs != null) {
while (rs.next()) {
byte[] imgBytes = rs.getBytes(1);
System.out.print(new String(imgBytes, "UTF-8"));
}
rs.close();
}
ps.close();
}
|
 |
