show.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 Show{
        
        LoginData loginData = new LoginData(); 
	  	Connection conn = loginData.getConn();
	  	Statement stmt=null;
	  	ResultSet rs=null;
        String strSql="";
        int totalrecord =0;
        int idcount=0;
        public int Count(){
	  	try{ 
	    Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
	    strSql = "SELECT count(*) as idcount FROM grade";
	  	ResultSet rs = stmt.executeQuery(strSql);
	  	if(rs.next())totalrecord =idcount;
	   
	  	}catch(SQLException e){
	  		System.out.println(e.getMessage());
	  		}
	  		return  totalrecord; 
	  	} 
	  	}