📄 add.jsp
字号:
<%@page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<%@ page contentType="text/html;charset=gb2312"%>
<html>
<head>
<title>保存留言</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFCCCC">
<%
String name=request.getParameter("name");
name=new String(name.getBytes("8859_1"));
String title=request.getParameter("title");
title=new String(title.getBytes("8859_1"));
String content=request.getParameter("content");
content=new String(content.getBytes("8859_1"));
String mail=request.getParameter("mail");
mail=new String(mail.getBytes("8859_1"));
Class.forName("org.gjt.mm.mysql.Driver");
String dbUrl = "jdbc:mysql://localhost/csnews";
String dbUser = "root";
String dbPassword = "";
Connection con = DriverManager.getConnection(dbUrl,dbUser,dbPassword);
Statement stm=con.createStatement();
String sql="insert into message values('"+title+"','"+name+"','"+content+"','"+
mail+"','" + new java.util.Date() + "')";
if(stm.executeUpdate(sql)==1)
<jsp:forward page="view.jsp"/>
else
out.print("添加失败");
con.close();
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -