addpic.jsp

JSP+ORACLE网站开发实例（下）.rar

<%@ include file="conn.jsp"%>

<%@  page  import="java.util.*"  %>  

<%@  page  import="java.text.*"%>    
<%@  page  import="java.io.*"%>  

<%request.setCharacterEncoding("GB2312");
 String user_id= (String) session.getValue("user_id"); 
//插入数据库  
String  sql="insert  into  scott.friendimg  values(?,?,?,scott.friendid.nextval)";  
//获取传值ID  
String  id=user_id;  
//获取image的路径  
String  kk=request.getParameter("image");  
//转换成file格式  
File  filename=new  File(kk);  
 
//将文件的长度读出，并转换成Long型  
long  l1=filename.length();  
int  l2=(int)l1;  
 
//以流的格式赋值  
FileInputStream  fis=new  FileInputStream(filename);  

PreparedStatement  ps  =conn.prepareStatement(sql);  
ps.setString(1,id);  
ps.setString(2,filename.getName());  
ps.setBinaryStream(3,fis,l2); 

ps.executeUpdate();  
ps.close();  
fis.close();  
stmt.executeUpdate("update scott.larchives set photo=photo+1 where user_id='"+user_id+"'");
 response.sendRedirect("sendphoto.jsp");
%>