i want to upload and display blob img and text data from data base in jsp using in netbens 8 but showing some error in code .the code is below
<%--
Document : newjsp
Created on : May 28, 2020, 10:18:20 PM
Author : lenovo
--%>
<%@page import="java.io.OutputStream"%>
<%@page import="java.sql.Blob"%>
<%@page import="java.sql.SQLException"%>
<%@page import="java.util.GregorianCalendar"%>
<%@page import="java.util.Calendar"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@page import="javax.swing.JOptionPane"%>
<%@page import="java.lang.String"%>
<%@page import="java.sql.Connection"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<title>JSP Page
<%
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/upload_img", "root", "root");
//Connection con = FactoryConnection_SQL_SERVER.getConnection("empCHART");
Statement stSuper = con.createStatement();
Statement stSetor = con.createStatement();
Blob image = null;
byte[] imgData = null;
ResultSet rsSuper = stSuper.executeQuery("SELECT * FROM image");
if (rsSuper.next()) {
image = rsSuper.getBlob(12);
imgData = image.getBytes(1, (int) image.length());
response.setContentType("image/gif");
OutputStream o = response.getOutputStream();
o.write(imgData); // even here we got the same as below.
//o.flush();
//o.close();
//--[...]
< img title="<%=rSuper.getString("1").trim()%> " src="<% = o.wite(imgData);// o.flush(); o.close(); %>">
correct the error
<%=rsSuper.getString("1")%>
<%=rsSuper.getString("Position")%>
Id: <%=rsSuper.getString("id")%>
Phone: <%=rsSuper.getString("Phone")%>
E-Mail: <%=rsSuper.getString("Email")%>
|