Oracle话语：图片的读取

Oracle语句：图片的读取

String imgPath= Common.getPropertiesValue("LOCAL_HOST")+"/"+ Common.getPropertiesValue("LOCAL_MANAGEROOT")+"/"+Common.getPropertiesValue("LOCAL_NEWS");
	String endtime=null;
	int lid=0;
	try {		
				connl = DBClassLocal.getConnection();
				String sqll = "select * from (select a.*,rownum  rn  from (select bb.imagesname,aa.newstitle,aa.newstitle2,aa.newscontent,aa.newstags,aa.tuijiantitle,aa.id from local_news aa, local_newsimages bb  where aa.id = bb.newsid  and aa.cateid = 'n1141' order by aa.createtime desc) a) where rn <= 1";
				psl = connl.prepareStatement(sqll);
				rsl=psl.executeQuery();
				while(rsl.next()){
					String path=rsl.getString("imagesname");
					String path2= imgPath+path;
					out.println("<img src='"+path2+"'/>");
					out.println("<br/>");
					out.println(rsl.getString("newstitle"));
					out.println("<br/>");
					out.println(rsl.getString("newscontent"));
					out.println("<br/>");
					lid=rsl.getInt("id");
					String time=rsl.getString("tuijiantitle"); 
					out.println("<a href='xiangxi.jsp?time="+time+"&amp;id="+id+"'>"+rsl.getString("newstitle2")+"</a>");
					out.println("<br/>");
					out.println("<a href='xdingdan.jsp?time="+time+"'>"+rsl.getString("newstags")+"</a>");
					out.println("<br/>");
				}
				
				out.println(endtime);
			} catch (Exception e) {
				e.printStackTrace();
			} finally {
				if (rsl != null) {
					rsl.close();
				}
				if (psl != null) {
					psl.close();
				}
				if (connl != null) {
					connl.close();
				}
			}

int time=Integer.parseInt(request.getParameter("time"));
	int id=Integer.parseInt(request.getParameter("id"));
	String imgPath= Common.getPropertiesValue("LOCAL_HOST")+"/"+ Common.getPropertiesValue("LOCAL_MANAGEROOT")+"/"+Common.getPropertiesValue("LOCAL_NEWS");
	Connection connl = null;
	PreparedStatement psl = null;
	ResultSet rsl = null;
	int shi=0;
	String tuanname=null;
	String endtime=null;
	try {		
				connl = DBClassLocal.getConnection();
				String sqll = "select * from local_news t,local_newsimages k where t.id=k.newsid and t.id=? ";
				psl = connl.prepareStatement(sqll);
				psl.setInt(1,id);
				rsl=psl.executeQuery();
				while(rsl.next()){
					endtime=rsl.getString("comefrom");
					String path=rsl.getString("imagesname");
					String path2= imgPath+path;
					out.println("<img src='"+path2+"'/>");
					out.println("<br/>");
				}
				String sql = "select * from HD_AXIUTUAN where id=? ";
				psl = connl.prepareStatement(sql);
				psl.setInt(1,time);
				rsl=psl.executeQuery();
				while(rsl.next()){
					tuanname=rsl.getString("tuanname");
					out.println(tuanname);
					shi=rsl.getInt("shi");
					int tuan=rsl.getInt("tuan");
					out.println("<br/>");
					out.println("市场价："+shi+"/斤");
					out.println("<br/>");
					out.println("团购价："+tuan+"/斤");
					out.println("<br/>");
				}
				out.println(endtime);
			} catch (Exception e) {
				e.printStackTrace();
			} finally {
				if (rsl != null) {
					rsl.close();
				}
				if (psl != null) {
					psl.close();
				}
				if (connl != null) {
					connl.close();
				}
			}