bill_send_book2.jsp

网站的实例

<%@ include file="data.jsp"%>
<%@ include file="adm_login.jsp"%>
<jsp:useBean id="today" class="ebs.dateTransfer" scope="page"/>
<%
String id=request.getParameter("billid").trim();
String sum=request.getParameter("sum").trim();
String price=request.getParameter("price").trim();
String date=today.strYear()+"-"+today.strMonth()+"-"+today.strDay();
int s1=Integer.parseInt(sum);

String sql="UPDATE bill SET bill_status='solved' WHERE bill_id="+id;
Stmt.executeUpdate(sql);

String sql1="INSERT INTO account(word_id,account_sum,account_price,account_status,account_time) VALUES("+id+","+sum+","+price+",'out','"+date+"')";
Stmt.executeUpdate(sql1);

String sql2="SELECT book_id FROM bill WHERE bill_id="+id;
Rst=Stmt.executeQuery(sql2);
Rst.next();
String bookid=Rst.getString("book_id");

String sql3="SELECT book_sum FROM book_info WHERE book_id="+bookid;
Rst=Stmt.executeQuery(sql3);
Rst.next();
int s2=Rst.getInt("book_sum");
s2=s2-s1;

String sql4="UPDATE book_info SET book_sum="+s2+" WHERE book_id="+bookid;
Stmt.executeUpdate(sql4);

//Rst.close(); 
Stmt.close();
Conn.close();  
String url="bill_send_book.jsp";
response.sendRedirect(url); 
%>