tushuguihuan_result.jsp

jsp与数据库连接的图书馆管理系统

<a href="tushuguihuan.jsp" target="mainFrame"> 返回&quot;图书归还&quot;界面</a>
<%@page contentType="text/html;charset=gbk" %><style type="text/css">
<!--
body {
	background-image: url(images/dream018.jpg);
}
.STYLE1 {
	font-size: large;
	font-weight: bold;
}
.STYLE2 {font-size: medium}
-->
</style>
<%@page import="java.sql.*" %>
<%
  String idbook=request.getParameter("idbook");
  String idcustomer=request.getParameter("idcustomer");
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	Connection con=DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=webapps/booksystem/db/bs.mdb;");
	Statement sql1=con.createStatement();
	ResultSet rs1=sql1.executeQuery("select * from yijiebook where sidcustomer='"+idcustomer+"'");
	Statement sql2=con.createStatement();
	ResultSet rs2=sql2.executeQuery("select * from yijiebook where sidbook='"+idbook+"'");
if(!rs1.next()){
out.print("此人未借书!");
}
else if(!rs2.next()){
out.print("此人未借此书!");
}

else{
	Statement sql=con.createStatement();
	ResultSet rs=sql.executeQuery("select * from yijiebook where sidbook='"+idbook+"'and sidcustomer='"+idcustomer+"'");
	if(rs.next()){
	sql.executeUpdate("Delete from yijiebook where sidbook='"+idbook+"'and sidcustomer='"+idcustomer+"'");
		out.print("'"+idbook+"'已归还！");
	
	}
	else{
	out.print("(图书编号：'"+idbook+"')不再数据库,可能已归还");
	}
	}
	//con.close;不能要
	%>