Java web开发中怎么把图片存入数据库? Java web开发中怎么把图片存入数据库?科图片比较多,好像 是要把文件保存在文件夹中,再把路径上传到数据库,还有就是把文件上传到服务器,再存路径 怎么写代码? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 建立一个图片服务器,把已有的和上传的都放到自定的路径下,然后用数据库保存绝对URL, package shop.car.control;import java.io.IOException;import java.io.PrintWriter;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.jsp.JspFactory;import javax.servlet.jsp.PageContext;import shop.car.model.GoodService;import com.jspsmart.upload.SmartUpload;import com.jspsmart.upload.SmartUploadException;public class ImageInput extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { this.doPost(request, response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { PrintWriter out = response.getWriter(); PageContext pageContext = null; JspFactory jsp = null; // 实例化上载bean SmartUpload mySmartUpload = new SmartUpload(); jsp = JspFactory.getDefaultFactory(); pageContext = jsp.getPageContext(this, request, response, "", true, 8192, true); // 初始化 mySmartUpload.initialize(pageContext); // 设置上载的最大值 mySmartUpload.setMaxFileSize(500 * 1024 * 1024); // 设定允许上传的文件(通过扩展名限制) mySmartUpload.setAllowedFilesList("jpg"); // 上载文件 try { mySmartUpload.upload(); } catch (SmartUploadException e2) { // TODO Auto-generated catch block e2.printStackTrace(); } int count = 0; try { count = mySmartUpload.save("/upload", SmartUpload.SAVE_VIRTUAL); } catch (SmartUploadException e1) { // TODO Auto-generated catch block e1.printStackTrace(); } out.println(count + "个文件上传成功!<br>"); out.println("TEST=" + mySmartUpload.getRequest().getParameter("TEST") + "<BR><BR>"); // 循环取得所有上载的文件 for (int i = 0; i < mySmartUpload.getFiles().getCount(); i++) { // 取得上载的文件 com.jspsmart.upload.File myFile = mySmartUpload.getFiles().getFile( i); if (!myFile.isMissing()) { // 取得上载的文件的文件名 String myFileName = myFile.getFileName(); // 取得不带后缀的文件名 String suffix = myFileName.substring(0, myFileName .lastIndexOf('.')); // 取得后缀名 String ext = mySmartUpload.getFiles().getFile(0).getFileExt(); // 取得文件的大小 int fileSize = myFile.getSize(); // 保存路径 String aa = request.getRealPath(request.getServletPath()) + myFileName; String trace = aa + myFileName; String s=new String(trace.getBytes("ISO-8859-1"),"utf-8"); // 取得别的参数 String explain = (String) mySmartUpload.getRequest() .getParameter("text"); String send = (String) mySmartUpload.getRequest().getParameter( "send"); // 将文件保存在服务器端 try { myFile.saveAs(trace, SmartUpload.SAVE_PHYSICAL); } catch (SmartUploadException e) { // TODO Auto-generated catch block e.printStackTrace(); } // 下面的是将上载的文件保存到数据库中 // 将文件读到流中 java.io.File file = new java.io.File(s); java.io.FileInputStream fis = new java.io.FileInputStream(file); out.println(file.length()); GoodService.addGoods(fis, file); out.println(("上载成功!!!").toString()); } else { out.println(("上载失败!!!").toString()); } }// 与前面的if对应 out.flush(); out.close(); }}报错Incorrect string value: '\xFF\xD8\xFF\xE0\x00\x10...' for column 'viewpic' at row 1;怎么解决啊,我用的都是utf-8 数据库里建个关于URL的字段,然后在页面上取到就可以了。 apache代理跳转至weblogic无规律的报错!!!! 请教下如何使用JSP实现OA??需要那些知识储备? 如何调用另一个系统的接口? jsp中的隐式对象page实际项目中用它来做什么? 请教各位大虾帮忙看看,怎么修改?(JSP) 今天调试java Web程序时,java虚拟机崩溃了 请教奇怪的session问题! 关于分级别动态显示的问题 在linux上,tomcat找不到oracle的驱动程序,请问要进行那些设置? Bean的构造函数问题 jsp页面中添加时间控件 静态页面中出现${}是什么意思啊?
然后用数据库保存绝对URL,
import java.io.PrintWriter;import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.jsp.JspFactory;
import javax.servlet.jsp.PageContext;import shop.car.model.GoodService;import com.jspsmart.upload.SmartUpload;
import com.jspsmart.upload.SmartUploadException;public class ImageInput extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException { this.doPost(request, response);
} public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException { PrintWriter out = response.getWriter();
PageContext pageContext = null;
JspFactory jsp = null;
// 实例化上载bean
SmartUpload mySmartUpload = new SmartUpload();
jsp = JspFactory.getDefaultFactory();
pageContext = jsp.getPageContext(this, request, response, "", true,
8192, true); // 初始化
mySmartUpload.initialize(pageContext);
// 设置上载的最大值
mySmartUpload.setMaxFileSize(500 * 1024 * 1024);
// 设定允许上传的文件(通过扩展名限制)
mySmartUpload.setAllowedFilesList("jpg");
// 上载文件
try {
mySmartUpload.upload();
} catch (SmartUploadException e2) {
// TODO Auto-generated catch block
e2.printStackTrace();
} int count = 0;
try {
count = mySmartUpload.save("/upload", SmartUpload.SAVE_VIRTUAL);
} catch (SmartUploadException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} out.println(count + "个文件上传成功!<br>");
out.println("TEST=" + mySmartUpload.getRequest().getParameter("TEST")
+ "<BR><BR>"); // 循环取得所有上载的文件
for (int i = 0; i < mySmartUpload.getFiles().getCount(); i++) {
// 取得上载的文件
com.jspsmart.upload.File myFile = mySmartUpload.getFiles().getFile(
i);
if (!myFile.isMissing()) {
// 取得上载的文件的文件名
String myFileName = myFile.getFileName();
// 取得不带后缀的文件名
String suffix = myFileName.substring(0, myFileName
.lastIndexOf('.'));
// 取得后缀名
String ext = mySmartUpload.getFiles().getFile(0).getFileExt();
// 取得文件的大小
int fileSize = myFile.getSize();
// 保存路径
String aa = request.getRealPath(request.getServletPath())
+ myFileName;
String trace = aa + myFileName;
String s=new String(trace.getBytes("ISO-8859-1"),"utf-8");
// 取得别的参数
String explain = (String) mySmartUpload.getRequest()
.getParameter("text");
String send = (String) mySmartUpload.getRequest().getParameter(
"send");
// 将文件保存在服务器端
try {
myFile.saveAs(trace, SmartUpload.SAVE_PHYSICAL);
} catch (SmartUploadException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
// 下面的是将上载的文件保存到数据库中
// 将文件读到流中
java.io.File file = new java.io.File(s);
java.io.FileInputStream fis = new java.io.FileInputStream(file);
out.println(file.length());
GoodService.addGoods(fis, file);
out.println(("上载成功!!!").toString());
} else {
out.println(("上载失败!!!").toString());
}
}// 与前面的if对应 out.flush();
out.close();
}}报错Incorrect string value: '\xFF\xD8\xFF\xE0\x00\x10...' for column 'viewpic' at row 1;
怎么解决啊,我用的都是utf-8