JSP向sql server存储图片问题(Tomcat报错)

ender369 2008-05-15 11:14:52

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:372)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

java.lang.NullPointerException
java.io.FileInputStream.<init>(FileInputStream.java:103)
java.io.FileInputStream.<init>(FileInputStream.java:66)
org.apache.jsp.uploadOK_jsp._jspService(uploadOK_jsp.java:80)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

note The full stack trace of the root cause is available in the Apache Tomcat/5.0.30 logs.

请问是怎么回事啊？？？

...全文

98 6 打赏收藏转发到动态举报

写回复

用AI写文章

6 条回复

切换为时间正序

请发表友善的回复…

发表回复

ayangtutu 2008-05-22

打赏
举报

[Quote=引用 5 楼 java_xinjun 的回复:]
所以的图片等二进制对象强烈建议直接读写文件，数据库存路径，简单实用，速度快，要明白数据库最终也
是文件读写，
[/Quote]

lifanfly 2008-05-22

打赏
举报

所以的图片等二进制对象强烈建议直接读写文件，数据库存路径，简单实用，速度快，要明白数据库最终也
是文件读写，

ender369 2008-05-22

打赏
举报

UploadOK.jsp

<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*,java.util.*,java.text.*,java.io.*" errorPage=""%>
<jsp:useBean id="ISO2GB" scope="page" class="community.ISO2GB"/>
<jsp:useBean id="JDBC" scope="page" class="community.JDBConnection"/>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>上传照片</title>
</head>

<body bgcolor="#efefa3" >

<%
Connection conn=JDBC.connection();
String id=request.getParameter("id");
String filename=ISO2GB.convert(request.getParameter("photo"));

FileInputStream str=new FileInputStream(filename);
String sql="insert into photo(id,pic) values(?,?)";
try
{

PreparedStatement pstmt=conn.prepareStatement(sql);
pstmt.setString(1,id);
pstmt.setBinaryStream(2,str,str.available());
pstmt.execute();
out.print("OK!");

pstmt.close();
conn.close();
}catch(Exception e){e.toString();}

%>

</body>
</html>