Search
Latest topics
Tim kiem CSDL _ JSP
Page 1 of 1
Tim kiem CSDL _ JSP
Dau tien ban co co so du lieu la QLSinhVien:
Sau do ban go code tim kiem sau:
Sau do ban go code tim kiem sau:
- Code:
<%@page contentType="text/html; charset=utf-8" %>
<%@page language="java" import="java.sql.*" %>
<%!
String drivername= "sun.jdbc.odbc.JdbcOdbcDriver";
String connectionURL = "jdbc:odbc:QLThuVien";
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
String ma = null;
String ten = null;
String ml = null;
String mnxb = null;
String sls = null;
String slt = null;
String nam = null;
%>
<%
String gt="Nhap sach can tim";
%>
<body background="Images/logobg.jpg">
<h3 align="center">TÌM KIẾM SÁCH TRONG THƯ VIỆN </h3>
<form action="search.jsp" method="post">
<div align="center">
<input name="tim" type="text" size="30" value="<%=gt%>">
<input name="timkiem" type="submit" value="Tim kiem">
</div>
</form>
<div>
<%
gt=request.getParameter("tim");
Class.forName(drivername).newInstance();
con = DriverManager.getConnection(connectionURL);
stmt = con.createStatement();
if(request.getParameter("timkiem")!=null)
{
String sql;//="select * from MonAn";
sql="SELECT * FROM Sach WHERE TenSach like '%" + gt + "%'";
rs=stmt.executeQuery(sql);
if(rs.next()==true)
{
//String sql="select * from MonAn";
sql="SELECT * FROM Sach WHERE TenSach like '%" + gt + "%'";
rs=stmt.executeQuery(sql);
out.print("<div>");
out.print("<table width='99%' border='1' bordercolor='#006633' align='center'>");
out.print("<tr bordercolor='#006633'>");
out.print("<td width='93' align='center'><strong style='color:#0066CC'>Ma Sach</strong></td>");
out.print("<td width='233' align='center'><strong style='color:#0066CC'>Ten Sach</strong></td>");
out.print("<td width='99' align='center'><strong style='color:#0066CC'>Ma Loai Sach</strong></td>");
out.print("<td width='229' align='center'><strong style='color:#0066CC'>Ma NXB</strong></td>");
out.print("<td width='99' align='center'><strong style='color:#0066CC'>So Luong Sach</strong></td>");
out.print("<td width='229' align='center'><strong style='color:#0066CC'>So Luong Trang</strong></td>");
out.print("<td width='229' align='center'><strong style='color:#0066CC'>Nam XB</strong></td>");
out.print("</tr>");
while(rs.next())
{
ma = rs.getString("MaSach");
ten = rs.getString("TenSach");
ml = rs.getString("MaLoai");
mnxb = rs.getString("MaNXB");
sls = rs.getString("SoLuongSach");
slt = rs.getString("SoLuongTrang");
nam = rs.getString("NamXB");
out.print("<tr>");
out.print("<td>" + ma + "</td>");
out.print("<td>" + ten + "</td>");
out.print("<td>" + ml + "</td>");
out.print("<td>" + mnxb + "</td>");
out.print("<td>" + sls + "</td>");
out.print("<td>" + slt + "</td>");
out.print("<td>" + nam + "</td>");
out.print("</tr>");
}
con.close();
out.print("</table>");
out.print("</div>");
out.print("<br>");
}
else
{
out.print("<font size='+2' color='blue'><strong algin='center'>Khong co sach nay trong thu vien</strong></font>");
}
}
%>
</div>
<p><a href="index.jsp">Nhấn vào đây để trở về trang chủ </a></p>
</body>
Similar topics
» Ham kiem tra tam giac
» kiểm tra email bang JavaScript
» Code thêm xóa sửa tìm kiếm trong c#
» 10 thủ thuật tìm kiếm tốt nhất
» Mẹo tìm kiếm bằng Google
» kiểm tra email bang JavaScript
» Code thêm xóa sửa tìm kiếm trong c#
» 10 thủ thuật tìm kiếm tốt nhất
» Mẹo tìm kiếm bằng Google
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
Thu Aug 23, 2012 5:38 am by Admin
» Tuyệt kỹ cua giai
Thu Aug 23, 2012 5:36 am by Admin
» NETCAT.........
Mon Aug 13, 2012 6:35 am by Admin
» Bảo mật CSDL bằng phương pháp mã hóa.
Tue Apr 17, 2012 10:04 pm by Admin
» Hàm mã hóa MD5 bằng JavaScript
Tue Apr 17, 2012 10:03 pm by Admin
» Giá của món quà
Fri Apr 13, 2012 6:01 am by Admin
» Sẽ chỉ yêu ai?
Fri Apr 13, 2012 6:01 am by Admin
» Cách đọc bảng chữ cái!
Thu Apr 12, 2012 10:37 pm by Admin
» Gắn trojan, keylog, virus vào website, forum
Tue Apr 10, 2012 1:14 am by Admin