图片上传保存到数据库问题

0 0

图片上传保存到数据库问题30

自己做了个图片上传保存到数据库的小程序，报错了，自己经验少，希望各位高手给指点一二！谢谢
数据库结构：
create table IMAGE
(
NAME VARCHAR2(20),
SEX   VARCHAR2(2),
IMAGE BLOB
)

下面是程序代码：

AddUserInfoServlet文件代码：

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.lzt.dao.AddUserInfoDao;

public class AddUserInfoServlet extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
doPost(request, response);

}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
request.setCharacterEncoding("GBK");
String name=request.getParameter("name");
String sex=request.getParameter("sex");
String image=request.getParameter("image");
AddUserInfoDao add=new AddUserInfoDao();
boolean flag= add.addInfo(name, sex, image);
if(flag){
response.sendRedirect("success.jsp");
}else{
response.sendRedirect("index.jsp");
}
}
}

AddUserInfoDao文件代码：

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class AddUserInfoDao {
public boolean addInfo(String name,String sex,String image){
Connection conn=null;
PreparedStatement pstmt=null;
FileInputStream fis=null;
File file=null;
try{
   Class.forName("oracle.jdbc.driver.OracleDriver");
   conn=DriverManager.getConnection("jdbc:oracle:thin:@lizhitao:1521:LZT","EZGADATA","EZGADATA");
   file=new File(image);
   long L=file.length();
   int i=(int)L;
   fis=new FileInputStream(file);
   String strSQL="INSERT INTO IMAGE(name,sex,image) VALUES(?,?,?)";
   pstmt=conn.prepareStatement(strSQL);
   pstmt.setString(1, name);
   pstmt.setString(2, sex);
   pstmt.setBinaryStream(3, fis, i);
   if(pstmt.executeUpdate()>0){
    return true;
   }
   else{
    return false;
   }
}catch(ClassNotFoundException ex){
   ex.printStackTrace();
   return false;
}catch(SQLException ex){
   ex.printStackTrace();
   return false;
}
catch(IOException ex){
   ex.printStackTrace();
   return false;
}
finally{
   try{
    fis.close();
    pstmt.close();
    conn.close();
   }catch(Exception ex){
    ex.printStackTrace();
   }
}
}

}

报错信息如下：

10/09/01 15:21:44 java.sql.SQLException: ORA-01460: 转换请求无法实现或不合理
10/09/01 15:21:44 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:189)
10/09/01 15:21:44 at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:242)
10/09/01 15:21:44 at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:554)
10/09/01 15:21:44 at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1478)
10/09/01 15:21:44 at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:888)
10/09/01 15:21:44 at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2076)
10/09/01 15:21:44 at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1986)
10/09/01 15:21:44 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2697)
10/09/01 15:21:44 at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:457)
10/09/01 15:21:44 at com.lzt.dao.AddUserInfoDao.addInfo(AddUserInfoDao.java:29)
10/09/01 15:21:44 at com.lzt.manager.AddUserInfoServlet.doPost(AddUserInfoServlet.java:27)
10/09/01 15:21:44 at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
10/09/01 15:21:44 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
10/09/01 15:21:44 at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:765)
10/09/01 15:21:44 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317)
10/09/01 15:21:44 at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790)
10/09/01 15:21:44 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)
10/09/01 15:21:44 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
10/09/01 15:21:44 at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:186)
10/09/01 15:21:44 at java.lang.Thread.run(Thread.java:619)

问题补充：

7454103 写道

引用

create table IMAGE
(
NAME VARCHAR2(20),
SEX VARCHAR2(2),
IMAGE BLOB
)

pstmt.setBinaryStream(3, fis, i);

参考下保存BLOB 的保存方法：

http://sxpujs.iteye.com/blog/369050

试试看！

刚才测试了一下，发现我刚才那个方法保存.tet格式的文本文件不会报错，但是保存二进制文件就出错了。可能blob的读取那还有有些问题，我换换种blob保存方式再试试，很感谢你！

DAO