in_new_book2.jsp

网站的实例

<%
/*
文件名: 
所需文件：
调用文件：
调用条件：
功能描述：
编码人：sT
编码日期：2002-05-27
*/
%>  

<%@ include file="adm_login.jsp"%> 
<%@ include file="data.jsp"%> 
<jsp:useBean id="today" class="ebs.dateTransfer" scope="page"/>
<%
String isbn=request.getParameter("isbn").trim();
String edit=request.getParameter("edit").trim();   
String name=request.getParameter("bookname").trim();
String author=request.getParameter("bookauthor").trim();  
String sum=request.getParameter("booksum").trim(); 
String publisher=request.getParameter("bookpublisher").trim();
String pubdate=request.getParameter("bookpubdate").trim();  
String price=request.getParameter("bookprice").trim(); 
String cost=request.getParameter("bookcost").trim(); 
String pages=request.getParameter("bookpages").trim(); 
String app=request.getParameter("bookapp").trim();
String intro=request.getParameter("bookintro").trim();  
String type=request.getParameter("type").trim(); 
String pic=request.getParameter("pic").trim(); 
String date=today.strYear()+"-"+today.strMonth()+"-"+today.strDay();
pic=pic+".bmp";
name=new String(name.getBytes("8859_1"),"gb2312");
author=new String(author.getBytes("8859_1"),"gb2312"); 
publisher=new String(publisher.getBytes("8859_1"),"gb2312");
intro=new String(intro.getBytes("8859_1"),"gb2312");

//更新图书表
String sql1="INSERT INTO book_info(book_isbn,book_edit,book_sum,book_name,book_author,book_pub,book_pubdate,book_price,book_pages,book_app,book_intro,book_kind,book_pic) VALUES('"+isbn+"','"+edit+"',"+sum+",'"+name+"','"+author+"','"+publisher+"','"+pubdate+"',"+price+","+pages+",'"+app+"','"+intro+"','"+type+"','"+pic+"')";
String sql2="SElECT book_id FROM book_info WHERE book_isbn='"+isbn+"' and book_edit='"+edit+"'"; 
Stmt.executeUpdate(sql1); 
//从图书表中查出图书id
Rst=Stmt.executeQuery(sql2);
Rst.next();
String id=Rst.getString("book_id");
//在进书表中插入新项
String sql3="INSERT INTO inbook(book_id,in_sum,in_price,in_time) VALUES("+id+","+sum+","+cost+",'"+date+"')"; 
Stmt.executeUpdate(sql3); 
//从进书表中查出新的进书单号
String sql4="SELECT in_id FROM inbook ORDER BY in_id DESC";
Rst=Stmt.executeQuery(sql4);
Rst.next();
String in_id=Rst.getString("in_id");
//更新胀目表
String sql5="INSERT INTO account(word_id,account_sum,account_price,account_status,account_time) VALUES("+in_id+","+sum+","+cost+",'in','"+date+"')";
Stmt.executeUpdate(sql5); 

//Rst.close();
Stmt.close();
Conn.close();  
String url="in_book_rst.jsp?isbn="+isbn+"&edit="+edit;
response.sendRedirect(url); 
%>