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 + -
显示快捷键?