📄 add_comments.jsp~7~
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312"><title>发表评论</title><style type="text/css"><!--body { background-color: #FFFFCC;}.style1 { font-size: 24px; color: #FF0000;}.style2 {font-size: 12px}--></style></head><body><jsp:useBean id="format" scope="page" class="photo.StrFormat"/><jsp:useBean id="dbconn" scope="page" class="photo.DBConnection"/><%try{Connection conn=dbconn.getConnection();Statement stmt=conn.createStatement();String content=format.StrFormat(request.getParameter("content"));int picture_id=Integer.parseInt(request.getParameter("picture_id"));String user_name=(String)session.getAttribute("user");String sql="insert into comments (content,picture_id,comment_time,user_name) values ('"+content+"','"+picture_id+"',getdate(),'"+user_name+"')";stmt.execute(sql);//out.println("success!");stmt.close();conn.close();}catch(Exception e){e.printStackTrace();}%><p> </p><p> </p><p> </p><table width="51%" border="1" align="center"> <tr> <td bgcolor="#CCCCFF"><div align="center" class="style1">恭喜，评论发表成功！</div></td> </tr></table><p align="center"><a href="pic_detail.jsp?picture_id=<%=picture_id%>" class="style2">返回</a></p></body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -