用jsp_servlet实现在mysql中存储图片_用jsp+servlet+javabean上传图片到数据库中，不是存路径...

展开全部

%@ page language="java"%>

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); //com.microsoft.jdbc.sqlserver.SQLserveDriver

String url="jdbc:oracle:thin:@lubin:1521:b2bdb"; //jdbc:microsoft:sqlserver://127.0.0.1:1433; jdbc:microsoft.sqlserver://127.0.0.1:1433

Connection con=DriverManager.getConnection(url,"demo","demo");

String sql="insert into test_img values (?,?,?)";

String id=request.getParameter("id");

String kk=request.getParameter("image");

File filename=new File(kk);

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!!e69da5e887aa3231313335323631343130323136353331333332613161!");

%>

显示图片

Class.forName("oracle.jdbc.driver.OracleDriver");

String url="jdbc:oracle:thin:@lubin:15