admin_adddo_book.jsp

来自「用JSP实现的 满好的 大家支持哦 大家多多支持」· JSP 代码 · 共 24 行

<%@ page language="java" import="java.sql.*" contentType="text/html;charset=GB2312"%>
<%
    String admin_book_Loginmessage=(String)session.getValue("admin_book_loginSign");
    String adminID=(String)session.getValue("adminID");    
    if(admin_book_Loginmessage!="OK")
    {
	response.sendRedirect("admin_book_index.jsp");
    }
%>
<jsp:useBean class="manage_sys.manage_sys" id="admin_adddo_book" scope="page"></jsp:useBean>
<%
    String BookName=new String(request.getParameter("BookName").getBytes("8859_1"));   
	String Author=new String(request.getParameter("Author").getBytes("8859_1")); 
	String Publish=new String(request.getParameter("Publish").getBytes("8859_1")); 
	String PubTime=new String(request.getParameter("PubTime").getBytes("8859_1")); 
	String BookNo=new String(request.getParameter("BookNo").getBytes("8859_1")); 
	String Content=new String(request.getParameter("Content").getBytes("8859_1")); 
	String Price=new String(request.getParameter("Price").getBytes("8859_1")); 
	String Amount=new String(request.getParameter("Amount").getBytes("8859_1")); 
    
    String sql="insert into my_book(BookName,Author,Publish,PubTime,BookNo,Content,Price,Amount) values('"+BookName+"','"+Author+"','"+Publish+"','"+PubTime+"','"+BookNo+"','"+Content+"','"+Price+"','"+Amount+"')";
    admin_adddo_book.executeUpdate(sql);
    response.sendRedirect("admin_book_index.jsp");
%>