in_old_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 sum=request.getParameter("sum").trim(); 
String price=request.getParameter("price").trim(); 
String sumadd=request.getParameter("sumadd").trim(); 
String date=today.strYear()+"-"+today.strMonth()+"-"+today.strDay();

int s=Integer.parseInt(sum);
int s1=Integer.parseInt(sumadd);  
s=s+s1;
String newsum=Integer.toString(s);
//更新图书表
String sql1="UPDATE book_info SET book_sum="+newsum+" where book_isbn='"+isbn+"' and book_edit='"+edit+"'";
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+","+sumadd+","+price+",'"+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+","+sumadd+","+price+",'in','"+date+"')";
Stmt.executeUpdate(sql5); 

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