show.jsp~7~
来自「这程序利用jsp实现BBS论坛系统」· JSP~7~ 代码 · 共 56 行
JSP~7~
56 行
<%@ taglib uri="/WEB-INF/struts-tiles.tld" prefix="tiles" %><%@ taglib uri="/WEB-INF/struts-nested.tld" prefix="nested" %><%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" %><%@ taglib uri="/WEB-INF/struts-template.tld" prefix="template" %><%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %><%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %><%@ page contentType="text/html; charset=GBK" %><%@ page import="java.sql.*"%><html> <head> <title></title> </head> <body> <table border="1"> <tr> <td width="20%">username</td><td width="80%">password</td> </tr> <% Connection conn=null; Statement stmt=null; ResultSet rs=null; try{ Class.forName("com.mysql.jdbc.Driver"); String url = "jdbc:mysql://localhost/bbs?user=root&password=521"; Connection conn = DriverManager.getConnection(url); stmt=conn.createStatement(); rs=stmt.executeQuery("select * from user"); int rowNum=0; while(rs.next()){ rowNum++; String firstName=rs.getString(1); String lastName=rs.getString("password"); %> <tr> <td><%rowNum%></td><td><%=firstName+lastName%></td> <% }%> </table> <% }catch(Execption e){ out.println(e.getMessage()); }finally{ try{ if(rs!=null) rs.close(); if(stmt!=null) stmt.close(); if(conn!=null) conn.close(); }catch(SQLException sqle){ out.println(sqle.getMessage()); } } %> </body></html>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?