insertnews.jsp

来自「JSP+ORACLE网站开发实例（下）.rar」· JSP 代码 · 共 40 行

<%@  page  language="java"%>  
<%@  page  contentType="text/html;charset=gb2312"  %>  
<%@  page  import="java.util.*"  %>  
<%@  page  import="java.sql.*"%>  
<%@  page  import="java.text.*"%>    
<%@  page  import="java.io.*"%>      
 
<%  
Class.forName("oracle.jdbc.driver.OracleDriver");    
String  url="jdbc:oracle:thin:@localhost:1521:job";    
Connection  con=DriverManager.getConnection(url,"system","manager");    
 
//插入数据库  
String  sql="insert  into  scott.testimg  values(?,?,?)";  
//获取传值ID  
String  id=request.getParameter("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  =con.prepareStatement(sql);  
ps.setString(1,id);  
ps.setString(2,filename.getName());  
ps.setBinaryStream(3,fis,l2);    
//ps.setBinaryStream(3,fis,fis.available());    
ps.executeUpdate();  
//ps.execute();    
ps.close();  
fis.close();  
out.println("ok!!!");  
%>