jsp图片动态存储到mysql数据库中 ..docVIP

jsp图片动态存储到mysql数据库中 . 一，创建数据库， create tables images(id int not null primary key ,content varchar(100),image blod ); 二，在jsp中连接数据库， import java.sql.Connection; import java.sql.DriverManager; public class Conn { final String MYSQLDBDRIVER=com.mysql.jdbc.Driver; final String MYSQLDBURL=jdbc:mysql://localhost:3306/userinfo; final String MYSQLDBUSER=root; final String MYSQLDBUSERPASS=123; public Connection getConnection(){ try{ Class.forName(MYSQLDBDRIVER); Connection con=DriverManager.getConnection(MYSQLDBURL,MYSQLDBUSER,MYSQLDBUSERPASS); return con; }catch(Exception e){ e.printStackTrace(); return null; } } } 三，在jsp页面中上传图片到mysql中 form method=post action=image.jsp input type=file name=image /br/ 相片描述input type=text name=content /br/ input type=submit / /form image.jsp页面如下： %@ page language=java contentType=text/html; charset=UTF-8 pageEncoding=UTF-8% %@ page import=java.sql.* % %@ page import=java.util.*% %@ page import=java.io.*% !DOCTYPE html PUBLIC -//W3C//DTD HTML 4.01 Transitional//EN /TR/html4/loose.dtd html head meta http-equiv=Content-Type content=text/html; charset=ISO-8859-1 title图片上传/title /head body jsp:useBean id=conn4 class=com.conDBMS.Conn scope=session / % String content=request.getParameter(content); String filename=request.getParameter(image); //ServletInputStream str=request.getInputStream(); InputStream str=new FileInputStream(filename); //byte b[]=new byte[str.available()]; //str.read(b); //ByteArrayInputStream bi=new ByteArrayInputStream(b); String sql1=select id from image; Statement stmt=conn4.getConnection().createStatement(); ResultSet rs=stmt.executeQuery(sql1); rs.last(); int id=rs.getInt(id)+1; String sql=insert into image(id,content,ima) values(+id+,?,?); PreparedStatement pstmt=conn4.getConnection().prepareStatement(sql); pstmt.setString(1,content); long l=(long)str.available(); pstmt.setBinaryStream(2,str,l) ; //out.print(bi.available()); try{ pst