inbook2.jsp

网站的实例

<%
/*
文件名: inbook2.jsp
所需文件：adm_login.jsp
调用文件：admin.jsp
调用条件：管理员已登陆
功能描述：判断进书是否为新书，如为新转道in_new_book.jsp,如为旧转道in_old_book.jsp
编码人：sT
编码日期：2002-05-27
*/
%>     

<%@ include file="adm_login.jsp"%> 
<%@ include file="data.jsp"%> 
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>   

<%
String isbn=request.getParameter("isbn").trim();
String edit=request.getParameter("edit").trim(); 

String sql="SELECT * FROM book_info WHERE book_isbn='"+isbn+"' and book_edit='"+edit+"'";

Rst=Stmt.executeQuery(sql);

if(Rst.next())
{
	Rst.close();
	Stmt.close();
	Conn.close();
	String url1="in_old_book.jsp?isbn="+isbn+"&edit="+edit;
	response.sendRedirect(url1);
}
else
{
	Rst.close();
	Stmt.close();
	Conn.close(); 
	String url2="in_new_book.jsp?isbn="+isbn+"&edit="+edit;
	response.sendRedirect(url2);  
}
%>