📄 show.jsp~4~
字号:
<%@ 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 + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -