picture.java

一、 网站名称:旅游信息管理网站 二、 编程语言:JSP+javabean+sql2000 三、 编程运行:首先把数据库文件导入数据库中,然后把tour文件拷贝到D:Tomcat 5.5webap

package picture;

import java.sql.*;
import java.util.*;
import java.text.*;
import java.io.*;

public class picture
{
public String tour_line_name;
public String filename;
public Connection con;

public boolean pic_update() throws Exception
{
  try{
Statement statement=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);

FileInputStream str=new FileInputStream(filename);
String sql="update tour_line_info set tour_line_image=? where tour_line_name='"+tour_line_name+"'";

PreparedStatement pstmt=con.prepareStatement(sql);
pstmt.setBinaryStream(1,str,str.available());
pstmt.execute();
return true;
}catch(SQLException ee)
{return false;}

}
}