?? shade.jsp
字號:
<%@ page contentType="text/html;charset=gb2312" %>
<html>
<head>
<title>留言</title>
</head>
<body bgcolor="#0080FF">
<center>
<p><b><font color="red">留言板</font></b></p>
<FORM METHOD=POST action="shade.jsp">
<TABLE width='60%' height='120'>
<tr>
<td align="center">請輸入您的名字<input type="text" name="name" maxlength="20"></td>
</tr>
<TR>
<td><textarea name="shade" cols="70" rows="5" maxlength="100"></textarea></td>
</TR>
<TR>
<td align="center"> <INPUT TYPE="submit" size="4" name="submit" value="提交留言"></td>
</TR>
</table>
</center>
</form>
<p align="center"><b><font color="red">已有多位來訪者在此留言：</font></b></p>
<center>
<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="workM" scope="page" class="sql.message" />
<%String sumbit=request.getParameter("submit");
if(sumbit!=null){
String name=request.getParameter("name");
String shade=request.getParameter("shade");
String sql="insert into message(name,shade) values('"+name+"','"+shade+"')";
if(workM.executeUpdate(sql)){
out.print(name+"已經成功留言。");
}
}
%>
<%
ResultSet RS = workM.executeQuery("SELECT * FROM message");
String name1;
String shade1;
out.print("<table width='70%' border='2' style='color:white' >");
out.print("<tr><td width='10%' >Name</td><td width='90%' >Words</td></tr>");
while (RS.next()) {
out.print("<tr><td>");
name1 = RS.getString("name");
out.print(name1);
out.print("</td><td>");
shade1=RS.getString("shade");
out.print(shade1);
out.print("</td></tr>");
}
out.print("</table>");
RS.close();
%>
</center>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -