<%@page import="java.sql.*"%>
<%@page import="java.io.*"%>
<%
try{
File file=new File("C:/rose.jpg");
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
PreparedStatement st = con.prepareStatement("insert into image(image) values(?)");
FileInputStream fis= new FileInputStream(file);
st.setBinaryStream(1, (InputStream)fis, (int)(file.length()));
int s = st.executeUpdate();
out.println("Image is inserted successfully");
}
catch(Exception e){
System.out.println(e);
}
%>
|