package com.alphasta.cms.syhanbaopingtai.action;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.io.PrintWriter;
import java.sql.Blob;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class Photosq extends HttpServlet {
public Connection getConnection() {
Connection conn = null;
PreparedStatement pstm=null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver"); // 加载数据库驱动
String url = "jdbc:oracle:thin:@10.26.1.209:1521:orcl3"; // 获取连接URL
String user = "abpt"; // 连接用户名
String password = "abpt"; // 连接密码
conn = DriverManager.getConnection(url, user, password); // 获取数据库连接
if (conn != null) {
}
} catch (Exception e) {
e.printStackTrace();
}
return conn; // 返回Connection实例
}
public static void writeImg(OutputStream os,String id){
Photo ss=new Photo();
Connection con = ss.getConnection();
String sql="select a1.zp2 from (select x.*, rownum rn from( select t.xm,t.sfzh,t.hjdz,t.wfzlmc,t.id,t.zp2 from abpt.CLYJ_RYHC t where t.id ='"+id+"' order by t.pcsj desc ) x) a1 where rn between 1 and 1";
System.out.println(sql);
PreparedStatement prepareStatement;
try {
prepareStatement = con.prepareStatement(sql);
ResultSet rs = prepareStatement.executeQuery();
byte[] b=new byte[1024];//创建缓冲区
if(rs.next()){
Blob blob = rs.getBlob(1);//获取blob图片数据
InputStream is=blob.getBinaryStream();//输入流
int i=0;
while ((i=is.read(b))!=-1) {
os.write(b, 0, i);//读取blob图片
}
os.close();
is.close();
}
rs.close();
prepareStatement.close();
con.close();
} catch (Exception e) {
e.printStackTrace();
}
}
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String id=new String(request.getParameter("id").getBytes("iso-8859-1"),"utf-8");
writeImg(response.getOutputStream(), id);
id="";
}
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
}
}
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.io.PrintWriter;
import java.sql.Blob;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class Photosq extends HttpServlet {
public Connection getConnection() {
Connection conn = null;
PreparedStatement pstm=null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver"); // 加载数据库驱动
String url = "jdbc:oracle:thin:@10.26.1.209:1521:orcl3"; // 获取连接URL
String user = "abpt"; // 连接用户名
String password = "abpt"; // 连接密码
conn = DriverManager.getConnection(url, user, password); // 获取数据库连接
if (conn != null) {
}
} catch (Exception e) {
e.printStackTrace();
}
return conn; // 返回Connection实例
}
public static void writeImg(OutputStream os,String id){
Photo ss=new Photo();
Connection con = ss.getConnection();
String sql="select a1.zp2 from (select x.*, rownum rn from( select t.xm,t.sfzh,t.hjdz,t.wfzlmc,t.id,t.zp2 from abpt.CLYJ_RYHC t where t.id ='"+id+"' order by t.pcsj desc ) x) a1 where rn between 1 and 1";
System.out.println(sql);
PreparedStatement prepareStatement;
try {
prepareStatement = con.prepareStatement(sql);
ResultSet rs = prepareStatement.executeQuery();
byte[] b=new byte[1024];//创建缓冲区
if(rs.next()){
Blob blob = rs.getBlob(1);//获取blob图片数据
InputStream is=blob.getBinaryStream();//输入流
int i=0;
while ((i=is.read(b))!=-1) {
os.write(b, 0, i);//读取blob图片
}
os.close();
is.close();
}
rs.close();
prepareStatement.close();
con.close();
} catch (Exception e) {
e.printStackTrace();
}
}
public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String id=new String(request.getParameter("id").getBytes("iso-8859-1"),"utf-8");
writeImg(response.getOutputStream(), id);
id="";
}
public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
}
}