如何从Oracle中取出声音文件,并在jsp页面中播放 如何从Oracle中取出声音文件,并在jsp页面中播放,各位大侠帮帮忙! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 音频文件应该可以在数据库中以二进制形式,Blob类型存储,在jsp文件中IO流读取 public User findUser(User user) { User u = null; Connection conn = null; PreparedStatement pstmt = null; ResultSet rs = null; try { conn = DBAccess.newInstance().getConnection(); conn.setAutoCommit(false); String sql = "select userId, userName, userPwd, userState, userRe,image from Users where userId=" + user.getUserId() + " for update"; log.info("sql=[" + sql + "]"); pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); if (rs.next()) { u = new User(); u.setUserId(rs.getInt("userId")); u.setUserName(rs.getString("userName")); u.setUserPwd(rs.getString("userPwd")); u.setUserState(rs.getInt("userState")); u.setUserRe(rs.getString("userRe")); // 从数据库取出图片 oracle.sql.BLOB blob = (oracle.sql.BLOB) rs.getBlob("image"); if (blob.length() > 0) { log.info("blob.length() == " + blob.length()); byte[] bytes = new byte[(int) blob.length()]; BufferedInputStream inputStream = new BufferedInputStream( blob.getBinaryStream()); inputStream.read(bytes, 0, bytes.length); inputStream.close(); u.setImage(bytes); } } conn.commit(); } catch (Exception e) { e.printStackTrace(); try { conn.rollback(); } catch (SQLException e1) { e1.printStackTrace(); } } return u; }以前做的,参考下.. SWFUpload上传组件 有没有人想知道我上次提的那个差8个小时的问题答案? FineReport报表软件应用案例1 关于图片处理的问题? (元旦了,还要加班,唉!!!)大家来一块讨论,解决不了的话,全当散分,用ireport 做不同纸张大小的套打 关于学习struts标签库 请教关于xrpcc的问题 案例的书要不要买 用图片提交表单的问题 网页内容不能即使刷新问题 想实现一个像csdn这样如果有新回复就在页面上有提醒的功能的页面,请提供些思路和做法 登录校验与dwr (ajax)
User u = null;
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
conn = DBAccess.newInstance().getConnection();
conn.setAutoCommit(false);
String sql = "select userId, userName, userPwd, userState, userRe,image from Users where userId="
+ user.getUserId() + " for update";
log.info("sql=[" + sql + "]");
pstmt = conn.prepareStatement(sql);
rs = pstmt.executeQuery();
if (rs.next()) {
u = new User();
u.setUserId(rs.getInt("userId"));
u.setUserName(rs.getString("userName"));
u.setUserPwd(rs.getString("userPwd"));
u.setUserState(rs.getInt("userState"));
u.setUserRe(rs.getString("userRe")); // 从数据库取出图片
oracle.sql.BLOB blob = (oracle.sql.BLOB) rs.getBlob("image");
if (blob.length() > 0) {
log.info("blob.length() == " + blob.length());
byte[] bytes = new byte[(int) blob.length()];
BufferedInputStream inputStream = new BufferedInputStream(
blob.getBinaryStream());
inputStream.read(bytes, 0, bytes.length);
inputStream.close();
u.setImage(bytes);
}
}
conn.commit();
} catch (Exception e) {
e.printStackTrace();
try {
conn.rollback();
} catch (SQLException e1) {
e1.printStackTrace();
}
} return u;
}
以前做的,参考下..