Hi friend,


I am sending you image insert code in jsp using mysql jdbc driver so please change driver name and implement the following code.


<%@ page language="java" import="java.sql.*,java.util.*,java.io.*,java.awt.image.BufferedImage,java.io.ByteArrayOutputStream,java.io.InputStream,java.text.*" %>

<%

Connection con = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String driver ="com.mysql.jdbc.Driver";
String userName ="amar" ;
String password ="amar123" ;
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,password);
PreparedStatement pst = con.prepareStatement("insert into Image values(?,?,?)");
File file = new File("/home/vinod/Desktop/apache-tomcat-6.0.1/webapps/examples/jsp/javabook.gif");
FileInputStream fis = new FileInputStream(file);
pst.setInt(1, 1);
pst.setString(2, "kumar");
pst.setBinaryStream(3,fis,fis.available());
int i = pst.executeUpdate();
if(i!=0){
out.println("image has been inserted");
}
else{
out.println("image is not inserted");
}
}
catch (Exception e){
System.out.println(e);
}

%>

----------------------------------------------


Visit for more information.

http://www.roseindia.net/jsp/

Thanks.