ps.executeUpdate();出错了！在上传图片时

[hsn1982]

<%
String fileName=request.getParameter("file");
out.println (fileName);
if (fileName!=null){
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.107)(PORT=1521)))(CONNECT_DATA =(SERVICE_NAME = test)))";
Connection con=DriverManager.getConnection(url,"YSL","YSL");
out.println("con success"+ "<br>");
File newFile=new File(fileName);
long l1=newFile.length();
int l2=(int)l1;
FileInputStream fis=new FileInputStream(newFile);

String sql="insert into COMPANY(LANG_ID,COMPANY_NO,LOGO) values ('','','')";
PreparedStatement ps =con.prepareStatement(sql);
ps.setString(1,"2");
ps.setString(2,"2");
ps.setBinaryStream(3,fis,l2);
ps.executeUpdate();
ps.close();
fis.close();
}
catch(Exception e){
out.println (e.toString());
}
}
%>

[ladeng5225]

执行executeUpdate()的方法应该是一个JAVABEANS在JSP中生成的ID调用的，而不应该是PreparedStatement的对象调用。

[knight_qmh]

String sql="insert into COMPANY(LANG_ID,COMPANY_NO,LOGO) values ('','','')";
改
String sql="insert into COMPANY(LANG_ID,COMPANY_NO,LOGO) values (?,?,?)";

[knight_qmh]

http://expert.csdn.net/Expert/topic/945/945944.xml?temp=.8132898