怎么样从数据库里面的表的内容生成一张列表显示在jsp页面里 你是想在登陆成功后将userid用户列表中的内容都显示出来吗?要是这样的话登陆成功后再执行一个查询取出userid中的内容就可以了,再有你的jsp显示这种列表最好用<table>,那样显示出来格式会更规范、美观一些。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 我是想三个字段的内容全都显示成一张动态的列表,我刚接触java,还不太懂,能否帮我具体解决一下 while(rs.next){ out.print("<tr>") out.print("<td>" + rs.getString("userid")+ "</td>") out.print("<td>" + rs.getString("password")+ "</td>") out.print("<td>" + rs.getString("email")+ "</td>") out.print("</tr>")} exception org.apache.jasper.JasperException: [Microsoft][SQLServer 2000 Driver for JDBC]Column index 4 is out of range.错误啊 /*前面一样,直到rs=smt.executeQuery(condition);*/<table>while(rs.next()){ <tr><td><%=re.getString(1)%></td><td><%=re.getString(2)%></td><td><%=re.getString(3)%></td></tr>}</table> <% Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance(); String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs"; Connection con= DriverManager.getConnection(url,"sa","111"); Statement smt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); ResultSet rs; String condition="select * from testtable "; rs=smt.executeQuery(condition); java.util.List list = new java.util.ArrayList(); while(rs.next()){ String[] temp = {rs.getString("userid"),rs.getString("password"),rs.getString("email")}; list.add(temp); } %> <table> <tr> <th>用户</th> <th>密码</th> <th>E-mail</th> </tr> <% for(int i = 0; i < list.size() ; i++){ String[] data = (String[])list.get(i); %> <tr> <%for(int j = 0 ; j < data.length ; j++) {%> <td><%=data[j]%></td> </tr> <%}%> <% } %> </table> <%rs.close(); smt.close(); con.close(); } %>发现5个错误请教怎么解决啊Generated servlet error: [javac] Since fork is true, ignoring compiler setting. [javac] Compiling 1 source file [javac] Since fork is true, ignoring compiler setting. [javac] C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\test\reg\list_jsp.java:31: 'try' without 'catch' or 'finally' [javac] try { [javac] ^ [javac] C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\test\reg\list_jsp.java:107: illegal start of type [javac] } catch (Throwable t) { [javac] ^ [javac] C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\test\reg\list_jsp.java:115: expected [javac] } [javac] ^ [javac] C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\test\reg\list_jsp.java:116: 'class' or 'interface' expected [javac] } [javac] ^ [javac] C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\test\reg\list_jsp.java:117: 'class' or 'interface' expected [javac] ^ [javac] 5 errors 自己写了一个java程序,但是很无语,求帮助! 求教 关于++的问题? 请问有没有easy language这个语言啊 急救~进销存日期选择框的实现 用过quaqua的请进 多线程中对特定线程的操作 请高手帮我解答些问题,一原代码中有些不明白 菜鸟问题 为什么我没权设置JVM支持IE的<Applet>标记? 请问如何即时刷新table中鼠标所选中的那条记录?程序代码见内。高分请教 关于RMI 请问一个java和c通讯时字节序的问题 求:取得applet面板大小的方法
out.print("<tr>")
out.print("<td>" + rs.getString("userid")+ "</td>")
out.print("<td>" + rs.getString("password")+ "</td>")
out.print("<td>" + rs.getString("email")+ "</td>")
out.print("</tr>")
}
错误啊
rs=smt.executeQuery(condition);
*/
<table>
while(rs.next()){
<tr>
<td><%=re.getString(1)%></td>
<td><%=re.getString(2)%></td>
<td><%=re.getString(3)%></td>
</tr>
}
</table>
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
Connection con= DriverManager.getConnection(url,"sa","111");
Statement smt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs;
String condition="select * from testtable ";
rs=smt.executeQuery(condition);
java.util.List list = new java.util.ArrayList();
while(rs.next()){
String[] temp = {rs.getString("userid"),rs.getString("password"),rs.getString("email")};
list.add(temp);
}
%>
<table>
<tr>
<th>用户</th>
<th>密码</th>
<th>E-mail</th>
</tr>
<%
for(int i = 0; i < list.size() ; i++){
String[] data = (String[])list.get(i);
%>
<tr>
<%for(int j = 0 ; j < data.length ; j++)
{%>
<td><%=data[j]%></td>
</tr>
<%}%>
<%
}
%>
</table>
<%rs.close();
smt.close();
con.close();
}
%>发现5个错误请教怎么解决啊
Generated servlet error:
[javac] Since fork is true, ignoring compiler setting.
[javac] Compiling 1 source file
[javac] Since fork is true, ignoring compiler setting.
[javac] C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\test\reg\list_jsp.java:31: 'try' without 'catch' or 'finally'
[javac] try {
[javac] ^
[javac] C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\test\reg\list_jsp.java:107: illegal start of type
[javac] } catch (Throwable t) {
[javac] ^
[javac] C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\test\reg\list_jsp.java:115: expected
[javac] }
[javac] ^
[javac] C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\test\reg\list_jsp.java:116: 'class' or 'interface' expected
[javac] }
[javac] ^
[javac] C:\Program Files\Apache Group\Tomcat 4.1\work\Standalone\localhost\test\reg\list_jsp.java:117: 'class' or 'interface' expected
[javac] ^
[javac] 5 errors