比如有这样一个连接:www.hhhh.com/asd.jsp?a=LLL 点了之后进入了一个jsp也面中心内容如下: <%
String bookid1 = request.getParameter("bookid");
String bookid2 = new String(bookid1.getBytes("ISO-8859-1"),"gb2312");
String yw = request.getParameter("yw");
List xx = DBHelper.getxx(bookid1);
List jj = DBHelper.getdj(bookid1);
String az = new String((jj.get(0)).toString().getBytes("ISO-8859-1"),"gb2312");
List j = DBHelper.getwj(bookid1);
String ac = new String((j.get(0)).toString().getBytes("ISO-8859-1"),"gb2312");
List k = DBHelper.getpj(bookid1);
String ax = new String((k.get(0)).toString().getBytes("ISO-8859-1"),"gb2312");
List dd = DBHelper.getdd(bookid1);
List qq = DBHelper.getqq(bookid1);
List cs = DBHelper.getcs(bookid1);
List ses = DBHelper.getses(bookid1);
List shanxibed = DBHelper.shanxibed(bookid1);
List shanxizzao = DBHelper.shanxizzao(bookid1);
List shanxixzao = DBHelper.shanxixzao(bookid1);
List shanxicy = DBHelper.shanxicy(bookid1);
List shanxikl = DBHelper.shanxikl(bookid1);
List shanxisb = DBHelper.shanxisb(bookid1);
List shanxiqt = DBHelper.shanxiqt(bookid1);
List asd = DBHelper.qqq(bookid1);
%>
out.write(" <form action='' name='f' method='post'>"+
" <table width='500' cellpadding='0' cellspacing='0' align='left'>" +
" <tr> <td bgcolor='#027bce'> <span class='STYLE46'>房型 </td>" +
" <td bgcolor='#027bce'> <span class='STYLE46'>门市价 </td>" +
" <td bgcolor='#027bce'> <span class='STYLE46'>淡季价(元) </td> <td bgcolor='#027bce'> <span class='STYLE46'>平季价(元) </td> <td bgcolor='#027bce'> <span class='STYLE46'>旺季价(元) </td> <td bgcolor='#027bce'> <span class='STYLE46'>早餐 </td> <td bgcolor='#027bce'> <span class='STYLE46'>床型 </td> <td bgcolor='#027bce'> <span class='STYLE46'>宽带 </td> </tr>");
for(int i=0; i <a.size(); i++)
{
out.write(" <tr> <td align='left'> <span class='STYLE46'>"+new String(a.get(i).toString().getBytes("ISO-8859-1"),"gb2312")+" </td>");
out.write(" <td> <span class='STYLE46'>"+new String(h.get(i).toString().getBytes("ISO-8859-1"),"gb2312")+" </td>");
out.write(" <td> <span class='STYLE46'>"+new String(b.get(i).toString().getBytes("ISO-8859-1"),"gb2312")+" </td>");
out.write(" <td> <span class='STYLE46'>"+new String(d.get(i).toString().getBytes("ISO-8859-1"),"gb2312")+" </td>");
out.write(" <td> <span class='STYLE46'>"+new String(c.get(i).toString().getBytes("ISO-8859-1"),"gb2312")+" </td>");
out.write(" <td> <span class='STYLE46'>"+new String(e.get(i).toString().getBytes("ISO-8859-1"),"gb2312")+" </td>");
out.write(" <td> <span class='STYLE46'>"+new String(f.get(i).toString().getBytes("ISO-8859-1"),"gb2312")+" </td>");
out.write(" <td> <span class='STYLE46'>"+new String(g.get(i).toString().getBytes("ISO-8859-1"),"gb2312")+" </td> </tr>");
out.write(" <tr> <td colspan=8> <img src='Hotel Express International4.files/fg.jpg' width='500' height='1'> </td> </tr>");
}
out.write(" </tr> </table> </form>");
现在在这个页面里进行了对数据库的操作,操作完之后要释放资源,那现在要怎么样释放资源?
是就写在这个JSP页面里?怎么写?
String bookid1 = request.getParameter("bookid");
String bookid2 = new String(bookid1.getBytes("ISO-8859-1"),"gb2312");
String yw = request.getParameter("yw");
List xx = DBHelper.getxx(bookid1);
List jj = DBHelper.getdj(bookid1);
String az = new String((jj.get(0)).toString().getBytes("ISO-8859-1"),"gb2312");
List j = DBHelper.getwj(bookid1);
String ac = new String((j.get(0)).toString().getBytes("ISO-8859-1"),"gb2312");
List k = DBHelper.getpj(bookid1);
String ax = new String((k.get(0)).toString().getBytes("ISO-8859-1"),"gb2312");
List dd = DBHelper.getdd(bookid1);
List qq = DBHelper.getqq(bookid1);
List cs = DBHelper.getcs(bookid1);
List ses = DBHelper.getses(bookid1);
List shanxibed = DBHelper.shanxibed(bookid1);
List shanxizzao = DBHelper.shanxizzao(bookid1);
List shanxixzao = DBHelper.shanxixzao(bookid1);
List shanxicy = DBHelper.shanxicy(bookid1);
List shanxikl = DBHelper.shanxikl(bookid1);
List shanxisb = DBHelper.shanxisb(bookid1);
List shanxiqt = DBHelper.shanxiqt(bookid1);
List asd = DBHelper.qqq(bookid1);
%>
out.write(" <form action='' name='f' method='post'>"+
" <table width='500' cellpadding='0' cellspacing='0' align='left'>" +
" <tr> <td bgcolor='#027bce'> <span class='STYLE46'>房型 </td>" +
" <td bgcolor='#027bce'> <span class='STYLE46'>门市价 </td>" +
" <td bgcolor='#027bce'> <span class='STYLE46'>淡季价(元) </td> <td bgcolor='#027bce'> <span class='STYLE46'>平季价(元) </td> <td bgcolor='#027bce'> <span class='STYLE46'>旺季价(元) </td> <td bgcolor='#027bce'> <span class='STYLE46'>早餐 </td> <td bgcolor='#027bce'> <span class='STYLE46'>床型 </td> <td bgcolor='#027bce'> <span class='STYLE46'>宽带 </td> </tr>");
for(int i=0; i <a.size(); i++)
{
out.write(" <tr> <td align='left'> <span class='STYLE46'>"+new String(a.get(i).toString().getBytes("ISO-8859-1"),"gb2312")+" </td>");
out.write(" <td> <span class='STYLE46'>"+new String(h.get(i).toString().getBytes("ISO-8859-1"),"gb2312")+" </td>");
out.write(" <td> <span class='STYLE46'>"+new String(b.get(i).toString().getBytes("ISO-8859-1"),"gb2312")+" </td>");
out.write(" <td> <span class='STYLE46'>"+new String(d.get(i).toString().getBytes("ISO-8859-1"),"gb2312")+" </td>");
out.write(" <td> <span class='STYLE46'>"+new String(c.get(i).toString().getBytes("ISO-8859-1"),"gb2312")+" </td>");
out.write(" <td> <span class='STYLE46'>"+new String(e.get(i).toString().getBytes("ISO-8859-1"),"gb2312")+" </td>");
out.write(" <td> <span class='STYLE46'>"+new String(f.get(i).toString().getBytes("ISO-8859-1"),"gb2312")+" </td>");
out.write(" <td> <span class='STYLE46'>"+new String(g.get(i).toString().getBytes("ISO-8859-1"),"gb2312")+" </td> </tr>");
out.write(" <tr> <td colspan=8> <img src='Hotel Express International4.files/fg.jpg' width='500' height='1'> </td> </tr>");
}
out.write(" </tr> </table> </form>");
现在在这个页面里进行了对数据库的操作,操作完之后要释放资源,那现在要怎么样释放资源?
是就写在这个JSP页面里?怎么写?
等对象的 close(); 方法就可以了。