📄 myjsp.jsp

📁 一个自己完成的网上书店

💻 JSP

字号:

<%@page language="java" contentType="text/html;charset=gb2312" import="java.sql.*" pageEncoding="gb2312"%>


<html>
  <head>
    <base href="<%%>">
    
    <title>My JSP 'MyJsp.jsp' starting page</title>
    
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->

  </head>
  
  <body><div align="center"><font face="Arial Black"><font color="#ff0000"><strong>&#29992;&#25143;&#36164;&#26009;&#31616;&#20171;</strong></font></font><br><div align="left"><br></div> 
  </div>
  <table border=1 align="center" width="10px" height="100px">
  <tr>
  <td width='200'>用户名</td>
  <td width='100'>密码</td>
  <td width='200'align="center">电子邮件</td>
  <td>住址</td>
  </tr>
  <%
  Class.forName("com.mysql.jdbc.Driver");
  DriverManager.registerDriver(new com.mysql.jdbc.Driver());
  String dburl="jdbc:mysql://localhost:3306/bookstore?useUnicode=true&characterEncoding=GB2312";
  String user="root";
  String pass="ptnest";
  Connection con;
  con=java.sql.DriverManager.getConnection(dburl,user,pass);
  Statement stmt=con.createStatement();
  ResultSet rs=stmt.executeQuery("select *from user");
  while(rs.next())
  {
  %>
  	<tr>
  	<%
  	String name = rs.getString("realname");
	name= new String(name.getBytes("ISO-8859-1"),"gb2312");
  	 %>
  	<td bgcolor=#fff0f5><%=new String(rs.getString("realname").getBytes("iso-8859-1"),"GB2312") %></td>  
  	<td bgcolor=#fff0f5><%=rs.getString("password") %></td>
  	<td bgcolor=#fff0f5><%=rs.getString("email") %></td>
  	<td bgcolor=#fff0f5><%=rs.getString("address") %></td>
  	</tr>
  	<% 
  	}
  	rs.close();
  	con.close();  	
  	%>
 
  </table>
  
  
  </body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -