📄 insert.jsp

📁 《jsp网站开发技术》中的源代码(清华大学出版社)

💻 JSP

字号:

<%@ page language="java"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.Date" %>
<jsp:useBean id="sqlbean" scope="page" class="guestbook.guestbook"/>
<%! String name,email,url,words,time,sql;%>
<html>
<body>
<%
Date MyDate=new Date();
time=Integer.toString(MyDate.getMonth()+1)+"-"+Integer.toString(MyDate.getDate())+" "+Integer.toString(MyDate.getHours())+":"+Integer.toString(MyDate.getMinutes());

if((request.getParameter("name")!=null)&&!(request.getParameter("name").equals("")))
  name=request.getParameter("name"); 
else
  name="no name";
if((request.getParameter("email")!=null)&&!(request.getParameter("email").equals("")))
  email =request.getParameter("email");
else
  email="no email";
if ((request.getParameter("url")!=null)&&!(request.getParameter("url").equals("")))
  url =request.getParameter("url");
else
  url="no url";

if((request.getParameter("words")!=null)&&!(request.getParameter("words").equals("")))
{
words=request.getParameter("words");
sql="insert into guestbook(Name,Email,Url,Words,postime) values('"+name+"','"+email+"','"+url+"','"+words+"','"+time+"')";
sqlbean.executeInsert(sql);
out.println("ok,what you have written have been written to the file,thanks."+"<br>");
out.println("your name:"+name+"<br>"+"your email address:"+email+"<br>");
out.println("your homepage:"+url+"<br>"+"what you have said:"+words+"<br>"+"post time:"+time);
}
else
{%>
<font color=red size=5>
<%out.println("sorry,please input something!");}
%></font>
<br><br><br>
现在查看留言簿中的内容:<br>
<a href="lookup.jsp" align=center>浏览留言簿的记录.</a>
<body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -