JSP

Question

jsp数据库查询功能代码该怎么写，各位请指教!!

Answer 1

就用java代码写好了，然后用<% %>括起来
或者写个bean来处理数据库的连接、查询等操作

Answer 2

<jsp:useBean id="InfoBean" scope="page" class = "information.InfoBean"/>
<%
ResultSet rs = InfoBean.executeQuery("select * from info");

while(rs!=null && rs.next()){
out.println("<LI>"+new String(rs.getString("name").getBytes("GB2312"),"ISO8859_1")+"</LI>");
out.println("<pre>ID:"+new String(rs.getString("id").getBytes("GB2312"),"ISO8859_1")+"</pre>");out.println("<img src=\"pictures/1.GIF\" width=\"155\" height=\"117\">");
}
rs.close();
%>