mess_add.jsp
来自「java + sqlserver2000编写的一个网上购书系统,实现了一些基本的」· JSP 代码 · 共 39 行
JSP
39 行
<%@ page language="java" pageEncoding="GBK"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*" %>
<jsp:useBean id="DBaddnew" scope="page" class="ConnBean.conn"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>My JSP 'book_up.jsp' starting page</title>
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body BGCOLOR="#FFCCCC">
<%
try{
ResultSet rs3=null;
String bno=request.getParameter("n_auth");
String sql3="select AdminID from admin where AdminName='"+bno+"' ";
rs3=DBaddnew.executeQuery(sql3);
rs3.next();
String cname=request.getParameter("n_title");
String sendpeople=rs3.getString("AdminID");
String bname=request.getParameter("n_time");
String cno= request.getParameter("n_content");
String SQLADD="insert into message(AdminID,SendTime,Context,ContextTitle) values('"+sendpeople+"','"+bname+"','"+cno+"','"+cname+"')";
DBaddnew.executeUpdate(SQLADD);
//out.print(SQLADD);
}catch(Exception e){
out.print(e);}
out.println("<script language=javascript>");
out.println("alert('恭喜你,添加成功!');");
out.println("window.location.href='message.jsp';");
out.println("</script>");
%>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?