//retrieved from the database and displayed on the page
<% @pageImport= "Java.text.SimpleDateFormat"%><% @pageImport= "java.sql.*"%><%@ page language= "java" contenttype= "text/html; Charset=utf-8 "pageencoding= "Utf-8"%><! DOCTYPE HTML PUBLIC "-//w3c//dtd HTML 4.01 transitional//en" "Http://www.w3.org/TR/html4/loose.dtd" >Class.forName ("Com.mysql.jdbc.Driver"); Connection Conn=drivermanager.getconnection ("Jdbc:mysql://127.0.0.1:3306/mydb", "Root", "" "); String SQL= "SELECT *" From info joins nation on info. Nation=nation. Code ";//String sql= "Select Code name Sex (SELECT * from Nation) birthday from info";PreparedStatement stat=conn.preparestatement (SQL); ResultSet Re=stat.executequery (); while(Re.next ()) {%> <tr> <td><%=re.getstring (1)%></td> <td><%=re.getstring (2)%></td> <td><%=re.getboolean (3)? " Male ":" Female "%></td> <td><%=re.getstring (7)%></td> <%Date S=re.getdate (5); SimpleDateFormat m=NewSimpleDateFormat ("yyyy mm month DD Day"); String Shijian=M.format (s); %> <td><%=shijian%></td> <td></td> </tr><%}conn.close ();%></table></body>The display effect is as follows
Web page Exercises