Oracle语句：图片的读取

万俟1053

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();
}
}