sql_gateway.jsp

来自「J2EE独立开发制作」· JSP 代码 · 共 32 行

JSP
32
字号
<!doctype html public "-//W3C//DTD HTML 4.0 Transitional//EN">
<% 
   String sqlStatement = (String) session.getAttribute("sqlStatement");
   if (sqlStatement == null) sqlStatement = "select * from User";
   String message = (String) session.getAttribute("message");
   if (message == null) message = " ";
%>

<%@ page contentType="text/html;charset=GBK" %>
<html>
<head>
  <title>SQL网关</title>
</head>

<body>
<h1>SQL网关</h1>
<p>输入一个SQL命令,然后点击“执行”按钮。命令执行的结果将<br>显示在页面的下方。</p>
<form action="servlet/test.SQLGatewayServlet" method="post">
<b>SQL命令:</b><br>
<textarea name="sqlStatement" cols=60 rows=8><%=sqlStatement%></textarea><br>
<br>
<input type="submit" value="执行">
</form>

<p>
<b>SQL命令执行结果:</b><br>
<table cellpadding="5" border="1">
<%=message%>
</table>
</p>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?