show.java

这个是我们做土地局的一个项目。感觉不错。欢迎下载

package huayi.servlets;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.lang.*;
import java.sql.*;
import javax.naming.*;
import huayi.gg.dbConn.*;

public class Show extends HttpServlet{

public void init(ServletConfig config) throws ServletException {

super.init(config);

}

public void service(HttpServletRequest request,HttpServletResponse response) throws IOException {

dbConn myConn=new dbConn();

//int XH=98;
int XH=Integer.parseInt(request.getParameter("XH"));
String sql=new String();
sql="select * from T_LYXXB where XH="+XH;
try{
ResultSet rs=myConn.executeQuery(sql);
if(rs.next());
  InputStream in=rs.getBinaryStream(6);
  
  response.reset(); 
  OutputStream o=response.getOutputStream();
  //o=response.getOutputStream();
  byte b[]=new byte[500];
  int n=0;
  while((n=in.read(b))!=-1)
  {o.write(b,0,n);}
  in.close();        
  o.flush();
  o.close();
  }catch(SQLException e){}
          
   myConn.close();        

  }}