add.jsp

来自「该源码为JSP的开发案例集锦」· JSP 代码 · 共 37 行

JSP
37
字号
<%@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 + =
减小字号Ctrl + -
显示快捷键?