machsearch.java

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

package Bean;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.*;
import java.io.*;
import data.LoginData;
public class MachSearch{
        
        LoginData loginData = new LoginData(); 
	  	Connection conn = loginData.getConn();
	  	Statement stmt=null;
	  	ResultSet rs=null;
        String strSql=null;
        int totalrecord =0;
	   
	    public int BookCount(){
	  	try{ 
	    Statement stmt =conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
	  	strSql = "SELECT count(*) as recordcount FROM grade";
		rs = stmt.executeQuery(strSql);
		if (rs.next()) totalrecord = rs.getInt("recordcount");
	   
	  	}catch(SQLException e){
	  		System.out.println(e.getMessage());
	  		}
	  	return 	totalrecord;
	  	} 
	  
	}