tushujieyue_result.jsp

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

<style type="text/css">
<!--
.STYLE1 {
	font-size: 24px;
	color: #FF0000;
}
-->
</style>
<a href="tushujieyue.jsp" target="mainFrame" class="STYLE1"> 返回&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.*" %>
<%	
	session.setMaxInactiveInterval(-1);	
	String sidbook=request.getParameter("idbook");
	String idbook=new String(sidbook.getBytes("iso-8859-1"));
	session.setAttribute("bookbianhao",idbook);	
	String sidcustomer=request.getParameter("idcustomer");
	String idcustomer=new String(sidcustomer.getBytes("iso-8859-1"));
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	Connection con=DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=webapps/booksystem/db/bs.mdb;");
	Statement sql2=con.createStatement();
	ResultSet rs2=sql2.executeQuery("select * from books where idbook='"+idbook+"'");
	
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()){
	       out.print("你已借过此书!");
	}else{
	
	Statement sql8=con.createStatement();
	ResultSet rs8=sql8.executeQuery("select * from customers where idcustomer='"+idcustomer+"'");
	
	if(!(rs8.next())){
       out.print("没有此人!");     
  }
	
else{
		
	Statement sql4=con.createStatement();
	ResultSet rs4=sql4.executeQuery("select bookcount from books where idbook='"+idbook+"'");
	if(rs4.next()){	
     int a;
	  a=rs4.getInt(1);
	 a++;
	sql4.executeUpdate("update books set bookcount='"+a+"' where idbook='"+idbook+"' ");
		}
	
	sql.executeUpdate("insert into yijiebook values('"+idbook+"','"+idcustomer+"') ");
	out.print("<strong>借阅（图书编号：'"+idbook+"'）成功！</strong>"+"<p>");
  }
} 
} 
/*
  Statement sql6=con.createStatement();
	ResultSet rs6=sql6.executeQuery("select number from customers where idcustomer='"+idcustomer+"'");
	if(rs6.next()){	
     int b;
	   b=rs6.getInt(1);
	   b--;
	   sql6.executeUpdate("update customers set number='"+b+"' where idcustomer='"+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 sql2=con.createStatement();
	ResultSet rs6=sql6.executeQuery("select number from customers where idcustomer='"+idcustomer+"'");
	if(rs6.next()){	
     int b;
	   b=rs6.getInt(1);
	   b--;
	   sql6.executeUpdate("update customers set number='"+b+"' where idcustomer='"+idcustomer+"'");
	}
	*/
%>