高手请进！！百思不得其解？？关于图片存入数据库问题。。

Question

你首先得把图片上传到服务器的某目录下(随便你了)然后在用文件流读取并放入到数据库中用SmartUpload吧(免费下载)
////////////////////////////////////////////
建议:建立一个路径专门存放图片图片名称格式譬如mm_yyyymmddhhmmss.gif(jpg)然后在数据库的数据表中用String类型字段描述该图片的路径 譬如/usr/local/tmp....../图片名称.gif(jpg)这样就OK啦

Answer 1

给你点代码,比较粗糙，但实用，自己看看啊,主要看文件保存的部分，有不懂的再问吧
<%@ page contentType="text/html; charset=gbk"%>
<%@ page import="com.common.*"%>
<%@ page import="com.dbbase.*"%>
<%@ page import="com.common.system.*"%>
<%@ page import="com.common.*" %>
<%@ page import="com.exception.*"%>
<%@ page import="com.exception.*" %>
<%@ page import="com.webmanage.jzyg.*" %>
<%@ page import="java.util.*"%>
<%@ page import="java.io.*"%>
<%@ include file="../../system/inc_getuser.jsp"%>
<%if(!User.checkPermission(user,"编辑教职员工")){%>
<%@ include file="../../system/inc_close_me.jsp"%>
<%
return;
}%>
<script src="../js/common.js"></script>
<jsp:useBean id="toolSmartUpload" scope="page" class="com.jspsmart.upload.SmartUpload" />//牵涉到文件保存，所以用SmartUpload类，上网去下载啊，不错的东东,有详细的文档说明的
<%
    returnValue rv=null;
toolSmartUpload.initialize(pageContext);
toolSmartUpload.upload();
com.jspsmart.upload.Request myRequest=toolSmartUpload.getRequest();
int id=ToolFunc.str2int(myRequest.getParameter("id"));
String overwrite=myRequest.getParameter("overwrite");
String name=myRequest.getParameter("name");
String department=myRequest.getParameter("department");
String worktitle=myRequest.getParameter("worktitle");
int doctor=ToolFunc.str2int(myRequest.getParameter("doctor"));
String tel=myRequest.getParameter("tel");
String office=myRequest.getParameter("office");
String email=myRequest.getParameter("email");
String education=myRequest.getParameter("education");
String parttimejob=myRequest.getParameter("parttimejob");
String research=myRequest.getParameter("research");
String courses=myRequest.getParameter("courses");
String result=myRequest.getParameter("result");
String honor=myRequest.getParameter("honor");
String webpage=myRequest.getParameter("webpage");
String wno=myRequest.getParameter("wno");
com.jspsmart.upload.File myFile=toolSmartUpload.getFiles().getFile(0);
double photoSize=myFile.getSize(); jzyg teacher=new jzyg();
teacher.setId(id);
teacher.setName(name);
teacher.setDepartment(department);
teacher.setWorktitle(worktitle);
teacher.setDoctor(doctor);
teacher.setTel(tel);
teacher.setOffice(office);
teacher.setEmail(email);
teacher.setEducation(education);
teacher.setParttimejob(parttimejob);
teacher.setResearch(research);
teacher.setCourses(courses);
teacher.setResult(result);
teacher.setHonor(honor);
teacher.setWebpage(webpage);
teacher.setWno(wno); if(photoSize>0)
{
SysProperties theSysProp = SysProperties.getInstance();
String uploadPath = theSysProp.getValue("jzyg.uploadpath");
File dir=new File(uploadPath);
if(!dir.exists())
{
dir.mkdirs();
}
myFile = toolSmartUpload.getFiles().getFile(0);
String extension=myFile.getFileExt();
extension=extension.toUpperCase();
if(extension.equals("GIF")||extension.equals("JPG"))
{
  String filename=myFile.getFileName();
  Date date = new Date();
  String fname=ToolFunc.int2str(date.getTime());
  filename=fname+"."+myFile.getFileExt();
  File myFile1=new File(uploadPath+filename);
  if(!myFile1.exists() || overwrite.equals("1"))  
  {
myFile.saveAs(uploadPath+filename);
teacher.setPhoto(filename);   }
  else
  {
%>
   <script>
if(confirm("文件已经存在，要覆盖原文件么?"))
{
parent.document.all.overwrite.value=1;
parent.saveTeacher();
}
wait_end(parent);
  </script>
  <%
return;
  }
 %>
<%
}
else{
  %>
 <script>
alert("只能输入JPG和GIF格式的照片文件,请重新选择");
wait_end(parent);
 </script>
 <% return;
 }
}
else if(photoSize<=0){} rv=teacher.save();
if(rv.success==false){
%>
<script>
alert("<%=rv.info%>");
wait_end(parent);
</script>
<% }else{%>
<%
int actCode =0;
int userId =0;
User myUser = User.getInstance();
try{
User theUser=User.getUserByAccount(wno);
if(theUser!=null){
actCode =ActCode.MOD;
userId =theUser.getUserId();
}else{
actCode =ActCode.ADD;
userId =0;
}
}catch(LPiException ex){
actCode =ActCode.ADD;
userId =0;
}
myUser.setUserId(userId);
myUser.setAccount(wno);
myUser.setPwd(wno);
myUser.setName(name);
myUser.setStatus(User.OPENED);
myUser.manage(user.getUserId(), actCode); %>
<% if(rv.info!=""){%>
<script>
alert("<%=rv.info%>");
<%
}
%>
parent.opener.location.replace("jzyg_list.jsp");
parent.close()
</script>
<% }
%>

Answer 2

请问yihongqiushui(水泓) 
能不能贴贴你的代码呀？

Answer 3

用SmartUpload
<%@ page language="java" import="java.sql.*,com.jspsmart.upload.*"%>
<jsp:useBean id="mySmartUpload" scope="page" class="com.jspsmart.upload.SmartUpload" /><HTML>
<BODY BGCOLOR="white"><H1>jspSmartUpload : Sample 4</H1>
<HR><% // Variables
int count=0; // Connect to the database
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:mysql:///test"); // SQL Request
Statement stmt = con.createStatement(ResultSet.TYPE_FORWARD_ONLY ,ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery("SELECT * FROM TFILES WHERE ID=1"); // if the resultset is not null
if (rs.next()){ // Initialization
mySmartUpload.initialize(pageContext); // Upload
mySmartUpload.upload(); // upload file in the DB if this file is not missing
if (!mySmartUpload.getFiles().getFile(0).isMissing()){ try { rs.updateString("FILENAME",mySmartUpload.getFiles().getFile(0).getFileName());

// Add the current file in the DB field
mySmartUpload.getFiles().getFile(0).fileToField(rs,"FILE"); // Update
rs.updateRow();
count++;

} catch(Exception e) {
out.println("An error occurs : " + e.toString());
} } } // Display the number of files uploaded
out.println(count + " file(s) uploaded in the database."); rs.close();
stmt.close();
con.close();%></BODY>
</HTML>

Answer 4

招聘JSP网页编程人员(1-2名)
1-2年的网页编程经验
语言:JSP,java,html,javascript
请在简历中写明对以上语言的掌握程度以及学历.北京友联创新系统集成有限公司
联系方式:
010-62984859-8010王先生
[email protected]