jieyuehistory.jsp

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

<%@page contentType="text/html;charset=gbk" %><style type="text/css">
<!--
body {
	background-image: url();
	background-color: #FFCCFF;
}
.STYLE1 {
	font-size: large;
	font-weight: bold;
}
.STYLE2 {font-size: medium}
-->
</style>
<%@page import="java.sql.*" %>
<%	
	Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	Connection con=DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=webapps/booksystem/db/bs.mdb;");
	Statement sql=con.createStatement();
	ResultSet rs=sql.executeQuery("select sidcustomer from yijiebook where idcustomer='"+session.getAttribute("inputusername")+"'");
	if(rs.next()){
    out.print("已借书目: ");
    
	String a,b;
	rs=sql.executeQuery("select * from books ");
	out.print("<table border>");
	out.print("<tr>");
	out.print("<th width=150>图书编号</td>");
	//out.print("<th width=150>图书名称</td>");
	out.print("</tr>");	
	out.print("<tr>");
		/*	
Statement sql1=con.createStatement();
	ResultSet rs1=sql1.executeQuery("select sidcustomer,idcustomer,idbook from customers,yijiebook,books where customers.idcustomer=yijiebook.sidcustomer and books.idbook=yijiebook.sidbook");
	
	if(rs1.next()){
	*/
	Statement sql1=con.createStatement();
	ResultSet rs1=sql1.executeQuery("select sidcustomer,idcustomer,idbook from customers,yijiebook,books where customers.idcustomer=yijiebook.sidcustomer and books.idbook=yijiebook.sidbook ");
	while(rs1.next()){
	out.print("<tr>");	
	a=rs1.getString(3);
	out.print("<td>"+a+"</td>");
		/*
	b=rs1.getString(1);
	out.print("<td>"+b+"</td>");
	
	Statement sql2=con.createStatement();
	ResultSet rs2=sql2.executeQuery("select bookname,sidbook,idbook from books,yijiebook where books.idbook=yijiebook.sidbook");
	while(rs2.next()){
	out.print("<tr>");	
	a=rs2.getString(1);
	out.print("<td>"+a+"</td>");
	b=rs2.getString(2);
	out.print("<td>"+b+"</td>");
	*/
	out.print("</tr>");
	}
	}
	else{
	out.print("你未借书!");
	}

	con.close();
%>