test1.jsp

基于jsp的图书管理系统的功能和实现

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@page import="java.sql.*"%>
<jsp:useBean id="connDbBean" scope="page" class="db.dbConn"/>
<%
String  username="123";
String password="123";
  String strSql="SELECT * FROM userdb WHERE PASSWORD='"+password+"'"+" "+"AND"+" "+"USERNAME='"+username+"'";
ResultSet rs = connDbBean.executeQuery(strSql);
while(rs.next()){
	out.print(rs.getInt("USERNAME"));
	out.print(rs.getInt("PASSWORD"));
	
	out.print("<BR>");
}
%>